Question 1

To rename a worksheet, you change the text on the _____.

Accepted Answer

A)  sheet columns 
B)  sheet rows 
C)  sheet header 
D)  sheet tab 
A)  sheet columns 
B)  sheet rows 
C)  sheet header 
D)  sheet tab

Question 2

Jenny inserted two types of SmartArt in a worksheet and wants to make them look more similar.Which of the following can she do?

Accepted Answer

A)  Align the SmartArt. 
B)  Apply the same style to the SmartArt. 
C)  Add shapes to the SmartArt. 
D)  Resize the SmartArt nonproportionally. 
A)  Align the SmartArt. 
B)  Apply the same style to the SmartArt. 
C)  Add shapes to the SmartArt. 
D)  Resize the SmartArt nonproportionally.

Question 3

You can use the Links dialog box to manually update a link in an Excel workbook.

Accepted Answer

A) True 
 B)False

Question 4

To edit a comment in a cell, move the pointer over the cell, and then click Edit in the Comment box.

Accepted Answer

A) True 
 B)False

Question 5

In the Visual Basic Editor, comments appear in green and begin with an apostrophe.

Accepted Answer

A) True 
 B)False

Question 6

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 7

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 8

Aaron has a column chart that displays data in the range B3:D7.When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following options can you set to make sure a worksheet will print on one page?

Accepted Answer

A)  Zoom percentage 
B)  Scaling 
C)  Print selection 
D)  Gridlines 
A)  Zoom percentage 
B)  Scaling 
C)  Print selection 
D)  Gridlines

Question 10

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

Accepted Answer

A) True 
 B)False

Question 11

What must you do before inserting a screenshot in a worksheet?

Accepted Answer

A)  Open the window you want to display in the screenshot. 
B)  Add blank rows to the worksheet to make room for the screenshot. 
C)  Hide the workbook window. 
D)  Select a layout for the screenshot. 
A)  Open the window you want to display in the screenshot. 
B)  Add blank rows to the worksheet to make room for the screenshot. 
C)  Hide the workbook window. 
D)  Select a layout for the screenshot.

Question 12

To go to a previous comment, use the Previous Comment button in the Comments group on the Review tab.

Accepted Answer

A) True 
 B)False

Question 13

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Accepted Answer

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

Question 14

The default worksheet text is _____-point Calibri.

Accepted Answer

A)  10 
B)  11 
C)  12 
D)  14 
A)  10 
B)  11 
C)  12 
D)  14

Question 15

How can you remove the split panes from a worksheet?

Accepted Answer

A)  Click the View tab, and then click the Split button in the Windows group. 
B)  Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. 
C)  Click the View tab, and then click the Hide button in the Windows group. 
D)  Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group. 
A)  Click the View tab, and then click the Split button in the Windows group. 
B)  Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. 
C)  Click the View tab, and then click the Hide button in the Windows group. 
D)  Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group.

Question 16

Which of the following would you use to print only one page of a multipage worksheet?

Accepted Answer

A)  Page Layout tab 
B)  Formulas tab 
C)  Backstage view 
D)  Page Setup dialog box 
A)  Page Layout tab 
B)  Formulas tab 
C)  Backstage view 
D)  Page Setup dialog box

Question 17

In SmartArt, you can enter text directly in the placeholders or you can use the _____.

Accepted Answer

A)  SmartArt Property dialog box 
B)  Text pane 
C)  Layout pane 
D)  Add Label dialog box 
A)  SmartArt Property dialog box 
B)  Text pane 
C)  Layout pane 
D)  Add Label dialog box

Question 18

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

Accepted Answer

A) True 
 B)False

Question 19

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 20

What happens when you drag a corner handle on SmartArt?

Accepted Answer

A)  You move the SmartArt. 
B)  You resize the SmartArt proportionally. 
C)  You resize the SmartArt nonproportionally. 
D)  You open the Text pane. 
A)  You move the SmartArt. 
B)  You resize the SmartArt proportionally. 
C)  You resize the SmartArt nonproportionally. 
D)  You open the Text pane.

To rename a worksheet, you change the text on the _____.

Jenny inserted two types of SmartArt in a worksheet and wants to make them look more similar.Which of the following can she do?

You can use the Links dialog box to manually update a link in an Excel workbook.

To edit a comment in a cell, move the pointer over the cell, and then click Edit in the Comment box.

In the Visual Basic Editor, comments appear in green and begin with an apostrophe.

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

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Aaron has a column chart that displays data in the range B3:D7.When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

Which of the following options can you set to make sure a worksheet will print on one page?

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

What must you do before inserting a screenshot in a worksheet?

To go to a previous comment, use the Previous Comment button in the Comments group on the Review tab.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

The default worksheet text is _____-point Calibri.

How can you remove the split panes from a worksheet?

Which of the following would you use to print only one page of a multipage worksheet?

In SmartArt, you can enter text directly in the placeholders or you can use the _____.

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

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

What happens when you drag a corner handle on SmartArt?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

To rename a worksheet, you change the text on the _____.

Jenny inserted two types of SmartArt in a worksheet and wants to make them look more similar.Which of the following can she do?

You can use the Links dialog box to manually update a link in an Excel workbook.

To edit a comment in a cell, move the pointer over the cell, and then click Edit in the Comment box.

In the Visual Basic Editor, comments appear in green and begin with an apostrophe.

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

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Aaron has a column chart that displays data in the range B3:D7.When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

Which of the following options can you set to make sure a worksheet will print on one page?

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

What must you do before inserting a screenshot in a worksheet?

To go to a previous comment, use the Previous Comment button in the Comments group on the Review tab.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

The default worksheet text is _____-point Calibri.

How can you remove the split panes from a worksheet?

Which of the following would you use to print only one page of a multipage worksheet?

In SmartArt, you can enter text directly in the placeholders or you can use the _____.

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

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

What happens when you drag a corner handle on SmartArt?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters