Year 5 - Unit 4 Quiz - Exploring Spreadsheet

Year 5 - Unit 4 Quiz - Exploring Spreadsheet

5th Grade

15 Qs

quiz-placeholder

Similar activities

asas sains komputer bab 1

asas sains komputer bab 1

1st - 6th Grade

10 Qs

การประเมินผล

การประเมินผล

1st - 5th Grade

10 Qs

QUIZ INFORMATIKA

QUIZ INFORMATIKA

1st - 10th Grade

19 Qs

IIB - Mayor

IIB - Mayor

4th - 6th Grade

10 Qs

5th_MTFeb_Obj

5th_MTFeb_Obj

5th Grade

18 Qs

Baza danych

Baza danych

1st - 9th Grade

18 Qs

Excel

Excel

5th - 6th Grade

15 Qs

Penilaian Harian Kelas 5 Akhir Semester 1

Penilaian Harian Kelas 5 Akhir Semester 1

5th Grade

10 Qs

Year 5 - Unit 4 Quiz - Exploring Spreadsheet

Year 5 - Unit 4 Quiz - Exploring Spreadsheet

Assessment

Quiz

Computers

5th Grade

Practice Problem

Medium

Created by

Krishnaveni Selvaraj

Used 13+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What would be a correct formula for SUM in excel?

=ADD(B3:B9)

SUM(B3:B9)


=SUM(B3:B9)

=AUTOSUM(B3:B9)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula gets the biggest value of a range of cells?

LARGE

MAX

COUNT

MIN

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol must all formula begin with?

-

@

(

=

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the Countif formula return?

Count the number of cells that contain numbers (value)

Biggest amount

Smallest amount

Rate

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which operator is used to multiply in Excel?

\

*

+

-

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

For dividing numbers in A1 AND B1, you use the following formula

=A1\B1

A!\B1

=A1/B1

=A/B

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which button allows you to 'Sort & Filter' the data in Excel?

A

B

C

D

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?