Question 1

You can use the Evaluate Formula button to identify the source of a cell error.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

To analyze the results of scenarios, you can create a(n) _____.

Accepted Answer

A)  Scenario Management chart 
B)  Scenario Overview 
C)  Scenario PivotTable 
D)  Answer report 
A)  Scenario Management chart 
B)  Scenario Overview 
C)  Scenario PivotTable 
D)  Answer report C

Question 4

To change the background color of a cell, you use the Background color button.

Accepted Answer

A) True 
 B)False

Question 5

Reggie created a data validation rule for cell B3, which contains a unit price. He wants to use the only the data validation in cell D3. Which of the following should he do?

Accepted Answer

A)  Use the Format Painter to copy the formats from cell B3 to cell D3. 
B)  Copy cell B3 to cell D3. 
C)  Copy cell B3 then paste values in cell D3. 
D)  Copy cell B3 and the paste validation in cell D3. 
A)  Use the Format Painter to copy the formats from cell B3 to cell D3. 
B)  Copy cell B3 to cell D3. 
C)  Copy cell B3 then paste values in cell D3. 
D)  Copy cell B3 and the paste validation in cell D3.

Question 6

A student enters the names of months in cells A2 to A5 with the heading "Month" in cell A1. Then he enters the number of days in each moth in cells B2 to B5 with the heading "Days" in cell B2. In order to arrange the names of the months in cells A6 to E6 with heading "Month" in cell A6 and the number of days each month in cells A7 to E7 with heading "Days" in cell A7, he can use the formula =TRANSPOSE(A1:B5).

Accepted Answer

A) True 
 B)False

Question 7

Tanya wants to insert a form control and then assign a macro to it. Which of the following objects should she insert?

Accepted Answer

A)  ActiveX command button 
B)  WordArt object 
C)  Icon object 
D)  Button form control 
A)  ActiveX command button 
B)  WordArt object 
C)  Icon object 
D)  Button form control

Question 8

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?

Accepted Answer

A)  Table filters 
B)  VLOOKUP function 
C)  Multilevel sort 
D)  Data validation 
A)  Table filters 
B)  VLOOKUP function 
C)  Multilevel sort 
D)  Data validation

Question 9

What type of chart is a Clustered Column - Line chart?

Accepted Answer

A)  Scatter chart 
B)  Combo chart 
C)  Radar chart 
D)  Stacked chart 
A)  Scatter chart 
B)  Combo chart 
C)  Radar chart 
D)  Stacked chart

Question 10

Where do you rename a workbook and adjust its save location?

Accepted Answer

A)  Save As dialog box 
B)  Home tab 
C)  Name box 
D)  Active cell 
A)  Save As dialog box 
B)  Home tab 
C)  Name box 
D)  Active cell

Question 11

The Remove Duplicates tool locates and deletes records that are duplicated across more than one field.

Accepted Answer

A) True 
 B)False

Question 12

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 
A)  Column Width command 
B)  Center button 
C)  Merge and Center button 
D)  Increase Indent button

Question 13

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

Accepted Answer

A) True 
 B)False

Question 14

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet results.

Accepted Answer

A) True 
 B)False

Question 15

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet. What does she need to specify in the Page Setup dialog box?

Accepted Answer

A)  Rows to repeat at the top of the worksheet 
B)  Print area to select 
C)  Columns to repeat at the left of the worksheet 
D)  Amount to rotate the titles so they fit on the page 
A)  Rows to repeat at the top of the worksheet 
B)  Print area to select 
C)  Columns to repeat at the left of the worksheet 
D)  Amount to rotate the titles so they fit on the page

Question 16

Which of the following properties can you change for a Command Button (ActiveX Control)?

Accepted Answer

A)  Code 
B)  Shape 
C)  Font 
D)  Layout 
A)  Code 
B)  Shape 
C)  Font 
D)  Layout

Question 17

When you enter a value in a worksheet cell, it is automatically left-aligned.

Accepted Answer

A) True 
 B)False

Question 18

To move a worksheet, you can drag its sheet tab to the left or right.

Accepted Answer

A) True 
 B)False

Question 19

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

Accepted Answer

A)  pane 
B)  window 
C)  view 
D)  outline 
A)  pane 
B)  window 
C)  view 
D)  outline

Question 20

Walter selected data on a worksheet to show in a chart. Which button on the Insert tab can he click to display charts appropriate for the selected data?

Accepted Answer

A)  PivotChart button 
B)  Illustrations button 
C)  Recommended Charts button 
D)  Appropriate Charts button 
A)  PivotChart button 
B)  Illustrations button 
C)  Recommended Charts button 
D)  Appropriate Charts button

You can use the Evaluate Formula button to identify the source of a cell error.

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

To analyze the results of scenarios, you can create a(n) _____.

To change the background color of a cell, you use the Background color button.

Reggie created a data validation rule for cell B3, which contains a unit price. He wants to use the only the data validation in cell D3. Which of the following should he do?

Tanya wants to insert a form control and then assign a macro to it. Which of the following objects should she insert?

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?

What type of chart is a Clustered Column - Line chart?

Where do you rename a workbook and adjust its save location?

The Remove Duplicates tool locates and deletes records that are duplicated across more than one field.

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

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet results.

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet. What does she need to specify in the Page Setup dialog box?

Which of the following properties can you change for a Command Button (ActiveX Control)?

When you enter a value in a worksheet cell, it is automatically left-aligned.

To move a worksheet, you can drag its sheet tab to the left or right.

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

Walter selected data on a worksheet to show in a chart. Which button on the Insert tab can he click to display charts appropriate for the selected data?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

You can use the Evaluate Formula button to identify the source of a cell error.

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

To analyze the results of scenarios, you can create a(n) _____.

To change the background color of a cell, you use the Background color button.

Reggie created a data validation rule for cell B3, which contains a unit price. He wants to use the only the data validation in cell D3. Which of the following should he do?

Tanya wants to insert a form control and then assign a macro to it. Which of the following objects should she insert?

Mila wants to specify what data users can enter in a table column. What Excel feature should she use?

What type of chart is a Clustered Column - Line chart?

Where do you rename a workbook and adjust its save location?

The Remove Duplicates tool locates and deletes records that are duplicated across more than one field.

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

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet results.

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet. What does she need to specify in the Page Setup dialog box?

Which of the following properties can you change for a Command Button (ActiveX Control)?

When you enter a value in a worksheet cell, it is automatically left-aligned.

To move a worksheet, you can drag its sheet tab to the left or right.

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

Walter selected data on a worksheet to show in a chart. Which button on the Insert tab can he click to display charts appropriate for the selected data?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters