Question 1

Saul wants to add a legend to a chart.On which of the following boxes should he click in Chart Elements after selecting the chart and then the + sign?
A) Color
B) Legend
C) Chart Titles
D) Data labels

Accepted Answer

In order to add a legend to a chart in Microsoft Excel, one needs to select the chart and then click on the "+" sign to display the Chart Elements options. From there, one should select the "Legend" box to add a legend to the chart.

Question 2

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?
A) AutoLoad (Excel)
B) Enabled (Form)
C) Locked (Form)
D) Name (Form)

Accepted Answer

The "Name" property is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet. This name can be used to refer to the control in VBA code. The other properties mentioned (AutoLoad, Enabled, Locked) are not relevant for specifying the name of the control.

Question 3

What should be selected in the Formula Bar to manually rename a form control button after clicking and selecting a new button?
A) Name Box
B) Formula box
C) Form Control box
D) Form control button box

Accepted Answer

The Name Box is where you can manually rename form control buttons after clicking and selecting a new button. The Formula Bar is used for editing cell formulas, so it would not be the appropriate choice. The Form Control Box and Form Control Button Box are not features in Excel.

Question 4

How can you align all objects to the upper-left corner of a cell?
A) Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid.
B) Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape.
C) Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Top.
D) Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Bottom.

Accepted Answer

The answer of How can you align all objects to...

Question 5

Cora wants to manually rename a new form control button with a macro assigned to it.Which of the following combination of keys can she use to select it?
A) Tab + Click
B) Ctrl + Click
C) Ctrl + Alt + Click
D) Shift + Alt + Click

Accepted Answer

To rename a form control button with a macro assigned to it, holding down the Ctrl key and then clicking on the button allows you to select it without triggering the macro. This enables you to then rename the button or adjust its properties.

Question 6

Don wants to compare two worksheets in the same workbook by viewing them side by side.What can he click to do so?
A) View tab > Window group > New Window > View Side by Side > Arrange All
B) View tab > Window group > New Window > View Side by Side > Freeze Panes > Select from drop down option
C) View tab > Window group > New Window > View Side by Side > Switch Windows > Select a window from the drop down menu
D) View tab > Window group > New Window > View Side by Side > Click sheets to compare in each workbook window

Accepted Answer

The answer of Don wants to compare two worksheets in...

Question 7

Alexa wants to insert a command button control in VBA and execute a program using the button.To do this, she clicks the option "Insert button" from the Active X Control, selects the command button option from it, then drags the mouse cursor to Excel sheet to insert "clickcommandbutton1." After this, she follows a step X.Then, she enters a code in the sheet, saves the code file, exits the editor, clicks the Excel sheet icon to the extreme left to return to the editor, turns off Design mode before clicking the Command button and executes the program.What did she do in step X in the procedure?
A) Right click on the command button and select "Format Control".
B) Right click on the command button and select "Command Button Object".
C) Right click on the command button and select "View Code".
D) Right click on the command button and select "Properties".

Accepted Answer

In step X, Alexa needs to right-click on the command button and select "View Code" to open the VBA editor and write the code for the program to be executed when the button is clicked.

Question 8

Nadine wants to insert a sparkline in Excel using the Quick Analysis tool.She can do this by selecting the data for which she wants to add Sparklines, then in the empty column to the right side of the data click the Quick Analysis button, click Sparklines and select the type of Sparkline she wants.

Accepted Answer

This is the correct process to insert a sparkline using the Quick Analysis tool in Excel.

Question 9

To insert WordArt in Excel, click on Insert > WordArt, then select the WordArt style and then replace with the desired text in the Placeholder text.

Accepted Answer

This is the correct procedure for inserting WordArt in Excel.

Question 10

Betty wants to choose the list to create a custom number format.To do so, what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom
A) Type
B) Symbol
C) Locale
D) Decimal places

Accepted Answer

Betty needs to choose the "Type" option to create her custom number format. This allows her to specify the format for the number, such as adding a specific text before or after the number, or formatting the number as a percentage or currency. The other options listed (Symbol, Locale, Decimal places) are not relevant for creating a custom number format.

Question 11

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?
A) Worksheet > View tab > Workbook Views group > Custom Views > Close
B) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name ) > OK
C) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name ) > Include in view (Tick check box- Hidden rows, columns and filter settings ) > OK
D) Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name ) > Include in view (select check box- Print settings ) > OK

Accepted Answer

Option C involves creating a custom view that includes hidden rows and columns, which is what Luis wants to do. Option A and D do not involve creating a custom view that includes hidden rows and columns. Option B involves creating a custom view, but does not include the option to include hidden rows and columns.

Question 12

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

