Question 1

What formula would you use to sum the values in cells A1 through A5 in Excel?

Accepted Answer

SUM(A1:A5)

Answer

COUNT(A1:A5)

Answer

TOTAL(A1,A5)

Answer

ADD(A1 .. A5)

Question 2

Which Excel function would you use to find the average of cells B2 through B6?

Accepted Answer

AVERAGE(B2:B6)

Answer

MEDIAN(B2:B6)

Answer

MEAN(B2:B6)

Answer

MODE(B2:B6)

Question 3

Which Excel function would you use to find the maximum value in the range C1 to C10?

Accepted Answer

MAX(C1:C10)

Answer

HIGHEST(C1:C10)

Answer

LARGE(C1:C10)

Answer

TOP(C1:C10)

Question 4

What is the correct formula to multiply the values in cells E1 and F1 in Excel?

Accepted Answer

E1*F1

Answer

E1+F1

Answer

MULTIPLY(E1,F1)

Answer

PRODUCT(E1,F1)

Question 5

Which Excel function would you use to round the value in cell G2 to the nearest integer?

Accepted Answer

ROUND(G2,0)

Answer

INTEGER(G2)

Answer

NEAREST(G2)

Answer

CEIL(G2)

Question 6

In Excel, what formula would you use to calculate the total of the values in cells A1, A3, A5, and A7?

Accepted Answer

SUM(A1, A3, A5, A7)

Answer

SUM(A1:A7)

Answer

TOTAL(A1, A3, A5, A7)

Answer

ADD(A1, A3, A5, A7)

Question 7

In Excel, what is the symbol used for multiplication?

Accepted Answer

*

Answer

/

Answer

%

Answer

+

Question 8

In Excel, which formula is used to divide the value in cell A1 by the value in cell B1?

Accepted Answer

A1/B1

Answer

A1*B1

Answer

A1+B1

Answer

A1-B1

Question 9

What function in Excel would you use to find the average of a series of numbers?

Accepted Answer

AVERAGE

Answer

MEDIAN

Answer

MODAL

Answer

MEAN

Question 10

Which function in Excel can you use to count the number of cells that contain numbers in a range?

Accepted Answer

COUNT

Answer

SUM

Answer

COUNTA

Answer

AVERAGE

Question 11

In Excel, what function would you use to return the largest number in a set of values?

Accepted Answer

MAX

Answer

GREATEST

Answer

LARGE

Answer

MIN

Question 12

What Excel function is used to find the smallest number in a range of cells from C1 to C10?

Accepted Answer

MIN(C1:C10)

Answer

AVERAGE(C1:C10)

Answer

SUM(C1:C10)

Answer

MAX(C1:C10)

Question 13

In Excel, how would you calculate the total sum of cells D1, D2, and D3?

Accepted Answer

=D1+D2+D3

Answer

=MULTIPLY(D1, D2, D3)

Answer

TOTAL(D1:D3)

Answer

SUM(D1:D3)

Question 14

Which Excel function is used to count cells that meet a specific condition in a range from G1 to G10?

Accepted Answer

COUNTIF(G1:G10, condition)

Answer

SUMIF(G1:G10, condition)

Answer

IF(G1:G10, condition)

Answer

COUNTA(G1:G10)

Related quizzes

Related quizzes