Excel Basics Ultimate Quiz! Trivia
8 Questions
| Attempts: 244
(41).jpg "Excel Basics Ultimate Quiz! Trivia - Quiz")
.
Questions and Answers
- 1.
What is the keyboard shortcut for copying data in Excel?
- A.
Ctrl / X
- B.
Ctrl / C
- C.
Ctrl / V
- D.
Ctrl / I
Correct Answer
B. Ctrl / C -
- 2.
The Format Painter icon in Excel looks like a
Correct Answer
paint brush - 3.
What is the formula for adding all numbers in column A?
- A.
=sum(A1:A2000)
- B.
+sum(A1:A2000)
- C.
=sum(A1-A2000)
- D.
=sum(A1+A2000)
Correct Answer
A. =sum(A1:A2000) -
- 4.
Which Excel function should be used if you need to sort that data alphabetically?
- A.
Filter
- B.
Function
- C.
Sort
- D.
Organize
Correct Answer
C. Sort -
- 5.
Which function should be used to count the number of values in column D?
- A.
ADD
- B.
VLOOKUP
- C.
AVG
- D.
COUNT
Correct Answer
D. COUNT -
- 6.
Name the area within a worksheet that is current, or ready to receive information?
- A.
Worksheet
- B.
Cell
- C.
Active Cell
- D.
Office Assistant
Correct Answer
C. Active Cell -
- 7.
Which one of the following is a spreadsheet application?
- A.
Microsoft Access
- B.
Microsoft Powerpoint
- C.
Microsoft Word
- D.
Microsoft Excel
Correct Answer
D. Microsoft Excel -
- 8.
In a spreadsheet formula which symbol is used to multiply?
- A.
+
- B.
-
- C.
X
- D.
*
Correct Answer
D. * -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2022Quiz Edited by
ProProfs Editorial Team -
Mar 16, 2010Quiz Created by
Kathierotz
Back to top