Excel Basic Knowledge
- 1.
If labels spill onto the column to its right & the column on the right is not empty you need to
- A.
Re size the column
- B.
Complete your calculations by hand, excel is too hard to learn
- C.
Leave it the way it is
Correct Answer
A. Re size the column -
- 2.
A__________ is a single point of color on the screen
- A.
Pixel
- B.
Cell
- C.
Border
- D.
Margin
Correct Answer
A. Pixel -
- 3.
A value is always _____________ aligned in the cells & is included in calculations
- A.
Left
- B.
Centered
- C.
Justified
- D.
Right
Correct Answer
D. Right -
- 4.
This button allows you to incorporate the currency format to data
- A.
.
- B.
%
- C.
=
- D.
-
- E.
$
Correct Answer
E. $ -
- 5.
When you key the date, excel applies a standard format that shows
- A.
2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.
- B.
Excel leaves it exactly the way I type it!
- C.
The formula to change the date
Correct Answer
A. 2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year. -
- 6.
What does the function Sum do?
- A.
Adds the values in the range & then divides by the number of cells in the range
- B.
Determines the largest value in a range
- C.
Multiplies the values in a range
- D.
Adds the values in the cell
Correct Answer
D. Adds the values in the cell -
- 7.
You can check results of your calculations by using
- A.
Auto fit
- B.
Auto replace
- C.
Auto correct
- D.
Auto calculate
Correct Answer
D. Auto calculate -
- 8.
A________ is a series of instructions that performs a calculation & displays an answer
- A.
Function
- B.
Formula
- C.
Range
- D.
Cell
Correct Answer
B. Formula -
- 9.
Formula's always start with
- A.
=
- B.
-
- C.
+
- D.
*
Correct Answer
A. = -
- 10.
When sorting, you must highlight the entire column of the column you wish to sort by
- A.
True
- B.
False
Correct Answer
B. False -
- 11.
To set up subtotals the data must first be formatted as a table
- A.
True
- B.
False
Correct Answer
B. False -
- 12.
You can use text in a formula
- A.
True
- B.
False
Correct Answer
A. True -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 19, 2013Quiz Edited by
ProProfs Editorial Team -
Jun 07, 2012Quiz Created by
Mkingsley10
Back to top