Which of the following is true when you copy and paste formulas using the fill handle?
a. You need to change the cell references to reflect the new formula location.
b. The AutoFill Options button lets you fill cells with specific elements of the copied cell.
c. The Paste Options button lets you paste only specific elements of the copied selection.
d. The formula is placed on the Office clipboard.
b. The AutoFill Options button lets you fill cells with specific elements of the copied cell.
Which of the following is true when you copy and paste formulas using the fill handle?
a. You need to change the cell references to reflect the new formula location.
b. The AutoFill Options button lets you fill cells with specific elements of the copied cell.
c. The Paste Options button lets you paste only specific elements of the copied selection.
d. The formula is placed on the Office clipboard.
b. The AutoFill Options button lets you fill cells with specific elements of the copied cell.
Which of the following is not a way to move cell contents?
a. drag-and-drop
b. the CTRL key + the Move pointer
c. the Cut and Paste buttons on the Home tab
d. the fill handle in the lower-right corner of an active cell or range
d. the fill handle in the lower-right corner of an active cell or range
Which of the following is true about adding cell borders?
a. You can only apply a border to the bottom of a cell.
b. A cell border underlines the cell text, not the entire cell.
c. A cell border extends the width of the cell.
d. You cannot apply borders to all worksheet cells.
c. A cell border extends the width of the cell.
Which of the following is true about deleting a worksheet row?
a. If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.
b. To delete a row, you can select the row, then use the Delete button in the Cells group.
c. After you delete a row, the rows below it shift down one row.
d. To delete a row, you can select the row, then press the DELETE key on the keyboard.
b. To delete a row, you can select the row, then use the Delete button in the Cells group.
To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?
a. Open the workbook, make changes, and then save it using a different name.
b. Leave the workbook closed.
c. Open the workbook, change the first worksheet, and save it using the Save command.
d. Open the workbook, make changes, and then save it using the same name.
a. Open the workbook, make changes, and then save it using a different name.
Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?
a.
The People in
b. The Specific People
c. The People with Existing Access
d.
The Co-workers in
a. The People in
Which of the following is a built-in formula that helps you perform complex calculations?
a. named range
b. mode indicator
c. clipboard
d. function
d. function
Which of the following tabs lets you set worksheet print options?
a. Home
b. File
c. View
d. Page Layout
b. File
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?
a. I-beam pointer
b. Normal pointer
c. Copy pointer
d. Move pointer
c. Copy pointer
To select a single worksheet cell so you can work with it, which of the following would you do?
a. Click the status bar.
b. Click the Name box.
c. Click the cell.
d. Move the cell pointer over the cell.
c. Click the cell.
