Question 1

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

Accepted Answer

This statement is correct. The Previous button can be found in the Comments group on the Review tab and allows you to navigate to the previous comment in the document.

Question 2

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?
A) No Fill
B) Theme Colors
C) Standard Colors
D) More Fill Colors

Accepted Answer

Linda selected "More Fill Colors" to access the Colors Dialog box and choose from Standard colors, as described in the scenario.

Question 3

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 allows the user to go to the next comment in the document.

Question 4

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 procedure to highlight track changes in a worksheet.

Question 5

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 steps mentioned in the question do not accurately reflect the process of converting a workbook to PDF. The correct steps would be to go to File > Save As > choose PDF from the Save as type dropdown menu > select Options to adjust any settings > click Save to save the PDF file.

Question 6

Which of these series of clicks will you select to add text to a SmartArt?
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

Accepted Answer

To add text to a SmartArt, you need to go to the Insert tab, then to the Illustrations group, then select SmartArt. This will bring up the Choose a SmartArt Graphic dialog box where you can select the type and layout you want. Once you've done that, you can add text in the text pane that appears on the left side of the screen.

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?
A) Insert tab
B) Format tab
C) Design tab
D) Review tab

Accepted Answer

The SmartArt Styles group and SmartArt Tools are both located on the Design tab, so Colin must click on that tab to access these options. The Insert tab is used for adding new objects to a presentation, the Format tab is used for editing the formatting of an object that is already on the slide, and the Review tab is used for adding comments and making changes to a presentation as a group.

Question 8

To detect language automatically, you should select the Detect language automatically check box in the Language dialog box.

Accepted Answer

By selecting the Detect language automatically check box in the Language dialog box, the system will automatically detect the language being used and apply the appropriate language settings.

Question 9

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?
A) Stars and Banners
B) Screen Clipping
C) Recently Used Shapes
D) Choose a SmartArt Graphic dialog box

Accepted Answer

The correct option for X is "Choose a SmartArt Graphic dialog box" as this is the destination where the user can select the type and layout of their choice from numerous options available. The other options are not relevant to adding a SmartArt graphic to the document.

Question 10

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 11

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 12

Brielle wants to increase the size of a SmartArt graphic in her worksheet. To do so, she clicks the following series: Shape > Format tab > SmartArt tools . What should she do next to resize the object proportionally?
A) Drag a middle handle.
B) Click the Larger button.
C) Click the Edit in 2-D button.
D) Click the Arrange button and select a arrange button options.

Accepted Answer

Brielle should drag a middle handle in order to resize the SmartArt graphic proportionally. This will ensure that the height and width of the graphic are adjusted together, maintaining the correct aspect ratio. Clicking the Larger button or selecting an arrange button option will not necessarily maintain the proportionality of the graphic's size. Clicking the Edit in 2-D button will not help her resize the SmartArt graphic at all.

Question 13

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Accepted Answer

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization, thus the statement is true.

Question 14

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?
A) Calculate Now
B) Calculate Sheet
C) Watch Window
D) Calculation Options

Accepted Answer

The answer of Amanda needs to manually calculate an open...

Question 15

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 process for adding suggestions or comments to a document.

Question 16

What would you choose as X in the given series of clicks to calculate formulas automatically: File
A) Formulas
B) Proofing
C) Language
D) Advanced

Accepted Answer

File > Formulas is the correct path to calculate formulas automatically.

Question 17

Nathan wants to create multiple charts for a table Power View, beginning with a pie chart. What should he select as X in the series of clicks to do this: Design tab > X > Other Charts > Pie Chart?
A) Tiles
B) Options
C) Other Chart
D) Switch Visualization

Accepted Answer

To create multiple charts for a table in Power View, starting with a pie chart, Nathan should navigate through the Design tab, then select "Switch Visualization," and finally choose "Other Charts > Pie Chart." This sequence allows changing the current visualization to a different type, such as a pie chart.

Question 18

How can you add a new picture to a SmartArt graphic?
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.

Accepted Answer

The answer of How can you add a new picture...

Question 19

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Accepted Answer

The correct sequence to set the default language in Microsoft Office applications typically involves going to File > Options > Language, then under the "Choose Editing Languages" section, you select the language you want to use and click "Set as Default." The sequence "Insert > Options > Language" is incorrect.

Question 20

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 after clicking on "Corrections." She can then select the thumbnail that sets the brightness to 40% and contrast to 20%, fulfilling her purpose. Options A, B, and C do not provide the specific adjustments Misha is looking for in the picture.

Quiz 2: Excel 2019

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

It is possible to go to the next comment using the Next 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.

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 these series of clicks will you select to add text to a SmartArt?

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 detect language automatically, you should select the Detect language automatically check box in the Language dialog box.

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

Brielle wants to increase the size of a SmartArt graphic in her worksheet. To do so, she clicks the following series: Shape > Format tab > SmartArt tools . What should she do next to resize the object proportionally?

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

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.

What would you choose as X in the given series of clicks to calculate formulas automatically: File

Nathan wants to create multiple charts for a table Power View, beginning with a pie chart. What should he select as X in the series of clicks to do this: Design tab > X > Other Charts > Pie Chart?

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

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.