Scribd
Upload
3 views2 pages

Calculation Using Functions

The document outlines a step-by-step guide for performing calculations using functions in a spreadsheet, including entering student data and calculating totals and averages. It also instructs on finding the highest and lowest marks for each subject and saving the workbook under specific names. The process is divided into two sections, focusing on data entry and formula application.

Uploaded by

deesha.n
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
3 views2 pages

Calculation Using Functions

The document outlines a step-by-step guide for performing calculations using functions in a spreadsheet, including entering student data and calculating totals and averages. It also instructs on finding the highest and lowest marks for each subject and saving the workbook under specific names. The process is divided into two sections, focusing on data entry and formula application.

Uploaded by

deesha.n
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

Calculation using Functions

Section A
1. Enter the following data on a new spreadsheet.

Student Compute
s English Math Science r
Steve 54 58 78 62
Megha 78 63 87 36
Krissy 85 42 41 78
Shaun 88 77 66 88
Kevin 54 74 58 96

2. Calculate the following

Student Total Average


s English Math Science Computer
Steve 54 58 78 62
Megha 78 63 87 36
Krissy 85 42 41 78
Shaun 88 77 66 88
Kevin 54 74 58 96

3. Add your name in cell H8

4. Save the workbook as functions1


Calculation using formula
Section B

1. Open save the workbook as functions1

2. Delete the columns that has “Total and Average”

3. Find highest and lowest marks obtained of each subject. As shown below.

ENGLIS MAT SCIENC COMPUTE


STUDENTS H H E R
STEVE 54 58 78 62
MEGHA 78 63 87 36
KRISSY 85 42 41 78
SHAUN 88 77 66 88
KEVIN 54 74 58 96
HIGHEST
MARKS
LOWEST MARKS

4. Save the workbook as functions2

You might also like