Question 1

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013.To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Accepted Answer

A) True 
 B)False

Question 2

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

Accepted Answer

A)  changing cell 
B)  constraint 
C)  objective cell 
D)  solving method 
A)  changing cell 
B)  constraint 
C)  objective cell 
D)  solving method

Question 3

To show a comment attached to the active cell, move the pointer over the cell.

Accepted Answer

A) True 
 B)False

Question 4

You can use the Auto Outline feature to group worksheet data into an outline.

Accepted Answer

A) True 
 B)False

Question 5

A(n) _____ summarizes large amounts of worksheet data in a compact table format.

Accepted Answer

A)  Area chart 
B)  PivotTable 
C)  Slicer 
D)  Filter 
A)  Area chart 
B)  PivotTable 
C)  Slicer 
D)  Filter

Question 6

Before you can change the properties of a Command Button (ActiveX Control) object, you must switch to _____.

Accepted Answer

A)  Page Layout view 
B)  Developer Mode 
C)  Backstage view 
D)  Design Mode 
A)  Page Layout view 
B)  Developer Mode 
C)  Backstage view 
D)  Design Mode

Question 7

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

Accepted Answer

A)  3-D map 
B)  Power field 
C)  measure 
D)  layer 
A)  3-D map 
B)  Power field 
C)  measure 
D)  layer

Question 8

When should you use relative cell references?

Accepted Answer

A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells. 
A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells.

Question 9

When you underline cell content, you are using _____.

Accepted Answer

A)  a font style 
B)  an orientation setting 
C)  an indent setting 
D)  a centering style 
A)  a font style 
B)  an orientation setting 
C)  an indent setting 
D)  a centering style

Question 10

When would you explode a slice in a pie chart?

Accepted Answer

A)  to show trends over time 
B)  to highlight the general direction of the data series 
C)  to identify the value the slice represents 
D)  to emphasize one data point 
A)  to show trends over time 
B)  to highlight the general direction of the data series 
C)  to identify the value the slice represents 
D)  to emphasize one data point

Question 11

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Accepted Answer

A) True 
 B)False

Question 12

Jason wants to display the text "Poor" if the value in cell A3 is less than 25.If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good".Which of the following formulas should he use?

Accepted Answer

A)  '=IF(A3  50, "Good", =IF(A3 < 25, "Poor", "Good") 
A)  '=IF(A3  50, "Good", =IF(A3 < 25, "Poor", "Good")

Question 13

Sven wants to use a more vivid color as the Accent 1 color in his workbook's theme.What can he do to change the Accent 1 color?

Accepted Answer

A)  Change the theme variant 
B)  Customize the theme colors 
C)  Change the theme effects 
D)  Customize the theme fonts 
A)  Change the theme variant 
B)  Customize the theme colors 
C)  Change the theme effects 
D)  Customize the theme fonts

Question 14

Which of the following lets you edit the contents of a cell?

Accepted Answer

A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar. 
A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar.

Question 15

Marguerite changes her Excel security settings to "Disable all macros with notification," and then opens a macro-enabled workbook.What must she do to run the macros in the workbook?

Accepted Answer

A)  Click the Enable Content button. 
B)  Click the Security button on the Developer tab. 
C)  Add a digital signature to the workbook. 
D)  Click the Update Links button. 
A)  Click the Enable Content button. 
B)  Click the Security button on the Developer tab. 
C)  Add a digital signature to the workbook. 
D)  Click the Update Links button.

Question 16

If the answer to a what-if question requires data from two tables, you can use Power Pivot to create a PivotTable that uses fields from both tables.

Accepted Answer

A) True 
 B)False

Question 17

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

Accepted Answer

A)  pan 
B)  window 
C)  view 
D)  outline 
A)  pan 
B)  window 
C)  view 
D)  outline

Question 18

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 19

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years.Which of the following functions can he use to calculate the current value of the investment?

Accepted Answer

A)  PMT 
B)  NPER 
C)  PV 
D)  RATE 
A)  PMT 
B)  NPER 
C)  PV 
D)  RATE

Question 20

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

Accepted Answer

A) True 
 B)False

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013.To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

To show a comment attached to the active cell, move the pointer over the cell.

You can use the Auto Outline feature to group worksheet data into an outline.

A(n) _____ summarizes large amounts of worksheet data in a compact table format.

Before you can change the properties of a Command Button (ActiveX Control) object, you must switch to _____.

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

When should you use relative cell references?

When you underline cell content, you are using _____.

When would you explode a slice in a pie chart?

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Jason wants to display the text "Poor" if the value in cell A3 is less than 25.If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good".Which of the following formulas should he use?

Sven wants to use a more vivid color as the Accent 1 color in his workbook's theme.What can he do to change the Accent 1 color?

Which of the following lets you edit the contents of a cell?

Marguerite changes her Excel security settings to "Disable all macros with notification," and then opens a macro-enabled workbook.What must she do to run the macros in the workbook?

If the answer to a what-if question requires data from two tables, you can use Power Pivot to create a PivotTable that uses fields from both tables.

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

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

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years.Which of the following functions can he use to calculate the current value of the investment?

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013.To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

To show a comment attached to the active cell, move the pointer over the cell.

You can use the Auto Outline feature to group worksheet data into an outline.

A(n) _____ summarizes large amounts of worksheet data in a compact table format.

Before you can change the properties of a Command Button (ActiveX Control) object, you must switch to _____.

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

When should you use relative cell references?

When you underline cell content, you are using _____.

When would you explode a slice in a pie chart?

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Jason wants to display the text "Poor" if the value in cell A3 is less than 25.If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good".Which of the following formulas should he use?

Sven wants to use a more vivid color as the Accent 1 color in his workbook's theme.What can he do to change the Accent 1 color?

Which of the following lets you edit the contents of a cell?

Marguerite changes her Excel security settings to "Disable all macros with notification," and then opens a macro-enabled workbook.What must she do to run the macros in the workbook?

If the answer to a what-if question requires data from two tables, you can use Power Pivot to create a PivotTable that uses fields from both tables.

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

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

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years.Which of the following functions can he use to calculate the current value of the investment?

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters