Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

Accepted Answer

A)  Shape Fill 
B)  Shape Effects 
C)  Shape Outline 
D)  More button 
A)  Shape Fill 
B)  Shape Effects 
C)  Shape Outline 
D)  More button

Question 4

Kimani is working on a data set in which she has to add pictures into cells adjacent to the respective names of objects in her file. To do so, she clicks on the following series: Insert tab > X > Pictures > Insert Picture dialog box > Locate the picture that she wants to insert into a cell in Excel > Insert > Format tab > Y > Edit height and width to fit into cell > Place picture into cell. What can X and Y in the series of clicks/entries be?

Accepted Answer

A)  Apps group, Arrange group 
B)  Illustrations group, Size group 
C)  Sparklines group, Adjust group 
D)  Charts group, Picture Styles group 
A)  Apps group, Arrange group 
B)  Illustrations group, Size group 
C)  Sparklines group, Adjust group 
D)  Charts group, Picture Styles group

Question 5

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 6

Which of the following is true of the Excel spell checker?

Accepted Answer

A)  You can change all instances of a flagged word to a selected suggestion. 
B)  You cannot add words to the spell checker dictionary. 
C)  You must accept all spell checker suggested replacement words. 
D)  For multiple instances of a misspelled word, you must change each one individually. 
A)  You can change all instances of a flagged word to a selected suggestion. 
B)  You cannot add words to the spell checker dictionary. 
C)  You must accept all spell checker suggested replacement words. 
D)  For multiple instances of a misspelled word, you must change each one individually.

Question 7

To edit a comment in a cell, right-click on the cell containing the comment, select Edit Comment in it, then make the necessary changes in it and click on the cell again.

Accepted Answer

A) True 
 B)False

Question 8

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 9

What is the default number of days for Excel change history?

Accepted Answer

A)  15 
B)  30 
C)  60 
D)  90 
A)  15 
B)  30 
C)  60 
D)  90

Question 10

Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file. He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice. What can X in this series of clicks/ selections be?

Accepted Answer

A)  Stars and Banners 
B)  Screen Clipping 
C)  Recently Used Shapes 
D)  Choose a SmartArt Graphic dialog box 
A)  Stars and Banners 
B)  Screen Clipping 
C)  Recently Used Shapes 
D)  Choose a SmartArt Graphic dialog box

Question 11

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file. To do so, she can click File > Info > Protect (Document, Presentation, or Workbook) > Protect Current Sheet > OK.

Accepted Answer

A) True 
 B)False

Question 12

To make your workbooks usable by people with disabilities, you can add alternative text to worksheet images.

Accepted Answer

A) True 
 B)False

Question 13

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which of the following should be clicked to change the caption of a control after right-clicking on it?

Accepted Answer

A)  Order 
B)  Grouping 
C)  Properties 
D)  Format Control 
A)  Order 
B)  Grouping 
C)  Properties 
D)  Format Control

Question 18

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which of the following steps will you take to demote a shape on your spreadsheet?

Accepted Answer

A)  With the insertion point in the task pane, press Shift+Tab keys. 
B)  Click the Insert a SmartArt Graphic command in a placeholder. 
C)  With the insertion point in the task pane, press the Tab key. 
D)  Select the shape, click the Convert command on Design tab and select Convert to Text. 
A)  With the insertion point in the task pane, press Shift+Tab keys. 
B)  Click the Insert a SmartArt Graphic command in a placeholder. 
C)  With the insertion point in the task pane, press the Tab key. 
D)  Select the shape, click the Convert command on Design tab and select Convert to Text.

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

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

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.

Which of the following is true of the Excel spell checker?

To edit a comment in a cell, right-click on the cell containing the comment, select Edit Comment in it, then make the necessary changes in it and click on the cell again.

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

What is the default number of days for Excel change history?

Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file. He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice. What can X in this series of clicks/ selections be?

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file. To do so, she can click File > Info > Protect (Document, Presentation, or Workbook) > Protect Current Sheet > OK.

To make your workbooks usable by people with disabilities, you can add alternative text to worksheet images.

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Which of the following should be clicked to change the caption of a control after right-clicking on it?

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

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

Which of the following steps will you take to demote a shape on your spreadsheet?

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

Customizing Your Workspace Text and Graphics

Filters

Exam 15: Customizing Your Workspace Text and Graphics

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

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

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.

Which of the following is true of the Excel spell checker?

To edit a comment in a cell, right-click on the cell containing the comment, select Edit Comment in it, then make the necessary changes in it and click on the cell again.

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

What is the default number of days for Excel change history?

Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file. He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice. What can X in this series of clicks/ selections be?

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file. To do so, she can click File > Info > Protect (Document, Presentation, or Workbook) > Protect Current Sheet > OK.

To make your workbooks usable by people with disabilities, you can add alternative text to worksheet images.

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Which of the following should be clicked to change the caption of a control after right-clicking on it?

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

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

Which of the following steps will you take to demote a shape on your spreadsheet?

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

Customizing Your Workspace Text and Graphics

Filters