Excel Crash Course Verified Correct Question And ANSWERS

Excel Crash Course Verified
Correct Question And
ANSWERS

GG YOUGWILLGBEGABLEGTOGFINDGTHEGFOLLOWING

 36GQUESTIONGWITHGCORRECTGANSWERS.
 ITGCONSISTGOFGMULTIPLEGCHOICEGOFGANSWERS.
 BOTHGCORRECTGANDGINCORRECTGANSWERSGAREGGHIGHLIGHTEDG
WITHGDIFFERENTGGCOLOR.
 WITHG100%GGUARANTEEGPASS.
 CORRECTGANSWERSGAREGHIGHLIGHTEDGINGGAGBLUEGCOLOR.




1. All of the following are keyboard shortcut that allow the user input to add
G G G G G G G G G G G G G G



more sheets to a workbook EXCEPT:
G G G G G



Alt i w Al G G G



t h i s Shi
G G G G



ft F11 G



Alt Shift F1 G G



G Alt h i w G G G



Incorrect: Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for addin
G G G G G G G G G G G G G G G G G G G



more sheets to a workbook.
G G G G G



Alt h i w is not a valid shortcut.
G G G G G G G G



2. What is a keyboard shortcut to open a file?
G G G G G G G G G



Ctrl o G



Ctrl f G



G Alt G



o

1G/G22

,Ctrl n: The correct answer is Ctrl o.
G G G G G G G



Ctrl f is the shortcut to find, or find and replace, text on the worksheet. Alt o is not a com
G G G G G G G G G G G G G G G G G G G G



and. Ctrl n is the shortcut to open a new workbook.
G G G G G G G G G G



3. What is the recommended workbook calculation setting for Excel?
G G G G G G G G G



Automatic
Manual
Automatic except for Data Tables
G G G G



Iterate: The correct answer is "Automatic except for Data Tables".
G G G G G G G G G



Data tables can significantly slow down Excel and other programs. "Automatic", the
G G G G G G G G G G G




2G/G22

, default setting, will automatically calculate everything in the workbook, including data t
G G G G G G G G G G G



ables, which will make the program run more slowly. The Manual setting will require th
G G G G G G G G G G G G G G



e user to frequently recalculate the workbook in order to display correctly. "Iterate" is n
G G G G G G G G G G G G G G



ot a setting for workbook calculation in Excel; iterative calculation is a toggle for users t
G G G G G G G G G G G G G G G



o set for workbooks that may have circular calculations.q
G G G G G G G G



4. To add a cell reference from a different worksheet into an existing formula
G G G G G G G G G G G G G



with your keyboard, you should follow the following steps:
G G G G G G G G



1. Hit F2 to get into the existing formula; delete any Incorrect formulas or operat
G G G G G G G G G G G G G G



rs 2. Hit F2 again to enable "Enter" mode on the bottom-left corner
G G G G G G G G G G G G



of the Excel sheet 3. Holding down Ctrl, use PageUp or PageDown to find the desi
G G G G G G G G G G G G G G G



red worksheet 4. Let go of the Ctrl and PageUp/Down keys 5. Use the arrow keys
G G G G G G G G G G G G G G G



G to locate the desired cell reference 6. Hit Enter
G G G G G G G G



1. Hit F2 to get into the existing formula; delete any Incorrect formulas or opera
G G G G G G G G G G G G G G



tors 2. Hit F2 again to enable "Enter" mode on the bottom-
G G G G G G G G G G G



left corner of the Excel sheet 3. Holding down Alt, use PageUp or PageDown to fi
G G G G G G G G G G G G G G G



nd the desired worksheet 4. Let go of the Ctrl and PageUp/Down keys 5. Use the ar
G G G G G G G G G G G G G G G G



row




3G/G22