Question 1 of 40 2.5 Points
When you position the mouse pointer on the border of a selected cell or range, the mouse pointer becomes a(n):
A. border button.
B. flashing button.
C. arrow.
D. dashed outline.
Question 2 of 40 2.5 Points
The formula in cell A3 is =($A$1+$A$2). When this formula is copied from cell A3 to cell D4, what formula appears in cell D4?
A. =($A$1+D3)
B. =(D2+D3)
C. =(A1+$D$2)
D. =($A$1+$A$2)
Question 3 of 40 2.5 Points
The formula in cell A4 is =A2/A1. Cell A2 is then deleted. The result in A4 is:
A. 1.
B. not defined.
C. 0.
D. an error message.
Question 4 of 40 2.5 Points
Using the Delete command when a cell is selected will delete:
A. the content of the cell, but not its format.
B. the format of the cell, but not its content.
C. the cell from the worksheet.
D. only a formula that is in the cell.
Question 5 of 40 2.5 Points
When you copy or move data:
A. formulas are not copied.
B. cell contents, formats, and any comments are all transferred.
C. formats are not copied.
D. cell contents, formats, and any comments are reformatted.
Question 6 of 40 2.5 Points
When you insert a row in a worksheet, the new row goes _____________ the row containing the active cell.
A. below
B. above
C. to the left of
D. to the right of
Question 7 of 40 2.5 Points
A dashed-chase border around a cell indicates that the:
A. content of the cell has been deleted.
B. cell is active.
C. content of the cell has been Cut or Copied.
D. cell contains a function.
Question 8 of 40 2.5 Points
Which one of the following is NOT an option of the Delete command within the Edit menu?
A. Delete and shift cells left
B. Delete and shift cells up
C. Delete entire row
D. Delete entire worksheet
Question 9 of 40 2.5 Points
When you are working in Excel, pressing the __________ displays a list of shortcut commands.
A. functions key
B. right mouse button
C. INSERT key
D. DESTINATION key
Question 10 of 40 2.5 Points
A person using a right-handed mouse can display a context menu, or a list of shortcut commands by:
A. pressing the right mouse button.
B. pressing the left mouse button.
C. pressing both mouse buttons together.
D. holding down the left mouse button and then pressing the right mouse button.
Question 11 of 40 2.5 Points
Which one of the methods below CANNOT be used to copy data?
A. Dragging the selection to the new area
B. Using the mouse and the CTRL key to drag and copy
C. Using the Copy and Paste commands
D. Using the Cut and Paste commands
Question 12 of 40 2.5 Points
The __________ commands (or buttons) can be used to move cells to new locations.
A. Edit Delete
B. INSERT
C. SHIFT+ARROW
D. Cut and Paste
Question 13 of 40 2.5 Points
The formula in cell A3 is =(A1+A2). When this formula is copied from cell A3 to cell D4, what formula appears in cell D4?
A. =($A$1+D3)
B. =(D2+D3)
C. =(A1+$D$2)
D. =($A$1+$A$2)
Question 14 of 40 2.5 Points
Excel allows you to make cell addresses "absolute" so they will not be modified as they are copied from cell to cell. This is done by adding __________ to any cell address used in a formula.
A. $ (dollar sign)
B. % (percentage sign)
C. SHIFT+ARROW key
D. a mathematical operator
Question 15 of 40 2.5 Points
Which one of the following methods CANNOT be used to move data?
A. Dragging the selection to the new area
B. Using the Copy and Paste commands from the Edit menu on the Menu bar
C. Using the Cut and Paste commands from the Edit menu on the Menu bar
D. Using the Cut and Paste buttons on the Toolbar
Question 16 of 40 2.5 Points
Which statement below about data in an original cell is TRUE?
A. Both moving and copying delete data in the original cell location.
B. Neither moving nor copying data delete data in the original location.
C. Copying data deletes data in the original cell location, whereas moving data does not.
D. Moving data deletes data in the original cell location, whereas copying does not.
Question 17 of 40 2.5 Points
Which one of the following is an example of a cell with an absolute reference?
A. A1
B. $A$1
C. A1$
D. $A1$
Question 18 of 40 2.5 Points
The formula in cell A3 is =($A$1+A2). When this formula is copied from cell A3 to cell D4, what formula appears in cell D4?
A. =($A$1+D3)
B. =(D2+D3)
C. =(A1+$D$2)
D. =($A$1+$A$2)
Question 19 of 40 2.5 Points
The mouse can produce a list of shortcuts, or a context menu. In Excel, which one of the following shortcuts does NOT appear for an active cell?
A. Cut
B. Save
C. Paste
D. Copy
Question 20 of 40 2.5 Points
A mixed reference describes a cell:
A. for which the row is frozen or the column is frozen.
B. for which both the row and the column are frozen.
C. for which neither the row nor the column is frozen.
D. that contains both text and a numeric value.
Question 21 of 40 2.5 Points
There may be times when you want to hide the data in certain columns. This can be accomplished by selecting:
A. Select, Column, and Hide.
B. Select, Column, and Hide.
C. Format, Column, and Hide.
D. Format, Column, and Delete.
Question 22 of 40 2.5 Points
To view more than one worksheet at a time, select:
A. Window, Split.
B. Window, Arrange.
C. Tools, Arrange.
D. Tools, Split.
Question 23 of 40 2.5 Points
You can change the characteristics of __________ by selecting Style from the Format menu, or by changing the font box or the number format box on the Home tab, depending on your version of Excel.
A. just the current workbook
B. just the current worksheet
C. all workbooks
D. selected columns or rows in the current worksheet
Question 24 of 40 2.5 Points
Which one of the following CANNOT be used to name a cell or a range?
A. _ASSETS1
B. ASSETS_1
C. 1ASSETS
D. ASSETS.1
Question 25 of 40 2.5 Points
There are three types of underlining that are in common use: regular underlines, accounting underlines, and:
A. text underlines.
B. bottom borders.
C. financial borders.
D. mathematical underlines.
Question 26 of 40 2.5 Points
Which key allows you to move the cell pointer to a specific cell range on the worksheet by specifying a name as the destination?
A. F5
B. F7
C. Shift
D. F9
Question 27 of 40 2.5 Points
Normally, when you enter data in a cell and press the __________ key, the cell selector moves down to the next row.
A. Move Selection
B. HOME
C. RESET
D. ENTER
Question 28 of 40 2.5 Points
Column B in an Excel worksheet is labeled SELL_PRICE and column C is labeled TAXES. Cell D1 contains =SELL_PRICE + TAXES. When this formula is moved to D2, the result will be the value of cell:
A. B2 plus the value of cell C2.
B. B1 plus the value of cell C1.
C. B2 plus the value of cell C1.
D. B1 plus the value of cell C2.
Question 29 of 40 2.5 Points
Where you want more precise column width settings, use the Column command on the __________ menu, and select Width.
A. Format
B. Edit
C. Modify
D. Tools
Question 30 of 40 2.5 Points
Cell C1 of a worksheet contains the formula =A1 + B$1. The result of the formula is 100. The Copy command is then used to copy the formula to cell C4. Assuming cell A4 is empty, which one of the following will appear in cell C4?
A. The sum of cells A4 and B4
B. The contents of cell A1
C. The contents of cell B1
D. The contents of cell B4 10-14-03
Question 31 of 40 2.5 Points
The __________ command, found on the Window menu, enables you to view a duplicate of the current worksheet or worksheets from different workbooks.
A. Review
B. Tiled
C. Arrange
D. Active
Question 32 of 40 2.5 Points
Which one of the following statements about frozen columns and cells is TRUE?
A. Data in frozen cells cannot be changed.
B. A frozen cell can never be an active cell.
C. Information in frozen cells cannot be printed.
D. Information stays on the screen, regardless of which cell is active.
Question 33 of 40 2.5 Points
One difference between splitting and freezing a worksheet is that:
A. split columns/rows do not move; frozen columns/rows can move.
B. frozen columns/rows do not move; split columns/rows can move.
C. frozen columns/rows cannot be modified; split columns/rows can be modified.
D. split columns/rows cannot be modified; frozen columns/rows can be modified.
Question 34 of 40 2.5 Points
To change the width of a column, select:
A. Cells, Width on the Edit menu.
B. Column, Width on the Window menu.
C. Cells on the Format menu.
D. Column Width on the Format menu.
Question 35 of 40 2.5 Points
The dates 01/01/2002 and 02/01/2002 are entered into cells A1 and A2, respectively. The two-cell range is selected and dragged to A3. The value in A3 will be:
A. 04/01/2002
B. 03/01/2002
C. 02/01/2002
D. 01/01/2002
Question 36 of 40 2.5 Points
The first step to copy a formula between worksheets is to select Copy from the Edit menu or the Clipboard menu. What should you do next so that the copy of the formula in the destination worksheet includes cell references from the source worksheet?
A. Select Paste Special on the Edit menu or the Clipboard, and then click OK.
B. Select Paste Special on the Edit menu or the Clipboard, and then click Paste Link.
C. Select Paste on the Edit menu or the Clipboard, and then click OK.
D. Select Paste on the Edit menu or the Clipboard, and then click Paste Link.
Question 37 of 40 2.5 Points
Protecting a worksheet will prevent changes from being made. To unprotect a single cell on the worksheet:
A. unlock the cell, then protect the worksheet.
B. unprotect the worksheet, then lock the cell.
C. protect the worksheet, then unlock the cell.
D. protect the cell, then protect the worksheet.
Question 38 of 40 2.5 Points
Which of the following is the type of underline that extends almost across the whole cell but contains gaps for visual purposes?
A. Accounting Underline
B. Regular Underline
C. Gapped Underlines
D. Bottom Borders
Question 39 of 40 2.5 Points
Setting a standard column width will change the width of:
A. all columns.
B. only selected columns.
C. only columns that have had their widths individually set.
D. all columns that have not had their widths individually set.
Question 40 of 40 2.5 Points
To copy an entire worksheet, click the __________ of the worksheet, then click the Copy button, select another sheet, and click the Paste button.
A. top left corner box of the worksheet
B. Window Freeze Panes command
C. F5 GOTO key
D. Format Sheet command
