JavaScript must be enabled in your web browser before using this form. You can enable now JavaScript via the Tools/Options menu of your web browser. After doing so, select the View/Reload or View/Refresh menu item to clear this message.
Microsoft Excel
Instructions
Please, answer all the questions below.
Please provide the following (*required)
First Name*
Last Name*
Email*
General Questions
1.
To enter a fraction, such as 1/4, the first thing you enter is ________.
One
Zero
Minus sign
2.
##### means:
You've entered a number wrong.
You've misspelled something.
The cell is not wide enough.
3.
A quick way to return to a specific area of a worksheet is to type in the ______.
Name box.
Formula bar.
Zoom box.
4.
Which key do you press to group two or more nonadjacent worksheets?
CTRL
SHIFT
ALT
5.
Which keyboard shortcut opens the Go To dialog box?
CTRL + B
F2
F5
6.
To fit all the columns on your worksheet on one printed page, what's your first step?
Adjust a column.
Use the Fit to option.
Change the page orientation.
Open the worksheet in Print Preview.
7.
If you want a loop to run until it finds a specified value, what type of loop would you use?
A For each...Next Loop
A Do...Loop
A Loop-dee-Loop
8.
Which function would you use to change text to initial capital letters?
PROPER
UPPER
LOWER
9.
Which of these references is an example of a mixed reference?
B1
$B$1
$B1
AB1
10.
Which of these is not an argument of the IF function?
Logical_test
Value_if_false
Value_when_false
Value_if_true
11.
Which function automatically totals a column or row of values?
TOTAL
ADD
SUM
AVG
12.
Which of these purposes does not pertain to charts?
Identifying trends
Selecting values
Recognizing patterns
Making comparisons
13.
Which of these arithmetic operators takes the highest precedence?
< (lesser than)
> (greater than)
/ (division)
^ (exponentiation)
14.
Which error value is displayed if =B30/0 is keyed into a cell?
#DIV/0
#N/A
#NAME?
#NULL!
15.
Which of the following is the correct order for an A to Z sort?
1, 3, 5, 7
7, 5, 3, 1
Tom, John , Adam
May 1, 2007; April 1, 2007; March 1, 2007
16.
Which command can be set to prohibit or allow a cell entry?
Background error checking
Data validation
Go to Special
Evaluate Formula
17.
What is a probable cause of the #NAME? error value message?
The formula uses a value that is not available.
The formula is divided by zero.
The formula uses unrecognized text.
The formula refers to a cell reference that is not valid.
18.
Which of these formulas is a 3-D reference?
0
#REF!
=([Book1]:Sheet1!)
19.
What is the rectangular area bordered by the axes called?
Chart area
Chart grid
Legend area
Plot area
20.
Which of the following arguments in a financial function indicates the interest for a period?
FV
PV
Nper
Rate
21.
To combine text from cell A2 (Nancy) and cell B2 (Davolio) so that the name is displayed in cell C2 as Davolio, Nancy (reversed name order), you would type this formula: =B2&", "&A2
True
False
22.
Using the Zoom command will make your worksheet print bigger or smaller.
23.
You cannot print row and column headings at the same time.
24.
To print comments at the end of a worksheet, you do not need to display them in the worksheet.
25.
To freeze column names, select the names.
Created with SurveyGold survey software - www.surveygold.com