Which tab do you use to display the area that contains the print command?
A. Home
B. Page Layout
C. View
D. File
File
100
On the Home Ribbon, what do you use to change the font size of characters in a cell?
A. Font drop-down list
B. Font Size drop-down list
C. Font Style drop-down list
D. Cell Styles drop-down list
Font Size Drop Down List
100
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
A. Alignment
B. Font
C. Size
D. Effects
Font
100
What command do you use to apply a background color to cells in a worksheet?
A. Drawing
B. Fill Color
C. Borders & Shading
D. Highlight
Fill Color
100
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
A. AVERAGE
B. MAX
C. MIN
D. SUM
MAX
200
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
A. Form
B. Boilerplate
C. Smart Sheet
D. Template
Template
200
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
A. Exit
B. Open
C. Save
D. Save As
Open
200
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
A. =B4+C4
B. =B4*C4
C. =B4 x C4
D. =B4-C4
=B4 * C4
200
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
A. Copy method from Shortcut Menu
B. Copy using the Fill Handle
C. Copy from the Home Ribbon
D. Copy using the Quick Access Toolbar
Copy using the Fill Handle
200
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
AutoSum
300
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
A. AVERAGE
B. MAX
C. MIN
D. SUM
AVERAGE
300
Which view is the default view used in Microsoft Excel?
A. Page Layout
B. Print
C. Normal
D. Web
Normal
300
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
A. values
B. formulas
C. labels
D. functions
Formula
300
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A. Absolute reference
B. Certain reference
C. Variable reference
D. Relative reference
Relative Reference
300
What is a prewritten formula that is built into Microsoft Excel called?
A. Utility
B. Procedure
C. Function
D. Statement
Function
400
Angie is calculating her average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry?
A. values
B. formulas
C. labels
D. functions
Function
400
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A. Smart Fit
B. AutoFit
C. Best Fit
D. True Fit
AutoFit
400
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 handle
B. Filler
C. Copy handle
D. Copy box
Fill Handle
400
What area contains the command used to customize the print options in Microsoft Excel?
A. Home Ribbon
B. Page Layout Ribbon
C. File Tab
D. Quick Access Toolbar
File Tab
400
Where can you find the Insert Function button in Microsoft Excel?
A. Quick Access Toolbar
B. Formula bar
C. Status bar
D. Shortcut menu
Formula Bar
500
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
A. AutoFit
B. Special Formatting
C. Subscript Formatting
D. Wrap Text
Autofit
500
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
A. Cell box
B. Address box
C. Name box
D. Formula box
Name Box
500
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
A. Cell
B. Column
C. Range
D. Row
Range
500
Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header?
A. values
B. formulas
C. labels
D. functions
Labels
500
Which of the following are valid Microsoft Excel functions?
A. AVERAGE, MAX, and NUM
B. MAX, MIN, and WEEK
C. AVERAGE, MAX, and MIN
D. WEEKDAY, MAX, and CLOSE