26-30
31-35
36-40
41-45
46-50
100
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
NOW
100
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Font
100
Which command on the Insert ribbon creates a link to a web page, picture, email address, or a program in a worksheet? Column D in a spreadsheet contains employee ID numbers. Which formatting would be most appropriate for the data in column D?
Hyperlink
100
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?
AutoFit
100
Which command on the Home ribbon joins selected cells into one and centers that contents into a larger single cell?
Merge & Center
200
Angie is calculating her average sales for the past four months. If she uses “=AVERAGE(B1:B4)”, this an example of which type of entry?
Functions
200
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
200
What command do you use to apply a background color to cells in a worksheet?
Text
200
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
Format Cells
300
On the Home ribbon, what do you use to change the font size of characters in a cell?
Font Size Drop-Down List
300
Which command on the Home ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
Orientation
300
Kenyon would like to apply the Title format to the data in row 1 of a spreadsheet. Which formatting style should he select?
Fill Color
300
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
Cell Style
400
Which quick-number style button formats numbers to display as currency in the worksheet?
Accounting
400
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
Currency
400
Kathryn needs the text in cell A1 to be angled by 90 degrees. Which alignment option should she select?
Orientation
400
What defines the color of the characters in an Excel worksheet?
Font Color
500
Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
Home Ribbon
500
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
Conditional Formatting
500
What type of formatting appears only when the value in a cell meets conditions specified by a user?
Conditional
500
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Font Color Drop-Down List
M
e
n
u