Excel Knowledge Test! Ultimate Trivia Quiz
13 Questions
| Total Attempts: 1770
Settings
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
Back to top