Lesson 2Microsoft Excel TEST
1. On the Home Ribbon, what do you use to change the font size of characters in a cell?
A.Font drop-down listB. Font Size drop-down listC. Increase Font SizeD. Cell Styles drop-down list
2. Which quick-number style button formats numbers to display as currency in the worksheet?
A.PercentB. AccountingC. CommaD. Dollar
3. Which panel contains areas where a user can view and enter document properties for Excel 2010 files?
A.Document informationB. File DetailsC. File Save AsD. File information
4. What are the lines, vertical and horizontal, in a worksheet called?
A.BordersB.GridlinesC. Cell linesD. Outline
5. What command do you use to apply a background color to cells in a worksheet?
A.DrawingB. Fill ColorC. Borders & ShadingD. Highlight
6.In Microsoft Excel 2010, a single character, word, or phrase is referred to as the:
A.Text.B. Data.C. String.D. Function.
7. Which view is the default view used in Excel 2010?
A.Page LayoutB. PrintC. NormalD.Web
8. Which command on the Auto Fill Options dialog box is the default option?
A.Copy CellsB. Fill Formatting OnlyC. Fill without FormattingD. Fill Series
9. Which command on the Home Ribbon do you use to apply a border to selected cells?
A.UnderlineB. LinesC. DrawingD. Format Cells
10. What is the process of using the mouse to move or copy cells called?
A.Click and pasteB. Drag and moveC. DraggingD. Drag and drop
11. Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
A. NumberB. FontC. ParagraphD. Format Cells
12. Which Excel 2010 mode replaces characters to the right of the insertion point as you type?
A.Data entryB. ToggleC. OvertypeD. Edit
13. The command that checks for incorrect spelled words is:
A.research.B. thesaurus.C. translate.D. spelling.
14. What are a predefined set of attributes such as font, font size, and shading?
A.DesignB. StyleC. FormatD. Template
15. Which ribbon contains commands to add a comment about a selected cell in a worksheet?
A.HomeB. InsertC. DataD. Review
16. What is the area with a thick black border in a worksheet called?
A.Current cellB. Target cellC. Cell formula areaD. Active cell
17. Which ribbon contains the command to apply a theme to a worksheet in Excel 2010?
A.HomeB. Page Layout C. Data D. View
18. Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?
A.Function LibraryB.Defined Names C. Formula AuditingD. Calculation
19. How do you add a border to worksheet cells?
A.Select cells and right-click to choose Outline from the Shortcut menu
B.Select cells and choose the Border command from the Home ribbon
C.Select cells and choose the Border command from the Insert ribbon
D.Select cells and choose the Outline command from the Home ribbon
20. What appears at the bottom of an Excel 2010 workbook to distinguish individual worksheets?
A.Worksheet linksB. Worksheet handlesC. Sheet tabsD. Sheet buttons
21. Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
A.Format as TableB.Cell StyleC.Format CellsD.Form
22. Which command creates a new view of the current document in a separate window?
A.Zoom to SelectionB. New WindowC. Arrange AllD. Freeze Panes
23. Which number format button does NOT appear in the Format group on the Home ribbon?
A.102 (scientific)B. $ (currency)C. % (percent)D. , (comma)
24. Which defines the appearance and shape of the letters, numbers, and special characters in Excel 2010?
A.FormatB. FontC. SizeD. Effects
25. Which of the following notebook- like features organizes the sheets for use in Excel?
A.WorkbookB. WorksheetC.NotepadD. Folder
26. What is the black square that appears in the bottom right corner of the cell border to create a series in multiple cells?
A.drag box.B. copy box.C. drag handle.D. fill handle.
27. What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
A.Mini ToolbarB. Quick Access ToolbarC. Shortcut MenuD. Shortcut Toolbar
28. In a worksheet, which command suggests other words with a similar meaning that can be used?
A.SpellingB. ResearchC. ThesaurusD. Language
29. What command will tile Excel 2010 windows and all other open program windows so that they appear side by side on the screen?
A.Zoom to SelectionB.New WindowC. Arrange AllD. Freeze Panes
30. 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, & (dollar sign) command button
31. Which term indicates how characters in an Excel 2010 worksheet are emphasized?
A.Font sizeB.Cell styleC.Font styleD.Alignment
32. Which option button enables a user to fill cells following a fill operation?
A.AutoCorrectB. InsertC. PasteD. Auto Fill
33. What command do you use to copy cell formatting from one cell to another in a worksheet?
A.Format cellB. Format PainterC. CopyD. Cut
34. What is the process for creating a hyperlink to an existing web page in Microsoft Excel 2010?
A.Type in the web address and by default automatic hyperlink formatting is turned on.
B.Use the create hyperlink command button on the Home ribbon.
C.Select the insert hyperlink command on the file tab.
D.Type in the main site name and Microsoft Excel 2010 will search for the correct hyperlink address.
35. Which option button provides formatting options following the insertion of cells, rows, or columns in a worksheet?
A.AutoCorrectB. InsertC. PasteD. Auto Fill
36. Which is an advantage of using Styles to apply formatting to a workbook?
A.Styles ensure consistent formatting from one workbook to the next
B. Styles have nicer formatting
C.Styles are required by Microsoft Excel 2010
D. Styles prevent users from making hangs to the formatting
37. Which quick-number style button formats numbers to display as percentages in the worksheet?
A.PercentB. AccountingC.CommaD. Dollar
38. Which command on the Home ribbon that centers the text within the merged cells?
A.CenterB. JustifyC.Merge & CenterD.Merge
39. What occurs when the cursor is moved over a cell and a user click?
A.The row is selected.B. The cell is selected.C. The column is selected.D. The worksheet is selected.
40. Why do users want to modify an existing style?
A.It saves time.
B. It is easier than creating a new style.
C. Once modified, all cells formatted with that style will be automatically updated.
D.The style will be available to all workbooks in Microsoft Excel 2010.
41. In Excel 2010, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
A.FormattingB. PrintingC. ArrangingD. Configuring
42. Which dialog box allows a user to select the first row as the table's header row?
A.FormatB. Table StyleC. Format StyleD. Format as Table
43. Which command creates decorative text in a worksheet?
A.SmartArtB. WordArtC. DrawD. Shape
44. What is the moving dashed line that appears around the cells when selected called?
A.Matching ants B. Selection rangeC. Flashing rangeD. Marquee
45. Which command on the Insert Ribbon creates a link to a web page, picture, emailaddress, or program in a worksheet?
A.HyperlinkB. Web linkC. LinkupD. Text link
46. Which Microsoft Excel 2010 feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A.AutoCompleteB. AutoFillC. AutoCorrectD.AutoSpell
47. Where can you find the command to apply a background color to a cell or range of cells in a worksheet?
A.Home RibbonB. Insert RibbonC. Page Layout RibbonD. View Ribbon
48. Where are user created styles able to be used?
A.In the worksheet for which they are createdB. In the workbook for which they are created
C.In all of Microsoft Excel 2010D. User created styles cannot be used
49. How do you copy formatting to different locations in the worksheet?
A.Copy formatB. Format copierC. Paint formatsD. Format painter
50. What button on the Home Ribbon automatically enlarges a selected cell's font size with one click?
A.ItalicB. Increase font sizeC. Decrease font sizeD. Bold
51. What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?
A.Fill handleB. FillerC. Copy handleD. Copy box
52. Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
A.LayoutB. TemplateC. ThemeD. Design
53. Which file contains data fields separated by a special character such as a comma?
A.Text fileB. Delimited fileC. Import fileD. Data file
54. On the Home Ribbon, what do you use to change the font face used in the worksheet?
A.Font drop-down listB. Font Size drop-down listC. Increase Font SizeD. Cell Styles drop-down list
55.What is used print a picture behind the data in Microsoft Excel 2010?
A.Image.B. Background.C.Picture.D. Graphic.
56. Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
A. ThemesB. Page SetupC. Sheet OptionsD. Arrange
57. What defines the color of the characters in an Excel 2010 worksheet?
A.Font sizeB. Font colorC. Cell colorD. Background
58. Which command on the Home Ribbon joins selected cells into one larger cell and centers that content in the new cell?
A.Wrap TextB. Group CellsC. Cell StylesD. Merge & Center
59. Which group on the Page Layout Ribbon contains commands used to organize objects placed in the worksheet?
A.Page SetupB. Scale to FitC. Sheet OptionsD. Arrange
60. Which mode enables you to use the mouse to select cells for use in a formula?
A.Edit modeB. Selection modeC. Formula modeD. Point mode