Excel 2010 Test Bank 1. Which of the following software programs is a powerful spreadsheet program that allows users t... DescriptionExcel 2010 Test Bank 1. Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? A. B. C. D. Show Office 2010 Windows Excel 2010 Calc Answer: C 2. Which of the following notebook- like features organizes the sheets for use in Excel? A. B. C. D. Workbook Worksheet Notepad 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. B. C. D. Scroll bar Navigation window Status bar 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 for 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. B. C. D. Data Information Text 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 the 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 What is considered the control Centre?The nucleus is considered as the control center of the cell as it has all the information for controlling the various components of the cell and keeping the cell alive. Solve any question of Cell : The Unit of Life with:- Patterns of problems.
What are the two other options in File tab which helps you control Microsoft Office?In Microsoft Word and other Microsoft Office products, the File tab is a section on the Office Ribbon that gives you access to file functions. For example, from the File tab, you can access the Open, Save, Close, Properties, and Recent file options.
Where is the general tab in Word?To see general options for working with your Microsoft 365 applications on Windows, click File > Options > General.
Which of the following option is not available in Microsoft Office File button?Detailed Solution. The correct answer is Presentation. Presentation is the option present in MS PowerPoint.
|
