Excel Lesson 6 & 7 Test Multiple Choice Identify the choice that best completes the statement or answers the question. FIGURE 7-1

Excel Case 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Please refer to the figure above as you answer the questions below. ____

1. Kristin wants to move the February worksheet in the top half of the pane to the Annual Statement worksheet in the bottom half of the pane. She intends to place the February worksheet after the January worksheet. What should she do? a. In the Annual Statement workbook, double-click the January sheet tab, and then click Arrange on the shortcut menu. b. In the Annual Statement workbook, right-click the January sheet tab, and then click Move or Copy on the shortcut menu. c. In the February Statement workbook, double-click the February sheet tab, and then click Arrange on the shortcut menu. d. In the February Statement workbook, right-click the February sheet tab, and then click Move or Copy on the shortcut menu.

____

____

2. Kristin wants to access the Arrange Windows dialog box. She clicks the ____ tab on the Ribbon, and then in the Window group, clicks the Arrange All button. a. Edit c. Format b. Data d. View 3. To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu. a. Location c. Move or Copy b. Relocate d. New Excel Case 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Please answer the questions below.

____

____

____

____

____

____

____

____

____

____

4. 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. Arrange c. Picture Styles b. Adjust d. Size 5. When you no longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. Then press the ____ key. a. Erase c. Recycle b. Delete d. Remove 6. A ____ is a cell in a worksheet that opens another file or page when you click it. a. pop-up cell c. button b. hyperlink d. transporter 7. The ____ contextual tab contains tools to edit and format the picture. a. Edit c. Format b. Graphics d. Delete 8. The Print what option called ____ prints the worksheet that appears on-screen, or a group of selected worksheets. a. Selection c. Entire worksheet b. Entire workbook d. Active Sheet(s) 9. To open the Shapes gallery, click the Insert tab on the Ribbon, and then, in the ____ group, click the Shapes button. a. Clip Art c. Pictures b. Shapes d. Illustrations 10. To insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears. a. Shapes c. Formulas b. Illustrations d. Data 11. To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button. a. Format c. Styles b. Edit d. Formulas 12. You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar. a. white c. blue b. red d. green 13. When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs. a. Status bar c. Ribbon

b. Drawing tab d. Side bar ____ 14. When you want to see all the data in a worksheet again, you can restore all the rows by clearing the filter. Click the filter arrow, and then click the ____ command. a. Clear Filter To c. Remove Filter To b. Clear Filter From d. Remove Filter From ____ 15. To change the tab color of a worksheet, right-click the sheet tab you want to recolor, point to ____ on the shortcut menu, and then click the color you want for that tab. a. Recolor c. Color b. Tab Color d. Tab ____ 16. In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group. a. comma c. period b. semicolon d. colon Excel Case 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. Please answer the questions below. ____ 17. How does Ron go about renaming his worksheet? a. Double-click its sheet tab, type the new name, and then press the Enter key b. Right-click its sheet tab, and then click Rename on the shortcut menu c. either a. or b. d. neither a. nor b. ____ 18. Ron now wants to change the tab color. He first right-clicks the sheet tab he wants to recolor, points to ____ on the shortcut menu, and then clicks the color he wants for the tab. a. Tab Color c. Tab b. Color d. none of the above ____ 19. To rename a worksheet, double-click its sheet tab, type the new name, and then press the ____ key. a. Ctrl c. F3 b. Tab d. Enter FIGURE 6-1

Excel Case 6-1 Mariana is adding some hyperlinks to her worksheet. Please refer to the figure above while answering the questions below. ____ 20. Mariana first wants to access the Insert Hyperlink dialog box shown in Figure 6-1. What should she do next? 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. ____ 21. ____ are predesigned workbook files that you can use as the basis or model for new workbooks. a. Templates c. Forms b. Formats d. Images ____ 22. When using the Arrange Windows dialog box, which layout is NOT an option? ____. a. Split c. Tiled b. Vertical d. Cascade ____ 23. ____ the worksheet you want to hide, and then click Hide on the shortcut menu. a. Single-click c. Right-click b. Double-click d. Left-click ____ 24. When working with cell references, any change you make to the ____ cell also changes the value in the destination cell. a. active c. source b. main d. primary ____ 25. You can create hyperlinks to ____. a. an e-mail address b. a specific location in the current workbook c. another Web page d. all of the above Matching Identify the letter of the choice that best matches the phrase or definition. a. b. c. d. e.

Sort Object Conditional formatting Filtering Comment

____ 26. A note attached to a cell that is usually used to explain or identify information contained in the cell ____ 27. Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria ____ 28. Rearranging the data in a more meaningful order ____ 29. Anything that appears on the screen that you can select and work with as a whole ____ 30. Highlights worksheet data by changing the look of cells that meet a specified condition Identify the letter of the choice that best matches the phrase or definition.

a. b. c. d. e. ____ ____ ____ ____

31. 32. 33. 34.

Active sheet Source Sheet tab Worksheet range Destination

The location where the data will appear after it is transferred A group of adjacent worksheets Identifies the worksheets within the workbook The worksheet that appears in the workbook window