Question 1

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?

Accepted Answer

A)  =IF(B2>=60, C2>=60) 
B)  =OR(B2>=60, C2>=60) 
C)  =AND(B2>=60, C2>=60) 
D)  =NOT(OR(B2>=60, C2>=60))

Question 2

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

Accepted Answer

A)  Chart Elements dialog box 
B)  Format Data Source dialog box 
C)  Select Data Source dialog box 
D)  Insert Chart dialog box

Question 3

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 _____.

Accepted Answer

A)  Document Calculations 
B)  List Formulas 
C)  Show Formulas 
D)  Formula Sheet

Question 4

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

Accepted Answer

A)  A PivotChart 
B)  Power Pivot 
C)  Solver 
D)  A timeline slicer

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  the first field to analyze 
B)  the number of the column to analyze 
C)  the number of values to analyze 
D)  the number of the function to use

Question 7

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?

Accepted Answer

A)  No Fill 
B)  Theme Colors 
C)  Standard Colors 
D)  More Fill Colors

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

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?

Accepted Answer

A)  DB(100000, 25000, 10, 4) 
B)  SLN(100000, 25000, 4) 
C)  DB(100000, 10, 4) 
D)  SLN(25000, 10, 4)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)  step trend 
B)  growth trend 
C)  AutoFill trend 
D)  linear trend

Question 12

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

Accepted Answer

A)  Electronic certificate 
B)  Security mark 
C)  Digital signature 
D)  Password

Question 13

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

Accepted Answer

A)  Get Defined Names 
B)  Apply Names 
C)  Use Defined Names 
D)  Named Ranges

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  Find 
B)  Replace 
C)  Select 
D)  Paste

Question 16

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

Accepted Answer

A)  Column Width command 
B)  Center button 
C)  Merge and Center button 
D)  Increase Indent button

Question 17

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.

Accepted Answer

A) True 
 B)False

Question 18

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?

Accepted Answer

A)  Total Row 
B)  Header Row 
C)  Footer Row 
D)  Banded Rows

Question 19

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.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  Open the Power Query Editor window. 
B)  Open the Queries & Connections pane. 
C)  Open the Business Intelligence pane. 
D)  Open the Get Data dialog box.

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?

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?

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