Excel Knowledge Test! Ultimate Trivia Quiz
13 Questions
| Total Attempts: 1842
Questions and Answers
- 1.Why is it good practice to avoid creating blank rows and columns in the main body in a list?
- A.
This is because a blank row or column can effect a formula result.
- B.
It makes the formula look nice.
- C.
It makes it easier to use formulas.
- 2.Identify the error value
- A.
########
- B.
Wrong answer
- C.
%%%%%%%
- 3.The SUM function is used to find the total fo a specified cell range?
- A.
True
- B.
False
- 4.The AVERAGE Function is used to find the average value in a specified cell range?
- A.
True
- B.
False
- 5.You can count Text using the COUNT function?
- A.
True
- B.
False
- 6.Which comparison operator will help you find the value in the IF Function?
- A.
"
- B.
=>
- C.
!
- 7.A cell should only contain one element of data?
- A.
True
- B.
False
- 8.The default position for text within a cell is left aligned.
- A.
True
- B.
False
- 9.The default position for numbers and dates is right aligned?
- A.
True
- B.
False
- 10.To select an adjacent cell range to hold down the CTRL key and click the cell or drag over the cells to be selected?
- A.
True
- B.
False
- 11.The Sort A to Z is for ascending order.
- A.
True
- B.
False
- 12.The Sort Z to A is for decending order?
- A.
True
- B.
False
- 13.Gridlines are in the Page setup in the Layout tab?
- A.
True
- B.
False
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: 70952 | 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: 62232 | 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: 45739 | Last updated: Mar 22, 2022
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top