Question 1

After you record a macro, you should _____ it to test the actions it contains.

Accepted Answer

A)  save 
B)  run 
C)  customize 
D)  rename 
A)  save 
B)  run 
C)  customize 
D)  rename

Question 2

You can click the Field List button to show or hide the PivotTable Fields pane.

Accepted Answer

A) True 
 B)False

Question 3

Amari formatted a picture using effects, styles, and a border.What tool can she use to copy the formatting from this picture to another one?

Accepted Answer

A)  Artistic Effects 
B)  Corrections 
C)  Format Painter 
D)  Format Duplicator 
A)  Artistic Effects 
B)  Corrections 
C)  Format Painter 
D)  Format Duplicator

Question 4

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 5

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

Accepted Answer

A)  structured reference 
B)  absolute reference 
C)  3-D reference 
D)  mixed reference 
A)  structured reference 
B)  absolute reference 
C)  3-D reference 
D)  mixed reference

Question 6

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 7

With a _____, you can emphasize one data point by exploding it.

Accepted Answer

A)  Column chart 
B)  Line chart 
C)  3-D Pie chart 
D)  3-D Area chart 
A)  Column chart 
B)  Line chart 
C)  3-D Pie chart 
D)  3-D Area chart

Question 8

To insert only the current date in cell B1, use the NOW function in cell B1 .

Accepted Answer

A) True 
 B)False

Question 9

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is true when you delete a cell?

Accepted Answer

A)  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. 
B)  Row and column alignment will not be affected. 
C)  You need to manually adjust cell references in surrounding formulas. 
D)  You can use the Delete command on the Insert tab. 
A)  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. 
B)  Row and column alignment will not be affected. 
C)  You need to manually adjust cell references in surrounding formulas. 
D)  You can use the Delete command on the Insert tab.

Question 11

Kyla has a Clustered Column PivotChart that compares sales in four locations.How can she add columns that show a 10 percent increase in sales in each location?

Accepted Answer

A)  Add a calculated field. 
B)  Switch columns and rows. 
C)  Filter the PivotChart. 
D)  Refresh the data. 
A)  Add a calculated field. 
B)  Switch columns and rows. 
C)  Filter the PivotChart. 
D)  Refresh the data.

Question 12

Luke is working with a table filtered to show only some records.What can he do to display all the records in the table?

Accepted Answer

A)  Reapply the filter. 
B)  Clear the filter. 
C)  Change the table format. 
D)  Apply a new filter. 
A)  Reapply the filter. 
B)  Clear the filter. 
C)  Change the table format. 
D)  Apply a new filter.

Question 13

Which of the following is true when you copy and paste formulas using the fill handle?

Accepted Answer

A)  The Paste Options button lets you paste only specific elements of the copied selection. 
B)  The AutoFill Options button lets you fill cells with specific elements of the copied cell. 
C)  The formula is placed on the Office clipboard. 
D)  You need to change the cell references to reflect the new formula location. 
A)  The Paste Options button lets you paste only specific elements of the copied selection. 
B)  The AutoFill Options button lets you fill cells with specific elements of the copied cell. 
C)  The formula is placed on the Office clipboard. 
D)  You need to change the cell references to reflect the new formula location.

Question 14

Which of the following is true about moving cell contents?

Accepted Answer

A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature. 
A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature.

Question 15

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

Accepted Answer

A) True 
 B)False

Question 16

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following options can change the colors and font style in a PivotChart?

Accepted Answer

A)  PivotChart style 
B)  PivotChart layout 
C)  PivotChart field buttons 
D)  PivotChart axis settings 
A)  PivotChart style 
B)  PivotChart layout 
C)  PivotChart field buttons 
D)  PivotChart axis settings

Question 18

To import data from an Access table into Excel, you use the _____ tool.

Accepted Answer

A)  Insert Table 
B)  Links & Connections 
C)  Get & Transform 
D)  Access to Excel 
A)  Insert Table 
B)  Links & Connections 
C)  Get & Transform 
D)  Access to Excel

Question 19

To print more than one copy of your worksheet, which tab would you go to?

Accepted Answer

A)  View 
B)  Page Layout 
C)  Insert 
D)  File 
A)  View 
B)  Page Layout 
C)  Insert 
D)  File

Question 20

Which of the following options can you use to increase the level of a SmartArt shape?

Accepted Answer

A)  Promote 
B)  Demote 
C)  Level Up 
D)  Larger 
A)  Promote 
B)  Demote 
C)  Level Up 
D)  Larger

After you record a macro, you should _____ it to test the actions it contains.

You can click the Field List button to show or hide the PivotTable Fields pane.

Amari formatted a picture using effects, styles, and a border.What tool can she use to copy the formatting from this picture to another one?

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

With a _____, you can emphasize one data point by exploding it.

To insert only the current date in cell B1, use the NOW function in cell B1 .

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

Which of the following is true when you delete a cell?

Kyla has a Clustered Column PivotChart that compares sales in four locations.How can she add columns that show a 10 percent increase in sales in each location?

Luke is working with a table filtered to show only some records.What can he do to display all the records in the table?

Which of the following is true when you copy and paste formulas using the fill handle?

Which of the following is true about moving cell contents?

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

Which of the following options can change the colors and font style in a PivotChart?

To import data from an Access table into Excel, you use the _____ tool.

To print more than one copy of your worksheet, which tab would you go to?

Which of the following options can you use to increase the level of a SmartArt shape?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

After you record a macro, you should _____ it to test the actions it contains.

You can click the Field List button to show or hide the PivotTable Fields pane.

Amari formatted a picture using effects, styles, and a border.What tool can she use to copy the formatting from this picture to another one?

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

With a _____, you can emphasize one data point by exploding it.

To insert only the current date in cell B1, use the NOW function in cell B1 .

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

Which of the following is true when you delete a cell?

Kyla has a Clustered Column PivotChart that compares sales in four locations.How can she add columns that show a 10 percent increase in sales in each location?

Luke is working with a table filtered to show only some records.What can he do to display all the records in the table?

Which of the following is true when you copy and paste formulas using the fill handle?

Which of the following is true about moving cell contents?

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

Which of the following options can change the colors and font style in a PivotChart?

To import data from an Access table into Excel, you use the _____ tool.

To print more than one copy of your worksheet, which tab would you go to?

Which of the following options can you use to increase the level of a SmartArt shape?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters