Mastering Spreadsheet Essentials

Mastering Spreadsheet Essentials

9th Grade

20 Qs

quiz-placeholder

Similar activities

Cyber Security Awreness

Cyber Security Awreness

9th - 12th Grade

15 Qs

Systems, Applications, Programming, and Embedded Software

Systems, Applications, Programming, and Embedded Software

8th Grade - University

20 Qs

Math G7 Chapter 3 Mastering Significant Figures and Estimation

Math G7 Chapter 3 Mastering Significant Figures and Estimation

7th Grade - University

20 Qs

The 7 Soft Skills You Need to Be Successful

The 7 Soft Skills You Need to Be Successful

9th Grade

15 Qs

Kuis Perangkat Komputer Kelas 7

Kuis Perangkat Komputer Kelas 7

7th Grade - University

20 Qs

HTML Level 1

HTML Level 1

8th Grade - University

16 Qs

Soal QuIz SMPIT IF Meningkatkan Kemampuan Berpikir

Soal QuIz SMPIT IF Meningkatkan Kemampuan Berpikir

9th Grade

20 Qs

Keterampilan Informatika Kelas 9

Keterampilan Informatika Kelas 9

9th Grade

20 Qs

Mastering Spreadsheet Essentials

Mastering Spreadsheet Essentials

Assessment

Quiz

Information Technology (IT)

9th Grade

Practice Problem

Easy

Created by

S Uwadiae

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to add the values in cells A1 and A2?

`=A1+A2`

`=SUM(A1:A2)`

`=ADD(A1,A2)`

`=A1-A2`

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a basic formula to subtract the value in cell B2 from B1?

`=B1+B2`

`=B1-B2`

`=SUBTRACT(B1,B2)`

`=B2-B1`

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you multiply the values in cells C1 and C2?

`=C1*C2`

`=MULTIPLY(C1,C2)`

`=C1+C2`

`=C1/C2`

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to divide the value in cell D1 by D2?

`=D1*D2`

`=D1-D2`

`=D1/D2`

`=DIVIDE(D1,D2)`

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the average of cells E1 to E5?

`=SUM(E1:E5)`

`=AVERAGE(E1:E5)`

`=MEAN(E1:E5)`

`=MEDIAN(E1:E5)`

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you format a cell to display numbers as currency?

Change the font

Use the currency format option

Use the percentage format option

Use the text format option

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a function to find the maximum value in a range of cells?

`=MIN()`

`=MAX()`

`=LARGEST()`

`=HIGHEST()`

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?