Question 1

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

Accepted Answer

A)  AutoLoad 
B)  Enabled 
C)  Boxname 
D)  (Name) 
A)  AutoLoad 
B)  Enabled 
C)  Boxname 
D)  (Name)

Question 2

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

Accepted Answer

A) True 
 B)False

Question 3

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Accepted Answer

A)  Analysis ToolPak 
B)  Solver PivotTable 
C)  Answer Report 
D)  Scenario Summary report 
A)  Analysis ToolPak 
B)  Solver PivotTable 
C)  Answer Report 
D)  Scenario Summary report

Question 4

Stephen inserted a picture that looks blurry in the worksheet. What can he do to improve the appearance of the picture?

Accepted Answer

A)  Apply a Glow picture effect. 
B)  Increase the sharpness of the picture. 
C)  Resize the picture. 
D)  Add a border. 
A)  Apply a Glow picture effect. 
B)  Increase the sharpness of the picture. 
C)  Resize the picture. 
D)  Add a border.

Question 5

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

Accepted Answer

A)  themes 
B)  icon sets 
C)  data bars 
D)  cell styles 
A)  themes 
B)  icon sets 
C)  data bars 
D)  cell styles

Question 6

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

Accepted Answer

A) True 
 B)False

Question 7

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

Accepted Answer

A) True 
 B)False

Question 8

When you share a workbook, where can you upload the workbook for sharing?

Accepted Answer

A)  To your social media page 
B)  To the Microsoft Office website 
C)  To a OneDrive account 
D)  To any public webpage 
A)  To your social media page 
B)  To the Microsoft Office website 
C)  To a OneDrive account 
D)  To any public webpage

Question 9

Which of the following statements is true about COUNT functions?

Accepted Answer

A)  The COUNT function returns the number of calls in a range that are not blank. 
B)  The COUNT function returns the number of calls in a range that contain any data at all. 
C)  Using the COUNT function is useful for computing the average of a cell range. 
D)  The COUNT function returns the number of cells in a range that contain numeric data. 
A)  The COUNT function returns the number of calls in a range that are not blank. 
B)  The COUNT function returns the number of calls in a range that contain any data at all. 
C)  Using the COUNT function is useful for computing the average of a cell range. 
D)  The COUNT function returns the number of cells in a range that contain numeric data.

Question 10

Which of the following features provides a way to correct a picture in a worksheet?

Accepted Answer

A)  Picture Effects 
B)  Picture Styles 
C)  Sharpen/Soften 
D)  Artistic Effects 
A)  Picture Effects 
B)  Picture Styles 
C)  Sharpen/Soften 
D)  Artistic Effects

Question 11

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

Accepted Answer

A) True 
 B)False

Question 12

Which Command Button property is used to internally reference the button?

Accepted Answer

A)  Caption 
B)  Name 
C)  Identifier 
D)  Description 
A)  Caption 
B)  Name 
C)  Identifier 
D)  Description

Question 13

Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?

Accepted Answer

A)  Change the starting and ending values of the vertical axis. 
B)  Change the number format of the vertical axis. 
C)  Add a vertical axis title. 
D)  Add a data table with a legend. 
A)  Change the starting and ending values of the vertical axis. 
B)  Change the number format of the vertical axis. 
C)  Add a vertical axis title. 
D)  Add a data table with a legend.

Question 14

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Accepted Answer

A) True 
 B)False

Question 15

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

Accepted Answer

A)  Click Margins in the Page Setup group on the Page Layout tab and then click on Normal. 
B)  Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab. 
C)  Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab. 
D)  Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab. 
A)  Click Margins in the Page Setup group on the Page Layout tab and then click on Normal. 
B)  Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab. 
C)  Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab. 
D)  Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.

Question 16

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Accepted Answer

A)  Gridlines View 
B)  Gridlines Print 
C)  Headings View 
D)  Headings Print 
A)  Gridlines View 
B)  Gridlines Print 
C)  Headings View 
D)  Headings Print

Question 17

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Accepted Answer

A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle 
A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle

Question 18

A(n) _____ summarizes large amounts of worksheet data in a compact table format.

Accepted Answer

A)  Area chart 
B)  PivotTable 
C)  Slicer 
D)  Filter 
A)  Area chart 
B)  PivotTable 
C)  Slicer 
D)  Filter

Question 19

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest. Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Accepted Answer

A)  PMT 
B)  NPER 
C)  FV 
D)  PV 
A)  PMT 
B)  NPER 
C)  FV 
D)  PV

Question 20

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Accepted Answer

A) True 
 B)False

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Stephen inserted a picture that looks blurry in the worksheet. What can he do to improve the appearance of the picture?

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

When you share a workbook, where can you upload the workbook for sharing?

Which of the following statements is true about COUNT functions?

Which of the following features provides a way to correct a picture in a worksheet?

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

Which Command Button property is used to internally reference the button?

Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

A(n) _____ summarizes large amounts of worksheet data in a compact table format.

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest. Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

When you link worksheet data to a Word document, you can change the worksheet data without affecting the Word document.

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Stephen inserted a picture that looks blurry in the worksheet. What can he do to improve the appearance of the picture?

If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

When you share a workbook, where can you upload the workbook for sharing?

Which of the following statements is true about COUNT functions?

Which of the following features provides a way to correct a picture in a worksheet?

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

Which Command Button property is used to internally reference the button?

Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

A(n) _____ summarizes large amounts of worksheet data in a compact table format.

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest. Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters