©FYNDLAY 2024/2025 ALL RIGHTS RESERVED 2:49PM A+
Excel Basics - Wall Street Prep
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.
1
, ©FYNDLAY 2024/2025 ALL RIGHTS RESERVED 2:49PM A+
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
2
Excel Basics - Wall Street Prep
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.
1
, ©FYNDLAY 2024/2025 ALL RIGHTS RESERVED 2:49PM A+
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
2
