Microsoft Excel Test MCQ Quiz!
7 Questions
| Total Attempts: 2999
(310).jpg "Microsoft Excel Test MCQ Quiz!")
.
Questions and Answers
- 1.In order to save a new document in Microsoft Excel, you must select one of the following toolbar options?
- A.
Edit
- B.
Format
- C.
Help
- D.
File
- 2.An Excel spreadsheet is primarily used for calculating which of the following options?
- A.
Data
- B.
Finances
- C.
Numbers
- D.
All of the above
- 3.Which of the following option is a formula?
- A.
=SUM(A1:A5)
- B.
Add A1 - A5
- C.
Subtract the numbers from A1 to A5
- D.
A1 = A5
- 4.Which one of the following options CANNOT be used in an Excel spreadsheet formula?
- A.
= (equal sign)
- B.
, (comma)
- C.
& (ampersand)
- D.
: (colon)
- 5.What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula?
- A.
To add all the data together using addition only
- B.
To tell the person viewing that this is a function and it should be added together
- C.
To calculate all the data correctly without any mistakes
- D.
To inform the computer that an arithmetic function will occur
- 6.Which of the following INCORRECTLY selects multiple cells?
- A.
(A1:G50)
- B.
(A1, B3:C9)
- C.
(A1:B5:C5)
- D.
(A1:B5#C5)
- 7.In order to add or alter a formula, under which of the following menu options can the 'function' menu be found?
- A.
Tools
- B.
File
- C.
Help
- D.
Insert
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: 64632 | Last updated: May 30, 2021
-
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: 60365 | Last updated: Nov 19, 2020
-
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: 44805 | Last updated: Feb 12, 2021
-
Sample QuestionWhich language is used to create macros in Excel?
Are You Really Best Friends? Take The Quiz & Prove It
Are You Really Best Friends? Take The Quiz & Prove It
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Back to top