Question 1

A _____ is a graphic object you use to filter data in a PivotTable and show only the data you need.

Accepted Answer

A)  sparkline 
B)  slicer 
C)  list control 
D)  Quick Analysis button 
A)  sparkline 
B)  slicer 
C)  list control 
D)  Quick Analysis button

Question 2

To see how copied contents will look with both values and number formatting, you would use Paste Numbers.

Accepted Answer

A) True 
 B)False

Question 3

Carmen filtered a table on the values in the Department column and now wants to clear the filter.What can she do? Select all the options that apply.

Accepted Answer

A)  Click the Sort & Filter button on the Home tab, then click Clear. 
B)  Click the Department arrow, then click Clear Filter from "Department". 
C)  Click the Filter Button check box on the Table Tools Design tab. 
D)  Right-click a cell in the Department column, then click Clear Contents on the shortcut menu. 
A)  Click the Sort & Filter button on the Home tab, then click Clear. 
B)  Click the Department arrow, then click Clear Filter from "Department". 
C)  Click the Filter Button check box on the Table Tools Design tab. 
D)  Right-click a cell in the Department column, then click Clear Contents on the shortcut menu.

Question 4

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

Accepted Answer

A) True 
 B)False

Question 5

Currency is an example of a number format.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following table style options can you show or hide in a table? Select all the options that apply.

Accepted Answer

A)  Table Name 
B)  Header Row 
C)  Filter Button 
D)  First Column 
A)  Table Name 
B)  Header Row 
C)  Filter Button 
D)  First Column

Question 7

In a chart, a data table displays the data series in rows and the category values in columns.

Accepted Answer

A) True 
 B)False

Question 8

What happens if you select the City and Product Type check boxes in the Insert Slicers dialog box?

Accepted Answer

A)  You add the City and Product Type buttons to a slicer. 
B)  You add the City and Product Type slicers to the worksheet. 
C)  You filter the PivotTable on the City and Product Type fields. 
D)  You add the City and Product Type fields to the PivotTable. 
A)  You add the City and Product Type buttons to a slicer. 
B)  You add the City and Product Type slicers to the worksheet. 
C)  You filter the PivotTable on the City and Product Type fields. 
D)  You add the City and Product Type fields to the PivotTable.

Question 9

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others.After clicking in row 25, which option should she select in the Breaks button list?

Accepted Answer

A)  Reset All Page Breaks 
B)  Remove Page Break 
C)  Reset Current Page Break 
D)  Move Page Break 
A)  Reset All Page Breaks 
B)  Remove Page Break 
C)  Reset Current Page Break 
D)  Move Page Break

Question 10

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

Accepted Answer

A)  Assign Macro 
B)  Run Macro 
C)  Set as Macro 
D)  View Macros 
A)  Assign Macro 
B)  Run Macro 
C)  Set as Macro 
D)  View Macros

Question 11

To filter a PivotTable to show expenses for only Chicago and Seattle in the City field, press _____ then click the Chicago and Seattle buttons in the City slicer.

Accepted Answer

A)  Tab 
B)  Alt 
C)  Ctrl 
D)  Shift 
A)  Tab 
B)  Alt 
C)  Ctrl 
D)  Shift

Question 12

When you group data to create a(n) custom view, you can create groups of columns or rows.

Accepted Answer

A) True 
 B)False

Question 13

You can create a PivotChart from data or from a PivotTable report.

Accepted Answer

A) True 
 B)False

Question 14

In cell B4, Marcia inserted the formula = (B1+B2)/B3.To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following arguments do you need to provide to the PMT function? Select all the options that apply.

Accepted Answer

A)  rate 
B)  nper 
C)  fv 
D)  pv 
A)  rate 
B)  nper 
C)  fv 
D)  pv

Question 16

Which of the following are financial functions? Select all the options that apply.

Accepted Answer

A)  PMT 
B)  PROPER 
C)  NPER 
D)  FV 
A)  PMT 
B)  PROPER 
C)  NPER 
D)  FV

Question 17

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

Accepted Answer

A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle 
A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle

Question 18

Which of the following are arguments for the VLOOKUP function? Select all the options that apply.

Accepted Answer

A)  lookup_value 
B)  table_array 
C)  vert_num 
D)  col_index_num 
A)  lookup_value 
B)  table_array 
C)  vert_num 
D)  col_index_num

Question 19

Which of the following appears in Page Layout view?

Accepted Answer

A)  Text box containing the header 
B)  Margins 
C)  Page number indicator 
D)  Blue dotted lines indicating page breaks 
A)  Text box containing the header 
B)  Margins 
C)  Page number indicator 
D)  Blue dotted lines indicating page breaks

Question 20

Liam often types the names of the 12 offices where his company does business.He wants to be able to enter the first office name, then drag the fill handle to enter the other office names.What should he create?

Accepted Answer

A)  macro, 
B)  Flash Fill list 
C)  custom AutoFill list 
D)  Quick Table 
A)  macro, 
B)  Flash Fill list 
C)  custom AutoFill list 
D)  Quick Table

A _____ is a graphic object you use to filter data in a PivotTable and show only the data you need.

To see how copied contents will look with both values and number formatting, you would use Paste Numbers.

Carmen filtered a table on the values in the Department column and now wants to clear the filter.What can she do? Select all the options that apply.

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

Currency is an example of a number format.

Which of the following table style options can you show or hide in a table? Select all the options that apply.

In a chart, a data table displays the data series in rows and the category values in columns.

What happens if you select the City and Product Type check boxes in the Insert Slicers dialog box?

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others.After clicking in row 25, which option should she select in the Breaks button list?

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

To filter a PivotTable to show expenses for only Chicago and Seattle in the City field, press _____ then click the Chicago and Seattle buttons in the City slicer.

When you group data to create a(n) custom view, you can create groups of columns or rows.

You can create a PivotChart from data or from a PivotTable report.

In cell B4, Marcia inserted the formula = (B1+B2)/B3.To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.

Which of the following arguments do you need to provide to the PMT function? Select all the options that apply.

Which of the following are financial functions? Select all the options that apply.

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

Which of the following are arguments for the VLOOKUP function? Select all the options that apply.

Which of the following appears in Page Layout view?

Liam often types the names of the 12 offices where his company does business.He wants to be able to enter the first office name, then drag the fill handle to enter the other office names.What should he create?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

A _____ is a graphic object you use to filter data in a PivotTable and show only the data you need.

To see how copied contents will look with both values and number formatting, you would use Paste Numbers.

Carmen filtered a table on the values in the Department column and now wants to clear the filter.What can she do? Select all the options that apply.

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

Currency is an example of a number format.

Which of the following table style options can you show or hide in a table? Select all the options that apply.

In a chart, a data table displays the data series in rows and the category values in columns.

What happens if you select the City and Product Type check boxes in the Insert Slicers dialog box?

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others.After clicking in row 25, which option should she select in the Breaks button list?

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

To filter a PivotTable to show expenses for only Chicago and Seattle in the City field, press _____ then click the Chicago and Seattle buttons in the City slicer.

When you group data to create a(n) custom view, you can create groups of columns or rows.

You can create a PivotChart from data or from a PivotTable report.

In cell B4, Marcia inserted the formula = (B1+B2)/B3.To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.

Which of the following arguments do you need to provide to the PMT function? Select all the options that apply.

Which of the following are financial functions? Select all the options that apply.

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

Which of the following are arguments for the VLOOKUP function? Select all the options that apply.

Which of the following appears in Page Layout view?

Liam often types the names of the 12 offices where his company does business.He wants to be able to enter the first office name, then drag the fill handle to enter the other office names.What should he create?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters