Question 1

To delete a defined name, open the Name Manager dialog box, click the defined name, and then click Deleted.

Accepted Answer

A) True 
 B)False

Question 2

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)  A5:F5 = int 
C)  A5:F5 = bin 
D)  A5:F5 >= 0 
A)  A5:F5 = 500.25 
B)  A5:F5 = int 
C)  A5:F5 = bin 
D)  A5:F5 >= 0

Question 3

When Micah opens a workbook containing external references, a dialog box appears indicating the workbook contains links to external sources. Micah trusts the linked data, so he can click the Trust button to update the data.

Accepted Answer

A) True 
 B)False

Question 4

Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?

Accepted Answer

A)  Click a column header and then click the Insert button on the Home tab. 
B)  Right-click a column header, click Format Cells on the shortcut menu, and then click Add New Column. 
C)  Click a column header, click the filter arrow, and then click Insert. 
D)  Double-click a column header and then click Insert on the shortcut menu. 
A)  Click a column header and then click the Insert button on the Home tab. 
B)  Right-click a column header, click Format Cells on the shortcut menu, and then click Add New Column. 
C)  Click a column header, click the filter arrow, and then click Insert. 
D)  Double-click a column header and then click Insert on the shortcut menu.

Question 5

Maureen added a trendline to a chart that shows sales trends for the past 10 years. To extend the trendline to forecast sales for the next two years, she enters 2 in the Backward box in the Format Trendline pane.

Accepted Answer

A) True 
 B)False

Question 6

You can edit a worksheet footer in _____.

Accepted Answer

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

Question 7

In what Power Pivot view can you define a relationship by dragging a common field between two tables to connect them?

Accepted Answer

A)  Diagram view 
B)  Design view 
C)  Datasheet view 
D)  Query view 
A)  Diagram view 
B)  Design view 
C)  Datasheet view 
D)  Query view

Question 8

To explicitly indicate that a range contains fields and records, you create a(n) _____.

Accepted Answer

A)  outline 
B)  table 
C)  advanced filter 
D)  chart 
A)  outline 
B)  table 
C)  advanced filter 
D)  chart

Question 9

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

Accepted Answer

A)  Alignment 
B)  Fonts 
C)  Color 
D)  Styles 
A)  Alignment 
B)  Fonts 
C)  Color 
D)  Styles

Question 10

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Accepted Answer

A)  conditional formatting 
B)  cell formatting 
C)  cell styles 
D)  Quick Access toolbar 
A)  conditional formatting 
B)  cell formatting 
C)  cell styles 
D)  Quick Access toolbar

Question 11

Which Excel dialog box do you use to fill a series based on extrapolation?

Accepted Answer

A)  Extrapolation dialog box 
B)  AutoFill dialog box 
C)  Trend dialog box 
D)  Series dialog box 
A)  Extrapolation dialog box 
B)  AutoFill dialog box 
C)  Trend dialog box 
D)  Series dialog box

Question 12

Leila has a table listing the number of houses each real estate agent sold, if any, each month. She can use the DCOUNTA function to find the number of agents with sales in June.

Accepted Answer

A) True 
 B)False

Question 13

A _____ is a form element used for entering data and running commands.

Accepted Answer

A)  macro 
B)  module 
C)  form control 
D)  form command 
A)  macro 
B)  module 
C)  form control 
D)  form command

Question 14

You can hide the PivotTable Field pane by deselecting the Field List button on the PivotTable Tools Analyze tab. 6/24/2020

Accepted Answer

A) True 
 B)False

Question 15

To display a tracer arrow to each cell providing direct data that is dependent on the active cell, click Formulas tab > Formula Auditing group > Trace Dependents.

Accepted Answer

A) True 
 B)False

Question 16

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

Accepted Answer

A) True 
 B)False

Question 17

In the formula =B6*$B$2, which of the following describes $B$2?

Accepted Answer

A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  Average 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  Average

Question 18

What must you do before removing a page break?

Accepted Answer

A)  Click the heading of the column containing the page break. 
B)  Select a cell below or to the right of the page break. 
C)  Click the heading of the row containing the page break. 
D)  Set the print area. 
A)  Click the heading of the column containing the page break. 
B)  Select a cell below or to the right of the page break. 
C)  Click the heading of the row containing the page break. 
D)  Set the print area.

Question 19

Davis wants to remove a column from the Climate Data query he created. To do so, he can point to the Climate Data query in the Queries & Connections pane, and then click the _____ button in the Climate Data dialog box.

Accepted Answer

A)  Load 
B)  Refresh 
C)  Edit 
D)  Restructure 
A)  Load 
B)  Refresh 
C)  Edit 
D)  Restructure

Question 20

Will has a table that includes a field with four product types. What kind of filter would be best to apply to the table?

Accepted Answer

A)  Date filter 
B)  Custom number filter 
C)  Slicer 
D)  Advanced filter 
A)  Date filter 
B)  Custom number filter 
C)  Slicer 
D)  Advanced filter

To delete a defined name, open the Name Manager dialog box, click the defined name, and then click Deleted.

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

When Micah opens a workbook containing external references, a dialog box appears indicating the workbook contains links to external sources. Micah trusts the linked data, so he can click the Trust button to update the data.

Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?

Maureen added a trendline to a chart that shows sales trends for the past 10 years. To extend the trendline to forecast sales for the next two years, she enters 2 in the Backward box in the Format Trendline pane.

You can edit a worksheet footer in _____.

In what Power Pivot view can you define a relationship by dragging a common field between two tables to connect them?

To explicitly indicate that a range contains fields and records, you create a(n) _____.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Which Excel dialog box do you use to fill a series based on extrapolation?

Leila has a table listing the number of houses each real estate agent sold, if any, each month. She can use the DCOUNTA function to find the number of agents with sales in June.

A _____ is a form element used for entering data and running commands.

You can hide the PivotTable Field pane by deselecting the Field List button on the PivotTable Tools Analyze tab. 6/24/2020

To display a tracer arrow to each cell providing direct data that is dependent on the active cell, click Formulas tab > Formula Auditing group > Trace Dependents.

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

In the formula =B6*$B$2, which of the following describes $B$2?

What must you do before removing a page break?

Davis wants to remove a column from the Climate Data query he created. To do so, he can point to the Climate Data query in the Queries & Connections pane, and then click the _____ button in the Climate Data dialog box.

Will has a table that includes a field with four product types. What kind of filter would be best to apply to the table?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

To delete a defined name, open the Name Manager dialog box, click the defined name, and then click Deleted.

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

When Micah opens a workbook containing external references, a dialog box appears indicating the workbook contains links to external sources. Micah trusts the linked data, so he can click the Trust button to update the data.

Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?

Maureen added a trendline to a chart that shows sales trends for the past 10 years. To extend the trendline to forecast sales for the next two years, she enters 2 in the Backward box in the Format Trendline pane.

You can edit a worksheet footer in _____.

In what Power Pivot view can you define a relationship by dragging a common field between two tables to connect them?

To explicitly indicate that a range contains fields and records, you create a(n) _____.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Which Excel dialog box do you use to fill a series based on extrapolation?

Leila has a table listing the number of houses each real estate agent sold, if any, each month. She can use the DCOUNTA function to find the number of agents with sales in June.

A _____ is a form element used for entering data and running commands.

You can hide the PivotTable Field pane by deselecting the Field List button on the PivotTable Tools Analyze tab. 6/24/2020

To display a tracer arrow to each cell providing direct data that is dependent on the active cell, click Formulas tab > Formula Auditing group > Trace Dependents.

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

In the formula =B6*$B$2, which of the following describes $B$2?

What must you do before removing a page break?

Davis wants to remove a column from the Climate Data query he created. To do so, he can point to the Climate Data query in the Queries & Connections pane, and then click the _____ button in the Climate Data dialog box.

Will has a table that includes a field with four product types. What kind of filter would be best to apply to the table?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters