(NEWEST) HARVARD SPREADSHEET MODELING TEST QUESTIONS AND
CORRECT ANSWERS
Cell A1 is chosen by pressing Ctrl-Home-ANSWER.
The cell at the intersection of the worksheet's last-used row and last-used
column is selected by pressing Ctrl-End-ANSWER.
Page Up: ANSWER Moves the cursor up one screen.
Page Down: ANSWER moves one screen down.
Alt-Page Up: ANSWER Scrolls one screen to the left
Alt-Page Down: ANSWER moves the screen to the right.
The previous worksheet can be selected by using Ctrl-Page Up.
The next worksheet is chosen by pressing Ctrl-Page Down.
Ctrl-Tab-ANSWER opens the next Excel workbook.
On a Mac, the ANSWER Option key is the ALT key.
On a Mac, Ctrl-Home is ANSWER CONTROL + FN + LEFT ARROW.
On a Mac, press Ctrl-END (ANSWER CONTROL + FN + RIGHT ARROW).
control c: copy of the answer
paste control v-ANSWER
control A-ANSWER chooses everything
F8-ANSWER Extend a choice, similar to Select All
SHIFT down: ANSWER chooses a selection of cells
, All of the data in the sheet is selected using the control shift asterisk
(ANSWER).
F5.
Control + G on a Mac opens a conversation window.
You can use this functionality to tint the boxes that might contain blank cells.
minimizes human error
Selection with text centering: ANSWER The text can be centered across several
columns by:
Creating text
Cell Format
Center Across the Selection
What is the beginning of each Excel formula? ANSWER =
$ sign before a letter - ANSWER $ sign before a cell reference guarantees that
the column reference stays the same when we copy the formula.
ANSWER Flash fill enables Excel to identify patterns.
When you enter the last names of the first two individuals in a list of full-length
names, for instance, the computer will understand that you just want the last
name.
It will also function if you wish to create an email list and add "-bakery.com"
along with the person's last name.
Sorting variables in formulas: ANSWER To give an input into a formula
including another variable a name (e.g., Chicago, 200),
The columns you choose to categorize can be highlighted.
press the formula tab,
then produce based on selection
In the small finders window located in the upper left corner of the worksheet,
200 should now be classified as Chicago.
Name Manager - ANSWER Name Manager allows you to change, remove, and
substitute range names.
CORRECT ANSWERS
Cell A1 is chosen by pressing Ctrl-Home-ANSWER.
The cell at the intersection of the worksheet's last-used row and last-used
column is selected by pressing Ctrl-End-ANSWER.
Page Up: ANSWER Moves the cursor up one screen.
Page Down: ANSWER moves one screen down.
Alt-Page Up: ANSWER Scrolls one screen to the left
Alt-Page Down: ANSWER moves the screen to the right.
The previous worksheet can be selected by using Ctrl-Page Up.
The next worksheet is chosen by pressing Ctrl-Page Down.
Ctrl-Tab-ANSWER opens the next Excel workbook.
On a Mac, the ANSWER Option key is the ALT key.
On a Mac, Ctrl-Home is ANSWER CONTROL + FN + LEFT ARROW.
On a Mac, press Ctrl-END (ANSWER CONTROL + FN + RIGHT ARROW).
control c: copy of the answer
paste control v-ANSWER
control A-ANSWER chooses everything
F8-ANSWER Extend a choice, similar to Select All
SHIFT down: ANSWER chooses a selection of cells
, All of the data in the sheet is selected using the control shift asterisk
(ANSWER).
F5.
Control + G on a Mac opens a conversation window.
You can use this functionality to tint the boxes that might contain blank cells.
minimizes human error
Selection with text centering: ANSWER The text can be centered across several
columns by:
Creating text
Cell Format
Center Across the Selection
What is the beginning of each Excel formula? ANSWER =
$ sign before a letter - ANSWER $ sign before a cell reference guarantees that
the column reference stays the same when we copy the formula.
ANSWER Flash fill enables Excel to identify patterns.
When you enter the last names of the first two individuals in a list of full-length
names, for instance, the computer will understand that you just want the last
name.
It will also function if you wish to create an email list and add "-bakery.com"
along with the person's last name.
Sorting variables in formulas: ANSWER To give an input into a formula
including another variable a name (e.g., Chicago, 200),
The columns you choose to categorize can be highlighted.
press the formula tab,
then produce based on selection
In the small finders window located in the upper left corner of the worksheet,
200 should now be classified as Chicago.
Name Manager - ANSWER Name Manager allows you to change, remove, and
substitute range names.
