Excel Test 1
Answer the following:
- 1.
- A.
Tool bar
- B.
Menu bar
- C.
Instruction bar
Correct Answer
B. Menu barExplanation
Menu bar
The Menu bar displays all the menus available for use in Excel 2003.Rate this question:
-
- 2.
- A.
Title bar
- B.
Menu bar
- C.
Tool bar
Correct Answer
A. Title barExplanation
The Title bar displays both the name of the application and the name of the spreadsheet.Rate this question:
-
- 3.
This is an example of ____________________________ headings.
Correct Answer
column - 4.
Each row is named by a ____________.
Correct Answer
number - 5.
A cell is an intersection of a column and row.
- A.
True
- B.
False
Correct Answer
A. True -
- 6.
A Workbook defaults to three worksheets. A Workbook must contain at least two worksheets.
- A.
True
- B.
False
Correct Answer
B. False -
- 7.
- Each Excel worksheet is made up of columns and rows.
- A.
True
- B.
False
- 8.
The ___________ cell, or the cell that can be acted upon, reveals a dark border.
- A.
Formula
- B.
Live
- C.
Active
Correct Answer
C. Active -
- 9.
The following cell is named_____________
- A.
C3
- B.
3C
- C.
C-#3
Correct Answer
A. C3 -
- 10.
- A darkened border, called the cell pointer, identifies it.
- A.
True
- B.
False
- 11.
The _______ menu contains all the operations that we will discuss in this lesson: New, Open, Close, Save and Save As.
- A.
File
- B.
Save
- C.
Title
Correct Answer
A. File -
- 12.
Used when to save a new file for the first time or save an existing file with a different name.
- A.
Save
- B.
Open
- C.
Save as
Correct Answer
C. Save as -
- 13.
Used to open an existing file from a floppy disk or hard drive of your computer.
- A.
Save
- B.
Open
- C.
Save as
Correct Answer
B. Open -
- 14.
Every workbook created in Excel must be saved and assigned a name to distinguish it from other workbooks.
- A.
True
- B.
False
Correct Answer
A. True -
- 15.
If you're saving the file for the first time and you do not choose a file name, Microsoft Excel will not assign a file name for you.
- A.
True
- B.
False
Correct Answer
B. False -
- 16.
Excel's______________ feature keeps track of previously-entered text. If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you.
- A.
Autofinish
- B.
Autofill
- C.
AutoComplete
Correct Answer
C. AutoComplete -
- 17.
- Double-click on the cell that contains the information to be changed.
- A.
True
- B.
False
- 18.
- A.
Undo button
- B.
Redo button
- C.
Backspace button
Correct Answer
A. Undo button -
- 19.
- Click-and-hold the left mouse button and drag left or right, up or down to the last cell you want to select.
- A.
To work in a range of cells
- B.
To delete a range of cells
- C.
To choose a range of cells
- 20.
Click the gray Row heading to select the entire row.
- A.
True
- B.
False
Correct Answer
A. True -
- 21.
Click the gray rectangle in the upper left corner to select half worksheet.
- A.
True
- B.
False
Correct Answer
B. False -
- 22.
If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select, and hold down the _______ key while selecting other ranges.
- A.
Control
- B.
Shift
- C.
Alt
Correct Answer
A. Control -
- 23.
Excel requires every formula to begin with an equal sign (=).
- A.
True
- B.
False
Correct Answer
A. True -
- 24.
- Type the ____________ to let Excel know that an add operation is to be performed.
- A.
Sum function
- B.
Addition sign (+)
- C.
All of the above
- 25.
Formulas can be created by using either numbers or cell references in the definition.
- A.
True
- B.
False
Correct Answer
A. True -
- 26.
To multiply two cells the formula, B2 and B3, you would need to insert a multiplication operator the letter "x" between them.
- A.
True
- B.
False
Correct Answer
B. False -
- 27.
_________________________ formulas involve more than one mathematical operation.
Correct Answer
Complex - 28.
In Excel, never do math "in your head" and type the answer in a cell where you would expect to have a formula calculate the answer.
- A.
True
- B.
False
Correct Answer
A. True -
- 29.
(5-2)*3
- A.
Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. perform multiplication first
- B.
Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. perform parenthesis first
- C.
Perform subtraction first
Correct Answer
B. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. perform parenthesis first -
- 30.
Press ________ or click the Enter button on the Formula bar. This step ends the formula.
- A.
Enter
- B.
Control
- C.
Shift
Correct Answer
A. Enter -
- 31.
The__________________ method allows you to copy a formula and fill it into many different consecutive cells at the same time.
- A.
Auto formula
- B.
Auto save
- C.
Fill formula
Correct Answer
C. Fill formula -
- 32.
You cannot use copy and paste to copy a formula to other cells.
- A.
True
- B.
False
Correct Answer
B. False -
- 33.
Click the Copy button. Marching "ants" appear around the copied cell(s).
- A.
True
- B.
False
Correct Answer
A. True -
- 34.
You can revise any formula that was previously written in a worksheet.
- A.
True
- B.
False
Correct Answer
A. True -
- 35.
___________ cell references in a formula always refer to the same cell or cell range in a formula.
- A.
Absolute
- B.
Auto complete
- C.
Fill
Correct Answer
A. Absolute -
- 36.
Identifies the largest number in a range of cells.
- A.
MIN
- B.
SUM
- C.
MAX
Correct Answer
C. MAX -
- 37.
- A.
Auto Sum Buttton
- B.
Auto Average Button
- C.
Both
Correct Answer
A. Auto Sum Buttton -
- 38.
Sheet tabs can be renamed by simply double clicking on the them and typing in the new name.
- A.
True
- B.
False
Correct Answer
A. True -
- 39.
You do not have the ability to insert new worksheets if needed or delete others you no longer want.
- A.
True
- B.
False
Correct Answer
B. False -
- 40.
____________ worksheets allows you to apply identical formulas and/or formatting across all the worksheets in the group.
- A.
Bunching
- B.
Grouping
- C.
Auto Select
Correct Answer
B. Grouping -
- 41.
_____________________ (double headed arrow) can be used to change a column width.
- A.
Adjustment tool
- B.
Redo button
- C.
Auto Fill Button
Correct Answer
A. Adjustment tool -
- 42.
The default font in a spreadsheet is ____________ points
- A.
Ariel 12
- B.
Times New Roman 10
- C.
Arial 10
Correct Answer
C. Arial 10 -
- 43.
- A.
Font Color
- B.
Cell Fill Color
- C.
Font Size
Correct Answer
A. Font Color -
- 44.
Bold, Italize, highlight
- A.
True
- B.
False
Correct Answer
B. False -
- 45.
Use to add a border around a range of cell
- A.
True
- B.
False
Correct Answer
A. True -
A. True
A. True
A. True
C. To choose a range of cells
C. All of the above
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 22, 2013Quiz Edited by
ProProfs Editorial Team -
Feb 08, 2011Quiz Created by
Daisyjones
Back to top