Exam 2: Excel 2019

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

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.

If you want to paste values and number formatting only, click the Paste Numbers button that appears below the pasted cell.

When you create a scenarios, you identify the input cells, the cells whose values will change in each scenario.

Which worksheet view shows headers, footers, and rulers?

Which of the following Excel tools displays the syntax for a selected function?

Ricki has an Analysis workbook containing many worksheets of sales data that she wants to use in a new workbook. What is the easiest way for her to use the sales data in the new workbook?

You can use the DELETE key to clear cell contents.

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

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?

Nolan wants to display a red triangle in a PivotTable cell for increased expenses, a blue triangle for steady expenses, and a green triangle for declining expenses. He can create a custom icon set to do so.

To turn track changes on in an Excel sheet, click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).

In the formula =[SalesPrice]*.05, what do you call [SalesPrice]?

To find every cell that satisfies the criteria you enter in the Fine and Replace dialog box, you click the Find Next button.

Which of the following tools can you use to validate data already entered in a workbook?

Marcos has a PivotTable that shows revenue by quarter. He wants to calculate the differences between the revenue for one quarter and another. What can he do?

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Which of these is the default layout for a newly created Pivot table?

Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the range A3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of each row in column N to track the monthly sales for each product. What can she insert in the range N3:N7?