Question 1

When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet.

Accepted Answer

When you set up worksheet protection, you can specify different actions that users are allowed to perform, such as selecting cells, formatting cells, or inserting/deleting rows and columns.

Question 2

Every cell in a workbook has a locked property, but the property is unused until the worksheet is protected.

Accepted Answer

The locked property of a cell is only effective when the worksheet is protected, so it is unused until then.

Question 3

Juanita lists expenses in a PivotTable field named Expenses. She wants to filter the PivotTable to display data only for expenses greater than $1,000. What type of filter should she use?
A) Manual
B) Date
C) Label
D) Value

Accepted Answer

Juanita should use a Value filter to filter the PivotTable based on the expense amounts. She can set the filter criteria to only include expenses greater than $1,000.

Question 4

Nicole has a PivotTable that groups Order dates by quarters, months, and years. She wants to group the data by year only. To do so, she can use the Grouping dialog box to regroup the dates.

Accepted Answer

By using the Grouping dialog box, Nicole can regroup the dates to display the data by year only.

Question 5

If you want to rename a worksheet in a protected workbook, you must first unprotect the workbook.

Accepted Answer

Renaming a worksheet requires making changes to the structure of the workbook, which is not allowed in a protected workbook. Therefore, you must unprotect the workbook before you can rename a worksheet.

Question 6

An advantage of the _____ PivotTable layout is that it reduces the width of the PivotTable by placing all fields from the Rows area in one column.
A) Outline
B) Compact
C) Tabular
D) Subtotals

Accepted Answer

The Compact PivotTable layout reduces the width of the PivotTable by placing all fields from the Rows area in one column, making it easier to view and analyze the data. The other options, Outline, Tabular, and Subtotals, do not have this specific advantage.

Question 7

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field.

Accepted Answer

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field. So, the statement is true.

Question 8

Doug is using WordArt for a chart title that displays an outline of letters with shadows. To display filled letters with reflections, he can change the Transform effect.

Accepted Answer

To display filled letters with reflections, Doug needs to change the Format effect instead of Transform effect.

Question 9

Edie has a worksheet listing lectures scheduled for the year. She wants to know how many cells in the Rating column contain "Excellent." Which of the following functions should she use?
A) DCOUNTA
B) COUNT
C) COUNTIF
D) COUNTAIF

Accepted Answer

The answer of Edie has a worksheet listing lectures scheduled...

Question 10

Rodney has a worksheet that lists the revenue earned per month from technology consulting services. He wants to know how much total revenue his company collected during September. Which of the following functions should he use?
A) DGET
B) DAVERAGE
C) DSUM
D) DMAX

Accepted Answer

Rodney should use the DSUM function to calculate the total revenue earned during September as it allows him to sum a range of values based on specified criteria.

Question 11

Marilyn added a few calculated fields and items to a PivotTable and wants to document the calculations on a separate worksheet. She can click the Fields, Items, & Sets button, and then click _____.
A) Document Calculations
B) List Formulas
C) Show Formulas
D) Formula Sheet

Accepted Answer

The "List Formulas" option allows Marilyn to document the calculations by listing all the formulas used in the PivotTable on a separate worksheet.

Question 12

Tamara wants to count the number of values in the Rating column that are greater than 7. Which of the following functions should she use?
A) DCOUNT
B) DCOUNTA
C) COUNTIF
D) COUNTAIF

Accepted Answer

The answer of Tamara wants to count the number of...

Question 13

A calculated field is a user-defined formula for calculations across one or more fields.

Accepted Answer

A calculated field is indeed a user-defined formula for calculations across one or more fields.

Question 14

Harry has a PivotTable listing Stores and the revenue they produce. He wants to calculate the difference between the revenue from one store and another. What should he create?
A) calculated item
B) measure
C) hierarchy
D) custom list

Accepted Answer

To calculate the difference between the revenue from one store and another, Harry should create a calculated item. This will allow him to add a new column that calculates the difference between the revenue of two stores.

Question 15

When you protect a worksheet, you prevent users from renaming or deleting the worksheet.

Accepted Answer

When you protect a worksheet, you prevent users from editing the locked cells and certain other features, but it does not prevent users from renaming or deleting the worksheet.

Question 16

When Kai right-clicks a sheet tab in a workbook, some commands on the shortcut menu are gray. That means the worksheet is hidden.

Accepted Answer

Gray commands in a shortcut menu typically indicate that those options are unavailable or not applicable at the moment, not necessarily that the worksheet is hidden.

Question 17

To unprotect a worksheet, open the worksheet, click the Review tab, and then click the Unprotect Sheet button.

Accepted Answer

This is the correct process to unprotect a worksheet in Microsoft Excel.

Question 18

Nathan has a PivotTable listing income from promotional events. He wants to multiple the value of a Tickets Sold field by a Price per Ticket field to find the total income from each type of ticket. He should create a calculated item .

Accepted Answer

A calculated field, not a calculated item, should be used to perform operations on entire fields in a PivotTable.

Question 19

The PivotTable layouts different mainly in how they arrange fields in the Rows area and where they display grand totals.

Accepted Answer

The answer of The PivotTable layouts different mainly in how...

Question 20

Ian has a PivotTable that includes a Product Name column and wants to filter a PivotTable so it shows only product names containing the word "Double." He should apply a Value filter.

Accepted Answer

Ian should apply a Label filter, not a Value filter, because he is filtering based on text in the Product Name column.

Quiz 2: Excel 2019

When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet.

Every cell in a workbook has a locked property, but the property is unused until the worksheet is protected.

Juanita lists expenses in a PivotTable field named Expenses. She wants to filter the PivotTable to display data only for expenses greater than $1,000. What type of filter should she use?

Nicole has a PivotTable that groups Order dates by quarters, months, and years. She wants to group the data by year only. To do so, she can use the Grouping dialog box to regroup the dates.

If you want to rename a worksheet in a protected workbook, you must first unprotect the workbook.

An advantage of the _____ PivotTable layout is that it reduces the width of the PivotTable by placing all fields from the Rows area in one column.

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field.

Doug is using WordArt for a chart title that displays an outline of letters with shadows. To display filled letters with reflections, he can change the Transform effect.

Edie has a worksheet listing lectures scheduled for the year. She wants to know how many cells in the Rating column contain "Excellent." Which of the following functions should she use?

Rodney has a worksheet that lists the revenue earned per month from technology consulting services. He wants to know how much total revenue his company collected during September. Which of the following functions should he use?

Marilyn added a few calculated fields and items to a PivotTable and wants to document the calculations on a separate worksheet. She can click the Fields, Items, & Sets button, and then click _____.

Tamara wants to count the number of values in the Rating column that are greater than 7. Which of the following functions should she use?