WorksheetsExcel Topic 5
Total questions: 11
Worksheet time: 6mins
Addition with Cell Reference and Sign
= B9/B5/B3
=B1+B2+B3
=PRODUCT(B5,B6)
=AVERAGE(B2:B7, B10:B15)
Addition with Formula and Comma
=PRODUCT(B5,B6)
=B3*B4*B5*B6
=COUNT(A2:A5, B4:B6)
=SUM(B1,B2,B3)
Addition with Formula and Range
=SUM(B1:B3)
=COUNT(A2:A5, B4:B6)
=ROW(A1)
=AVERAGE(B2:B7, B10:B15)
Averaging
=PRODUCT(B5,B6)
=COUNT(A2:A5, B4:B6)
=SUM(B1:B3)
=AVERAGE(B2:B7, B10:B15)
Counting
=PRODUCT(B5,B6)
=COUNT(A2:A5, B4:B6)
=ROW(A1)
=AVERAGE(B2:B7, B10:B15)
Division
= B9/B5/B3
=SUM(B1:B3)
=AVERAGE(B2:B7, B10:B15)
=B1+B2+B3
Multiplication with Cell Reference and Sign
=B3-B2-B1
=COUNT(A2:A5, B4:B6)
=AVERAGE(B2:B7, B10:B15)
=B3*B4*B5*B6
Multiplication with Formula and Comma
= B9/B5/B3
=B3-B2-B1
=PRODUCT(B5,B6)
=ROW(A1)
Numbering
=ROW(A1)
=B1+B2+B3
=PRODUCT (B3:B5)
=B3*B4*B5*B6
Subtraction
=B3-B2-B1
=COUNT(A2:A5, B4:B6)
=SUM(B1:B3)
=AVERAGE(B2:B7, B10:B15)
What is an example of an Excel file extension?
.doc
.jpg
.wav
.xls
