Question 1

How can you add a new picture to a SmartArt graphic?

Accepted Answer

A)  Click the SmartArt button on the Insert tab,then click Picture,click a layout,and then click OK. 
B)  Select a picture,click the Picture Layout button on the Format tab under Picture Tools,and then select a layout. 
C)  Select a picture,click the Insert tab under Picture Tools,click the Insert Picture,and then select a layout. 
D)  Under SmartArt Tools,click the Design tab,then click the Add Shape button arrow,and then select the picture you want to add. 
A)  Click the SmartArt button on the Insert tab,then click Picture,click a layout,and then click OK. 
B)  Select a picture,click the Picture Layout button on the Format tab under Picture Tools,and then select a layout. 
C)  Select a picture,click the Insert tab under Picture Tools,click the Insert Picture,and then select a layout. 
D)  Under SmartArt Tools,click the Design tab,then click the Add Shape button arrow,and then select the picture you want to add.

Question 2

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

Accepted Answer

A)  Click the thumbnail image of the window whose screenshot he wants to insert. 
B)  Click Screen Clipping,then press and hold the left mouse button to drag and capture the window screen. 
C)  Select a thumbnail of the required window,then press and hold the left mouse button to drag and capture the window screen. 
D)  Click Screen Clipping,and when the pointer becomes a hand icon,capture the window screen. 
A)  Click the thumbnail image of the window whose screenshot he wants to insert. 
B)  Click Screen Clipping,then press and hold the left mouse button to drag and capture the window screen. 
C)  Select a thumbnail of the required window,then press and hold the left mouse button to drag and capture the window screen. 
D)  Click Screen Clipping,and when the pointer becomes a hand icon,capture the window screen.

Question 3

To show all comments in a worksheet,click Review tab > Comments group > Show All Comments.

Accepted Answer

A) True 
 B)False

Question 4

Braydon wants to sharpen a picture to the maximum limit to make it more appealing.He clicks on the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should he select from the drop-down menu that appears on clicking Sharpen/Soften?

Accepted Answer

A)  Select the left-most thumbnail. 
B)  Select the thumbnail at the top. 
C)  Select the right-most thumbnail. 
D)  Select the thumbnail at the bottom. 
A)  Select the left-most thumbnail. 
B)  Select the thumbnail at the top. 
C)  Select the right-most thumbnail. 
D)  Select the thumbnail at the bottom.

Question 5

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

Accepted Answer

A) True 
 B)False

Question 6

In order to reject changes made by all users in a workbook,click/enter information in the following series: Review tab > Changes group > Track Changes > Accept or Reject Changes > OK (if prompted to save the workbook)> Select Changes to Accept or Reject dialog box > Select Where check box > OK > Review information about each change in the dialog box > Reject > OK.

Accepted Answer

A) True 
 B)False

Question 7

Misha wants to set the brightness of a picture to 40% and contrast to 20%.She clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should she select from the drop-down menu that appears on clicking Corrections and then select the thumbnail that fulfils her purpose?

Accepted Answer

A)  Color Tone 
B)  Sharpen/Soften 
C)  Color Saturation 
D)  Brightness/Contrast 
A)  Color Tone 
B)  Sharpen/Soften 
C)  Color Saturation 
D)  Brightness/Contrast

Question 8

To copy and paste comments in an Excel sheet,select the cell containing the comment and press Ctrl+V.Then select the cell where you want to paste the comment,right click on it and select Paste Special from the popup menu.

Accepted Answer

A) True 
 B)False

Question 9

Stella wants to merge two workbooks.She begins by opening the workbooks,then selects the worksheets she wants to copy by clicking on the first sheet tab that she wants to copy,pressing and holding the Shift key,and then clicking on the last sheet tab.Then she right-clicks on one of the selected tabs and selects an option from the menu.Which of the following can her selection be?

Accepted Answer

A)  Insert 
B)  Rename 
C)  View Code 
D)  Move or Copy 
A)  Insert 
B)  Rename 
C)  View Code 
D)  Move or Copy

Question 10

Linda wants to change the color of the SmartArt that she has used in her spreadsheet.To do so,she clicks on the shape in the SmartArt graphic.She then clicks on the arrow next to Shape Fill under Drawing Tools,on the Format tab,in the Shape Styles group.Linda then selects an option from the menu that appears,and under the Colors Dialog box and Standard,she chooses the color she wants the SmartArt to be and clicks OK.What can the option that she selected from the menu under Shape Fill be?

Accepted Answer

A)  No Fill 
B)  Theme Colors 
C)  Standard Colors 
D)  More Fill Colors 
A)  No Fill 
B)  Theme Colors 
C)  Standard Colors 
D)  More Fill Colors

Question 11

Kyler wants to add an outer shadow to a picture in his worksheet.He clicks on the picture,then clicks Picture Effects on Format tab under Picture Tools.What should he do next to fulfil his purpose?

Accepted Answer

A)  Select Shadow from the drop-down menu,then under Inner,select the effect she wants. 
B)  Select Shadow from the drop-down menu,then under Outer,select the effect she wants. 
C)  Select Shadow from the drop-down menu,then under No Shadow,select the effect she wants. 
D)  Select Shadow from the drop-down menu,then under Perspective,select the effect she wants. 
A)  Select Shadow from the drop-down menu,then under Inner,select the effect she wants. 
B)  Select Shadow from the drop-down menu,then under Outer,select the effect she wants. 
C)  Select Shadow from the drop-down menu,then under No Shadow,select the effect she wants. 
D)  Select Shadow from the drop-down menu,then under Perspective,select the effect she wants.

Question 12

Which of these series of clicks will you select to add text to a SmartArt?

Accepted Answer

A)  Insert tab > Illustrations group > Online Pictures > Insert pictures > Select from menu > [Text] in Text pane > Type text 
B)  Insert tab > Illustrations group > SmartArt > Choose a SmartArt Graphic dialog box > Select type and layout >[Text] in Text pane > Type text 
C)  Insert tab > Illustrations group > Shapes > Recently used shapes > Select type and layout > [Text] in Text pane > Type text 
D)  Insert tab > Illustrations group > Take a Screenshot > Available Windows > Select from the menu > [Text] in Text pane > Type text 
A)  Insert tab > Illustrations group > Online Pictures > Insert pictures > Select from menu > [Text] in Text pane > Type text 
B)  Insert tab > Illustrations group > SmartArt > Choose a SmartArt Graphic dialog box > Select type and layout >[Text] in Text pane > Type text 
C)  Insert tab > Illustrations group > Shapes > Recently used shapes > Select type and layout > [Text] in Text pane > Type text 
D)  Insert tab > Illustrations group > Take a Screenshot > Available Windows > Select from the menu > [Text] in Text pane > Type text

Question 13

Which of the following lets you resize a selected picture on your worksheet?

Accepted Answer

A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture. 
A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture.

How can you add a new picture to a SmartArt graphic?

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

To show all comments in a worksheet,click Review tab > Comments group > Show All Comments.

Braydon wants to sharpen a picture to the maximum limit to make it more appealing.He clicks on the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should he select from the drop-down menu that appears on clicking Sharpen/Soften?

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

To copy and paste comments in an Excel sheet,select the cell containing the comment and press Ctrl+V.Then select the cell where you want to paste the comment,right click on it and select Paste Special from the popup menu.

Kyler wants to add an outer shadow to a picture in his worksheet.He clicks on the picture,then clicks Picture Effects on Format tab under Picture Tools.What should he do next to fulfil his purpose?

Which of these series of clicks will you select to add text to a SmartArt?

Which of the following lets you resize a selected picture on your worksheet?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Filters

Exam 15: Collaborating with Your Team.(Digital Only).

How can you add a new picture to a SmartArt graphic?

Ernie wants to add a screenshot of an entire window into his file.To do so,he clicks on the document at the location where he wants to add the screenshot,then clicks Screenshot in the Illustrations group on the Insert tab.What will he do when the Available windows gallery appears next?

To show all comments in a worksheet,click Review tab > Comments group > Show All Comments.

Braydon wants to sharpen a picture to the maximum limit to make it more appealing.He clicks on the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should he select from the drop-down menu that appears on clicking Sharpen/Soften?

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

To copy and paste comments in an Excel sheet,select the cell containing the comment and press Ctrl+V.Then select the cell where you want to paste the comment,right click on it and select Paste Special from the popup menu.

Kyler wants to add an outer shadow to a picture in his worksheet.He clicks on the picture,then clicks Picture Effects on Format tab under Picture Tools.What should he do next to fulfil his purpose?

Which of these series of clicks will you select to add text to a SmartArt?

Which of the following lets you resize a selected picture on your worksheet?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Filters