Exam 2: Excel 2019

To edit placeholder text, such as in a chart title, you click the object and then type the new text.

Cedric wants to print one page of worksheet data on two pages. Which of the following can he do?

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

Arlo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal Seek command?

The Remove Duplicates tool locates and deletes records that are duplicated across more than one field.

Tracing formula _____ shows which formulas are affected by an error in another cell.

Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the SmartArt to group blocks of information in a pyramid. What should he do?

Lindsay wants to filter a PivotTable to display only June revenue data. Which of the following fields should she add to the Filters area?

Ben moved a chart to a chart sheet, but now the axis labels are too small. What can he do to make them easier to read?

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

To select a single worksheet cell so you can work with it, which of the following would you do?

A threaded comment is one that remains attached to a cell even if you move the cell.

If you want to combine data from multiple worksheets and display the results on another worksheet, you can summarize the data.

You can use the Evaluate Formula button to identify the source of a cell error.

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

To save a workbook for the first time, you use the Save As dialog box.

To specify an action based on certain conditions, you use an If…Then…Else conditional statement in VBA.