Harvard Spreadsheet Modeling EXAM (updated
2026) Questions & Answers | Latest Already
Graded A+
Save
Practice questions for this set
Learn 1 /7 Study with Learn
formula to return our percentage penalty. We will show how either the INT
function or ROUNDDOWN function can be used to solve this problem.
Choose an answer
1 Ctrl-Home 2 =VLOOKUP
3 control c 4 Alt-Page Up
Don't know?
Terms in this set (104)
,Ctrl-Home Selects cell A1
Ctrl-End Selects the cell at the intersection of the last-used
column and last-used row on the worksheet
Page Up Scrolls up one screen
Page Down Scrolls down one screen
Alt-Page Up Scrolls left one screen
Alt-Page Down Scrolls right one screen
Ctrl-Page Up Selects the previous worksheet
Ctrl-Page Down Selects the next worksheet
Ctrl-Tab Moves to the next open Excel workbook
ALT key on a mac Option key
Ctrl-Home on mac CONTROL + FN + LEFT ARROW
Ctrl-END on mac CONTROL + FN + RIGHT ARROW
control c copy
control v paste
control A select all
, F8 Extend a selection, works like Select All
SHIFT down selecting a range of cells
control shift asterisk selects all data in the sheet
F5 Goes to a dialogue box
Mac is control + G
This feature allows you to shade the boxes which
could contain blank cells
Reduces human error
Selection with centering text You can center the text across multiple columns by:
Writing text
Format Cells
Center Across Selection
what does each formula start with in =
excel?
$ sign before a letter $ sign before the number in a cell reference
ensures that when we copy the formula, the
column reference remains unchanged
Flash fill Flash fill allows excel to find patterns.
For example, in a list of full length names, the
computer will recognize that you only want the last
name after entering the last names of the first two
people in the list.
It will also work if you want to make an email list
and take the last name of the person and add
"@bakery.com"
2026) Questions & Answers | Latest Already
Graded A+
Save
Practice questions for this set
Learn 1 /7 Study with Learn
formula to return our percentage penalty. We will show how either the INT
function or ROUNDDOWN function can be used to solve this problem.
Choose an answer
1 Ctrl-Home 2 =VLOOKUP
3 control c 4 Alt-Page Up
Don't know?
Terms in this set (104)
,Ctrl-Home Selects cell A1
Ctrl-End Selects the cell at the intersection of the last-used
column and last-used row on the worksheet
Page Up Scrolls up one screen
Page Down Scrolls down one screen
Alt-Page Up Scrolls left one screen
Alt-Page Down Scrolls right one screen
Ctrl-Page Up Selects the previous worksheet
Ctrl-Page Down Selects the next worksheet
Ctrl-Tab Moves to the next open Excel workbook
ALT key on a mac Option key
Ctrl-Home on mac CONTROL + FN + LEFT ARROW
Ctrl-END on mac CONTROL + FN + RIGHT ARROW
control c copy
control v paste
control A select all
, F8 Extend a selection, works like Select All
SHIFT down selecting a range of cells
control shift asterisk selects all data in the sheet
F5 Goes to a dialogue box
Mac is control + G
This feature allows you to shade the boxes which
could contain blank cells
Reduces human error
Selection with centering text You can center the text across multiple columns by:
Writing text
Format Cells
Center Across Selection
what does each formula start with in =
excel?
$ sign before a letter $ sign before the number in a cell reference
ensures that when we copy the formula, the
column reference remains unchanged
Flash fill Flash fill allows excel to find patterns.
For example, in a list of full length names, the
computer will recognize that you only want the last
name after entering the last names of the first two
people in the list.
It will also work if you want to make an email list
and take the last name of the person and add
"@bakery.com"
