What are the thousands of small grid rectangles that make up a worksheet called?
Cells
Which feature on the Home Tab combines multiple highlighted cells into one larger single cell?
Merge & Center
What keyboard shortcut opens the Find feature on the Home Tab?
Ctrl + F
What special character ($) is used to create an absolute cell reference?
Dollar Sign ($)
In Excel, what math symbol is used to perform multiplication in formulas?
Asterisk (*)
Name two of the three primary items that a single cell can store.
Functions, Formulas, or Text
Top, Middle, or Bottom
Left-click and drag the sheet tab to the desired position
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
Write the decima; equivalent of an 8.5% sales tax rate to use in an Excel calculation.
0.085
True or False: An Excel workbook can contain multiple worksheets.
True
True or False: You can AutoFit the width of multiple columns at the exact same time.
True
Name two of the four action buttons available inside the Find and Replace dialog box.
Find, Replace, Find All or Replace All
What type of cell reference automatically adjusts its row and column coordinates based on where it is copied?
Relative References
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)
False
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.
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
If the formula "=B7+C7" in cell "D7" is coped 2 rows down to cell "D9", what does the new formula become?
=B9+C9
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
What symbol is placed inside a formula to denote a range of connected cells, such as from cell A1 through A5?
Colon
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.
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
Its stays strictly (=$B$7+$C$7)
Based on the 4 items above (totaling $15.00), what is the calculated sales tax amount?
$1.275 (or $1.28 rounded)