Spreadsheet Fundamentals
Navigating & Formatting
Sheet & Row Management
Formulas & References
Real-World Math Challenge
100

What are the thousands of small grid rectangles that make up a worksheet called?

Cells

100

Which feature on the Home Tab combines multiple highlighted cells into one larger single cell?

Merge & Center

100

What keyboard shortcut opens the Find feature on the Home Tab?

Ctrl + F

100

What special character ($) is used to create an absolute cell reference?

Dollar Sign ($)

100

In Excel, what math symbol is used to perform multiplication in formulas?

Asterisk (*)

200

Name two of the three primary items that a single cell can store.

Functions, Formulas, or Text

200
Name two of the three ways text can be aligned vertically within a cell.

Top, Middle, or Bottom

200
How do you reorder/ move a worksheet tab to a new position along the bottom bar?

Left-click and drag the sheet tab to the desired position

200

Why would a user choose to use an absolute cell reference like "$A$1" instead of a relative reference like "A1"?

To keep the cell reference from changing when copying the formula to another cell

200

Write the decima; equivalent of an 8.5% sales tax rate to use in an Excel calculation.

0.085

300

True or False: An Excel workbook can contain multiple worksheets.

True

300

True or False: You can AutoFit the width of multiple columns at the exact same time.

True

300

Name two of the four action buttons available inside the Find and Replace dialog box.

Find, Replace, Find All or Replace All

300

What type of cell reference automatically adjusts its row and column coordinates based on where it is copied?

Relative References

300

Why are parentheses necessary around addition when calculating sales tax on multiple items, such as =(A7+A8)*0.085?

To force Excel to calculate the total price sum before multiplying by the tax rate (Order of Operations)

400
True or False: Excel contains less than 50 total built-in functions.

False

400

How do you change the color of a worksheet tab at the bottom of your screen?

Right-click the sheet tab, hover over Tab Color, and pick a color from the palette.

400

If you want to insert a brand new row between Row 8 and Row 9, which row heading must you select before right-clicking to insert?

Row 9

400

If the formula "=B7+C7" in cell "D7" is coped 2 rows down to cell "D9", what does the new formula become?

=B9+C9

400

You buy 4 items listed in cells A7 ($5.00), A8 ($7.00), A9 ($2.00), and A10 ($1.00). Write the exact formula to calculate the 8.5% sales tax for all 4 items combined.

=(A7+A8+A9+A10)*.085

                   or 

=(A7+A8+A9+A10)*0.085

500

What symbol is placed inside a formula to denote a range of connected cells, such as from cell A1 through A5?

Colon

500

True or False: When building a formula, you are required to manually type out cell addresses and cannot click on cells directly.

False, you can click directly on cells to select them in formulas.

500

When copying a worksheet, what checkbox in the "Move or Copy..." window must be checked so you don't accidentally move the original file?

Create a copy

500
What would happen to the formula "=$B$7+$C$7" if copied from cell "D7" down to cell "D9"?

Its stays strictly (=$B$7+$C$7)

500

Based on the 4 items above (totaling $15.00), what is the calculated sales tax amount?

$1.275 (or $1.28 rounded)

M
e
n
u