CTS Excel 2010 Test Questions 1-35

Excel 2010 Test Bank 1. Which of the following software programs is a powerful spreadsheet pro gram that allows users to organize data, complete calculations, and graph data? A. B. C. D.

Office 2010 Windows Excel 2010 Calc

Answer: C 2. Which of the following notebooknotebook - like features organizes the sheets for use in Ex cel? A. Workbook B. Worksheet C.  Notepad D. Folder Answer: A 3. Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? A. Workbook B. Worksheet C.  Notepad D. Folder Answer: B 4. What is immediately visible on screen when you open Excel 2010? A. B. C. D.

Create new workbook dialog box Open a workbook dialog box A new workbook The File panel

Answer: C 5. What do you use to navigate and display different portions of a worksheet in the worksheet window? A. B. C. D.

Arrow keys Page Up or Page Down key Slider bars Scroll bars

Answer: D 6. 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 bar B.  Navigation window C. Status bar D. Title bar Answer: C 7. What is considered the control center in Excel and many other Office programs? A. B. C. D.

Title bar Ribbon Status bar Menu

Answer: B 8. Which Microsoft Office object would you use fo r quick, convenient, one-click access to frequently used Excel commands? A. B. C. D.

Quick Access Toolbar Title bar Status bar Mini Toolbar

Answer: A 9. What feature was created for users who prefer to use the keyboard rather than the mouse, and  provides keyboard code icons that may be used in conjunction with the ALT key? A. B. C. D.

Quick Access Toolbar ScreenTips Mini Toolbar KeyTips

Answer: B 10. What is the name of the list of frequently used Excel commands available when a user rightclicks an item in the worksheet? A. Mini Toolbar

B. Quick Access Toolbar C. Shortcut Menu D. Shortcut Toolbar Answer: C 11. What is the intersection of a row and a column in a worksheet called? A. B. C. D.

Cell Table Cube Block

Answer: A 12. What occurs when the cursor is moved over a cell and a user clicks? A. B. C. D.

The row is selected The cell is selected The column is selected The worksheet is selected

Answer: B 13. What do you use to place worksheet titles, column titles, and row titles in a worksheet? A. Data B. Information C. Text D.  Numbers Answer: C 14. When you enter text into a cell, which Excel feature works behind the scenes to recognize and correct common mistakes? A. B. C. D.

AutoChange AutoText Spelling & Grammar Check AutoCorrect

Answer: D 15. Which of the following do you use to move one cell to the right in an Excel 2010 worksheet? A. Right arrow key

B. Enter key C. Page Up key D. Home key Answer: A 16. Which of the following do you use to move down one cell in an Excel 2010 worksheet? A. B. C. D.

Right arrow key Enter key Page Up key Home key

Answer: B 17. Which of the following causes Excel 2010 to recognize data entered into a cell as text rather than number format? A. B. C. D.

Parentheses ( ) Forward Slash (/) A space Percent sign (%)

Answer: C 18. What is a series of two or more adjacent cells in a column or row or a rectangular group of cells called? A. B. C. D.

Group Array Range Series

Answer: C 19. What function adds all of the numbers in a range of cells? A. B. C. D.

Calculate Sum Compute Add

Answer: B 20. In Excel 2010, which feature makes an exact replica of the cell data and format while keeping the original cell intact?

A. B. C. D.

Repeat Move Cut Copy

Answer: D 21. In Excel 2010, what is the name of the command that relocates a cell’s data and its format, then clears the data from the original cell and resets the original cell's format to default? A. B. C. D.

Repeat Move Cut Copy

Answer: B 22. What is the name of the small black square in the lower-right corner of t he heavy border of an active cell that repeats a cell's value in adjacent cells? A. B. C. D.

Fill handle Filler Copy handle Copy box

Answer: A 23. When copying values in Excel 2010, which feature automatically adjusts cell references for the new copy location? A. B. C. D.

Absolute reference Certain reference Variable reference Relative reference

Answer: D 24. Which command on the Home Tab displays the total of the selected cells directly after the selected cells? A. B. C. D.

Sum Add Total Calculate

Answer: A 25. What is the name of the on-screen command that appears in a worksheet when you copy one range to another range? A. B. C. D.

Copy options Auto fill options Reference options Cell options

Answer: B 26. Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? A. B. C. D.

Close Save Save As Exit

Answer: C 27. Which command do you use to save a new worksheet in Excel 2010? A. B. C. D.

Close Save Save As Exit

Answer: B 28. In Excel 2010, what do you use to emphasize certain entries and make the worksheet easier to read and understand? A. B. C. D.

Formatting Printing Arranging Configuring

Answer: A 29. Which defines the appearance and shape of the letters, numbers, and special characters in Excel 2010? A. Format B. Font

C. Size D. Effects Answer: B

30. Which term indicates how characters in an Excel 2010 worksheet are emphasized?

A. B. C. D.

Font size Cell style Font style Alignment

Answer: C 31. What defines the color of the characters in an Excel 2010 worksheet? A. B. C. D.

Font size Font color Cell color Background

Answer: B 32. Which term describes how fonts are measured, and is approximately 1/72 of an inch? A. B. C. D.

Character size Font weight Style size Point size

Answer: D 33. What button on the Home Ribbon automatically enlarges a selected cell’s font size with one click? A. B. C. D.

Italic Increase font size Decrease font size Bold

Answer: B 34. What command on the Home Ribbon applies a thick, dark style to characters in the selected cell?

A. B. C. D.

Italic Underline Bold Superscript

Answer: C 35. On the Home Ribbon, what do you use to change the font face used in the worksheet? A. B. C. D. Answer: A

Font drop-down list Font Size drop-down list Increase Font Size Cell Styles drop-down list