Exam 2: Excel 2019

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

Excel provides a tool for tracing formula operators.

What feature inserts a function that totals the cells above or to the left of the selected cell?

To change the contents of a macro, you must use the Record Macro button to step into the macro.

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Which of the following formulas can you use to find the serial number of the date January 1, 2017?

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

After creating a macro, how can you make it easier to run for other workbook users?

Hannah is preparing to take out a mortgage to buy a house. She wants to compare the monthly payments for the loans she is considering, which have interest rates ranging from 3.5% to 5.25%. She can quickly fill in the values from 3.5% to 5.25% using a sequential series.

To enter your name in the lower right corner of a worksheet page, you can _____.

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

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?

Which of the following views shows how a worksheet will appear when printed?

Olivia inserted two pictures in a worksheet and wants to position their top edges in the same row. Which of the following is an efficient way for her to do this?

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

To copy a cell's formatting to another cell, which of the following can you use?

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

Before you can unprotect a worksheet, you must enter the correct password.

The SUMIF function totals only the cells in a range that meet given criteria.