Question 1

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 answer of In order to reject changes made by...

Question 2

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 the worksheet, you need to drag any corner handle which allows you to resize the picture proportionally. Dragging other borders or double-clicking the picture does not allow you to resize it. Dragging the picture to a new location moves it but does not resize it.

Question 3

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

Braydon should select the right-most thumbnail as it represents the maximum sharpening effect.

Question 4

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

Accepted Answer

This statement is correct. To show a comment in an active cell, you need to select the cell, go to the Review tab on the ribbon, locate the Comments group, and click the Show/Hide Comment button.

Question 5

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 method to edit a comment in a cell.

Question 6

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 the correct process for highlighting track changes in a worksheet.

Question 7

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 8

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

Accepted Answer

This is the correct procedure to show all comments in a worksheet.

Question 9

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 the correct way to provide suggestions to other people using a document, by selecting the text and creating a comment on the Review tab.

Question 10

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 choose an effect under "Outer" to add an outer shadow to the picture.

Question 11

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

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

Question 12

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

Accepted Answer

The Next button in the Comments group on the Review tab can be used to go to the next comment in the document.

Question 13

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, we need to access its properties. Therefore, clicking on the Properties option after right-clicking on the control is the correct choice.

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

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

Accepted Answer

The steps mentioned to delete comments are correct.

Question 16

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

Accepted Answer

The Previous button in the Comments group on the Review tab is used to go to a previous comment.

Question 17

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 and then select the thumbnail that allows her to set the brightness to 40% and contrast to 20%.

Question 18

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

The instructions given are incorrect. To convert a workbook to PDF, Henri needs to click on File > Save As > (Enter name in) File name box > Save as type list > PDF > Options > OK > Save. The option for Minimum Size (publishing online) is not relevant for printing in high quality.

Question 19

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 is the correct process for turning on track changes in Excel.

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

Quiz 15: Customizing Your Workspace Text and Graphics

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

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 a comment in an active cell, select the cell, then click Review tab > Comments group > Show/Hide Comment.

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.

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

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

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.

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

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

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

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 delete comments, select the cell that contains comments, right-click on it and select Delete Comment option from the menu.

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

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.

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?

Quiz 15: Customizing Your Workspace Text and Graphics

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

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 a comment in an active cell, select the cell, then click Review tab > Comments group > Show/Hide Comment.

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.

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

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

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.

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

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

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

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 delete comments, select the cell that contains comments, right-click on it and select Delete Comment option from the menu.

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

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.

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?

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.