Year 5 - Unit 4 Quiz - Exploring Spreadsheet

Year 5 - Unit 4 Quiz - Exploring Spreadsheet

5th Grade

15 Qs

quiz-placeholder

Similar activities

Cấu trúc tuần tự-rẽ nhánh

Cấu trúc tuần tự-rẽ nhánh

5th Grade

20 Qs

Latihan Kuis Kihajar

Latihan Kuis Kihajar

4th - 6th Grade

15 Qs

Dosya ve İnternet adresleri Uzantıları

Dosya ve İnternet adresleri Uzantıları

4th - 12th Grade

16 Qs

Teknologi Dan Komunikasi T4

Teknologi Dan Komunikasi T4

3rd - 6th Grade

10 Qs

การจัดการตลาดสินค้า

การจัดการตลาดสินค้า

5th Grade

20 Qs

Doc Quiz

Doc Quiz

2nd - 6th Grade

20 Qs

ÔN TẬP HK2 TIN 5 23 - 24

ÔN TẬP HK2 TIN 5 23 - 24

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?