FREE Excel Trivia Questions and Answers

Question 1

Click the worksheet tab of the sheet you wish to copy, hold down SHIFT, and then drag the chosen sheet along the row of sheet tabs to copy the complete worksheet and all of its data.

Accepted Answer

FALSE

Answer

TRUE

Question 2

A _______ is the term for the point where a row and a column intersect.

Accepted Answer

cell

Answer

sum

Answer

worksheet

Answer

chart

Question 3

A cell cluster is referred to as a ___.

Accepted Answer

cell range

Answer

cell cluster

Answer

chart

Answer

multicell

Question 4

What location does the fill handle have?

Accepted Answer

in the bottom-right corner of the selected cell

Answer

in Backstage view

Answer

on the right side of the Home tab on the Ribbon

Answer

at the beginning of any formula or function

Question 5

Why does the value in cell G1 in this image appear to be somewhat different from the value in the formula bar?

Accepted Answer

It’s using the Currency number format.

Answer

It’s using conditional formatting.

Answer

It’s using a formula.

Answer

It’s using an absolute cell reference.

Question 6

To switch between Workbooks, click the tabs at the bottom of a workbook.

Accepted Answer

worksheets

Answer

permissions

Answer

formulas

Answer

number formats

Question 7

Say you are looking for your average grade. What's wrong with the image's formula, exactly?

Accepted Answer

It should have an equals sign (=) at the beginning.

Answer

It should use the COUNT function instead.

Answer

It should use quotation marks instead of parentheses.

Answer

There is nothing wrong with the formula.

Question 8

True or False: By double-clicking the cell that the formula is located in, you can view the formula.

Accepted Answer

TRUE

Answer

FALSE

Question 9

Which of the following is a reference to an absolute cell?

Accepted Answer

$A$2

Answer

#A2

Answer

A:2

Answer

A2

Question 10

Which of the following formulas is true? Please check all that apply.

Accepted Answer

=R2*D2

Answer

A3+100

Answer

=F2+F3+F4-53

Answer

=5B+6B