Study guides, Class notes & Summaries

Excel Crash Course Exam from Wall Street Prep - Wall Street Prep Questions And Answers Updated 2022

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

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

EXCEL CRASH COURSE EXAM QUESTIONS AND CORRECT ANSWERS | 2024 UPDATE | 100% CORRECT

EXCEL CRASH COURSE EXAM QUESTIONS AND CORRECT ANSWERS | 2024 UPDATE | 100% CORRECT

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

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

EXCEL CERTIFICATION EXAM QUESTIONS WITH CORRECT ANSWERS

CFI ASSESSMENT QUESTIONS SAND ANSWERS