Exam 2: Excel-2019

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

Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

In the formula =A8*$A$1, which of the following describes A8?

To change theme effects, click the Effects button on the Page Layout tab, then select an effect from the gallery.

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

Which of the following options can you use to increase the level of a SmartArt shape?

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

A teacher creates a table for Sports Day events. The table includes columns for Event, Rank, First Name, and Last Name. To find the top-ranking participants for each event, the teacher can sort the table first by Event and then by Rank.

Tomoko lists monthly sales for each region in a worksheet. Before adding subtotals for each region, she needs to sort the values in the Region column.

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

Alba wants to display a picture as the worksheet background. Which of the following buttons on the Page Layout tab should she use?

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

Jada has a worksheet listing the first and last names of her students in a single column. Which Excel tool can she use to split the names into separate columns?

ActiveX is a named set of instructions, written in the Visual Basic programming language, that perform tasks automatically in a specified order.

Musa wants to customize the fonts he uses in a workbook. He can change the heading font and the _____ font.

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

Amelia wants to insert a hyperlink to an e-mail address. Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?

Han has four workbooks open, with one maximized on the desktop. Which button can he click on the View tab to display a different workbook?