Question 1

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. After entering a comment, Mariana notices that the username in the comment box is not her name. The name matches the user name entered for that ____.
A) computer
B) company
C) copy of Excel
D) copy of Office 2010

Accepted Answer

The username in the comment box in Excel matches the user name entered for that specific copy of Excel. Excel uses the user information set during the installation or initial setup of the program to identify the author of comments.

Question 2

Match between columns
                        Premises: A visual control that looks like a note pad.

Accepted Answer

The Answer of horizontal axis and vertical axis and PivotTable is...

Question 3

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry wants to adjust the brightness and contrast. He accesses the Format contextual tab and uses the tools in the ____ group to change the brightness and contrast.
A) Picture Styles
B) Arrange
C) Size
D) Adjust

Accepted Answer

The "Adjust" group contains tools such as "Brightness", "Contrast", and "Sharpness" which are used to adjust the appearance of the picture.

Question 4

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry also wants to change the picture's shape and border. He accesses the Format contextual tab and uses the tools in the ____ group to change the shape and color.
A) Picture Styles
B) Arrange
C) Size
D) Adjust

Accepted Answer

The Picture Styles group under the Format contextual tab is where you can change the shape and border of a picture in Excel. The Arrange group is for arranging the position of objects, the Size group is for adjusting the size of objects, and the Adjust group is not a valid group for this task.

Question 5

Match between columns
                        Premises: Usually plots the categories along the bottom of the chart.

Accepted Answer

The Answer of horizontal axis and slicer and PivotChart and is...

Question 6

The ____________________ menu displays a list of all the values that appear in that column along with additional criteria and color filtering options.

Accepted Answer

The answer of The ____________________ menu displays a list of...

Question 7

Match between columns
                        Premises: Usually plots values, such as dollar amounts, along the left side of the chart.

Accepted Answer

The Answer of vertical axis and PivotTable and horizontal axis is...

Question 8

You can create hyperlinks to ____.
A) another Web page
B) a specific location in the current workbook
C) an e-mail address
D) all of the above

Accepted Answer

Hyperlinks can be created to another webpage, a specific location in the current workbook, or an email address, making option D the correct choice.

Question 9

Match between columns
                        Premises: A visual representation of the data in a PivotTable.

Accepted Answer

The Answer of horizontal axis and PivotChart and PivotTable and is...

Question 10

FIGURE EX 6-1  In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.
A) Click the cell she wants to use for the hyperlink. On the Insert tab of the Ribbon, in the Links group, click the Hyperlink button.
B) Right-click the cell or object, and then click Hyperlink on the shortcut menu
C) either a. or b.
D) neither a. nor b.

Accepted Answer

Both options A and B will allow the user to access the Insert Hyperlink dialog box. Option A involves clicking the cell to be used for the hyperlink and then selecting the Hyperlink button in the Links group under the Insert tab of the Ribbon. Option B involves right-clicking the cell or object and selecting the Hyperlink option from the shortcut menu.

Question 11

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

Accepted Answer

The answer of You can show or hide all the...

Question 12

To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button.
A) Search
B) Editing
C) Proofing
D) Help

Accepted Answer

The Research task pane is opened by clicking the Review tab on the Ribbon and then, in the Proofing group, clicking the Research button.

Question 13

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Accepted Answer

The answer of What is a first-level and second-level sort,...

Question 14

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. To change the username, click the ____ tab, and then click Options in the navigation bar.
A) File
B) Home
C) Insert
D) Data

Accepted Answer

To change the username, Mariana needs to access the options for Microsoft Excel, which are located in the File tab. The Home, Insert, and Data tabs do not contain the options menu.

Question 15

The ____ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias.
A) Research
B) Resource
C) Library
D) Reference

Accepted Answer

The Research task pane provides access to various types of references such as dictionaries, thesauruses, and encyclopedias.

Question 16

All of the comments tools are located on the ____________________ tab of the Ribbon in the Comments group.

Accepted Answer

The answer of All of the comments tools are located...

Question 17

FIGURE EX 6-1  In order to enter a ScreenTip to go with your hyperlink, you would click ScreenTip in the dialog box shown in Figure EX 6-1 above. The Set Hyperlink ScreenTip ____ will appear.
A) menu
B) wizard
C) status bar
D) dialog box

Accepted Answer

The Set Hyperlink ScreenTip option appears in a dialog box, as stated in the question. The other options (menu, wizard, status bar) do not apply to this specific scenario.

Question 18

Match between columns
                        Premises: A structure in which the data can be rearranged and summarized in different ways so that you can view the data from various perspectives.

Accepted Answer

The Answer of PivotTable and horizontal axis and slicer and is...

Question 19

A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.

Accepted Answer

The answer of A(n) ____________________ sort arranges data with letters...

Question 20

The ____________________ Rules format cells based on comparison operators such as greater than, less than, between, and equal to.

Accepted Answer

The answer of The ____________________ Rules format cells based on...

Quiz 2: Microsoft Excel Basics

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. After entering a comment, Mariana notices that the username in the comment box is not her name. The name matches the user name entered for that ____.

Identify the letter of the choice that best matches the phrase or definition.

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry wants to adjust the brightness and contrast. He accesses the Format contextual tab and uses the tools in the ____ group to change the brightness and contrast.

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry also wants to change the picture's shape and border. He accesses the Format contextual tab and uses the tools in the ____ group to change the shape and color.

Identify the letter of the choice that best matches the phrase or definition.

The ____________________ menu displays a list of all the values that appear in that column along with additional criteria and color filtering options.

Identify the letter of the choice that best matches the phrase or definition.

You can create hyperlinks to ____.

Identify the letter of the choice that best matches the phrase or definition.

FIGURE EX 6-1 In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button.

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. To change the username, click the ____ tab, and then click Options in the navigation bar.

The ____ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias.

All of the comments tools are located on the ____________________ tab of the Ribbon in the Comments group.

FIGURE EX 6-1 In order to enter a ScreenTip to go with your hyperlink, you would click ScreenTip in the dialog box shown in Figure EX 6-1 above. The Set Hyperlink ScreenTip ____ will appear.

Identify the letter of the choice that best matches the phrase or definition.

A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.

The ____________________ Rules format cells based on comparison operators such as greater than, less than, between, and equal to.