Question

Write the formula to find the total marks of each students
a=sum(C2:G2)
b=sum(C2:F2)
c- BOTH​

Answer 1

Answer:

Formula Description

Formula Description=C2-B2 Subtracts contents of B2 from contents of C2

Formula Description=C2-B2 Subtracts contents of B2 from contents of C2=C2/B2 Divides contents of C2 by contents of B2

Formula Description=C2-B2 Subtracts contents of B2 from contents of C2=C2/B2 Divides contents of C2 by contents of B2=(B2+C2+D2)/3 Adds contents of B2, C2, and D2 and divides result by 3

Answer 2

Answer:

Formula

Description=C2-B2

Subtracts contents of B2 from contents

of C2

Formula

Description=C2-B2

Subtracts contents of B2

from contents of C2=C2/B2

Divides contents of C2 by contents of

B2

Formula

Description=C2-B2 Subtracts contents of B2

from contents of C2=C2/B2

Divides contents of C2 by Adds contents of B2, C2, and D2 and

contents of B2=(B2+C2+D2)/3

divides result by 3