The instructions provided are for protecting a specific sheet within a workbook, but not for marking the entire workbook as final. To mark the whole workbook as final, Lilia would need to click File > Info > Protect (Document, Presentation, or Workbook) > Mark as Final.

Question 13

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?
A) Click Custom Views and double-click on the display settings she wants to see.
B) Under Windows group on the View tab, click on View Side by Side.
C) Under Windows group on the View tab, click on Switch Windows and select the View she wants.
D) Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

Accepted Answer

DA) Clicking Custom Views and double-clicking on the display settings allows Rukha to switch between her custom views, effectively showing or hiding specific rows and columns as per the view's configuration.D) By clicking Custom View and checking or unchecking the box beside Hidden rows, columns, and filter settings, Rukha can toggle the visibility of specific rows and columns according to her needs, thus switching between views where all rows and columns are visible and views where only specific rows and columns are shown.

Question 14

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?
A) Reset Window Position
B) Synchronous Scrolling
C) Arrange All
D) Zoom to Selection

Accepted Answer

Clicking on Synchronous Scrolling will enable Al to scroll through both worksheets at the same time, allowing for easy comparison of data.

Question 15

Which of the following will you click after the following series to distribute form controls horizontally: Select controls > Drawing Tools Format tab > Align?
A) Distribute Horizontally
B) Distribute Vertically
C) Distribute Evenly
D) Distribute Across

Accepted Answer

The question states that the goal is to distribute form controls horizontally. Therefore, the best choice is A) Distribute Horizontally. The other options (B) Distribute Vertically, (C) Distribute Evenly, and (D) Distribute Across do not specifically address horizontal distribution, so they are not the best choices.

Question 16

Mila wants to digitally sign a workbook to communicate that no further modifications should be made in the workbook.She clicks Insert tab > Text group > X > Microsoft Office Signature Line > Signature Setup Dialog box > Type Information for each box in the dialog box > Show sign date in signature line OK.What can X be in this series of clicks? ​
A) Create New
B) Create from File
C) Signature line List
D) Add Signature Services

Accepted Answer

The correct sequence for adding a digital signature involves selecting "Signature Line" from the Text group under the Insert tab. This option allows the user to add a signature line to the document, indicating where a digital signature can be applied.

Question 17

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?
A) Erase All
B) Clear All
C) Delete All
D) Remove All

Accepted Answer

The option "Remove All" is the best choice as it accurately describes the action that will be taken, which is to remove all of the selected types of data from the document. The other options (Erase All, Clear All, and Delete All) could also potentially be used, but they are not as precise in describing the action and may lead to confusion.

Question 18

For use as watermark, Alba wants to insert a picture as a worksheet background.For this, she clicks the worksheet she wants to display with a background, then selects an option X from the Page Layout tab in the Page Setup group.Alba then selects the picture for use as background, and then clicks Insert.What can X in her series of selections be?
A) Breaks
B) Margins
C) Orientation
D) Background

Accepted Answer

The answer of For use as watermark, Alba wants to...

Question 19

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

This is the correct series of steps to check compatibility with Excel versions 2007, 2010, and 2013.

Question 20

Which of these combination of keys will you click to clear an outline?
A) Worksheet > Data tab > Outline group > Group > AutoOutline
B) Worksheet > Data tab > Outline group > Ungroup > Clear Outline
C) Worksheet > Data tab > Outline group > Group > Group > Rows > OK
D) Worksheet > Data tab > Outline group > Ungroup > Ungroup > Rows > OK

Accepted Answer

To clear an outline, we need to first ungroup the outline and then click on the "Clear Outline" button in the Outline group under the Data tab. Option B correctly follows these steps, while the other options involve redundant or incorrect steps.

Quiz 8: Excel

Saul wants to add a legend to a chart.On which of the following boxes should he click in Chart Elements after selecting the chart and then the + sign?

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

What should be selected in the Formula Bar to manually rename a form control button after clicking and selecting a new button?

How can you align all objects to the upper-left corner of a cell?

Cora wants to manually rename a new form control button with a macro assigned to it.Which of the following combination of keys can she use to select it?

Don wants to compare two worksheets in the same workbook by viewing them side by side.What can he click to do so?

Nadine wants to insert a sparkline in Excel using the Quick Analysis tool.She can do this by selecting the data for which she wants to add Sparklines, then in the empty column to the right side of the data click the Quick Analysis button, click Sparklines and select the type of Sparkline she wants.

To insert WordArt in Excel, click on Insert > WordArt, then select the WordArt style and then replace with the desired text in the Placeholder text.

Betty wants to choose the list to create a custom number format.To do so, what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

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.

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Which of the following will you click after the following series to distribute form controls horizontally: Select controls > Drawing Tools Format tab > Align?

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?

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 these combination of keys will you click to clear an outline?