Exam 2: Excel 2019

The scores of a student in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?

Which of the following dialog boxes do you use to remove a data series from a chart?

Marilyn added a few calculated fields and items to a PivotTable and wants to document the calculations on a separate worksheet. She can click the Fields, Items, & Sets button, and then click _____.

_____ provides access to the Data Model, a database attached to an Excel workbook.

When you print in portrait orientation, the page is wider than it is tall.

In the formula = SUBTOTAL(1, Customers_Table(ID]), what does the 1 refer to?

Linda wants to change the color of the SmartArt that she has used in her spreadsheet. To do so, she clicks on the shape in the SmartArt graphic. She then clicks on the arrow next to Shape Fill under Drawing Tools, on the Format tab, in the Shape Styles group. Linda then selects an option from the menu that appears, and under the Colors Dialog box and Standard, she chooses the color she wants the SmartArt to be and clicks OK. What can the option that she selected from the menu under Shape Fill be?

To insert WordArt in Excel, click the WordArt button on the Insert tab, select the WordArt style, and then type to replace the placeholder text.

Which of the following formulas would you use to calculate the fourth year of depreciation of a $100,000 loan that declines to a salvage value of $25,000 after 10 years?

References to fields in an Excel table are called table references.

A(n) _____ changes values by a constant percentage.

A(n) _____ marks a workbook as coming from a trusted author.

To use defined names in existing formulas, click the Define Name arrow, and then click _____.

If you add two fields to the Rows area of a PivotTable, you can click the plus box to expand the fields and display their values.

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command .

To combine multiple cells into one combined cell, which of the following do you use?

Pam inserted links to data in another workbook, but now wants to replace the links with data and calculated values. She can break the links to the other workbook.

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?

In order to reject changes made by all users in a workbook, click/enter information in the following series: Review tab > Changes group > Track Changes > Accept or Reject Changes > OK (if prompted to save the workbook) > Select Changes to Accept or Reject dialog box > Select Where check box > OK > Review information about each change in the dialog box > Reject > OK.

How can you display all the queries in the current workbook?