Excel crash stuvia - Study guides, Class notes & Summaries

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - ANSWERSAlt h i w What is a keyboard shortcut to open a file?` - ANSWERSCtrl o What is the recommended workbook calculation setting for Excel? - ANSWERSAutomatic Except for Data Tables To add a cell reference from a different worksheet into an existing formula with your keyboard, you should follow the following steps: - ANSWERS1. Hit F2 to get into the existing formula; delete ...

=ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(start_date,End_date,Basis) - ANSWER-YEARFRAC Function =DATE(year, month, day) - ANSWER-DATE Function =DAY(Serial Number) - ANSWER-DAY Function

What is the keyboard shortcut to freeze panes within a worksheet? - ANSWER-Alt W F F Please select the answer that best describes the shortcut to Split (not freeze) an excel sheet into just two panes (top and bottom) To navigate from pane to pane - ANSWER-1. With the active cell on any row but in column A, hit Alt W S to split the panes to a top and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit F6 several times to get from one pane to the other)...

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - ANSWER-Alt h i w What is a keyboard shortcut to open a file?` - ANSWER-Ctrl o What is the recommended workbook calculation setting for Excel? - ANSWER-Automatic Except for Data Tables To add a cell reference from a different worksheet into an existing formula with your keyboard, you should follow the following steps: - ANSWER-1. Hit F2 to get into the existing formula; delete ...

Add/delete sheets - ANSWERSalt-i-w OR alt h-i-s Moving around task ribbon - ANSWERSTab and shift (to select) Auto fit cell - ANSWERSalt-h-o-i Custom fit columns - ANSWERSalt h-o-w Custom fit rows - ANSWERSalt h-o-h Select entire column/row - ANSWERSctrl shift-arrow key Format cells - ANSWERSctrl 1 Paste special - ANSWERSalt e-s Freeze panes - ANSWERSalt w-f-f Split panes - ANSWERSalt w-s

Keyboard Versus the Mouse - ANSWER-Almost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel using only the keyboard Name Box - ANSWER-Tells you what cell you are in (top left below the ribbon) Formula Bar - ANSWER-When you insert a formula into a cell and hit return, the cell will show you the output The formula bar, however, will show you the formula Next to "fx" right b...