Question 1

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 2

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 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 rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 5

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 boxE) B) and C)
F) A) and C)

Question 6

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 EffectsE) A) and B)
F) B) and C)

Question 7

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.E) A) and D)
F) All of the above

Question 8

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)   ViewE) A) and D)
F) A) and B)

Question 9

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 boxE) B) and C)
F) C) and D)

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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.E) A) and D)
F) B) and D)

Question 16

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.E) C) and D)
F) None of the above

Question 17

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

Accepted Answer

A)   sheet columns
B)   sheet rows
C)   sheet header
D)   sheet tabE) A) and B)
F) A) and C)

Question 18

The default worksheet text is _____-point Calibri.

Accepted Answer

A)   10
B)   11
C)   12
D)   14E) B) and C)
F) A) and D)

Question 19

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)   GridlinesE) B) and C)
F) All of the above

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.E) A) and B)
F) All of the above

Exam 7: Excel

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The default worksheet text is _____-point Calibri.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How can you remove the split panes from a worksheet?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What happens when you drag a corner handle on SmartArt?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified