Question 1

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

Accepted Answer

A)  The Paste Options button then lets you paste specific elements of the copied cells. 
B)  The formula is copied with cell references you must adjust to avoid worksheet errors. 
C)  The Auto Fill Options button appears. 
D)  Pointing to the destination cell causes a preview of the cell contents to appear. 
A)  The Paste Options button then lets you paste specific elements of the copied cells. 
B)  The formula is copied with cell references you must adjust to avoid worksheet errors. 
C)  The Auto Fill Options button appears. 
D)  Pointing to the destination cell causes a preview of the cell contents to appear.

Question 2

Brielle wants to increase the width of SmartArt but not its height.Which of the following should she do?

Accepted Answer

A)  Drag the middle sizing handle on the right. 
B)  Drag a corner sizing handle. 
C)  Click the Larger button in the Shapes group. 
D)  Click the Reset Graphic button in the Reset group. 
A)  Drag the middle sizing handle on the right. 
B)  Drag a corner sizing handle. 
C)  Click the Larger button in the Shapes group. 
D)  Click the Reset Graphic button in the Reset group.

Question 3

Stephen inserted a picture that looks blurry in the worksheet.What can he do to improve the appearance of the picture?

Accepted Answer

A)  Apply a Glow picture effect. 
B)  Increase the sharpness of the picture. 
C)  Resize the picture. 
D)  Add a border. 
A)  Apply a Glow picture effect. 
B)  Increase the sharpness of the picture. 
C)  Resize the picture. 
D)  Add a border.

Question 4

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

Accepted Answer

A) True 
 B)False

Question 5

A one-input data table shows the result of varying one input value.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following are Excel what-if analysis tools? Select all the options that apply.

Accepted Answer

A)  Goal Seek 
B)  Scenario Manager 
C)  Data Validation 
D)  Solver 
A)  Goal Seek 
B)  Scenario Manager 
C)  Data Validation 
D)  Solver

Question 7

You have cut the range A1:A5, and want to paste it to C1:C5.Which of the following statements is true?

Accepted Answer

A)  Before you paste it, you need to select C1:C5. 
B)  Before you paste it, you only need to select cell C1. 
C)  After you paste it, the information is deleted from the Clipboard. 
D)  After you paste it, the information is deleted from the original location. 
A)  Before you paste it, you need to select C1:C5. 
B)  Before you paste it, you only need to select cell C1. 
C)  After you paste it, the information is deleted from the Clipboard. 
D)  After you paste it, the information is deleted from the original location.

Question 8

Where can you see a brief description of a selected function?

Accepted Answer

A)  Formula bar 
B)  Insert Function dialog box 
C)  Insert dialog box 
D)  Insert tab 
A)  Formula bar 
B)  Insert Function dialog box 
C)  Insert dialog box 
D)  Insert tab

Question 9

To clear all the comments from a workbook, you must delete them one at a time.

Accepted Answer

A) True 
 B)False

Question 10

The rows of Jonathan's PivotTable display store details for each quarter.To display quarterly details for each store, he can reorder the Store and Quarter fields in the Rows area.

Accepted Answer

A) True 
 B)False

Question 11

Jerome inserted a Check Box form control and set cell A10 as the cell link.When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

Accepted Answer

A) True 
 B)False

Question 12

Tracer arrows help you determine which cells are included in named ranges.

Accepted Answer

A) True 
 B)False

Question 13

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

Accepted Answer

A)  extent 
B)  scope 
C)  limitations 
D)  properties 
A)  extent 
B)  scope 
C)  limitations 
D)  properties

Question 14

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Accepted Answer

A) True 
 B)False

Question 15

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Accepted Answer

A) True 
 B)False

Question 16

One advantage of exporting a workbook as a PDF file is that a PDF preserves formatting and fonts but still lets readers edit the data.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following inserts a function into a cell?

Accepted Answer

A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix 
A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix

Question 18

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Accepted Answer

A)  argument 
B)  function 
C)  label 
D)  active cell 
A)  argument 
B)  function 
C)  label 
D)  active cell

Question 19

Which of the following Excel tools can you use to track and correct errors in a worksheet? Select all the options that apply.

Accepted Answer

A)  Error Checking dialog box 
B)  Evaluate Formula button on the Formulas tab 
C)  Calculation Options button on the Formulas tab 
D)  Watch Window 
A)  Error Checking dialog box 
B)  Evaluate Formula button on the Formulas tab 
C)  Calculation Options button on the Formulas tab 
D)  Watch Window

Question 20

The Analysis ToolPak is an Excel add-in that contains statistical analysis tools.

Accepted Answer

A) True 
 B)False

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

Brielle wants to increase the width of SmartArt but not its height.Which of the following should she do?

Stephen inserted a picture that looks blurry in the worksheet.What can he do to improve the appearance of the picture?

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

A one-input data table shows the result of varying one input value.

Which of the following are Excel what-if analysis tools? Select all the options that apply.

You have cut the range A1:A5, and want to paste it to C1:C5.Which of the following statements is true?

Where can you see a brief description of a selected function?

To clear all the comments from a workbook, you must delete them one at a time.

The rows of Jonathan's PivotTable display store details for each quarter.To display quarterly details for each store, he can reorder the Store and Quarter fields in the Rows area.

Jerome inserted a Check Box form control and set cell A10 as the cell link.When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

Tracer arrows help you determine which cells are included in named ranges.

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

One advantage of exporting a workbook as a PDF file is that a PDF preserves formatting and fonts but still lets readers edit the data.

Which of the following inserts a function into a cell?

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Which of the following Excel tools can you use to track and correct errors in a worksheet? Select all the options that apply.

The Analysis ToolPak is an Excel add-in that contains statistical analysis tools.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

Brielle wants to increase the width of SmartArt but not its height.Which of the following should she do?

Stephen inserted a picture that looks blurry in the worksheet.What can he do to improve the appearance of the picture?

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

A one-input data table shows the result of varying one input value.

Which of the following are Excel what-if analysis tools? Select all the options that apply.

You have cut the range A1:A5, and want to paste it to C1:C5.Which of the following statements is true?

Where can you see a brief description of a selected function?

To clear all the comments from a workbook, you must delete them one at a time.

The rows of Jonathan's PivotTable display store details for each quarter.To display quarterly details for each store, he can reorder the Store and Quarter fields in the Rows area.

Jerome inserted a Check Box form control and set cell A10 as the cell link.When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

Tracer arrows help you determine which cells are included in named ranges.

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

One advantage of exporting a workbook as a PDF file is that a PDF preserves formatting and fonts but still lets readers edit the data.

Which of the following inserts a function into a cell?

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Which of the following Excel tools can you use to track and correct errors in a worksheet? Select all the options that apply.

The Analysis ToolPak is an Excel add-in that contains statistical analysis tools.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters