Question
A school maintains students' examination records using spreadsheets. Explain how the following spreadsheet features can be used effectively:
Formulae
Functions
Cell Referencing
Charts
Conditional Formatting Illustrate your answer with a suitable example
Answer :
Word Count : 557
________ ________ ______ _______ ______ ________ _________ __________ _________.
__________ ___ __________ ___ ____.
____ __________ ____ ____ ______ ________ __________ ________ ___ _____ ____ _____.
__________ ______ ________ _______ ______ ____ ____ ________.
______ _______ _______ _________ ____ _____ _______ __________ _____ ___ ___ ____.
_____ ______ ___ _____ _________ ____ ____ ______ _________ __________.
___ __________ ________ ___ ____ __________.
_________ ____ ____ ____ ________ ___ ________ ________ _________ _____.
____ ______ ______ ___ ______ _______ ______ _______ ______.
_____ _________ _____ __________ ______ _____ ______ ________ _________ _________ _______ ___.
__________ _____ ______ ____ _________ ________ ___ ___ ______ _______ ___.
____ ________ _____ ___ _________ ___.
______ _______ _______ ______ ______ ___.
_______ ______ ______ ______ _________ ____ _______.
________ ____ ____ _________ ______ ____ ______ ________ __________ ______ __________ _____.
__________ ___ _________ _________ __________ ____ _____ ___.
___ _____ ___ _________ _______ _______ _______.
________ _____ _________ ____ ____ ________ ______ _______ _______ ___ _____ ______.
______ ______ _________ ____ _________.
________ ____ _____ __________ _______ _______.
___ ___ ___ _______ ________ __________ ___ ____ ________.
____ ________ __________ ______ _____ ____ ____ _____ ____ ____ ____.
__________ ______ _________ _____ ________ ______ __________ _________ _____.
______ _____ ________ ____ ____ ______ _________ _______.
___ __________ _________ ____ ___ _______.
________ ________ ______ _____ ____ ___ ___ _______ _________ _______ _____.
_________ __________ ____ ______ _____ ____ _______ _____ ______ __________ _______ _________.
______ ______ ________ _______ ______ _____ ________ ________ __________ ______.
___ ______ _____ _________ __________ ________ ____ __________ ___.
__________ ___ ____ _____ __________ ______ ___ ________.
_____ _____ ___ _____ ____ ________ ______ ____ ____ _________ _______ _________.
________ __________ ______ _____ ________.
____ _______ ____ _____ __________ ____ ______ ____ _________.
____ ___ __________ ______ ________ _____ ______ _____.
______ _______ ____ ________ _______ _____ _______ _____ ________ ___ ____.
_____ ________ __________ _________ ______ __________ _____ _____ ________ ________ ___.
__________ _______.
Skip in 10
A spreadsheet is a useful computer application for maintaining and analysing students’ examination records in a school. It allows marks, totals, percentages, grades and performance patterns to be calculated quickly and presented clearly. Features such as formulae, functions, cell referencing, charts and conditional formatting make the management of examination data more accurate and efficient. Formulae are expressions used to perform calculations in a spreadsheet. They normally begin with an equal sign (=) and can use numbers, cell addresses and mathematical operators. For example, if a student’s marks in English, Mathematics, Science and Computer are entered in cells B2, C2, D2 and E2, the total marks can be calculated in F2 using the formula `=SUM(B2:E2)`, or by adding the cells directly as `=B2+C2+D2+E2`. The percentage can then be calculated using `=F2/400*100`, assuming the maximum marks are 400. Formulae reduce manual calculations and minimise errors. Functions are predefined formulas provided by spreadsheet software such as Microsoft Excel or LibreOffice Calc. They are particularly useful when examination records contain many students. The SUM function can calculate total marks, while AVERAGE can determine the average marks of a student or class. For example, `=AVERAGE(B2:E2)` calculates the average marks of one student. The MAX and MIN functions can identify the highest and lowest marks in a subject. The COUNT function can count the number of students whose marks
______ ________ ______ _____ ______ ___ _______ ____ __________ _____.________ ________ ______ _______ ______ ________ _________ __________ _________.
__________ ___ __________ ___ ____.
____ __________ ____ ____ ______ ________ __________ ________ ___ _____ ____ _____.
__________ ______ ________ _______ ______ ____ ____ ________.
______ _______ _______ _________ ____ _____ _______ __________ _____ ___ ___ ____.
_____ ______ ___ _____ _________ ____ ____ ______ _________ __________.
___ __________ ________ ___ ____ __________.
_________ ____ ____ ____ ________ ___ ________ ________ _________ _____.
____ ______ ______ ___ ______ _______ ______ _______ ______.
_____ _________ _____ __________ ______ _____ ______ ________ _________ _________ _______ ___.
__________ _____ ______ ____ _________ ________ ___ ___ ______ _______ ___.
____ ________ _____ ___ _________ ___.
______ _______ _______ ______ ______ ___.
_______ ______ ______ ______ _________ ____ _______.
________ ____ ____ _________ ______ ____ ______ ________ __________ ______ __________ _____.
__________ ___ _________ _________ __________ ____ _____ ___.
___ _____ ___ _________ _______ _______ _______.
________ _____ _________ ____ ____ ________ ______ _______ _______ ___ _____ ______.
______ ______ _________ ____ _________.
________ ____ _____ __________ _______ _______.
___ ___ ___ _______ ________ __________ ___ ____ ________.
____ ________ __________ ______ _____ ____ ____ _____ ____ ____ ____.
__________ ______ _________ _____ ________ ______ __________ _________ _____.
______ _____ ________ ____ ____ ______ _________ _______.
___ __________ _________ ____ ___ _______.
________ ________ ______ _____ ____ ___ ___ _______ _________ _______ _____.
_________ __________ ____ ______ _____ ____ _______ _____ ______ __________ _______ _________.
______ ______ ________ _______ ______ _____ ________ ________ __________ ______.
___ ______ _____ _________ __________ ________ ____ __________ ___.
__________ ___ ____ _____ __________ ______ ___ ________.
_____ _____ ___ _____ ____ ________ ______ ____ ____ _________ _______ _________.
________ __________ ______ _____ ________.
____ _______ ____ _____ __________ ____ ______ ____ _________.
____ ___ __________ ______ ________ _____ ______ _____.
______ _______ ____ ________ _______ _____ _______ _____ ________ ___ ____.
_____ ________ __________ _________ ______ __________ _____ _____ ________ ________ ___.
__________ _______.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.