Question 1

Issac wants to add a border to a picture in a worksheet.To do so,he clicks the following series: Picture > X > Arrow next to Picture Border > Select color of choice.Which of these can X be in the following series of clicks?

Accepted Answer

A)  Size 
B)  Adjust 
C)  Arrange 
D)  Picture Styles

Question 2

To edit a comment in a cell,select the cell that contains the comment,right-click on it and select the Edit Comment option from the menu.

Accepted Answer

A) True 
 B)False

Question 3

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be? ​

Accepted Answer

A)  Next 
B)  Delete 
C)  Previous 
D)  New Comment

Question 4

To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Smith creates a basic cycle graphic with five shapes and then decides to add a sixth one below it.To do this,he clicks the down arrow to the right of the Add Shape button on the SmartArt Tools under Design tab,and then selects an option from the menu to finish the task.Which of these must he have selected from the menu options?

Accepted Answer

A)  Add Shape After 
B)  Add Shape Before 
C)  Add Shape Under 
D)  Add Shape Below

Question 7

Colin wants to apply a Quick Style to a SmartArt graphic.To do so,he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice.Which of these can X be in the following series of clicks?

Accepted Answer

A)  Insert tab 
B)  Format tab 
C)  Design tab 
D)  Review tab

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

Johnson doesn't like the organization of information in a SmartArt graphic and wants to change its layout to fit the content better.To do so,he follows this series of clicks: SmartArt graphic > Design tab > X > More drop-down menu > Select layout of choice.Which of the following can X be?

Accepted Answer

A)  Layouts group 
B)  Illustrations group 
C)  SmartStyles group 
D)  Create Graphic group

Question 12

Which of these series of clicks will you use to promote a shape in an Excel sheet?

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.

Question 13

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Accepted Answer

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

Question 16

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.

Question 17

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

Question 18

To provide suggestions to other people using your document,select the text you want to comment on,then click New Comment on the Review tab and type your comment.

Accepted Answer

A) True 
 B)False

Question 19

Return value comments help others understand what values are returned by a procedure.

Accepted Answer

A) True 
 B)False

Question 20

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

Accepted Answer

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

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

Issac wants to add a border to a picture in a worksheet.To do so,he clicks the following series: Picture > X > Arrow next to Picture Border > Select color of choice.Which of these can X be in the following series of clicks?

To edit a comment in a cell,select the cell that contains the comment,right-click on it and select the Edit Comment option from the menu.

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be?

To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.

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.

Colin wants to apply a Quick Style to a SmartArt graphic.To do so,he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice.Which of these can X be in the following series of clicks?

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

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

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.

Johnson doesn't like the organization of information in a SmartArt graphic and wants to change its layout to fit the content better.To do so,he follows this series of clicks: SmartArt graphic > Design tab > X > More drop-down menu > Select layout of choice.Which of the following can X be?

Which of these series of clicks will you use to promote a shape in an Excel sheet?

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

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) ?

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

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

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?

To provide suggestions to other people using your document,select the text you want to comment on,then click New Comment on the Review tab and type your comment.

Return value comments help others understand what values are returned by a procedure.

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

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

Issac wants to add a border to a picture in a worksheet.To do so,he clicks the following series: Picture > X > Arrow next to Picture Border > Select color of choice.Which of these can X be in the following series of clicks?

To edit a comment in a cell,select the cell that contains the comment,right-click on it and select the Edit Comment option from the menu.

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be? ​

To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.

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.

Colin wants to apply a Quick Style to a SmartArt graphic.To do so,he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice.Which of these can X be in the following series of clicks?

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

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

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.

Johnson doesn't like the organization of information in a SmartArt graphic and wants to change its layout to fit the content better.To do so,he follows this series of clicks: SmartArt graphic > Design tab > X > More drop-down menu > Select layout of choice.Which of the following can X be?

Which of these series of clicks will you use to promote a shape in an Excel sheet?

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

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) ?

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

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

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?

To provide suggestions to other people using your document,select the text you want to comment on,then click New Comment on the Review tab and type your comment.

Return value comments help others understand what values are returned by a procedure.

Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet.He clicks the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should Stephen select from the drop down menu that appears on clicking Corrections?

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be?