Question 1

Tracer arrows help you determine which cells are included in named ranges.

Accepted Answer

A) True 
 B)False

Question 2

If you change data used in the data model, what should you do?

Accepted Answer

A)  Refresh the data. 
B)  Reset the relationships. 
C)  Add the new data to the data model. 
D)  Display the data in Table view. 
A)  Refresh the data. 
B)  Reset the relationships. 
C)  Add the new data to the data model. 
D)  Display the data in Table view.

Question 3

In formulas, calculations in square brackets are calculated first.

Accepted Answer

A) True 
 B)False

Question 4

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

Accepted Answer

A) True 
 B)False

Question 5

You can use the I-beam pointer to move cell contents into adjacent cells.

Accepted Answer

A) True 
 B)False

Question 6

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 7

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

Accepted Answer

A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting 
A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting

Question 8

What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

Accepted Answer

A)  WordArt 
B)  Screenshot 
C)  Picture 
D)  SmartArt 
A)  WordArt 
B)  Screenshot 
C)  Picture 
D)  SmartArt

Question 9

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

Question 10

Rohan can display the current date in a cell using the TODAY() function.

Accepted Answer

A) True 
 B)False

Question 11

Flash Fill enters text based on patterns it finds in the data.

Accepted Answer

A) True 
 B)False

Question 12

Which property do you use to change the text displayed on a form control?

Accepted Answer

A)  Caption 
B)  Tag 
C)  Display Name 
D)  Label 
A)  Caption 
B)  Tag 
C)  Display Name 
D)  Label

Question 13

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 14

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 15

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 16

When you set a Stop error alert style in a cell, users have the option of entering data or cancelling.

Accepted Answer

A) True 
 B)False

Question 17

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Accepted Answer

A) True 
 B)False

Question 18

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

Accepted Answer

A)  On the Margins tab of the Page Setup dialog box, change the number in the Left box. 
B)  On the Page Layout tab, click the Margins button and then click Normal. 
C)  On the Page tab of the Page Setup dialog box, change the Orientation setting. 
D)  On the Margins tab of the Page Setup dialog box, click the Preset button. 
A)  On the Margins tab of the Page Setup dialog box, change the number in the Left box. 
B)  On the Page Layout tab, click the Margins button and then click Normal. 
C)  On the Page tab of the Page Setup dialog box, change the Orientation setting. 
D)  On the Margins tab of the Page Setup dialog box, click the Preset button.

Question 19

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 20

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

Accepted Answer

A)  Limits 
B)  Answer 
C)  Sensitivity 
D)  Scenario 
A)  Limits 
B)  Answer 
C)  Sensitivity 
D)  Scenario

Tracer arrows help you determine which cells are included in named ranges.

If you change data used in the data model, what should you do?

In formulas, calculations in square brackets are calculated first.

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

You can use the I-beam pointer to move cell contents into adjacent cells.

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

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

A workbook template has which of the following file extensions?

Rohan can display the current date in a cell using the TODAY() function.

Flash Fill enters text based on patterns it finds in the data.

Which property do you use to change the text displayed on a form control?

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

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

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

When you set a Stop error alert style in a cell, users have the option of entering data or cancelling.

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

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

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 2: Excel 2019

Tracer arrows help you determine which cells are included in named ranges.

If you change data used in the data model, what should you do?

In formulas, calculations in square brackets are calculated first.

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

You can use the I-beam pointer to move cell contents into adjacent cells.

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

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

A workbook template has which of the following file extensions?

Rohan can display the current date in a cell using the TODAY() function.

Flash Fill enters text based on patterns it finds in the data.

Which property do you use to change the text displayed on a form control?

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

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

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

When you set a Stop error alert style in a cell, users have the option of entering data or cancelling.

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

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

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters