Harvard Spreadsheet Modeling EXAM (updated
2025) Questions & Answers|| LATEST UPDATE
2025/26
Ctrl-Home -CORRECT ANSWER Selects cell A1
Ctrl-End -CORRECT ANSWER Selects the cell at the intersection of the last-used column
and last-used row on the worksheet
Page Up -CORRECT ANSWER Scrolls up one screen
Page Down -CORRECT ANSWER Scrolls down one screen
Alt-Page Up -CORRECT ANSWER Scrolls left one screen
Alt-Page Down -CORRECT ANSWER Scrolls right one screen
Ctrl-Page Up -CORRECT ANSWER Selects the previous worksheet
Ctrl-Page Down -CORRECT ANSWER Selects the next worksheet
Ctrl-Tab -CORRECT ANSWER Moves to the next open Excel workbook
,ALT key on a mac -CORRECT ANSWER Option key
Ctrl-Home on mac -CORRECT ANSWER CONTROL + FN + LEFT ARROW
Ctrl-END on mac -CORRECT ANSWER CONTROL + FN + RIGHT ARROW
control c -CORRECT ANSWER copy
control v -CORRECT ANSWER paste
control A -CORRECT ANSWER select all
F8 -CORRECT ANSWER Extend a selection, works like Select All
SHIFT down -CORRECT ANSWER selecting a range of cells
control shift asterisk -CORRECT ANSWER selects all data in the sheet
F5
Mac is control + G -CORRECT ANSWER Goes to a dialogue box
, This feature allows you to shade the boxes which could contain blank cells
Reduces human error
Selection with centering text -CORRECT ANSWER You can center the text across
multiple columns by:
Writing text
Format Cells
Center Across Selection
what does each formula start with in excel? -CORRECT ANSWER =
$ sign before a letter -CORRECT ANSWER $ sign before the number in a cell reference
ensures that when we copy the formula, the column reference remains unchanged
Flash fill -CORRECT ANSWER 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"
Categorizing variables in formulas -CORRECT ANSWER To assign a name to input into a
formula with another variable (ex: Chicago, 200),
2025) Questions & Answers|| LATEST UPDATE
2025/26
Ctrl-Home -CORRECT ANSWER Selects cell A1
Ctrl-End -CORRECT ANSWER Selects the cell at the intersection of the last-used column
and last-used row on the worksheet
Page Up -CORRECT ANSWER Scrolls up one screen
Page Down -CORRECT ANSWER Scrolls down one screen
Alt-Page Up -CORRECT ANSWER Scrolls left one screen
Alt-Page Down -CORRECT ANSWER Scrolls right one screen
Ctrl-Page Up -CORRECT ANSWER Selects the previous worksheet
Ctrl-Page Down -CORRECT ANSWER Selects the next worksheet
Ctrl-Tab -CORRECT ANSWER Moves to the next open Excel workbook
,ALT key on a mac -CORRECT ANSWER Option key
Ctrl-Home on mac -CORRECT ANSWER CONTROL + FN + LEFT ARROW
Ctrl-END on mac -CORRECT ANSWER CONTROL + FN + RIGHT ARROW
control c -CORRECT ANSWER copy
control v -CORRECT ANSWER paste
control A -CORRECT ANSWER select all
F8 -CORRECT ANSWER Extend a selection, works like Select All
SHIFT down -CORRECT ANSWER selecting a range of cells
control shift asterisk -CORRECT ANSWER selects all data in the sheet
F5
Mac is control + G -CORRECT ANSWER Goes to a dialogue box
, This feature allows you to shade the boxes which could contain blank cells
Reduces human error
Selection with centering text -CORRECT ANSWER You can center the text across
multiple columns by:
Writing text
Format Cells
Center Across Selection
what does each formula start with in excel? -CORRECT ANSWER =
$ sign before a letter -CORRECT ANSWER $ sign before the number in a cell reference
ensures that when we copy the formula, the column reference remains unchanged
Flash fill -CORRECT ANSWER 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"
Categorizing variables in formulas -CORRECT ANSWER To assign a name to input into a
formula with another variable (ex: Chicago, 200),
