10/9/24, 11:03 AM EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET PREP QUESTIONS AND ANSWERS UPDA…
EXCEL CRASH COURSE EXAM FROM WALL
STREET PREP - WALL STREET PREP QUESTIONS
AND ANSWERS UPDATED 2024/ GET IT 100%
ACCURATE!!
Terms in this set (36)
All of the following are Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all
keyboard shortcut that keyboard shortcuts for adding more sheets to a
allow the user input to workbook.
add more sheets to a Alt h i w is not a valid shortcut.
workbook EXCEPT:
Alt i w
Alt h i s
Shift F11
Alt Shift F1
Alt h i w
Incorrect
What is a keyboard The correct answer is Ctrl o.
shortcut to open a file? Ctrl f is the shortcut to find, or find and replace, text
Ctrl o on the worksheet. Alt o is not a command. Ctrl n is
Ctrl f the shortcut to open a new workbook.
Alt o
Ctrl n
,10/9/24, 11:03 AM EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET PREP QUESTIONS AND ANSWERS UPDA…
The correct answer is "Automatic except for Data
Tables".
What is the
Data tables can significantly slow down Excel and
recommended workbook
other programs. "Automatic", the default setting, will
calculation setting for
automatically calculate everything in the workbook,
Excel?
including data tables, which will make the program
Automatic
run more slowly. The Manual setting will require the
Manual
user to frequently recalculate the workbook in order
Automatic except for
to display correctly. "Iterate" is not a setting for
Data Tables
workbook calculation in Excel; iterative calculation
Iterate
is a toggle for users to set for workbooks that may
have circular calculations.q
, 10/9/24, 11:03 AM EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET PREP QUESTIONS AND ANSWERS UPDA…
To add a cell reference The correct answer is:
from a different Hit F2 to get into the existing formula; delete any
worksheet into an incorrect formulas or operators
existing formula with your Hit F2 again to enable "Enter" mode on the bottom-
keyboard, you should left corner of the Excel sheet
follow the following Holding down Ctrl, use PageUp or PageDown to
steps: find the desired worksheet
1. Hit F2 to get into the Let go of the Ctrl and PageUp/Down keys
existing formula; delete Use the arrow keys to locate the desired cell
any incorrect formulas or reference
operators 2. Hit F2 again Hit Enter
to enable "Enter" mode In the incorrect option, 3. Alt Page Up / Down will
on the bottom-left not allow the user to navigate to a different
corner of the Excel sheet worksheet; 6. Hit Escape will not save any cell
3. Holding down Ctrl, use references, but will delete any new data or formula
PageUp or PageDown to that has been entered into the cell.
find the desired
worksheet 4. Let go of
the Ctrl and
PageUp/Down keys 5.
Use the arrow keys to
locate the desired cell
reference 6. Hit Enter
1. Hit F2 to get into the
existing formula; delete
any incorrect formulas or
operators 2. Hit F2 again
to enable "Enter" mode
on the bottom-left
corner of the Excel sheet
3. Holding down Alt, use
PageUp or PageDown to
find the desired
worksheet 4. Let go of
the Ctrl and
PageUp/Down keys 5.
Use the arrow keys to
locate the desired cell
reference 6. Hit Escape
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MEGAMINDS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.99. You're not tied to anything after your purchase.
