Excel Crash Course Verified Correct Question And ANSWERS

Excel Crash Course Verified
Correct Question And
ANSWERS
D YOUDWILLDBEDABLEDTODFINDDTHEDFOLLOWING

 36DQUESTIONDWITHDCORRECTDANSWERS.
 ITDCONSISTDOFDMULTIPLEDCHOICEDOFDANSWERS.
 BOTHDCORRECTDANDDINCORRECTDANSWERSDAREDDHIGHLIGHTEDD
WITHDDIFFERENTDDCOLOR.
 WITHD100%DGUARANTEEDPASS.
 CORRECTDANSWERSDAREDHIGHLIGHTEDDINDDADBLUEDCOLOR.




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



more sheets to a workbook EXCEPT:
D D D D D



Alt i w A D D D



lt h i s Sh
D D D D



ift F11 D



Alt Shift F1 D D



Alt h i w
D D D D



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



g more sheets to a workbook.
D D D D D



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



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



Ctrl o D



Ctrl f D



Alt
D D



o

1D/D22

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



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



mand. Ctrl n is the shortcut to open a new workbook.
D D D D D D D D D D



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



Automatic
Manual
Automatic except for Data Tables
D D D D



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



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




2D/D22

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



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



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



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



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



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



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



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



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



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



ired worksheet 4. Let go of the Ctrl and PageUp/Down keys 5. Use the arrow key
D D D D D D D D D D D D D D D



s to locate the desired cell reference 6. Hit Enter
D D D D D D D D D



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



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



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



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



row




3D/D22