Mastering Spreadsheet Essentials

Mastering Spreadsheet Essentials

9th Grade

20 Qs

quiz-placeholder

Similar activities

CM- U2L4 - Exploring Windows OS Features

CM- U2L4 - Exploring Windows OS Features

9th Grade - University

20 Qs

S3 Admin and IT Spreadsheets

S3 Admin and IT Spreadsheets

9th Grade

15 Qs

Introduction to MS - Excel

Introduction to MS - Excel

9th Grade - University

25 Qs

Class 9 Viva Questions 9B mideterm

Class 9 Viva Questions 9B mideterm

9th Grade

20 Qs

Module 3 - Unity Scripting Basics

Module 3 - Unity Scripting Basics

9th - 12th Grade

15 Qs

Excel grade 3

Excel grade 3

4th Grade - University

19 Qs

COMPUTER RELATED SYMBOLS REVIEWER MADE BY ETLIZTE

COMPUTER RELATED SYMBOLS REVIEWER MADE BY ETLIZTE

9th Grade

25 Qs

Design Principles Quiz

Design Principles Quiz

7th Grade - University

20 Qs

Mastering Spreadsheet Essentials

Mastering Spreadsheet Essentials

Assessment

Quiz

Information Technology (IT)

9th Grade

Easy

Created by

S Uwadiae

Used 1+ times

FREE Resource

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()`

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?