Exam 2: Excel 2019

When you want to load data such as an Access table into the Data Model, which option do you select in the Import Data dialog box?

When James added a date field to a PivotTable, Excel grouped the date values into quarters, months, and years. He does not want to group the data this way, so he clicks the Remove button on the PivotTable Tools Analyze tab.

In a complex formula, how does Excel determine which calculation to perform first?

When you click a cell to insert a cell reference in a formula, you must type a(n) number to lock the cell reference in the formula.

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?

What can you do to store the parameters of the current Solver model in a worksheet so you do not lose the model details when you create a new model?

Liza has a table with six fields and 50 records. To make it easier to distinguish the records, she can apply banded rows.

When you add a field to the Filters area of a PivotTable, Excel displays a slicer near the top of the worksheet.

Igor wants to set 1-inch margins on the left and right and 0.5-inch margins on the top and bottom of a printed page. Which of the following dialog boxes should he use to change the margins?

A named range, also called a descriptive range, uses descriptive names instead of cell or range references.

Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks?

Which of the following tools do you use to view the contents of the Data Model?

Annemarie wants to save a workbook as a shared workbook to allow several users to work on it simultaneously. For this, she clicks X > Y > Share Workbook > Editing tab > Allow changes by more than one user at the same time > OK > Save the shared workbook on a network location for other users to access it in Save As dialog box. What can X and Y be in the series of clicks?

Cedric has a table listing customer data, including the date of their purchase. He can sort the Date data in descending order to quickly find customers with recent purchases.

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

When you use the Windows Start menu to start Excel, it opens in Backstage view.

The DAVERAGE function returns the maximum value in a column for cells matching the criteria.

To remove trace arrows in a cell, select the cell, then click Formulas > Arrow beside Remove Arrows > The type of arrow you want to remove from the list.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.