1
2
3
4
5
100
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?
Ctrl+End
100
Joan wants to format the cells in her spreadsheet. What is the shortcut that will open the format dialog box?
Ctrl+1
100
Which of the following software programs is a powerful spreadsheet that allows users to organize data, complete calculations ,and graph data?
Excel 2010
100
Which of the following notebook- like features organizes the sheets for use in Excel?
Workbook
100
Which of the following would you use to enter,calculate, manipulate,and analyze data such as numbers and text in Excel?
Worksheet
200
Which Microsoft Office object would you use for quick,convenient, one-click access to frequently used in Excel commands?
Quick Access Toolbar
200
What is the name of the list of frequently used commands available when a user right-clicks an item in the worksheet?
Shortcut Menu
200
Which command do you use to close an open file and completely exit the Microsoft Excel program?
Exit
200
David wants to key the numbers 1 to 1000 in Column A of his spreadsheet. What command should he use to complete the task?
AutoFill
200
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a
Range
300
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
Copy
300
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
AutoFit
300
Where can you find the Insert Function button in Microsoft Excel?
Formula bar
300
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Merge and Center
300
Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select ?
Orientation
400
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
400
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
Cell Style
400
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
Format as Table
400
Which defines the appearance and shape of the letters , numbers ,and special characters in Microsoft Excel?
Font
400
What defines the color of the characters in an Microsoft Excel worksheet?
Font color
500
Jim would like to print only the cell range A1:F20. What page setup option should he change?
Print Area
500
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet.Which option should she choose?
Freeze
500
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
Page Layout
500
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
Arrange All
500
To help organize and identify Microsoft Excel file by providing details about the files,which of the following would you use?
Document properties
M
e
n
u