Question 1

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 
A)  Home 
B)  Page Layout 
C)  Insert 
D)  View

Question 2

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. 
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 3

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 
A)  a deleted worksheet 
B)  a worksheet with no calculations 
C)  a repositioned worksheet 
D)  a copy of another worksheet named Income

Question 4

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. 
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 5

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. 
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 6

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 7

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. 
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 8

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. 
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 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. 
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

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 
A)  Tools group 
B)  Themes group 
C)  Page Setup group 
D)  Background group

Question 11

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. 
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.

Question 12

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 
A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted

Question 13

Which worksheet view shows headers,footers,and rulers?

Accepted Answer

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

Question 14

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 15

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. 
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 16

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 
A)  delete 
B)  conditionally format 
C)  edit 
D)  hide

Question 17

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 18

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) 
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 19

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 
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 20

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

Accepted Answer

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

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

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

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

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

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

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

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

Which of the following is true about adding cell borders?

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?

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

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

Which worksheet view shows headers,footers,and rulers?

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

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

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

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.

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

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

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

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters

Exam 1: Getting Started With Excel

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

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

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

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

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

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

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

Which of the following is true about adding cell borders?

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?

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

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

Which worksheet view shows headers,footers,and rulers?

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

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

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

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.

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

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

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

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters