| A | B |
|---|
| Unless you specify otherwise text you enter in a cell are aligned to the ______. | Left |
| ____ enables you to copy formatting from one worksheet cell to another without copying the cell’s contents. | Format Painter |
| Unless you specify otherwise number you enter in a cell are aligned to the _____. | Right |
| Number ____ change the way data looks in a cell. | Formats |
| When you ____ the row height increases automatically to display additional lines until all the text is visible. | Wrap text |
| A symbol that indicates the type of calculation to perform. | Operator |
| Cell reference that contain both relative and absolute references. | Mixed cell reference |
| Does not change when copied or moved to a new cell. | Absolute cell reference |
| Adjusts to its new location when copied or moved. | Relative cell reference |
| A constant (text or number) or cell reference used in a formula. | Operand |
| The sequence used to calculate the value of a formula is called the ____. | Order of evaluation |
| On the Home tab of the Ribbon the ____ group includes buttons for inserting and deleting rows columns and cells. | Cells |
| You can switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys. | Ctrl+` (grave accent) |
| If you want to specify a precise column width use the Column Width ____. | Dialog box |
| The name of each worksheet appears in the ____ at the bottom of the worksheet window. | Sheet tab |
| As you format cells ____ shows the results of the different formatting options you can choose. | Live Preview |
| Which of the following is not a type of cell reference? | Relational |
| Click the Ctrl+C keys to ____ selected cells. | Copy |
| The ____ consists of the cells and ranges designated for printing. | Print Area |
| ____ copies a cell’s contents and/or formatting into an adjacent cell or range. | Filling |
| The formula = B3^3 is an example of a(n) ____ operation. | Exponentiation |
| Worksheet users frequently need to add long columns or rows of numbers. The ____ button makes this operation simple. | Sum |
| Click the Ctrl+V keys to ____ selected cells. | Paste |
| The formula = E6/4 is an example of a(n) ____ operation. | Division |
| Click the Ctrl+X keys to ____ selected cells. | Cut |
| When inserting rows or columns in a worksheet if you select more than one row or column the same number of rows or columns you selected are ____ in the worksheet. | Inserted |
| When you print the Rows and/or columns in a worksheet that are shown on each page are called Print ______. | Titles |
| The formula =4*D5 is an example of a(n) ____ operation. | Multiplication |
| The equation used to calculate values in a cell is called a _______. | Formula |
| A group of selected cells is called a(n) ____________________. | Range |
| When you ____ panes you select which rows and/or columns of the worksheet remain visible on the screen as the rest of the worksheet scrolls. | Freeze |
| When formulas with mixed cell references are copied or moved the row or column references preceded by a ____ do not change. | Dollar Sign |
| Each formula begins with a/an_______. | Equal Sign |
