Excel 1
5 Questions
| Attempts: 167
Take this quick quiz that will evaluate your skills with Excel!
Questions and Answers
- 1.
If you clicked on Autofill Options how would you be able to change this data? (Note: there may be more than one correct answer.)
- A.
Remove the weekend days automatically
- B.
Automatically insert today's date
- C.
Copy "Monday" in all cells
- D.
Change the call formatting to display abbreviated names for the days (i.e. "Mon", "Tue")
Correct Answer(s)
A. Remove the weekend days automatically
B. Automatically insert today's date -
- 2.
This data has had an Autofilter applied to Column B so that some of the original data is now hidden. If you were to remove the Autofilter, how many rows of data (NOT including Header Row) would you see?
- A.
2
- B.
3
- C.
1
- D.
4
Correct Answer
A. 2 -
- 3.
What is the name of the formula used to determine the highest value in an array of cells?
- A.
MIN
- B.
MAX
- C.
COUNT
- D.
DESCENDING
- E.
ASCENDING
Correct Answer
B. MAX -
- 4.
Which of the following is among the correct ways to write a formula to take the sum of cells C1 through F1?
- A.
=sum(c1,f1)
- B.
Sum(c1:f1)
- C.
=SUM(C1:F1)
- D.
=SUM(C1-F1)
Correct Answer
A. =sum(c1,f1) -
- 5.
What is the name of the cell highlighted in yellow?
Correct Answer
B3
b3
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 28, 2013Quiz Edited by
ProProfs Editorial Team -
Jul 01, 2011Quiz Created by
Aoxonoma
Back to top