Front | Back |
A group of cells that touch each other and form a rectangle is a ____.
|
A group of cells that touch each other and form a rectangle is a Range
|
To edit data in a cell, select the cell and press the ___ key, referred to as the Edit key.
|
To edit data in a cell, select the cell and press the F2 key, referred to as the Edit key.
|
You would use the ___ to copy a cell's format to another cell.
|
You would use the Format Painter to copy a cell's format to another cell.
|
Formats that have already been created within Excel are called ___.
|
Formats that have already been created within Excel are called Auto Formats.
|
Data stored on the ___ will remain until it is replaced with new data.
|
Data stored on the Clipboard will remain until it is replaced with new data.
|
The drag-and-drop method is the same for moving data as it is for copying data except that you do not hold down the ___ key.
|
The drag-and-drop method is the same for moving data as it is for copying data except that you do not hold down the Ctrl key.
|
To add a cell, row, or column to a worksheet, you should use commands on the ___ menu.
|
To add a cell, row, or column to a worksheet, you should use commands on the Insert menu.
|
Frozen rows are indicated by a darkened ___ that separatesthe frozen and unfrozen areas.
|
Frozen rows are indicated by a darkened gridline that separatesthe frozen and unfrozen areas.
|
Suppose that the value in B3 is equal to 3 and the value in C4 is 4. Whichof the following formulas would display the value of 3?
|
=B3*(C3+4)
|
Suppose that the value in B3 is equal to 12 and the value in C3 is 3. Whichof the following formulas would display the value of 3?
|
=B3/(C3+1)
|
The ___ function is the most frequently used type of function formula.
|
The Sum function is the most frequently used type of function formula.
|
Press__ to switch between displaying formulas and displaying values.
|
Press Ctrl+ to switch between displaying formulas and displaying values.
|
The ___ function determines the payment needed each period to repay a loan.
|
The PMT function determines the payment needed each period to repay a loan.
|
The ___ function displays the data or time based on the computers clock.
|
The Now function displays the data or time based on the computers clock.
|
The ___ functions will display today's data in a worksheet.
|
The Now functions will display today's data in a worksheet.
|