Question 1

Which part of a Check Box (Form Control) shape should you click to rename the control?

Accepted Answer

A)  text label 
B)  outer edge 
C)  sizing handle 
D)  check box 
A)  text label 
B)  outer edge 
C)  sizing handle 
D)  check box

Question 2

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

Accepted Answer

A)  What-If Analysis 
B)  Data Validation 
C)  Remove Duplicates 
D)  Consolidate worksheet data. 
A)  What-If Analysis 
B)  Data Validation 
C)  Remove Duplicates 
D)  Consolidate worksheet data.

Question 3

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

Accepted Answer

A) True 
 B)False

Question 4

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Accepted Answer

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

Question 5

Colin inserted SmartArt using an Organizational Chart layout. How can he make the SmartArt look more distinctive?

Accepted Answer

A)  Decrease the size. 
B)  Promote all the shapes. 
C)  Apply a SmartArt style. 
D)  Compress the pictures in the SmartArt. 
A)  Decrease the size. 
B)  Promote all the shapes. 
C)  Apply a SmartArt style. 
D)  Compress the pictures in the SmartArt.

Question 6

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Accepted Answer

A)  Sum 
B)  Count 
C)  Average 
D)  %Total 
A)  Sum 
B)  Count 
C)  Average 
D)  %Total

Question 7

Changing a worksheet window to Normal view changes the contents of the worksheet.

Accepted Answer

A) True 
 B)False

Question 8

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 Table 
A)  Format Cells dialog box 
B)  Format Painter 
C)  Quick Analysis Tool 
D)  Format as Table

Question 9

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Accepted Answer

A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function 
A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function

Question 10

Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3?

Accepted Answer

A)  =LEFT(A24, 2) 
B)  =RIGHT(A24, 2) 
C)  =LOWER(A24) 
D)  =EXTRACT(A24, 2) 
A)  =LEFT(A24, 2) 
B)  =RIGHT(A24, 2) 
C)  =LOWER(A24) 
D)  =EXTRACT(A24, 2)

Question 11

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

Accepted Answer

A)  Column chart 
B)  Line chart 
C)  Pie chart 
D)  Area chart 
A)  Column chart 
B)  Line chart 
C)  Pie chart 
D)  Area chart

Question 12

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

Accepted Answer

A) True 
 B)False

Question 13

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

Accepted Answer

A)  changing cell 
B)  constraint 
C)  objective cell 
D)  solving method 
A)  changing cell 
B)  constraint 
C)  objective cell 
D)  solving method

Question 14

To print a worksheet, you begin by going to Backstage view.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following objects contains VBA code that determines its behavior?

Accepted Answer

A)  Form control 
B)  ActiveX command button 
C)  Shape from the Shapes gallery 
D)  Icon from the Icons gallery 
A)  Form control 
B)  ActiveX command button 
C)  Shape from the Shapes gallery 
D)  Icon from the Icons gallery

Question 16

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Accepted Answer

A) True 
 B)False

Question 17

Liam often types the names of the 12 offices where his company does business. He wants to be able to enter the first office name, then drag the fill handle to enter the other office names. What should he create?

Accepted Answer

A)  macro, 
B)  Flash Fill list 
C)  custom AutoFill list 
D)  Quick Table 
A)  macro, 
B)  Flash Fill list 
C)  custom AutoFill list 
D)  Quick Table

Question 18

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Accepted Answer

A) True 
 B)False

Question 19

Cedric wants to print one page of worksheet data on two pages. Which of the following can he do?

Accepted Answer

A)  Insert a page break. 
B)  Add print titles. 
C)  Freeze the top row. 
D)  Change the zoom. 
A)  Insert a page break. 
B)  Add print titles. 
C)  Freeze the top row. 
D)  Change the zoom.

Question 20

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

Accepted Answer

A) True 
 B)False

Which part of a Check Box (Form Control) shape should you click to rename the control?

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Colin inserted SmartArt using an Organizational Chart layout. How can he make the SmartArt look more distinctive?

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Changing a worksheet window to Normal view changes the contents of the worksheet.

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

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3?

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

To print a worksheet, you begin by going to Backstage view.

Which of the following objects contains VBA code that determines its behavior?

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Liam often types the names of the 12 offices where his company does business. He wants to be able to enter the first office name, then drag the fill handle to enter the other office names. What should he create?

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Cedric wants to print one page of worksheet data on two pages. Which of the following can he do?

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Which part of a Check Box (Form Control) shape should you click to rename the control?

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Colin inserted SmartArt using an Organizational Chart layout. How can he make the SmartArt look more distinctive?

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Changing a worksheet window to Normal view changes the contents of the worksheet.

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

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3?

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

To print a worksheet, you begin by going to Backstage view.

Which of the following objects contains VBA code that determines its behavior?

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Liam often types the names of the 12 offices where his company does business. He wants to be able to enter the first office name, then drag the fill handle to enter the other office names. What should he create?

If you click the check box of a text field in the PivotTable Fields pane, Excel adds the field to the Rows area.

Cedric wants to print one page of worksheet data on two pages. Which of the following can he do?

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters