Excel Quiz
13 Questions
| Total Attempts: 1649
Settings
ECDL Excel Quiz
Questions and Answers
- 1.
- A.
This is because a blank row or column can effect a formula result.
- B.
It makes the formula look nice.
- C.
Makes it easier to use formulas
- 2.Identify the error value
- A.
########
- B.
Wrong answer
- C.
%%%%%%%
- 3.The SUM Function is usd 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.
- A.
True
- B.
False
- 11.The Sort A to Z is for acending order
- A.
True
- B.
False
- 12.The Sort Z to A is for decending order?
- A.
True
- B.
False
- 13.Gridlines is in the Page setup in the Layout tab?
- A.
True
- B.
False
Back to top