Question 1

Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?

Accepted Answer

A)  Calculate Now 
B)  Manual 
C)  On Save 
D)  Recalculate 
A)  Calculate Now 
B)  Manual 
C)  On Save 
D)  Recalculate

Question 2

Smith created SmartArt that illustrates four steps in a process. How can he add a fifth step?

Accepted Answer

A)  Apply a SmartArt style. 
B)  Convert the SmartArt to shapes. 
C)  Promote a shape. 
D)  Add a shape. 
A)  Apply a SmartArt style. 
B)  Convert the SmartArt to shapes. 
C)  Promote a shape. 
D)  Add a shape.

Question 3

Where can you display a list of all the macros in the current workbook.

Accepted Answer

A)  Visual Basic dialog box 
B)  This Workbook dialog box 
C)  Developer dialog box 
D)  Macro dialog box 
A)  Visual Basic dialog box 
B)  This Workbook dialog box 
C)  Developer dialog box 
D)  Macro dialog box

Question 4

Which of the following Excel features finds a numeric solution to a problem involving several input values?

Accepted Answer

A)  Solver 
B)  PivotTable 
C)  one-variable data table 
D)  Goal Seek 
A)  Solver 
B)  PivotTable 
C)  one-variable data table 
D)  Goal Seek

Question 5

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Accepted Answer

A)  master 
B)  model 
C)  template 
D)  standard 
A)  master 
B)  model 
C)  template 
D)  standard

Question 6

In a complex formula, how does Excel determine which calculation to perform first?

Accepted Answer

A)  It calculates the leftmost formulas first. 
B)  It calculates operations outside parentheses first. 
C)  It follows the order of operations. 
D)  It calculates functions first. 
A)  It calculates the leftmost formulas first. 
B)  It calculates operations outside parentheses first. 
C)  It follows the order of operations. 
D)  It calculates functions first.

Question 7

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

Accepted Answer

A)  What-If Analysis 
B)  Data Validation 
C)  Remove Duplicates 
D)  Consolidate worksheet data. 
A)  What-If Analysis 
B)  Data Validation 
C)  Remove Duplicates 
D)  Consolidate worksheet data.

Question 8

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

Accepted Answer

A) True 
 B)False

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

After selecting a range of data, what can you click to display common chart types based on the range you selected?

Accepted Answer

A)  Chart Options button 
B)  Paste Options button 
C)  Flash Fill button 
D)  Quick Analysis button 
A)  Chart Options button 
B)  Paste Options button 
C)  Flash Fill button 
D)  Quick Analysis button

Question 11

To change the starting and ending values on a chart axis, use the _____ pane.

Accepted Answer

A)  Chart 
B)  Format Axis 
C)  Format Shape 
D)  Labels 
A)  Chart 
B)  Format Axis 
C)  Format Shape 
D)  Labels

Question 12

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

Accepted Answer

A)  Shape Fill 
B)  Shape Effects 
C)  Shape Outline 
D)  More button 
A)  Shape Fill 
B)  Shape Effects 
C)  Shape Outline 
D)  More button

Question 13

Which of the following would you use to print only one page of a multipage worksheet?

Accepted Answer

A)  Page Layout tab 
B)  Formulas tab 
C)  Backstage view 
D)  Page Setup dialog box 
A)  Page Layout tab 
B)  Formulas tab 
C)  Backstage view 
D)  Page Setup dialog box

Question 14

Lauren wants to share a workbook via email. Which Share pane option should she use to do so?

Accepted Answer

A)  Get a sharing link, 
B)  Send now 
C)  Send as attachment 
D)  Start email program 
A)  Get a sharing link, 
B)  Send now 
C)  Send as attachment 
D)  Start email program

Question 15

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Accepted Answer

A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function. 
A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function.

Question 16

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 17

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

Accepted Answer

A) True 
 B)False

Question 18

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?

Accepted Answer

A)  '=COUNT(B1:B20) 
B)  =COUNTA(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20) 
A)  '=COUNT(B1:B20) 
B)  =COUNTA(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20)

Question 19

Which of the following can you do to decrease the level of a SmartArt shape?

Accepted Answer

A)  Make the shape smaller. 
B)  Promote the shape. 
C)  Demote the shape. 
D)  Move the shape. 
A)  Make the shape smaller. 
B)  Promote the shape. 
C)  Demote the shape. 
D)  Move the shape.

Question 20

The Table Styles gallery includes an option for creating a custom table style.

Accepted Answer

A) True 
 B)False

Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?

Smith created SmartArt that illustrates four steps in a process. How can he add a fifth step?

Where can you display a list of all the macros in the current workbook.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

In a complex formula, how does Excel determine which calculation to perform first?

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

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

After selecting a range of data, what can you click to display common chart types based on the range you selected?

To change the starting and ending values on a chart axis, use the _____ pane.

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

Which of the following would you use to print only one page of a multipage worksheet?

Lauren wants to share a workbook via email. Which Share pane option should she use to do so?

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

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

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?

Which of the following can you do to decrease the level of a SmartArt shape?

The Table Styles gallery includes an option for creating a custom table style.

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

Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?

Smith created SmartArt that illustrates four steps in a process. How can he add a fifth step?

Where can you display a list of all the macros in the current workbook.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

In a complex formula, how does Excel determine which calculation to perform first?

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

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

After selecting a range of data, what can you click to display common chart types based on the range you selected?

To change the starting and ending values on a chart axis, use the _____ pane.

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

Which of the following would you use to print only one page of a multipage worksheet?

Lauren wants to share a workbook via email. Which Share pane option should she use to do so?

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

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

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?

Which of the following can you do to decrease the level of a SmartArt shape?

The Table Styles gallery includes an option for creating a custom table style.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters