Question 1

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

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

Question 2

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

This is the correct process to edit a comment in a cell.

Question 3

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

To convert a workbook to PDF for high-quality printing, you should choose "Standard (publishing online and printing)" instead of "Minimum Size (publishing online)" to ensure the PDF is optimized for print quality.

Question 4

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

Accepted Answer

The statement is accurate, the Previous button can be found in the Comments group on the Review tab to navigate to the previous comment.

Question 5

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?
A) Color Tone
B) Sharpen/Soften
C) Color Saturation
D) Brightness/Contrast

Accepted Answer

Misha should select "Brightness/Contrast" from the drop-down menu that appears on clicking Corrections. She can then select the thumbnail that allows her to set the brightness to 40% and contrast to 20%.

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

The correct sequence to reject changes is to use the "Reject" option directly after reviewing each change, not after selecting the "Where" checkbox.

Question 7

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

This is correct. To provide suggestions to other people using the document, you can select the text you want to comment on and click on "New Comment" on the Review tab. Then, type your comment in the box that appears.

Question 8

To show a comment in an active cell,select the cell,then click Review tab > Comments group > Show/Hide Comment.

Accepted Answer

This is correct, to show a comment in an active cell, you select the cell and then click on the Review tab, go to the Comments group, and click Show/Hide Comment. This will display the comment associated with the cell.

Question 9

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

Accepted Answer

Clicking on the Next button in the Comments group on the Review tab will take you to the next comment in the document.

Question 10

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?
A) Color Tone
B) Sharpen/Soften
C) Color Saturation
D) Brightness/Contrast

Accepted Answer

Stephen should select Sharpen/Soften from the drop down menu to reduce the sharpness of the picture.

Question 11

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)?
A) Shape Fill
B) Shape Effects
C) Shape Outline
D) More button

Accepted Answer

To apply a shape style in most graphic or office software, you typically need to access a broader selection of styles than what's immediately visible. The "More button" (often represented by a small arrow or a drop-down icon) within the "Shape Styles" group allows you to view and select from additional styles not immediately displayed in the ribbon or toolbar.

Question 12

Which of the following lets you resize a selected picture on your worksheet?
A) Drag it to a new location.
B) Drag any corner handle.
C) Drag its top border.
D) Double-click the picture.

Accepted Answer

To resize a selected picture on a worksheet, you should drag any corner handle. This will allow you to maintain the aspect ratio of the picture while resizing it. Dragging to a new location will only move the picture, not resize it. Dragging its top border will only change the height and not maintain the aspect ratio. Double-clicking the picture will only open the Format Picture tab in the ribbon.

Question 13

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

To copy and paste comments in Excel, you first need to copy the cell with the comment (Ctrl+C), then right-click the destination cell, select Paste Special, and choose Comments from the options.

Question 14

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

Accepted Answer

Kyler should select Shadow from the drop-down menu and then select the desired effect under Outer to add an outer shadow to the picture.

Question 15

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

Accepted Answer

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

Question 16

To turn track changes on in an Excel sheet,click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).

Accepted Answer

This describes the correct steps to turn on track changes in Excel.

Question 17

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

This is the correct way to edit a comment in a cell in Microsoft Excel.

Question 18

Which of the following should be clicked to change the caption of a control after right-clicking on it?
A) Order
B) Grouping
C) Properties
D) Format Control

Accepted Answer

To change the caption of a control after right-clicking on it, we need to access its properties. The Properties option provides access to all the available settings for a control, including its caption. The other options (Order, Grouping, and Format Control) are not relevant to changing the caption.

Question 19

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

Accepted Answer

The right-most thumbnail in the Sharpen/Soften drop-down menu is the maximum limit for sharpening a picture, which is what Braydon wants to do.

Question 20

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

Accepted Answer

To show all comments in a worksheet, one needs to click on the Review tab, then look for the Comments group, and finally click on Show All Comments.

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

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.

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.

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.

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

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.

To show a comment in an active cell,select the cell,then click Review tab > Comments group > Show/Hide Comment.

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

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?

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

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

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?

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

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.

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

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?

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