# Excel Knowledge Test! Ultimate Trivia Quiz

13 Questions | Total Attempts: 1770  Settings  Related Topics
• 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.

• 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