ITKokka
Lesson 7 · Note 7

Simple Calculations Using Values

📌 The Short Note

Download

📖 Explanation

Simple Calculations Using Values in a Spreadsheet

Introduction

A spreadsheet can perform mathematical calculations using numbers entered directly into formulas or values stored in worksheet cells. Mathematical operators such as addition, subtraction, multiplication, division and exponentiation are used to carry out these calculations.

This note explains how to perform simple calculations using values, how to create formulas with cell addresses, and how spreadsheet calculations can be applied to everyday problems such as finding the perimeter and area of shapes, calculating prices, and finding the surface area and volume of a cube.

1. Simple Calculations Using Values

A mathematical operator is a symbol that tells spreadsheet software which mathematical operation to perform. Operators can be used with numbers typed directly into a formula.


Operation Operator Purpose Example Result formula


Addition + Adds two or =5+3 8 more values.

Subtraction - Subtracts one =10-4 6 value from
another.

Multiplication * Multiplies =6*4 24 two or more
values.

Division / Divides one =20/5 4 value by
another.

Powers ^ Raises a =2^3 8 (Exponentiation) number to a
power.

Entering a calculation directly

  1. Select the cell where the answer should appear.
  2. Type an equal sign (=).
  3. Enter the numbers and mathematical operator.
  4. Press Enter to calculate the result.

For example, entering =5+3 into a cell displays 8 after pressing Enter.

<ExampleLabel>{=html}Example: Basic calculations</ExampleLabel>{=html}

  • =10-4 gives 6.
  • =6*4 gives 24.
  • =20/5 gives 4.
  • =2^3 gives 8.

Key Idea: A spreadsheet formula begins with an equal sign (=). The operators +, -, *, / and ^ perform addition, subtraction, multiplication, division and powers respectively.

2. Formulas Using Cell Addresses

A cell address (also called a cell reference) identifies the location of a cell in a worksheet. It is formed using a column letter and a row number. For example, A1 refers to the cell in column A and row 1.

Instead of typing numbers directly into a formula, we can use cell addresses to refer to values stored in cells.

Cell Value


A2 5 B2 3

The formula =A2+B2 adds the values in those two cells and displays 8.

Using different operators with cell addresses

Formula Operation Result


=A2+B2 Adds the values in A2 and B2. 8 =A3-B3 Subtracts the value in B3 from A3. 6 =A4*B4 Multiplies the values in A4 and B4. 42 =A5/B5 Divides the value in A5 by B5. 4 =A6^B6 Raises the value in A6 to the power stored in B6. 8

Why use cell addresses?

  • Values can be changed: Update a number in a cell without rewriting the formula.
  • Results update automatically: When a value used by a formula changes, the spreadsheet recalculates the result.
  • Formulas can be reused: Similar formulas can be entered for different rows of data.

<ExampleLabel>{=html}Example: Changing values in a total calculation</ExampleLabel>{=html}

Suppose cell A2 contains 15 and B2 contains 25. Cell C2 contains the formula =A2+B2, so the total is 40. If A2 is changed from 15 to 20, the formula remains =A2+B2, and the displayed result changes automatically to 45.

Key Idea: A formula using cell addresses calculates with the values stored in those cells. When the referenced values change, the calculated result is updated automatically.

3. Practical Spreadsheet Calculations

Spreadsheet formulas can be used to solve practical problems. The following examples show how mathematical formulas can be entered into worksheet cells.

3.1 Perimeter of a Rectangle

The perimeter of a rectangle is the total distance around its boundary.

[ P = 2 \times {=tex}(L + W) ]

Where P is perimeter, L is length and W is width.

<ExampleLabel>{=html}Example: Finding the perimeter of a rectangle</ExampleLabel>{=html}

Suppose the length is 10 and the width is 5.

[ P = 2 \times {=tex}(10 + 5) = 30 ]

If the length is stored in cell A1 and the width in A2, enter:

=2*(A1+A2)

The result is 30.

3.2 Area of a Rectangle

The area of a rectangle is the amount of surface covered by the rectangle.

[ A = L \times {=tex}W ]

Where A is area, L is length and W is width.

<ExampleLabel>{=html}Example: Finding the area of a rectangle</ExampleLabel>{=html}

Suppose the length is 8 and the width is 4.

[ A = 8 \times 4{=tex} = 32 ]

If the length is stored in A1 and the width in A2, enter:

=A1*A2

The result is 32.

Perimeter and Area: The Difference


Perimeter Area


Measures the distance around a Measures the surface covered by a shape. shape.

For a rectangle: 2*(L+W) For a rectangle: L*W

Expressed in units such as cm or m. Expressed in square units such as cm² or m².

3.3 Price Calculations

Spreadsheets are useful for calculating item totals, subtotals, discounts and final prices.

Total price

[ \text{Total Price}{=tex} = \text{Quantity}{=tex} \times {=tex}\text{Price}{=tex} ]

If quantity is in B2 and unit price is in C2, enter:

=B2*C2

For example, 5 pens at Rs. 50 each cost Rs. 250.

Subtotal

The subtotal is the sum of the individual item totals. If the item totals are in cells D2 to D4, enter:

=SUM(D2:D4)

The SUM function adds all the values in the specified cell range.

Discount

To calculate a 10% discount on a subtotal stored in B1, enter:

=B1*0.1

Final price

To subtract the discount in B2 from the subtotal in B1, enter:

=B1-B2

<ExampleLabel>{=html}Example: Calculating a shopping bill</ExampleLabel>{=html}

Item Quantity Unit price (Rs.) Total (Rs.)


Pen 5 50 250 Book 3 120 360 Eraser 10 30 300

Subtotal: =SUM(D2:D4) = Rs. 910

Discount (10%): =B1*0.1 = Rs. 91, if B1 contains the subtotal.

Final price: =B1-B2 = Rs. 819, if B2 contains the discount.

3.4 Surface Area and Volume of a Cube

A cube is a three-dimensional solid with six equal square faces and equal edges. Let s represent the length of one side.

Surface area

The surface area is the total area of all six faces.

[ \text{Surface Area}{=tex} = 6 \times {=tex}s^2 ]

Spreadsheet formula: =6*A1^2

Here, A1 contains the side length.

Volume

Volume is the amount of space occupied by a three-dimensional object.

[ \text{Volume}{=tex} = s^3 ]

Spreadsheet formula: =A1^3

Here, A1 contains the side length.

<ExampleLabel>{=html}Example: A cube with a side length of 5</ExampleLabel>{=html}

Surface area: (6 \times 5{=tex}^2 = 6 \times 25{=tex} = 150) square units.

Volume: (5^3 = 5 \times 5{=tex} \times 5{=tex} = 125) cubic units.

4. Useful Spreadsheet Functions and Formula Features


Feature Purpose Example


Mathematical operator Performs a mathematical =B2*C2 operation.

Cell address Refers to a value A1 stored in a worksheet
cell.

SUM function Adds values in a range =SUM(D2:D4) of cells.

Cell range Refers to a group of D2:D4 cells.

A colon (:) between two cell addresses indicates a range. For example, D2:D4 refers to D2, D3 and D4.

5. Exam-Focused Points

  • A formula can use numbers directly or cell addresses.
  • Spreadsheet formulas begin with an equal sign (=).
  • The multiplication operator is an asterisk (*), not the letter x.
  • The exponentiation operator is a caret (^).
  • Cell addresses consist of a column letter and a row number, such as A1.
  • When a referenced value changes, the formula result is recalculated automatically.
  • The perimeter of a rectangle is 2*(length+width).
  • The area of a rectangle is length*width.
  • Total price is quantity*price.
  • The surface area of a cube is 6*s^2.
  • The volume of a cube is s^3.

Key Idea: Spreadsheet formulas can perform calculations using direct numerical values or cell addresses. Cell references make calculations easier to update because results are recalculated when the referenced values change.

Key Idea: Remember the difference between perimeter and area, and between the surface area and volume of a cube. They measure different properties and use different formulas.

Summary

Simple spreadsheet calculations can be performed by entering numbers and mathematical operators directly into formulas. Cell addresses can also be used to refer to values stored in a worksheet, making formulas easier to update and reuse.

Practical applications include calculating the perimeter and area of rectangles, item prices and discounts, and the surface area and volume of cubes. By choosing the correct mathematical formula and using cell references properly, spreadsheet software can perform these calculations accurately and update results automatically.

Share:
← Mathematical OperatorsSpreadsheet Functions →