Excel Basics Ultimate Quiz! Trivia
8 Questions
| Total 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
- 2.The Format Painter icon in Excel looks like a
- 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)
- 4.Which Excel function should be used if you need to sort that data alphabetically?
- A.
Filter
- B.
Function
- C.
Sort
- D.
Organize
- 5.Which function should be used to count the number of values in column D?
- A.
ADD
- B.
VLOOKUP
- C.
AVG
- 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
- 7.Which one of the following is a spreadsheet application?
- A.
Microsoft Access
- B.
Microsoft Powerpoint
- C.
Microsoft Word
- D.
Microsoft Excel
- 8.In a spreadsheet formula which symbol is used to multiply?
- A.
+
- B.
-
- C.
X
- D.
*
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 70895 | Last updated: Mar 22, 2022
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 62218 | Last updated: Mar 22, 2022
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 45730 | Last updated: Mar 22, 2022
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top