Question 1

In Excel, what symbol is used to start a formula?

Accepted Answer

=

Answer

$

Answer

@

Answer

#

Question 2

What feature in Excel is used to automatically fill data based on a pattern?

Accepted Answer

Fill Handle

Answer

Cell Style

Answer

Data Validation

Answer

Freeze Panes

Question 3

Which function in Excel adds up a range of numbers?

Accepted Answer

SUM

Answer

AVERAGE

Answer

MAX

Answer

COUNT

Question 4

What does the 'Merge & Center' feature do in Excel?

Accepted Answer

Combines multiple cells into one and centers the text

Answer

Changes the cell color

Answer

Changes the font size

Answer

Splits a single cell into multiple

Question 5

In Excel, what does a cell reference like B2 indicate?

Accepted Answer

The cell located at column B and row 2

Answer

The cell located at row 2 and column B

Answer

The entire row 2

Answer

The entire column B

Question 6

A ROW in an Excel spreadsheet appears in which direction?

Accepted Answer

Horizontal

Answer

Diagonal

Answer

Vertical

Question 7

On an Excel spreadsheet a column appears in which direction?

Accepted Answer

Vertical

Answer

Diagonal

Answer

Horizontal

Question 8

What would you use to make the gridlines of a spreadsheet stand out?

Accepted Answer

A BORDER

Answer

FILL HANDLE

Answer

BOLD

Answer

A COLUMN

Question 9

IWhich of the following would multiply two cells?

Accepted Answer

=B2*C2

Answer

(D8xE8)

Answer

=A1XB1

Answer

C4*C5

Question 10

Which function will SUM totals in a column for you

Accepted Answer

$\sum_{\ }^{ }$

Answer

$\sum_{\ }^{ }$

Answer

$\sum_{\ }^{ }$

Answer

$\sum_{\ }^{ }$

Question 11

Which of the following represents a RANGE on an Excel sheet?

Accepted Answer

D5&#58;F13

Answer

A2#D5

Answer

B1; F3

Answer

=A2"F3

Related quizzes

Related quizzes