Scribd
Upload
2 views2 pages

Extra Class Test

The document contains two tasks related to spreadsheet functions and formulas. Task 1 requires selecting appropriate functions like MAX, MIN, COUNT, IF, and SUM for various scenarios, while Task 2 involves writing formulas to calculate specific statistics from a given dataset of learners' marks. The tasks aim to assess understanding of spreadsheet operations and data analysis.

Uploaded by

anju.ybis
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views2 pages

Extra Class Test

The document contains two tasks related to spreadsheet functions and formulas. Task 1 requires selecting appropriate functions like MAX, MIN, COUNT, IF, and SUM for various scenarios, while Task 2 involves writing formulas to calculate specific statistics from a given dataset of learners' marks. The tasks aim to assess understanding of spreadsheet operations and data analysis.

Uploaded by

anju.ybis
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Name __________________________ Class____________________ Marks ____________________

Task 1
Choose the most appropriate function to use in each of the following situations and give an
example of how it can be used in a spreadsheet.
MAX( ) MIN( ) COUNT( ) IF( ) SUM( )

Activity Function Example


To choose between two or
more options

To find the largest value from a range of values

To calculate the total of


numeric values

To determine the number of items

To find the smallest value from a range of values

Task 2
Using the spreadsheet below, write down a spreadsheet formula to calculate the following.

A B C D E F

1 Learner_ID First_name Last_name Maths English Geography


2 1234 Fatima Kareem 87 78 55
3 1235 Roman Wright 45 85 65
4 1236 Gita Patil 90 75 98
5 1238 Connie Riley 79 75 85
6 1239 Ali Hassan 80 73 66
7 1240 Tyler Brown 82 72 68
8 1241 Mariana Lee 83 70 75
9 1242 Umair Tanvir 85 69 85
10 1243 Harold Stewart 86 67 75
11 1244 Suresh Joshi 88 66 89
12 1245 Amir Kahn 89 64 95
13 1246 Hee Tan 91 63 99
14 1247 John Brown 92 61 85
The number of learners in the class. ________________________________

The lowest mark in the geography test. _______________________________________

The highest mark in the maths test. ___________________________________

The number of learners who scored more than 80% in the math test.________________________________

Kahoot Quiz /10

Project PPT /5

Written exam /10

Total /25

You might also like