Excel Topic 5

Excel Topic 5

7th Grade

11 Qs

quiz-placeholder

Similar activities

Tin Học KTTX2

Tin Học KTTX2

7th Grade

14 Qs

Formeln (Excel)

Formeln (Excel)

6th - 7th Grade

11 Qs

Excel

Excel

1st - 12th Grade

12 Qs

computer

computer

5th - 8th Grade

10 Qs

Spreadsheets V2

Spreadsheets V2

6th - 8th Grade

15 Qs

Google Sheets Basics

Google Sheets Basics

6th - 9th Grade

6 Qs

Spreadsheet Formula

Spreadsheet Formula

7th Grade

15 Qs

Basics of Excel

Basics of Excel

6th - 8th Grade

10 Qs

Excel Topic 5

Excel Topic 5

Assessment

Quiz

Computers

7th Grade

Easy

Created by

Christina Moore

Used 42+ times

FREE Resource

11 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Addition with Cell Reference and Sign

= B9/B5/B3

=B1+B2+B3

=PRODUCT(B5,B6)

=AVERAGE(B2:B7, B10:B15)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Addition with Formula and Comma

=PRODUCT(B5,B6)

=B3*B4*B5*B6

=COUNT(A2:A5, B4:B6)

=SUM(B1,B2,B3)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Addition with Formula and Range

=SUM(B1:B3)

=COUNT(A2:A5, B4:B6)

=ROW(A1)

=AVERAGE(B2:B7, B10:B15)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Averaging

=PRODUCT(B5,B6)

=COUNT(A2:A5, B4:B6)

=SUM(B1:B3)

=AVERAGE(B2:B7, B10:B15)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Counting

=PRODUCT(B5,B6)

=COUNT(A2:A5, B4:B6)

=ROW(A1)

=AVERAGE(B2:B7, B10:B15)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Division

= B9/B5/B3

=SUM(B1:B3)

=AVERAGE(B2:B7, B10:B15)

=B1+B2+B3

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Multiplication with Cell Reference and Sign

=B3-B2-B1

=COUNT(A2:A5, B4:B6)

=AVERAGE(B2:B7, B10:B15)

=B3*B4*B5*B6

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?