Question 1

Formula for A1 add B1

Accepted Answer

=A1+B1

Answer

=SUM (A:B)

Answer

A1:B1

Question 2

Formula for D3 subtract A1

Accepted Answer

=D3-A1

Answer

D3:A1

Answer

=SUM (A:D3)

Question 3

Formula for C5 multiply by E1

Accepted Answer

=C5*E1

Answer

=C5xE1

Answer

=C5:E1

Question 4

Formula for C1 divide by E1

Accepted Answer

=C1/E1

Answer

=C1:E1

Answer

=C/E

Question 5

Think of a better formula: =A1+A2+A3+A4+A5

Accepted Answer

=SUM (A1:A5)

Answer

=(A1:A5)

Answer

=SUM (A)

Question 6

Think of a better formula: =A1+B1+C1+D1+E1

Accepted Answer

=SUM (A2:E2)

Answer

=SUM (A:E)

Answer

=(A1:E5)

Question 7

How could you use (A1:E5) to find the largest number in the excel sheet?

Accepted Answer

=MAX(A1:E5)

Answer

=FULLSEND(A1:E5)

Answer

=MIN(A1:E5)

Question 8

How could you use (A1:E5) to find the lowest number in the excel sheet?

Accepted Answer

=MIN(A1:E5)

Answer

=FULLSEND(A1:E5)

Answer

=MAX(A1:E5)

Related quizzes