Partly ONLINE CISM 2530
Popular in Course
Popular in Computer Information Systems
This 16 page Class Notes was uploaded by Kenyatta McDermott on Monday October 12, 2015. The Class Notes belongs to CISM 2530 at Georgia Southern University taught by Andrew Burns in Fall. Since its upload, it has received 89 views. For similar materials see /class/222071/cism-2530-georgia-southern-university in Computer Information Systems at Georgia Southern University.
Reviews for Partly ONLINE
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/12/15
Microsoft Excel 2010 J Chapter 3 WhatIf Analysis Charting QT and Working with Large Worksheets g SHELLY E CASHMAN S SERIES WhatIF Analysis IF Function Nested IF Function Goal Seek Charts Pie Chart Chart Sheet 0 Working with Large Worksheets What If Analysis Charting and Working with Large Worksheets 2 m7 ri 77 7YLV7 1 77 a m 7 xv x r 391c a mi i gt iiima riz lam 7 3 7 2r L 4 a mi i 5 739YLV ri 7 fiWhat lf Analysis Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called what if analysis or sensitivity analysis IF Function uses logical operators of AND OR Goal Seek Has end answer and finds beginning Scenario Manager 1 or 2 Input Data Tables What If Analysis Charting and Working with Large Worksheets 20 Z 22 23 24 25 6 Revenue Home insert Page Layout Cost of Goods Sold Gross Margin 0 entered in Formula b13gtb7 entered in Logical test box current values of expressions displayed U dib39nn is met and velums one vahe If TRUE and another value IF FALSE Valuelfalse Is the value that is rammed If Lo calte5t is FALSE If omllted PALE Is returned Expenses Valueiffalse box Bonus Commission memm39 0 Marketing umeme Will i Cm Research and Development Support General and Administrative Total Expenses Operating Income What If Analysis Charting and Working with Large Worksheets lfyou know the result you want a formula to produce you can use goal seeking to determine the value of a cell on which the formula depends Goal Seek command on the Data tab Goal seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for a value in another cell What If Analysis Charting and Working with Large Worksheets Home 1mm Pageloyuul Formn om Rauiew 1 6r Gari emal Dar Conntmnm 501 Fiim H25 v 7 JR SUM1325625 Goal Seek Status 7 7 7 7 7quot 47quot7 diaiogbox War4mm Bonus Emnmmmn Goa Seek Slain Moran 39 Goal mm m Cell 1125 nuuelmg 1 round a solution unrenrch nun Devdonmlml Twat v New Sales Revenue for Bonus Carat value 300000713 Salmon Generll 0M Adminl rtl Na Cancel button 1 Z 3 4 5 6 7 8 9 r operating inceme u l 20000000 changesfrom 17903270 45732354 43875574 196895 3215575925510 46704182 119433533 114458020 5136405 339 39 Research and Development 23352091 59716766 57229010 25682027 225 56618 22 Support General and Administrative 53917324 137379225 132135278 59296880 522 00309 39 ZRiTotllExponees 141876867 382812379 153676978BZ 154032514 514346 34059 Ni 37155832 75016164 5710578161 54058024 7 57300007002007 139 39 11 1 l uwi 1am What If Analysis Charting and Working with Large Worksheets W x a 3 i Ti HEW 71quot at g 2g 15 7 g g gang 57f at 5 2g g 7 g ighehg 571 at ECharts Discussing Pies l Helps to show the relationship or proportion of parts to the whole Can be created like other charts on a different sheet then the data The sheet with the chart only is called a chart sheet 0 Like other charts has data points and data series What If Analysis Charting and Working with Large Worksheets Navembe r 23 Dacha December 12 1496 September 1396 What If Analysis Charting and Working with Large Worksheets Design in J 39 Format Selmiun 5 Remit to Matth Ster m urfI 39r Inva PM a quotia 95 T V w p B FormatChavtArea F 3D Rotation Bade Cola Border Style Glaw and Suft Edge i 9 LR Increase X Rotation 30 Format 30 39 button Size Pgrspectivet jS P rapevue Text AltTe xt E Levin14 rm Obpect position Qa39mt asset Chart Sale What If Analysis Charting and Working with Large Worksheets AbsoluteMixedRelative Cell Addressing 0 Freeze Panes Splitting Windows What If Analysis Charting and Working with Large Worksheets Absolute versus Relative Addressing Table 37 6 Examples of Absolute Relative and Mixed Cell References Cell Reference Type of Reference 354 Absolute cell reference B4 Mixed reference 34 Mixed reference 84 Relative cell reference Meaning Both column and row references remain the same When you copy this cell because the cell references are absolute This cell reference is mixed The column reference changes when you copy this cell to another column because it is relative The row reference does not change because it is absolute This cell reference is mixed The column reference does not change because it is absolute The row reference changes when you copy this cell reference to another row because it is relative Both column and row references are relative When copied to another cell both the column and row in the cell reference are adjusted to reflect the new location What If Analysis Charting and Working with Large Worksheets 11 0 am usIcV ops 39x on man lal rqjtc a tri e xc Home Insert Page layout Formulas Data Review View Enter box 138nm 31 Q 2quot Clipboard V 39 313911 4 Taill Font All ment Number Styles x A 3131B4 A 10 Modern Music Shops NOW 1 1 SixMonth Financial Projection 90 12 w 4 1 3 Revenue I 796223553 511226858 I Cost of Goods Sold I 15 Gross Margin 1395 cell B13 is relative 17 Expenses 39 What If Analysis Charting and Working with Large Worksheets Fl row titles in column A n 3 i will remain on the a screen when scrolling Paste right Clipboard Fdnt tops Review 2F 39 313 v f column titles in first twelve rows will remain On the screen when scrolling down In 10 Modern Music Shops ii SixMonth Financial Projection Revenue 14 Cost of Goods Sold 15 Gross Mar 17 Expenses and columns 18 Bonus 19 Commission 20 Marketing 21 Research and Development Total Expenses thin black lines indicate 15 border of frozen rows 2 Support General and Administrative What If Analysis Charting and Working with Large Worksheets Home imen Pagelmui rmmum om ew1w w E j 3 mg Bunk Pvuiew J WNW W 7 A 3N Window I 131mm mm H ii Murmurii Hm Page 1 Guam 7 Huang 2mm mm Zbomia I 3m 5mm your QMIMW 39 seamen 35mewa 39 1 wmmacewmom S sminim va z lter 2mm r 3424271123 Window group mums comuninv Emeer Iml Ocvnhwumrl Baum swoon General and A minlctullve upper panes move in venical synchronization 9quot x W7 Emmi 1790707 745782 77 7 scroll bars for left 211 Marketing 46704182 119433533 andriahivanes 21 Research and Development 23352091 597167 226256613 22 Supponoenera1ana Administrative 53330223 149291915 205057 5341544 23 TnQIEvnensas 146339772 3942 lower panes 24 move in vertical 391 4 s1 milAmara 1 1 Relay 1 T left panes move in right panes move in horizontal synchronization horizontal synchronization What If Analysis Charting and Working with Large Worksheets Access Test April 26th quot39 630 PM The Access Test contains 25 task questions and 25 questions of multiple choice or true false The entire test will be done on SAM 2010 You will have 120 minutes to complete all 50 questions This test will be the only thing we do that night You must have access to SAM 2010 to complete the test Task Topics The following are potential task topics but should not be considered the complete list You will have 4 tries at each question to get it right A practice test for the tasks portion will be made available on SAM 2010 Open a database Datasheet view vs Design view Enter records into a table Define fields as numbers or currency Create tables queries amp forms Change data types in tables Default values Specify a validate rule Referential integrity enforce Viewing relational joins Input mask wizard Calculated fields Criteria within a query Update queries Using group by in queries Blank forms Adding a field to an existing form Report wizard Adding totals to a report Add group to a report Compact a database Multiple Choice and TF Topics The following are potential task topics but should not be considered the complete list You will have 1 try at each question to get it right Fieldgt Recordgt Tablegt Database What is Access One to many relationships Primary keys vs foreign keys n I I of data Sort keys in queries Wildcards in queries Exporting and importing data into access Lookup fields Bound controls vs unbound controls Detail reports vs summary reports Sections of a report Summary options in the report wizard 4 objects Relational database vs database Bonus Questions 4 points As you may recall we discussed 2 bonus questions as we went through the 5 access chapters 1 First bonus question will revolve around orphan records and how you can prevent them in a database Do a little release and be prepared to write a few sentences on the subject Second bonus question will be about the 4 objects we studied that is found in a database What Iquot object must come first