Excel Topic 5

Excel Topic 5

7th Grade

11 Qs

quiz-placeholder

Similar activities

Exel Formulas

Exel Formulas

6th - 8th Grade

12 Qs

Year 8 Homework 3 - HT2

Year 8 Homework 3 - HT2

7th Grade

15 Qs

Pēcpārbaudījums 6. klase

Pēcpārbaudījums 6. klase

6th Grade - University

10 Qs

Rumus Date Time

Rumus Date Time

1st - 10th Grade

10 Qs

Pretest Pengolahan Data Dasar

Pretest Pengolahan Data Dasar

7th Grade

10 Qs

Excel Basics

Excel Basics

5th - 10th Grade

12 Qs

Informática Saenz

Informática Saenz

7th 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?