Excel Crash Course/36 Questions With CompleteSolution Rated (A+)Quiz :All of the following are keyboard shortcut that allow the user input toadd more sheets to a workbook EXCEPT:Alt i wAlt h i sShift F11Alt Shift F1Alt h i wIncorrect-Answer :Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboardshortcuts for adding more sheets to a workbook.Alt h i w is not a valid shortcut.Quiz :What is a keyboard shortcut to open a file?Ctrl oCtrl fAlt oCtrl n-Answer :The correct answer is Ctrl o.Ctrl f is the shortcut to find, or find and replace, text on the worksheet. Alt o isnot a command. Ctrl n is the shortcut to open a new workbook.Quiz :What is the recommended workbook calculation setting for Excel?AutomaticManualAutomatic except for Data TablesIterate-Answer :The correct answer is "Automatic except for Data Tables".Data tables can significantly slow down Excel and other programs."Automatic", the default setting, will automatically calculate everything in theworkbook, including data tables, which will make the program run moreslowly. The Manual setting will requirethe user to frequently recalculate theworkbook in order to display correctly. "Iterate" is not a setting for workbookcalculation in Excel; iterative calculation is a toggle for users to set forworkbooks that may have circular calculations.qQuiz :Toadd a cell reference from a different worksheet into an existingformula with your keyboard, you should follow the following steps:1. Hit F2 to get into the existing formula; delete any incorrect formulas oroperators 2. Hit F2 again to enable "Enter" mode on the bottom-left corner ofthe Excel sheet 3. Holding down Ctrl, use PageUp or PageDown to find thePreview Mode
This document has 11 pages. Sign in to access the full document!