Technology Exam

For Vero Beac h High S

40 cards   |   Total Attempts: 184
  

Cards In This Set

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.