Question 1

Why is it necessary to use care when inserting worksheet cells?

Accepted Answer

A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy. 
A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy.

Question 2

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

Accepted Answer

A)  Select Chart Element button 
B)  Change Colors button 
C)  Quick Layout button 
D)  Shape Styles gallery 
A)  Select Chart Element button 
B)  Change Colors button 
C)  Quick Layout button 
D)  Shape Styles gallery

Question 3

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

Accepted Answer

A)  PivotTable 
B)  3D map 
C)  measure 
D)  PowerTable 
A)  PivotTable 
B)  3D map 
C)  measure 
D)  PowerTable

Question 4

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

Accepted Answer

A)  Error bars 
B)  Number format code 
C)  Number style 
D)  Trendline 
A)  Error bars 
B)  Number format code 
C)  Number style 
D)  Trendline

Question 5

The Analysis ToolPak is an Excel add-in that contains statistical analysis tools.

Accepted Answer

A) True 
 B)False

Question 6

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

Accepted Answer

A) True 
 B)False

Question 7

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Accepted Answer

A) True 
 B)False

Question 8

When you share a protected workbook, only the data is protected, not the workbook structure.

Accepted Answer

A) True 
 B)False

Question 9

To display the first four characters from a cell containing text, you can use the MID function.

Accepted Answer

A) True 
 B)False

Question 10

When you use a named range in a formula, it becomes a(n) _____ reference by default.

Accepted Answer

A)  external 
B)  3-D 
C)  absolute 
D)  relative 
A)  external 
B)  3-D 
C)  absolute 
D)  relative

Question 11

Willa created three scenarios to perform a what-if analysis. To apply the values in the first scenario to the worksheet, she can select the first scenario and then click the Load button.

Accepted Answer

A) True 
 B)False

Question 12

How are Excel tables and PivotTables similar?

Accepted Answer

A)  Both summarize data automatically. 
B)  Both have styles you can apply for quick formatting. 
C)  Both have Field Header buttons. 
D)  Both are based on data from another worksheet. 
A)  Both summarize data automatically. 
B)  Both have styles you can apply for quick formatting. 
C)  Both have Field Header buttons. 
D)  Both are based on data from another worksheet.

Question 13

Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

Accepted Answer

A)  Axes 
B)  Legend 
C)  Gridlines 
D)  Trendline 
A)  Axes 
B)  Legend 
C)  Gridlines 
D)  Trendline

Question 14

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

Accepted Answer

A) True 
 B)False

Question 15

To return cell contents to its default font and style, you can use the _____ command.

Accepted Answer

A)  Clear Formats 
B)  Clear Contents 
C)  Clear All 
D)  Clear Comments 
A)  Clear Formats 
B)  Clear Contents 
C)  Clear All 
D)  Clear Comments

Question 16

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest. Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Accepted Answer

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

Question 17

To which of the following locations can you move a PivotChart?

Accepted Answer

A)  New workbook 
B)  Worksheet in the current workbook 
C)  Worksheet in a different workbook 
D)  You cannot move a PivotChart. 
A)  New workbook 
B)  Worksheet in the current workbook 
C)  Worksheet in a different workbook 
D)  You cannot move a PivotChart.

Question 18

To find the largest value in a cell range, use the MIN function.

Accepted Answer

A) True 
 B)False

Question 19

When you wrap and center a range, you combine the cells into one cell.

Accepted Answer

A) True 
 B)False

Question 20

If you add the Month field to the Filters area of a PivotTable, Excel filters the PivotTable to show data only for January.

Accepted Answer

A) True 
 B)False

Why is it necessary to use care when inserting worksheet cells?

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

The Analysis ToolPak is an Excel add-in that contains statistical analysis tools.

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

When you share a protected workbook, only the data is protected, not the workbook structure.

To display the first four characters from a cell containing text, you can use the MID function.

When you use a named range in a formula, it becomes a(n) _____ reference by default.

Willa created three scenarios to perform a what-if analysis. To apply the values in the first scenario to the worksheet, she can select the first scenario and then click the Load button.

How are Excel tables and PivotTables similar?

Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

To return cell contents to its default font and style, you can use the _____ command.

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest. Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

To which of the following locations can you move a PivotChart?

To find the largest value in a cell range, use the MIN function.

When you wrap and center a range, you combine the cells into one cell.

If you add the Month field to the Filters area of a PivotTable, Excel filters the PivotTable to show data only for January.

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

Why is it necessary to use care when inserting worksheet cells?

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

The Analysis ToolPak is an Excel add-in that contains statistical analysis tools.

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

When you share a protected workbook, only the data is protected, not the workbook structure.

To display the first four characters from a cell containing text, you can use the MID function.

When you use a named range in a formula, it becomes a(n) _____ reference by default.

Willa created three scenarios to perform a what-if analysis. To apply the values in the first scenario to the worksheet, she can select the first scenario and then click the Load button.

How are Excel tables and PivotTables similar?

Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

To return cell contents to its default font and style, you can use the _____ command.

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest. Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

To which of the following locations can you move a PivotChart?

To find the largest value in a cell range, use the MIN function.

When you wrap and center a range, you combine the cells into one cell.

If you add the Month field to the Filters area of a PivotTable, Excel filters the PivotTable to show data only for January.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters