Question 1

Jim wants to print sections of the various worksheets.The most efficient way for him to do so is to print one worksheet at a time.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following tabs lets you set worksheet print options?

Accepted Answer

A)  Preview 
B)  Home 
C)  Page Layout 
D)  View 
A)  Preview 
B)  Home 
C)  Page Layout 
D)  View

Question 3

Track Changes is a new feature that highlights all the changes you make as you edit a worksheet.

Accepted Answer

A) True 
 B)False

Question 4

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

Accepted Answer

A)  icon sets 
B)  data bars 
C)  Highlight Cells Rules 
D)  color scales 
A)  icon sets 
B)  data bars 
C)  Highlight Cells Rules 
D)  color scales

Question 6

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

Accepted Answer

A) True 
 B)False

Question 7

You can merge scenarios to apply scenarios from another worksheet into the current one.

Accepted Answer

A) True 
 B)False

Question 8

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Accepted Answer

A)  Refresh the PivotChart. 
B)  Change the PivotChart layout. 
C)  Change the data source of the PivotChart. 
D)  Update the links in the workbook. 
A)  Refresh the PivotChart. 
B)  Change the PivotChart layout. 
C)  Change the data source of the PivotChart. 
D)  Update the links in the workbook.

Question 9

Which of the following functions inserts the total of a range?

Accepted Answer

A)  ROUND 
B)  AUTOSUM 
C)  AVERAGE 
D)  SUM 
A)  ROUND 
B)  AUTOSUM 
C)  AVERAGE 
D)  SUM

Question 10

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

Accepted Answer

A)  number of the column containing the return value 
B)  location of the lookup table 
C)  whether to return a value only when an exact match is found 
D)  cell with the lookup value 
A)  number of the column containing the return value 
B)  location of the lookup table 
C)  whether to return a value only when an exact match is found 
D)  cell with the lookup value

Question 11

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 12

If you change many formatting options such as theme colors, cell styles, and fonts, how can you preserve the settings for use in another workbook?

Accepted Answer

A)  Create a new cell style. 
B)  Create a custom theme color. 
C)  Create custom theme fonts. 
D)  Save the settings as a custom theme. 
A)  Create a new cell style. 
B)  Create a custom theme color. 
C)  Create custom theme fonts. 
D)  Save the settings as a custom theme.

Question 13

To accept a suggested spelling for that instance only, which of the following would you click?

Accepted Answer

A)  Change 
B)  Change All 
C)  Ignore Once 
D)  Add to Dictionary 
A)  Change 
B)  Change All 
C)  Ignore Once 
D)  Add to Dictionary

Question 14

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 15

You can edit cell contents in the formula bar or in the cell itself.

Accepted Answer

A) True 
 B)False

Question 16

You can add a legend to sparklines to indicate the high and low points in the chart.

Accepted Answer

A) True 
 B)False

Question 17

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following form controls provides a way for users to enter data?

Accepted Answer

A)  Check box 
B)  Label 
C)  Rectangle 
D)  Index list 
A)  Check box 
B)  Label 
C)  Rectangle 
D)  Index list

Question 19

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 20

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

Accepted Answer

A)  Leave the workbook closed. 
B)  Open the workbook, change the first worksheet, and save it using the Save command. 
C)  Open the workbook, make changes, and then save it using the same name. 
D)  Open the workbook, make changes, and then save it using a different name. 
A)  Leave the workbook closed. 
B)  Open the workbook, change the first worksheet, and save it using the Save command. 
C)  Open the workbook, make changes, and then save it using the same name. 
D)  Open the workbook, make changes, and then save it using a different name.

Jim wants to print sections of the various worksheets.The most efficient way for him to do so is to print one worksheet at a time.

Which of the following tabs lets you set worksheet print options?

Track Changes is a new feature that highlights all the changes you make as you edit a worksheet.

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

You can merge scenarios to apply scenarios from another worksheet into the current one.

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Which of the following functions inserts the total of a range?

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

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

If you change many formatting options such as theme colors, cell styles, and fonts, how can you preserve the settings for use in another workbook?

To accept a suggested spelling for that instance only, which of the following would you click?

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?

You can edit cell contents in the formula bar or in the cell itself.

You can add a legend to sparklines to indicate the high and low points in the chart.

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Which of the following form controls provides a way for users to enter data?

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

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Jim wants to print sections of the various worksheets.The most efficient way for him to do so is to print one worksheet at a time.

Which of the following tabs lets you set worksheet print options?

Track Changes is a new feature that highlights all the changes you make as you edit a worksheet.

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

You can merge scenarios to apply scenarios from another worksheet into the current one.

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Which of the following functions inserts the total of a range?

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

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

If you change many formatting options such as theme colors, cell styles, and fonts, how can you preserve the settings for use in another workbook?

To accept a suggested spelling for that instance only, which of the following would you click?

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?

You can edit cell contents in the formula bar or in the cell itself.

You can add a legend to sparklines to indicate the high and low points in the chart.

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Which of the following form controls provides a way for users to enter data?

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

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters