Question 1

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet.What should she do before creating the PivotChart?

Accepted Answer

A)  Select the range where the PivotChart should be inserted. 
B)  Collapse the PivotTable fields to make room for the PivotChart. 
C)  Select a cell in the PivotTable. 
D)  Apply a PivotTable style so the PivotChart uses the same one. 
A)  Select the range where the PivotChart should be inserted. 
B)  Collapse the PivotTable fields to make room for the PivotChart. 
C)  Select a cell in the PivotTable. 
D)  Apply a PivotTable style so the PivotChart uses the same one.

Question 2

You can use the Evaluate Formula button to identify the source of a cell error.

Accepted Answer

A) True 
 B)False

Question 3

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

Accepted Answer

A)  left 
B)  center 
C)  bold 
D)  underline 
A)  left 
B)  center 
C)  bold 
D)  underline

Question 5

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Accepted Answer

A) True 
 B)False

Question 6

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

Accepted Answer

A) True 
 B)False

Question 7

You can add a calculated field to a PivotTable to use formulas to analyze the PivotTable data.

Accepted Answer

A) True 
 B)False

Question 8

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 9

What can you do when you have two levels of data in PivotTable rows?

Accepted Answer

A)  Add a calculated row to the PivotTable. 
B)  Use the Collapse and Expand buttons to drill down and up in the data. 
C)  Filter the PivotTable on two columns. 
D)  Create a 3-D PivotChart. 
A)  Add a calculated row to the PivotTable. 
B)  Use the Collapse and Expand buttons to drill down and up in the data. 
C)  Filter the PivotTable on two columns. 
D)  Create a 3-D PivotChart.

Question 10

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series.How can she quickly remove it?

Accepted Answer

A)  Switch the rows and columns. 
B)  Apply a Quick Layout. 
C)  Select the data series and then press DEL. 
D)  Right-click the data series and then click Hide. 
A)  Switch the rows and columns. 
B)  Apply a Quick Layout. 
C)  Select the data series and then press DEL. 
D)  Right-click the data series and then click Hide.

Question 11

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Accepted Answer

A)  Advance 
B)  Macro 
C)  Developer 
D)  Power Tools 
A)  Advance 
B)  Macro 
C)  Developer 
D)  Power Tools

Question 12

Calista wants to provide additional information about a hyperlink she is creating.Which of the following can she do?

Accepted Answer

A)  Add a description. 
B)  Add a ScreenTip. 
C)  Change the Link to location. 
D)  Add a HyperTip. 
A)  Add a description. 
B)  Add a ScreenTip. 
C)  Change the Link to location. 
D)  Add a HyperTip.

Question 13

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

Accepted Answer

A)  switch 
B)  relate 
C)  refresh 
D)  group 
A)  switch 
B)  relate 
C)  refresh 
D)  group

Question 14

Which of the following is the temporary storage area that holds selections you copy or cut?

Accepted Answer

A)  Clipboard 
B)  Backstage 
C)  Name box 
D)  Worksheet window 
A)  Clipboard 
B)  Backstage 
C)  Name box 
D)  Worksheet window

Question 15

To change the background color of a cell, you use the Background color button.

Accepted Answer

A) True 
 B)False

Question 16

You can create a query to by adding what type of data to the data model?

Accepted Answer

A)  Current worksheet data 
B)  Outlook address book 
C)  Word document 
D)  Word mail merge 
A)  Current worksheet data 
B)  Outlook address book 
C)  Word document 
D)  Word mail merge

Question 17

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 18

Stephanie added data validation to a worksheet column after entering a few records of data.Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

Accepted Answer

A)  Tracer Arrows 
B)  Error Check 
C)  Watch Window 
D)  Circle Invalid Data 
A)  Tracer Arrows 
B)  Error Check 
C)  Watch Window 
D)  Circle Invalid Data

Question 19

You can use trendlines to project future data based on past trends.

Accepted Answer

A) True 
 B)False

Question 20

A workbook template has which of the following file extensions?

Accepted Answer

A)  .xltx 
B)  .xls 
C)  .xlsx 
D)  .xlst 
A)  .xltx 
B)  .xls 
C)  .xlsx 
D)  .xlst

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet.What should she do before creating the PivotChart?

You can use the Evaluate Formula button to identify the source of a cell error.

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

You can add a calculated field to a PivotTable to use formulas to analyze the PivotTable data.

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

What can you do when you have two levels of data in PivotTable rows?

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series.How can she quickly remove it?

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Calista wants to provide additional information about a hyperlink she is creating.Which of the following can she do?

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

Which of the following is the temporary storage area that holds selections you copy or cut?

To change the background color of a cell, you use the Background color button.

You can create a query to by adding what type of data to the data model?

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

Stephanie added data validation to a worksheet column after entering a few records of data.Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

You can use trendlines to project future data based on past trends.

A workbook template has which of the following file extensions?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet.What should she do before creating the PivotChart?

You can use the Evaluate Formula button to identify the source of a cell error.

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

You can add a calculated field to a PivotTable to use formulas to analyze the PivotTable data.

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

What can you do when you have two levels of data in PivotTable rows?

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series.How can she quickly remove it?

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Calista wants to provide additional information about a hyperlink she is creating.Which of the following can she do?

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

Which of the following is the temporary storage area that holds selections you copy or cut?

To change the background color of a cell, you use the Background color button.

You can create a query to by adding what type of data to the data model?

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

Stephanie added data validation to a worksheet column after entering a few records of data.Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

You can use trendlines to project future data based on past trends.

A workbook template has which of the following file extensions?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters