Question 1

An error message is displayed in cell B10 of Paul's worksheet.If he traces the formula _____, he can identify the cells that contribute to the formula in cell B10.

Accepted Answer

A)  precedents 
B)  scope 
C)  inconsistencies 
D)  constraints 
A)  precedents 
B)  scope 
C)  inconsistencies 
D)  constraints

Question 2

Esperanza wants to save a series of commands she performs often.Which of the following should she do?

Accepted Answer

A)  Create a protected commands worksheet. 
B)  Turn on automatic calculations. 
C)  Run a procedure. 
D)  Record a macro. 
A)  Create a protected commands worksheet. 
B)  Turn on automatic calculations. 
C)  Run a procedure. 
D)  Record a macro.

Question 3

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

Accepted Answer

A) True 
 B)False

Question 4

You can change the color of a data series by selecting the series and then clicking the _____ button.

Accepted Answer

A)  Text Outline 
B)  Shape Fill 
C)  Shape Effects 
D)  Series Color 
A)  Text Outline 
B)  Shape Fill 
C)  Shape Effects 
D)  Series Color

Question 5

Maria has a line chart that shows expense amounts on the vertical axis.What can she do to display the values as dollar amounts?

Accepted Answer

A)  Change the starting and ending values of the vertical axis. 
B)  Change the number format of the vertical axis. 
C)  Add a vertical axis title. 
D)  Add a data table with a legend. 
A)  Change the starting and ending values of the vertical axis. 
B)  Change the number format of the vertical axis. 
C)  Add a vertical axis title. 
D)  Add a data table with a legend.

Question 6

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

Accepted Answer

A)  =MONTH(F5) 
B)  =MONTH("F5") 
C)  =MONTH(TODAY(2016,7,0)) 
D)  =MONTH(DAY(2016,7,0)) 
A)  =MONTH(F5) 
B)  =MONTH("F5") 
C)  =MONTH(TODAY(2016,7,0)) 
D)  =MONTH(DAY(2016,7,0))

Question 7

How can you add a record to the end of a table?

Accepted Answer

A)  Click the last cell of the table and then press ENTER. 
B)  lick the Insert arrow in the Cells group and then click Add Row to End of Table. 
C)  Type data directly below the last row of the table. 
D)  Click the last cell of the table and then press DOWN ARROW. 
A)  Click the last cell of the table and then press ENTER. 
B)  lick the Insert arrow in the Cells group and then click Add Row to End of Table. 
C)  Type data directly below the last row of the table. 
D)  Click the last cell of the table and then press DOWN ARROW.

Question 8

To change the color of cell content, you use the ________ color list arrow.

Accepted Answer

A)  Cell 
B)  Text 
C)  Pattern 
D)  Font 
A)  Cell 
B)  Text 
C)  Pattern 
D)  Font

Question 9

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

Accepted Answer

A)  Right-click and select Insert from the drop-down menu, and pick Table Rows Above. 
B)  Right-click and select Insert from the drop-down menu, and pick Table Rows Below. 
C)  Click on the Design tab in the Tools group, and then click Remove Duplicates. 
D)  Click the arrow next to Delete on the Home tab, in the Cells group, and then click Delete Table Rows. 
A)  Right-click and select Insert from the drop-down menu, and pick Table Rows Above. 
B)  Right-click and select Insert from the drop-down menu, and pick Table Rows Below. 
C)  Click on the Design tab in the Tools group, and then click Remove Duplicates. 
D)  Click the arrow next to Delete on the Home tab, in the Cells group, and then click Delete Table Rows.

Question 10

Which dialog box do you use to delete a macro?

Accepted Answer

A)  Macro dialog box 
B)  Visual Basic dialog box 
C)  Edit Macros dialog box 
D)  Manage Macros dialog box 
A)  Macro dialog box 
B)  Visual Basic dialog box 
C)  Edit Macros dialog box 
D)  Manage Macros dialog box

Question 11

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

Accepted Answer

A)  CTRL 
B)  ALT 
C)  SHIFT 
D)  ESC 
A)  CTRL 
B)  ALT 
C)  SHIFT 
D)  ESC

Question 12

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Accepted Answer

A)  Delete the conditional formatting rule. 
B)  Edit the conditional formatting rule. 
C)  Format the range in the Font dialog box. 
D)  Format the range as a table. 
A)  Delete the conditional formatting rule. 
B)  Edit the conditional formatting rule. 
C)  Format the range in the Font dialog box. 
D)  Format the range as a table.

Question 13

To analyze the results of scenarios, you can create a(n) _____.

Accepted Answer

A)  Scenario Management chart 
B)  Scenario Overview 
C)  Scenario PivotTable 
D)  Answer report 
A)  Scenario Management chart 
B)  Scenario Overview 
C)  Scenario PivotTable 
D)  Answer report

Question 14

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

Accepted Answer

A) True 
 B)False

Question 15

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row.Which of the following is an efficient way for her to do this?

Accepted Answer

A)  Change the picture layout. 
B)  Align the pictures. 
C)  Bring each picture forward. 
D)  Apply picture corrections. 
A)  Change the picture layout. 
B)  Align the pictures. 
C)  Bring each picture forward. 
D)  Apply picture corrections.

Question 16

In one workbook, Tim wants to include a link to another workbook.Which of the following dialog boxes should he use to add the link?

Accepted Answer

A)  Style dialog box 
B)  Insert Text dialog box 
C)  ScreenTip Text box 
D)  Insert Hyperlink dialog box 
A)  Style dialog box 
B)  Insert Text dialog box 
C)  ScreenTip Text box 
D)  Insert Hyperlink dialog box

Question 17

You can insert WordArt into a worksheet, but not a chart.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?

Accepted Answer

A)  A5:F5 = 500.25 
B)  iA5:F5 = int 
C)  A5:F5 = bin 
D)  A5:F5 >= 0 
A)  A5:F5 = 500.25 
B)  iA5:F5 = int 
C)  A5:F5 = bin 
D)  A5:F5 >= 0

Question 19

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Accepted Answer

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

Question 20

Julio wants to analyze the best, most likely, and worst outcomes for changing expense values.He should create three scenarios.

Accepted Answer

A) True 
 B)False

An error message is displayed in cell B10 of Paul's worksheet.If he traces the formula _____, he can identify the cells that contribute to the formula in cell B10.

Esperanza wants to save a series of commands she performs often.Which of the following should she do?

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

You can change the color of a data series by selecting the series and then clicking the _____ button.

Maria has a line chart that shows expense amounts on the vertical axis.What can she do to display the values as dollar amounts?

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

How can you add a record to the end of a table?

To change the color of cell content, you use the ________ color list arrow.

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

Which dialog box do you use to delete a macro?

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

To analyze the results of scenarios, you can create a(n) _____.

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row.Which of the following is an efficient way for her to do this?

In one workbook, Tim wants to include a link to another workbook.Which of the following dialog boxes should he use to add the link?

You can insert WordArt into a worksheet, but not a chart.

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Julio wants to analyze the best, most likely, and worst outcomes for changing expense values.He should create three scenarios.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

An error message is displayed in cell B10 of Paul's worksheet.If he traces the formula _____, he can identify the cells that contribute to the formula in cell B10.

Esperanza wants to save a series of commands she performs often.Which of the following should she do?

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

You can change the color of a data series by selecting the series and then clicking the _____ button.

Maria has a line chart that shows expense amounts on the vertical axis.What can she do to display the values as dollar amounts?

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

How can you add a record to the end of a table?

To change the color of cell content, you use the ________ color list arrow.

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

Which dialog box do you use to delete a macro?

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

To analyze the results of scenarios, you can create a(n) _____.

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row.Which of the following is an efficient way for her to do this?

In one workbook, Tim wants to include a link to another workbook.Which of the following dialog boxes should he use to add the link?

You can insert WordArt into a worksheet, but not a chart.

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Julio wants to analyze the best, most likely, and worst outcomes for changing expense values.He should create three scenarios.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters