Stat functions: SUM() MCQs Quiz | Class 9
This quiz is for Class 9 students studying Computer Applications (Code 165), Unit 3: Office Tools (Spreadsheets). It covers the topic of statistical functions, specifically focusing on adding values across a range using the SUM() function. Test your knowledge, submit your answers, and download the PDF answer sheet at the end.
Understanding the SUM() Function in Spreadsheets
The SUM() function is one of the most fundamental and widely used functions in any spreadsheet application like Microsoft Excel, Google Sheets, or LibreOffice Calc. Its primary purpose is to add numerical values together. This can include numbers in individual cells, a range of cells, or a combination of both.
Key Concepts of SUM()
Understanding the syntax and application of SUM() is crucial for performing calculations efficiently.
- Syntax: The basic syntax is
=SUM(number1, [number2], ...). You must always start a formula with an equals sign (=). - Adding a Range: To add all numbers in a continuous block of cells (a range), you use a colon (:). For example,
=SUM(A1:A10)adds all the numbers in cells A1 through A10. - Adding Individual Cells: To add numbers from non-adjacent cells, you separate them with commas. For example,
=SUM(A1, B5, C3)adds the values from only those three specific cells. - Combining Ranges and Cells: You can mix and match ranges and individual cells, like
=SUM(A1:A5, C1, D1:D5). - Handling Non-Numeric Data: The SUM() function is smart enough to ignore text and blank cells within a range. If a cell in the range
A1:A10contains the word “Hello”, SUM() will simply skip it and add the remaining numbers.
Using AutoSum
Most spreadsheet programs have an “AutoSum” feature, often represented by the Greek letter Sigma (Σ). This is a shortcut to quickly insert a SUM() formula. If you select a cell below a column of numbers and click AutoSum, it will automatically create a formula like =SUM(C2:C10) to add the numbers directly above it.
Common Examples of SUM()
Here is a small table illustrating how the SUM() function works with a sample dataset.
| Formula | Description | Result (based on data A1=10, A2=20, B1=5) |
|---|---|---|
=SUM(A1:A2) |
Adds values in the range from A1 to A2. | 30 |
=SUM(A1, B1) |
Adds values from individual cells A1 and B1. | 15 |
=SUM(A1:A2, B1) |
Adds values from the range A1:A2 and cell B1. | 35 |
=SUM(A:A) |
Adds all numerical values in the entire column A. | 30 |
Quick Revision Points
- Always start a formula with an equals sign (
=). SUMis the function name.- Parentheses
()contain the arguments (the cells or numbers to be added). - A colon (
:) denotes a continuous range of cells. - A comma (
,) separates individual cells or ranges. - The SUM function ignores text and empty cells, preventing errors.
Practice Questions
- Write a formula to calculate the total of values in cells B2, B3, B4, B5, and B6.
- How would you write a formula to add the value in cell C1 to the total of the range D1 through D10?
- What would the formula
=SUM(F1:F5)calculate if F1=5, F2=”Test”, F3=10, and F4 is empty? - Describe the difference between the formulas
=SUM(A1:C1)and=SUM(A1, C1). - If you want to sum the first 100 cells in column E, what is the most efficient formula to use?
