Question 1

Which of the following is true when you copy and paste formulas using the fill handle?

Accepted Answer

A)   The Paste Options button lets you paste only specific elements of the copied selection.
B)   The AutoFill Options button lets you fill cells with specific elements of the copied cell.
C)   The formula is placed on the Office clipboard.
D)   You need to change the cell references to reflect the new formula location.

Question 2

To delete a worksheet column,you can first select it by _____.

Accepted Answer

A)   clicking the column heading
B)   double-clicking the column heading
C)   clicking anywhere in the column
D)   double-clicking anywhere in the column

Question 3

You receive a worksheet in which the rows are numbered 1,2,3,5,6.This means that row 4 is _____.

Accepted Answer

A)   deleted
B)   hidden
C)   cut
D)   conditionally formatted

Question 4

Which of the following is true about deleting a worksheet row?

Accepted Answer

A)   After you delete a row,the rows below it shift down one row.
B)   To delete a row,you can select the row,then press the DELETE key on the keyboard.
C)   To delete a row,you can select the row,then use the Delete button in the Cells group.
D)   If you select a row and click the Delete list arrow,you can select Delete Sheet to delete the row.

Question 5

Which worksheet view shows headers,footers,and rulers?

Accepted Answer

A)   Normal view
B)   Page Break Preview
C)   Page Layout view
D)   Formula view

Question 6

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data,you can _____ column C.

Accepted Answer

A)   delete
B)   conditionally format
C)   edit
D)   hide

Question 7

Which of the following is true about inserting cells in a worksheet?

Accepted Answer

A)   Excel automatically adjusts cell references to reflect new formula locations.
B)   You need to adjust cell references in all formulas that have moved.
C)   You cannot insert cells in a worksheet.
D)   Cells below the inserted cells are always moved downward.

Question 8

A worksheet named Income (2) is most likely which of the following?

Accepted Answer

A)   a deleted worksheet
B)   a worksheet with no calculations
C)   a repositioned worksheet
D)   a copy of another worksheet named Income

Question 9

Which of the following is true about adding cell borders?

Accepted Answer

A)   You cannot apply borders to all worksheet cells.
B)   A cell border underlines the cell text,not the entire cell.
C)   A cell border extends the width of the cell.
D)   You can only apply a border to the bottom of a cell.

Question 10

Dean wants to insert five blank rows above a row.To do so,he can select the heading of the row above which he wants to insert the additional rows,hold Ctrl key,click the selected rows,and then click Insert on the pop-up menu.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following tabs lets you set worksheet print options?

Accepted Answer

A)   File
B)   Home
C)   Page Layout
D)   View

Question 12

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

Accepted Answer

A)   Tools group
B)   Themes group
C)   Page Setup group
D)   Background group

Question 13

When you double-click a cell's right column border,which of the following occurs?

Accepted Answer

A)   The column is deleted.
B)   AutoFit resizes the column to 8.43 characters wide.
C)   A column is added to the right of the column's border.
D)   AutoFit resizes the column to the widest cell entry.

Question 14

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

Accepted Answer

A)   The formula =B6+B7+B8+B9+B10.
B)   The formula =TOTAL(B6-B10) 
C)   The formula =SUM(B6:B10) 
D)   The formula +SUM(B6-B10)

Question 15

To enter data in a cell using examples already in your workbook,you can use the flash fill feature.

Accepted Answer

A) True 
 B)False

Question 16

Miley wants to perform calculations on four worksheets with identical structures at the same time.So,in order to group them and perform the task faster,she can press the Ctrl + Alt key and click the worksheet tabs she wants to group and then modify either of the worksheets for automatic change in the other one.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following methods copies an existing worksheet within the same workbook?

Accepted Answer

A)   Drag its sheet tab to a new location.
B)   Press and hold CTRL and drag its sheet tab to a new location.
C)   Press and hold SHIFT and drag its sheet tab to a new location.
D)   Press and hold ALT and drag its sheet tab to a new location.

Question 18

To print your worksheet on a piece of paper larger than 8-1/2 x 11",which Excel tab would you use?

Accepted Answer

A)   Home
B)   Page Layout
C)   Insert
D)   View

Question 19

