Question 1

Which of the following will you click on the Reports list box in Solver Results dialog box to produce an Answer Report?

Accepted Answer

A)   Limits
B)   Answer
C)   Sensitivity
D)   Outline ReportsE) B) and D)
F) A) and B)

Question 2

When you select a cell in a worksheet and then click the Split button on the View tab, how many panes appear in the worksheet window?

Accepted Answer

A)   six
B)   two
C)   four
D)   threeE) A) and B)
F) A) and C)

Question 3

To add cells to the Watch Window, select all cells on a worksheet with formulas, then click Home tab > Editing group > Find & Replace > Go To Special > Formulas tab > Formula Auditing group > Watch Window > Add Watch > Add.

Accepted Answer

A) True 
 B)False

Question 4

What is the correct formula to insert the date January 12, 1998 into a cell?

Accepted Answer

A)   =DATE(1998,1,12) 
B)   =DATE(1998,12,1) 
C)   =DATE(12-1-1998) 
D)   =DATE(1/12/1998) E) B) and C)
F) B) and D)

Question 5

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Accepted Answer

A)   =IF(B2>=60, "Pass", "Fail") 
B)   =IF(B2
C)   =IF(B2 = 60, "Pass", "Fail") 
D)   =IFERROR(IF((B2 >= 60, "Pass", "Fail") ) E) A) and B)
F) None of the above

Question 6

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Accepted Answer

A)   master
B)   model
C)   template
D)   standardE) B) and C)
F) All of the above

Question 7

If you create a PivotTable and then add data to its data source, you must refresh the PivotTable to update the data.

Accepted Answer

A) True 
 B)False

Question 8

You can create a _____ to define what data values are allowed in a cell.

Accepted Answer

A)   custom error
B)   macro
C)   conditional formatting rule
D)   validation ruleE) B) and C)
F) A) and B)

Question 9

You can use the Name Manager dialog box to view and manage named ranges, including the _____, which indicates where the named range is recognized.

Accepted Answer

A)   scope
B)   external reference
C)   filter
D)   extentE) A) and B)
F) All of the above

Question 10

When you change cell contents to italics, you are changing the cell's alignment.

Accepted Answer

A) True 
 B)False

Question 11

Which function should you use to calculate the present value of an investment that pays different amounts each year?

Accepted Answer

A)   NPV
B)   PMT
C)   DPV
D)   FVE) A) and D)
F) B) and C)

Question 12

To outline data, select the rows or columns you want to group, and then click the Group button on the Data tab.

Accepted Answer

A) True 
 B)False

Question 13

To delete comments, select the cell that contains comments, right-click on it and select Delete Comment option from the menu.

Accepted Answer

A) True 
 B)False

Question 14

Andrea wants to import data from a file that contains numbers organized in columns separated by tab characters. Which option should she select in the Get & Transform group on the Data tab?

Accepted Answer

A)   From Web
B)   From Text/CSV
C)   From Table/Range
D)   From DelimitedE) A) and D)
F) All of the above

Question 15

In a protected worksheet, you lock cells so that users can change their values.

Accepted Answer

A) True 
 B)False

Question 16

The _____ displays the cell reference of the active cell.

Accepted Answer

A)   formula bar
B)   Name box
C)   worksheet title
D)   status barE) A) and B)
F) B) and C)

Question 17

Which of the following can you do to make a chart title stand out on a chart?

Accepted Answer

A)   Change the text direction.
B)   Resize the chart.
C)   Display the title on the outside end of the data series.
D)   Increase the font size.E) A) and D)
F) All of the above

Question 18

To increase the magnification of a worksheet from 100% to 120%, you use the Magnification slider.

Accepted Answer

A) True 
 B)False

Question 19

Tracy created a table where the odd and even-numbered columns are formatted differently. She wants to remove this formatting. What setting should she change?

Accepted Answer

A)   Banded columns
B)   Calculated columns
C)   Odd/Even columns
D)   First columnE) B) and C)
F) C) and D)

Question 20

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

Accepted Answer

A)   Format Cells dialog box
B)   Format Painter
C)   Quick Analysis Tool
D)   Format as TableE) A) and B)
F) B) and D)

Exam 2: Excel 2019

You can create a _____ to define what data values are allowed in a cell.

Correct AnswerverifiedShow Answer

You can use the Name Manager dialog box to view and manage named ranges, including the _____, which indicates where the named range is recognized.

Correct AnswerverifiedShow Answer

When you select a cell in a worksheet and then click the Split button on the View tab, how many panes appear in the worksheet window?

Correct AnswerverifiedShow Answer

To outline data, select the rows or columns you want to group, and then click the Group button on the Data tab.

Correct AnswerverifiedShow Answer

What is the correct formula to insert the date January 12, 1998 into a cell?

Correct AnswerverifiedShow Answer

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Correct AnswerverifiedShow Answer

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Correct AnswerverifiedShow Answer

If you create a PivotTable and then add data to its data source, you must refresh the PivotTable to update the data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which function should you use to calculate the present value of an investment that pays different amounts each year?

Correct AnswerverifiedShow Answer

Which of the following can you do to make a chart title stand out on a chart?

Correct AnswerverifiedShow Answer

In a protected worksheet, you lock cells so that users can change their values.

Correct AnswerverifiedShow Answer

The _____ displays the cell reference of the active cell.

Correct AnswerverifiedShow Answer

To delete comments, select the cell that contains comments, right-click on it and select Delete Comment option from the menu.

Correct AnswerverifiedShow Answer

To increase the magnification of a worksheet from 100% to 120%, you use the Magnification slider.

Correct AnswerverifiedShow Answer

Andrea wants to import data from a file that contains numbers organized in columns separated by tab characters. Which option should she select in the Get & Transform group on the Data tab?

Correct AnswerverifiedShow Answer

When you change cell contents to italics, you are changing the cell's alignment.

Correct AnswerverifiedShow Answer

Tracy created a table where the odd and even-numbered columns are formatted differently. She wants to remove this formatting. What setting should she change?

Correct AnswerverifiedShow Answer

To add cells to the Watch Window, select all cells on a worksheet with formulas, then click Home tab > Editing group > Find & Replace > Go To Special > Formulas tab > Formula Auditing group > Watch Window > Add Watch > Add.

Correct AnswerverifiedShow Answer

Which of the following will you click on the Reports list box in Solver Results dialog box to produce an Answer Report?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified