Microsoft ExcelLesson 3
1. Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
A.FontB. OrientationC. Wrap TextD. Merge & Center
2. How would a user hide a row or column from view without permanently deleting the information?
A.Choose the Disappear command on the Shortcut menu
B. Choose the Hide command on the Quick Access Toolbar
C. Choose the Show/Hide command on the Home Ribbon
D.Choose the Hide command on the Shortcut menu
3. Which command on the Page Layout Ribbon enables a user to specify the rows or columns to repeat on each printed page of the worksheet?
A.Print AreaB. MarginsC. OrientationD. Print Titles
4. What determines what part of a worksheet prints?
A.Print thisB. Print whatC. Print areaD. Print setup
5. Which command on the Page Layout Ribbon enables a user to mark the exact area of the worksheet to print?
A.Print AreaB. MarginsC. OrientationD. Print Titles
6. What command prevents unwanted changes to data in a worksheet by specifying exactly what information may be changed?
A.Protect WorkbookB.Protect SheetC. ShareD. Protection
7. What controls the landscape or portrait print function?
A.MarginB.OrientationC. AlignmentD. Size
8. Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
A.Page LayoutB.PrintC.NormalD.Web
9. What allows the user to control the amount of space between the data and the edge of the paper?
A.MarginB.OrientationC. HeaderD. Size
10. Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
A.Workbook viewsB. ShowC. ZoomD. Window
11. Which group on the Home Ribbon contains the command to continue a pattern into oneor more adjacent cells?
A.EditingB. AlignmentC. StylesD. Cells
12. Which term describes the blank portions of a page that fall outside the main body of the printed document?
A. BordersB. EdgesC. FramesD. Margins
13. What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
A.MarginsB. Print titlesC. Header & FooterD. Page Setup
14. What is the name of the process of finding and correcting errors in a worksheet?
A.RestoringB. DebuggingC. RepairingD. Servicing
15. What item at the bottom of an Excel worksheet window presents information about the worksheet, the progress of current tasks, and controls for viewing the worksheet?
A.Scroll barB. Navigation windowC. Status barD. Title bar
16. What command do you use to increase or decrease the size of a selected cell or range of cells to fill the Excel Window area for better visibility?
A.Magnify Area B. Enlarge Selected Area C. Amplify RangeD. Zoom to Selection
17. What is the data printed on the bottom of each worksheet page?
A.margin data.B. footer.C. endnote.D. border.
18. The area of the Microsoft Excel that contains the view and zoom buttons is known as the:
A.status bar.B. title bar.C. formula bar.D. name box.
19. In Microsoft Excel 2010, what is the name of the pop-ups that appear near the active cell?
A.Smart tagsB. HintsC. Help tagsD. Notes
20. How do you insert special symbols not available on the keyboard in Microsoft Excel 2010?
A.Home ribbon, symbol command buttonB. Home ribbon, $ (dollar sign) command button
C. Insert Ribbon, symbol command buttonD. Insert Ribbon, & (ampersand) command button
21. What is the name of the on-screen command that appears in a worksheet when you copy one range to another range?
A.Copy optionsB. Auto fill optionsC. Reference optionsD. Cell options
22. The command on the Page Layout ribbon that refers to data printed on the top of each worksheet page is the:
A.Header.B. Top data.C. Border.D. Print first.
23. Which dialog box in Excel 2010 do you use to set the rotation of text in a cell to a specific degree?
A.OrientationB. Format CellsC. Format TextD. Alignment
24. Which of the following causes Excel 2010 to recognize data entered into a cell as text rather than number format?
A.Parentheses ( )B. Forward Slash (/)C. A spaceD. Percent sign (%)
25.Which command do you use to remove manual page breaks from a worksheet area?
A.Select break, press Delete on keyboard
B. Select Remove Page Break from the Breaks drop-down area
C.Select break, press Backspace on keyboard
D.Select break, press Remove Page Break from Shortcut Menu
26. When you enter text into a cell, which Excel feature works behind the scenes to recognize and correct common mistakes?
A.AutoChangeB. Auto TextC. Spelling & Grammar CheckD. AutoCorrect
27. Which command separates a worksheet window into four individual panes?
A. Arrange AllB.Freeze PanesC. New WindowD. Split
28. Which command do you use to reduce the margin between the border and the text in the cell?
A.OrientationB. Decrease IndentC. Column WidthD. Alignment
29. Which tab do you use to display the area that contains the print command?
A.HomeB. Page LayoutC. ViewD. File
30. On the Home Ribbon, what do you use to change the text color of characters in a cell?
A.Font Color drop-down listB. Font Size drop-down list
C.Fill Color drop-down listD. Cell Styles drop-down list
31. How does the user hide a workbook?
A.Choose the Hide command on the view ribbon
B.Double-click the sheet tab to hide the sheet
C.Click the Format drop-down in the Cells group on the Home ribbon to see the Hide & Unhide options
D. Select the sheet tab and then Shift + F1
32. What do you insert into a worksheet to cause the data start on a new page when printing?
A.Data MarginB. Page BorderC. Page BreakD. Page Margin
33. Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
A. Print AreaB. BreaksC. BackgroundD. Effects
34. If a worksheet contains data that you do not want to be viewed, what method is used to remove the data from worksheet view without permanently deleting the data?
A.DeleteB. RemoveC. HideD. Erase
35. Which command in the Print tab backstage view must be selected to print all sheets in a workbook?
A. Print allB. Print entire workbookC. Whole workbookD. All sheets