Exam 2: Excel 2019

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?

Alba wants to use a watermark image as the background of her worksheet. She goes to the Page Setup group on the Page Layout tab. What option should she click to begin choosing the image file to use as a watermark?

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

The Comma Style format adds a comma and a dollar sign to a cell value.

Column sparklines show a general trend without a legend, title, or gridlines.

Eleanor wants to repeat the first row of the worksheet on each printed page of a four-page worksheet. Which of the following options should she use in the Page Setup dialog box?

If you are importing financial data from a text file that uses commas in currency values, make sure it uses _____ to separate the columns of values.

In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours?

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

When you underline cell content, you are using _____.

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

The scenario overview report lists the values for the changing and result cells within each scenario.

Which type of sparklines display a green block for increased values and a red block for declining values?

A(n) _____ chart organizes hierarchies of data in a series of concentric rings and is appropriate for showing groups within categories of information.

How can you tell if Solver is activated in your version of Excel?

When you import a query into an Excel table, what does Excel use for the table name?

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

To create a formula that provides a statistical analysis of data, include a function from the Text category.

While working in Page Layout view, how can you enter your name so it appears in the lower-right corner of the printout?

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.