Excel Basics - Wall Street Prep Questions And Answers
With Verified Solutions 100% Correct (Graded A+) Latest
Update 2024/2025.
Create new sheet - ANSWER ctrl i w
switch between sheets - ANSWER ctrl page up / ctrl page down
access anything on the ribbon - ANSWER atl
toggle between excel books - ANSWER ctrl tab
open new file - ANSWER ctrl o
bold - ANSWER ctrl b
options - ANSWER alt f t
auto size cell - ANSWER alt h o i
designate width of box - ANSWER alt h o w
highlight column - ANSWER ctrl space
highlight row - ANSWER shift space
undo - ANSWER ctrl z
redo - ANSWER ctrl y
formatting - ANSWER ctrl 1
highlight all columns next - ANSWER ctrl shift > / <
paste special - ANSWER alt e s
zoom in / out - ANSWER alt v z
freeze pane - ANSWER alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the
worksheet scrolls.
split pane - ANSWER alt w s
hop between panes - ANSWER F6
go inside cell to see functions - ANSWER F2
go inside cell to clear specific info - ANSWER ALT h e
input comment - ANSWER Shift F2
, Fill Highlighted Area Right / Down - ANSWER ctrl r / ctrl d
Input New Row - ANSWER ALT i r
input new column - ANSWER alt i c
deleting columns / rows - ANSWER ALT H D R / ALT H D C
Paste Special Formatting - ANSWER ALT E S T
Trace Precedents - ANSWER ATL M P / (delete it ALT M A A) allows you to see which cells are
referenced in a particular formula or function
Trace Dependents - ANSWER ALT M D
find and replace - ANSWER ctrl h
IF - ANSWER criteria, output if true, output if false
IF(AND( - ANSWER IF(AND(first test, 2nd test), output is true, output if false)
Date function - ANSWER (year,month,day) but if you do DATE(Year(cell w/ date to reference)+1,
Month(cell w/ date), Day(cell with date)) makes easier to drag out a list of dates increasing each year by
1
YearFrac - ANSWER Start, End, Basis (Basis = 0 or omitted = 30/360, 1 = actual / actual, 2 =
actual over / 360, 3 = actual / 365) _____ is a function that will return the number of years between two
dates.
HLookup - ANSWER (look up value, table range, row number) - searches for a value in the top
row of a table or an array of values, and then returns a value in the same column from a row you specify
in the table or array - use HLOOKUP when your comparison values are located in row across the top of a
table of data, and you want to look a specified number of rows.
Vlookup - ANSWER (look up value, table range, column number) - searches for a value in the
leftmost column of a table, and then returns a value in the same row from a column you specify in the
table or array - use VLOOKUP when you comparison values are located in a column to the left of a table
of data, and you want to look across (and to the right) a specified number of columns) *if looking up
words add a 4th value as 0 aka (look up value, table range, column number, 0)
MATCH - ANSWER (look up value, lookup array, match type) - returns the relative position
(number) of an item in an array that matches specified look up value. Best when combing this function
w/ HLOOKUP, VLOOKUP, OFFSET, INDEX, CHOOSE to make formulas more durable and dynamic.
Create Drop Down Menu - ANSWER ALT + D L
OFFSET - ANSWER reference point (make above top left data), rows, columns
Input Data Table - ANSWER Highlight Table
ALT D T
Vertical Table (No Row Input Needed)
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 Amazingsirpaul. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.79. You're not tied to anything after your purchase.
