Exam (elaborations)
Excel Crash Course Exam
- Course
- Institution
- Book
Excel Crash Course Exam
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
More summaries for
-
Excel Crash Course Exam
Seller
Follow
morrismuriithi009
Content preview
Excel Crash Course Exam from Wall Street Prep - Wall StreetPrep Questions And Answers Updated 2022
Auto-width columns to fit the size - ANSWER: Alt + H + O + I
Define width of columns - ANSWER: Alt + H + O + W
Rename a worksheet - ANSWER: ALT + H + O + R
Add worksheet - ANSWER: Alt + H + I + S
Freeze and unfreeze panes - ANSWER: Alt + W + F + F
Split pane - ANSWER: Alt + W + S
Jump from split pane to split pane - ANSWER: F6
To navigate outside the cell when in formula - ANSWER: F2
Add comment - ANSWER: Alt + N + C2
Delete Row/Column - ANSWER: Ctrl -
Add row - ANSWER: Ctrl + Shift + +
Paste special - ANSWER: Alt + E + S or Ctrl + Alt + V
Transpose - ANSWER: Alt + E + S + E
How to get to date format "April-24" - ANSWER: Go to Ctrl + 1, then Custom, then
select mm-yy
Remove all borders - ANSWER: Ctrl + Shift + _
Trace precedents - ANSWER: Alt + M + P
Trace dependents - ANSWER: Alt + M + D
Remove arrows - ANSWER: Alt + M + A
How to format inputs/hardcodes blue - ANSWER: Go to special (Ctrl + G), then
Custom, select Constants and format text blue
Go to special - ANSWER: Ctrl + G
Conditional formatting - ANSWER: Alt + O + D or Alt + H + L
, Custom formatting formula syntax - ANSWER: [positive number format; negative
number format, 0 format]
How to out text after a number in custom formatting - ANSWER: Use quote marks
How to align positive numbers with negative numbers in custom formats - ANSWER:
Put a ) after the positive number format, it will appear as a space
Zoom in and out - ANSWER: Ctrl + Alt + +/-
In custom formatting, what should you use instead of 0s to ensure commas only
appear in the thousands - ANSWER: #
What function is the same as EOMONTH but for a specific date? - ANSWER: EDATE
How to output different things depending on if there's text or numbers in a cell -
ANSWER: IF + ISTEXT functions
Function to turn things into a date - ANSWER: DATE
When to use HLOOKUP - ANSWER: When your comparison values are all in a row
across the top of the data table, and you want to look down a specified number of
rows
When to use a VLOOKUP - ANSWER: When your comparison values are located in a
col to the left of a data table and you want to look across a specified number of
columns
INDEX - ANSWER: allows you to pinpoint a location of a return value in an array
CHOOSE - ANSWER: allows you to choose which value in a set of values
OFFSET - ANSWER: instead of selecting a whole array, you select a reference point
which is usually the top left hand corner of the array or above the column if only one
column. Then select rows and columns as numbers across and down from the
reference point
MATCH - ANSWER: returns the relative position (number) of an item in an array that
matches a specified value
Where should the MATCH lookup array start when combined with OFFSET? -
ANSWER: Start at the OFFSET reference point and -1 after the MATCH function
INDIRECT - ANSWER: returns whatever is in a cell, but when combined with &
becomes a powerful way to dynamically sum a range with certain criteria
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
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 morrismuriithi009. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75759 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now