Excel crash stuvia - Study guides, Class notes & Summaries

move back and forth between the worksheets in a workbook - ANSWER-*Ctrl PageUp* or *Ctrl PageDown* open a file - ANSWER-*alt f o* *ctrl o* save a file - ANSWER-*alt f s* *ctrl s* print a file - ANSWER-*alt f p* *ctrl p* navigating to the toolbars without the mouse - ANSWER-hit *Alt and the appropriate letter* (or use the right/left arrow keys) to get to the desired tab once there, use the Tab and Shift Tab keys to navigate around accessing settings - ANSWER-File > ...

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w Incorrect - ANSWER-Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a workbook. Alt h i w is not a valid shortcut. What is a keyboard shortcut to open a file? Ctrl o Ctrl f Alt o Ctrl n - ANSWER-The correct answer is Ctrl o. Ctrl f is the shortcut to find, or find and repl...

Average Function - ANSWER-Definition: An Excel function that adds a group of values, and then divides the result by the number of values in the group. IF Statement Function - ANSWER-Definition: A function that returns one value when a condition you specify evaluates to true and a different value if it evaluates to false. Explanation: First you begin with the logical test for the function, and then provide the value the function should output if the logical test is evaluated to true, and last...

Keyboard Versus the Mouse - ANSWERSAlmost 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 - ANSWERSTells you what cell you are in (top left below the ribbon) Formula Bar - ANSWERSWhen 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...

=AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(start_date,months) - ANSWER-EOMONTH Function =EDATE(start date,months) - ANSWER-EDATE Function =ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(sta...

If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same width across all the worksheets in my workbook, how would I do that? - ANSWER-1. Group the worksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In the active sheet type in "Company Financials" in A1 and apply the desired width to all columns 3. Remember to hit Ctrl Pageup or Pagedown to make sure that future edits only apply to active sheet. What is the key...

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 ...

manipulating data inside a cell - ANSWER-*F2* is the command that puts you inside a cell: -pressing the F2 key once shows you the components of the formula you created earlier, puts you inside a cell and enables you to navigate through it to edit the existing cell data -pressing the F2 key twice activates the cursor and enables you to move to different cells, worksheets, and even other open Excel files *Shift arrow key* will highlight characters one at a time *Shift Ctrl arrow key* will ...

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w Incorrect - ANSWERSAlt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a workbook. Alt h i w is not a valid shortcut. What is a keyboard shortcut to open a file? Ctrl o Ctrl f Alt o Ctrl n - ANSWERSThe correct answer is Ctrl o. Ctrl f is the shortcut to find, or find and repl...

Explanation: Start by inputting the start_date into the first argument. Then input how many months ahead or behind you would like to go from that start_date. EDATE Function - ANSWER-Definition: Similar to EOMONTH but this return the exact date from the start-date, after the specified number of months. Explanation: Start by inputting the start_date into the first argument. Then input how many months ahead or behind you would like to go from that start_date. ISNUMBER Function - ANSWER-Defin...