Exam 2: Excel-2019

You can use the DELETE key to clear cell contents.

When you unprotect a workbook, you allow anyone to insert, delete, and rename its worksheets.

You use the SUMIFS function to sum ranges with multiple criteria.

After adding data validation criteria to a worksheet, which of the following features can you use to locate data that doesn't satisfy the criteria?

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

The COUNTIF function counts blank cells.

If you change theme colors, you must restore the original colors before closing Excel.

It is possible to go to the next comment using the Next Comment button in the Comments group on the Review tab.

After adding tables to the Data Model, where can you create a relationship between the tables?

When you record a macro, Excel stores it as a VBA module attached to the workbook.

To return cell contents to its default font and style, you can use the _____ command.

To remove a field from a PivotTable, clear its check box in the field list.

When you create a PivotChart directly from data, what does Excel do?

When you underline cell content, you are using _____.

In one workbook, Tim wants to include a link to another workbook. Which of the following dialog boxes should he use to add the link?

Jeremy created a worksheet with a Departments column and an Expenses column. To average the expense amounts for the Customer Service Department only, he can use the AVERAGE function.

When you use a named range in a formula, it becomes a(n) _____ reference by default.

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas. She does not want to update the data tables on the worksheet, but she does want to update the other formulas. Which of the following is the most efficient way for her to do so?

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

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?