The Basics
This is the box where you type data in Excel
What is a cell
This formatting option makes the text darker and thicker so it stands out. Often used for titles and labels
What is bold
In Excel, every formula must begin with this symbol
What is an equal sign
What key can you hit to remove the contents of a cell?
What is the delete key
This type of cell reference changes automatically when a formula is copied to another cell
What is a relative cell reference
This is a horizonatal line of cells in Excel
What is a row
This formatting style adds a dollar sign and two decimal places to numbers.
What is currency
This simple formula adds the values in cells B4 and B5.
What is =B4+B5
This command has a shortcut of control c
What is copy
This type of cell reference uses dollar signs (like $A$1) to remain constant when copied.
What is an absolute cell reference
This is a vertical line of cells in Excel
What is a column
This is a little arrow found in the lower-right of a group that displays more related commands
What is dialog launcher
This simple formula finds the difference between Budgeted net pay in cell B3 and Actual net pay in cell C3.
What is =B3-C3
This command allows you to add a row or column into a worksheet
What is insert
When the formula =A1+B1 is copied from row 1 to row 2, it changes to what formula?
What is =A2+B2
This is the term for an Excel file that can contain multiple worksheets
What is a workbook
This formatting tool lets you place text on the left, center, or right side of a cell
What is alignment
This function (icon) quickly adds a range of numbers together
What is the backwards E or the Sum icon
This toolbar is customizable.
What is the Quick Access Toolbar
I the formula =$A$1*B2, this part of the formula will not change when copied.
What is $A$1
Multiple commands are appropriately subdivided into groups on this
What is a ribbon
What would you do to format how your data looks before printing?
Click on page setup
This formula adds all the numbers from cell A1 through A10.
=SUM(A1:A10)
This feature of a cell allows you to copy formulas in an entire column
What is a fill handle
This type of reference has either the row or the column fixed, but not both (example: A$1 or $A1)
What is a mixed cell reference