To create a new,blank workbook,which of the following can you use?

Accepted Answer

A)   The Open command in Backstage view.
B)   The New command in Backstage view.
C)   The New command on the File tab.
D)   The Open command on the File tab.

Question 20

Which of the following is true about deleting a worksheet? Select all the options that apply.

Accepted Answer

A)   You can right-click a sheet tab and click Delete.
B)   You can use the Delete list arrow in the Cells group on the Home tab.
C)   You can use the Delete button in the worksheet group on the Insert tab.
D)   You cannot delete a worksheet from a workbook.

Exam 1: Getting Started With Excel

Which of the following tabs lets you set worksheet print options?

Correct Answer
verified

When you double-click a cell's right column border,which of the following occurs?

Correct Answer
verified

Which of the following is true about inserting cells in a worksheet?

Correct Answer
verified

To enter data in a cell using examples already in your workbook,you can use the flash fill feature.

Correct Answer
verified

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

Correct Answer
verified

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

Correct Answer
verified

You receive a worksheet in which the rows are numbered 1,2,3,5,6.This means that row 4 is _____.

Correct Answer
verified

A worksheet named Income (2) is most likely which of the following?

Correct Answer
verified

Which of the following is true about adding cell borders?

Correct Answer
verified

Which of the following is true about deleting a worksheet row?

Correct Answer
verified

To delete a worksheet column,you can first select it by _____.

Correct Answer
verified

Which worksheet view shows headers,footers,and rulers?

Correct Answer
verified

Which of the following is true when you copy and paste formulas using the fill handle?

Correct Answer
verified

Which of the following methods copies an existing worksheet within the same workbook?

Correct Answer
verified

To create a new,blank workbook,which of the following can you use?

Correct Answer
verified

Correct Answer
verified

To print your worksheet on a piece of paper larger than 8-1/2 x 11",which Excel tab would you use?

Correct Answer
verified

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data,you can _____ column C.

Correct Answer
verified

Dean wants to insert five blank rows above a row.To do so,he can select the heading of the row above which he wants to insert the additional rows,hold Ctrl key,click the selected rows,and then click Insert on the pop-up menu.

Correct Answer
verified

Which of the following is true about deleting a worksheet? Select all the options that apply.

Correct Answer
verified

Exam 1: Getting Started With Excel

Which of the following tabs lets you set worksheet print options?

Correct AnswerverifiedShow Answer

When you double-click a cell's right column border,which of the following occurs?

Correct AnswerverifiedShow Answer

Which of the following is true about inserting cells in a worksheet?

Correct AnswerverifiedShow Answer

To enter data in a cell using examples already in your workbook,you can use the flash fill feature.

Correct AnswerverifiedShow Answer

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

Correct AnswerverifiedShow Answer

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

Correct AnswerverifiedShow Answer

You receive a worksheet in which the rows are numbered 1,2,3,5,6.This means that row 4 is _____.

Correct AnswerverifiedShow Answer

A worksheet named Income (2) is most likely which of the following?

Correct AnswerverifiedShow Answer

Which of the following is true about adding cell borders?

Correct AnswerverifiedShow Answer

Which of the following is true about deleting a worksheet row?

Correct AnswerverifiedShow Answer

To delete a worksheet column,you can first select it by _____.

Correct AnswerverifiedShow Answer

Which worksheet view shows headers,footers,and rulers?

Correct AnswerverifiedShow Answer

Which of the following is true when you copy and paste formulas using the fill handle?

Correct AnswerverifiedShow Answer

Which of the following methods copies an existing worksheet within the same workbook?

Correct AnswerverifiedShow Answer

To create a new,blank workbook,which of the following can you use?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

To print your worksheet on a piece of paper larger than 8-1/2 x 11",which Excel tab would you use?

Correct AnswerverifiedShow Answer

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data,you can _____ column C.

Correct AnswerverifiedShow Answer

Dean wants to insert five blank rows above a row.To do so,he can select the heading of the row above which he wants to insert the additional rows,hold Ctrl key,click the selected rows,and then click Insert on the pop-up menu.

Correct AnswerverifiedShow Answer

Which of the following is true about deleting a worksheet? Select all the options that apply.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified