Spreadsheets

What is a spreadsheet? A spreadsheet is a computer program that looks like a big table made of rows and columns. It helps you store, organise and calculate information easily.

Basic parts:

• Cells — each small box in the table where you type information. A cell is identified by a column letter and a row number (for example, A1).
• Columns — vertical groups named with letters (A, B, C…).
• Rows — horizontal groups named with numbers (1, 2, 3…).
• Worksheet — one sheet or page in the spreadsheet program. A file with many sheets is called a workbook.
• Active cell — the cell you are currently typing in (it has a border).

Entering and organising data: Type text (like names) or numbers (like marks or prices) into cells. You can move from one cell to another using the keyboard or mouse. Use different columns for different kinds of information (for example, column A for names, column B for marks).

Using formulas: Formulas start with an equals sign (=). They tell the spreadsheet to do calculations automatically. Instead of typing the answer, type a formula that uses cell addresses (for example, =A2+B2). When the numbers change, the spreadsheet recalculates the answer for you.

Common tasks: adding columns of numbers, finding the average, finding the highest or lowest number, and counting items. Spreadsheets can also create charts (graphs) from your data to show information visually.

Why it helps students: Spreadsheets make it easy to keep marks, budgets, lists, and other school data neat and correct. They save time and reduce mistakes because calculations are automatic.

A spreadsheet is a computer program that helps you store, organise and calculate information in a table made of rows and columns. Each small box is called a cell. Spreadsheet software lets you enter numbers and words, use formulas to do calculations, sort and filter data, and make charts to show information clearly.

Common parts of a spreadsheet:

• Rows (numbered 1, 2, 3...)
• Columns (labelled A, B, C...)
• Cells (for example A1, B2)
• Worksheet (one sheet); workbook (many sheets)

How students can use spreadsheets: enter marks, add up totals, find averages, track pocket money or class attendance. Most spreadsheets also let you format cells (colour, borders), copy formulas quickly, and create charts (bar, pie, line) to show results visually. Many spreadsheet programs are available for free or with the computer: examples include Microsoft Excel, Google Sheets, LibreOffice Calc and Apple Numbers.

Workbook: A workbook is a spreadsheet file that can contain many worksheets (also called sheets). Think of a workbook as a notebook, and each worksheet as one page of that notebook. A workbook is saved as a single file (for example: mybook.xlsx).

Worksheet: A worksheet is one page inside the workbook. It has a grid made of columns (labeled A, B, C...) and rows (numbered 1, 2, 3...). The intersection of a column and a row is a cell. Each cell has an address (cell reference) such as A1, B2, C3. You put text, numbers, or formulas into cells.

Basic parts and actions:

• Rows and columns: Rows are horizontal and numbered; columns are vertical and lettered.
• Cells: A single box like A1. Use cell addresses to refer to values.
• Multiple sheets: You can add, rename, copy, move, or delete sheets (tabs) inside a workbook.
• Entering data: Type text (names), numbers (marks, amounts), or formulas (start with =).
• Saving: The whole workbook (all sheets) is saved together as one file.

How worksheets help: Use separate sheets for different months, subjects, or terms (for example: Sheet1 = Term1 marks, Sheet2 = Term2 marks). You can link cells between sheets so a total sheet pulls together results from each term.

Cell references: Use A1 notation. Example: =A2+B2 adds the values in cells A2 and B2. Ranges use a colon: A1:A5 means cells A1 through A5.

A spreadsheet is like a big sheet of paper made up of many small boxes. Each box is called a cell. Cells are arranged in horizontal lines called rows and vertical lines called columns.

Rows run left to right and are numbered 1, 2, 3, ... along the side. Each row holds cells with the same row number (for example, row 3 has cells A3, B3, C3...).

Columns run top to bottom and are labelled A, B, C, ... (then AA, AB, ... when there are many columns). Each column holds cells with the same column letter (for example, column B has cells B1, B2, B3...).

Cells are the intersections of a row and a column. A cell is identified by its cell reference or address, which is the column letter followed by the row number, for example A1, C4.

Active cell is the cell currently selected (it usually has a thick border). You can type a number, text or a formula into the active cell. A range means a group of cells, written like A1:A5 (cells A1 through A5) or B2:D4 (a block from column B row 2 to column D row 4).

Spreadsheets use rows and columns to organize information so it is easy to read, calculate and make graphs. For example, you can put students' names in column A and their marks in column B, then use formulas to add or average the marks.

Tips for Class 5 students:

• Remember the column letter comes first, then the row number (e.g., D7).
• To add numbers from many cells you give the range to a formula, e.g., =SUM(B2:B6).
• Select a range to create a chart or to copy values at once.

A spreadsheet is made of cells (small boxes). Each cell sits where a column and a row meet. Columns are labelled with letters (A, B, C ...) and rows with numbers (1, 2, 3 ...). A cell address (also called a cell reference) tells you exactly which cell you mean by writing the column letter followed by the row number. For example, B3 means the cell in column B and row 3.

Examples of addresses and ranges:

• Single cell: A1, C5, D10
• Range (many cells): A2:A6 (all cells from A2 down to A6), A2:B4 (rectangle from column A to B and rows 2 to 4)

Using cell addresses in formulas: Always start a formula with an equal sign (=). You can use cell addresses to tell the spreadsheet which numbers to use. For example, if A2 has 40 and B2 has 50, the formula =A2+B2 shows 90.

Relative vs absolute references (simple idea):

• Relative reference (normal): when you copy a formula down or across, cell addresses change automatically (e.g., copying =B2+C2 from row 2 to row 3 becomes =B3+C3).
• Absolute reference (fixed): use the $ sign to keep a cell fixed when copying. Example: $B$2 always points to column B row 2 no matter where you copy the formula.

Common functions use ranges: SUM(A2:A6) adds all numbers in that range; AVERAGE(B2:B6) finds the mean.

Tip: The Name Box (usually above the sheet) shows the address of the active cell. This helps you know which cell you are in.

What is an Active Cell?

An active cell in a spreadsheet is the single cell that is ready to accept input. It is the cell where you can type text, numbers or a formula right away. The active cell is usually shown with a thick border around it and its address (for example, A1, B2) is shown in the name box (top left).

What is a Cell Pointer?

The cell pointer is the indicator that shows where the active cell is. It can mean the thick bordered cell, the blinking insertion point inside the cell when you edit it, or the mouse pointer shape that changes when you move it over cells (a thin white cross for selecting cells, a small black cross for using the fill handle).

How they work together

• When you click any cell with the mouse, that cell becomes the active cell and the cell pointer points to it.
• When you type, the content appears in the active cell and also in the formula/input bar.
• You can move the active cell using arrow keys, mouse clicks, Enter/Tab keys, or the name box.
• If you select a range of cells, one of the cells in the range is the active cell (usually the first clicked or the top-left cell). That is where typing will go unless you edit a different cell.

Editing modes

• Direct typing: select the active cell and start typing — the new value replaces the old value.
• Edit in cell: press F2 (or double-click) to edit the contents inside the cell; the blinking cursor (cell pointer) shows where text will be changed.
• Formula bar: you can also type or edit cell contents in the formula/input bar while a cell is active.

Why it is important

Knowing which cell is active helps you avoid entering data in the wrong place and helps you build correct formulas using the right cell addresses.

What is entering data? Entering data means putting information into the cells of a spreadsheet (like LibreOffice Calc, Microsoft Excel, or Google Sheets). Each box in the spreadsheet is a cell. You click a cell, type your information, and press Enter or Tab to store it.

Types of data you can enter

• Text (labels) – names, headings, subjects (e.g., "Math", "Tom")
• Numbers (values) – marks, quantities, ages (e.g., 45, 120)
• Dates and times – 10/10/2025 or 08:30 AM
• Currency – amounts with a currency symbol (e.g., $50, ₹200)
• Percentages – 25% (often entered as 0.25 and formatted as %)
• Formulas – calculations starting with = (e.g., =A2+B2)

How to enter and change data (simple steps)

1. Click the cell where you want the information.
2. Type the text, number, date or formula.
3. Press Enter to move down or Tab to move right; the value is saved in the cell.
4. To edit, double-click the cell or select it and edit in the formula bar, then press Enter.
5. To delete a cell's contents, select it and press Delete or Backspace.

Useful tools and tips

• AutoFill: Drag the small square at the corner of a selected cell to copy values or continue a series (e.g., days, months, numbers).
• Copy and Paste: Use Ctrl+C and Ctrl+V to duplicate data.
• Formatting: Change alignment, font, number format (date, currency, percent) so data looks correct and is easier to read.
• Undo/Redo: Use Ctrl+Z to undo mistakes and Ctrl+Y to redo.
• Start formulas with = : e.g., =A1+B1, =SUM(B2:B6). The spreadsheet computes results automatically.

Why entering data correctly matters

Correct data entry ensures calculations, charts and reports are accurate. For example, entering a date as text can prevent sorting by date, and entering "5%" as text stops percentage calculations.

Data Types are the different kinds of information you enter into spreadsheet cells. Choosing the correct type makes calculations and charts work correctly.

• Text (Labels) — Words and names used for headings or descriptions. Example: Riya, Maths.
• Number (Values) — Numbers you can calculate with. Example: 45, 120.
• Currency — Numbers with a money symbol. Example: ₹250.00
• Date and Time — Dates or times. Example: 10/04/2025, 09:30 AM.
• Percentage — Numbers shown as a part of 100. Example: 75%.
• Boolean (Logical) — TRUE/FALSE or Yes/No used for simple checks.
• Formula — An expression starting with = that computes a result. Example: =SUM(B2:B6).

How spreadsheets treat them: Text is shown but not used in arithmetic. Numbers, currency, percentages and dates can be used in calculations. Formulas use these types to give results. You can change a cell's format (Number, Date, Currency, Percent) so values display correctly.

Example table:

Using the right data type helps get correct totals, averages and clear charts.

What is a cell? A cell is one box in a spreadsheet, identified by a column letter and row number (for example, A1).

Active cell: The cell with a thick border where data will be entered is called the active cell.

What is a range? A range is a group of cells. Adjacent (continuous) ranges are written with a colon, for example A1:C3 means all cells from A1 to C3.

Why select cells/ranges? You select cells to type or edit data, apply formatting (bold, color), perform calculations (like SUM), copy/paste, sort, or create charts.

How to select:

• Single cell: Click the cell or use arrow keys.
• Adjacent range: Click and drag the mouse over cells, or click the first cell, hold Shift, and click the last cell (e.g., click A1, Shift+click C3).
• Non-adjacent cells or ranges: Hold Ctrl (or Command on Mac) and click each cell or drag each range.
• Whole row or column: Click the row number or column letter. To select multiple rows/columns, click and drag their headers or use Shift+click.
• Entire sheet: Click the top-left corner (above row numbers and left of column letters) or press Ctrl+A.
• Name box / formula bar: You can type a range (like B2:B6) into the name box to select it quickly.

Tips for class 5 students: Always include column labels and row labels when selecting data for charts so the chart uses names correctly. Use small steps: select, check the border, then apply formatting or a formula.

What is a cell? A cell is one box in a spreadsheet identified by a column letter and row number (for example A1). Each cell can hold text, a number, a date, or a formula.

Why editing cells is important — Editing lets you correct mistakes, update values (like marks or prices), change formulas, and keep your data accurate.

Ways to edit a cell

• Overwrite: Click a cell and start typing. Press Enter to accept.
• Edit in the cell: Double-click the cell and change text or numbers directly; press Enter to save or Esc to cancel.
• Edit in the formula bar: Select the cell and change its content in the formula bar above the sheet.
• Use keyboard shortcut: Press F2 (most spreadsheet programs) to edit the active cell.

Other common editing actions

• Delete content: Select cell(s) and press Delete (clears contents but not formatting).
• Clear formats vs contents: Some menus separate “Clear Contents” (removes value/formula) and “Clear Formats” (keeps value but resets look).
• Undo/Redo: Use Undo (Ctrl+Z) if you make a mistake; Redo (Ctrl+Y) to restore.
• Copy, cut and paste: Copy (Ctrl+C), Cut (Ctrl+X) and Paste (Ctrl+V) move or duplicate cell data. Use Paste Special to paste only values or formats.
• Fill handle / Auto-fill: Drag the small square at a cell corner to copy values or continue a series (like dates or numbers).
• Editing formulas: Begin formulas with = (for example =A2+B2). To change a formula, edit it in the cell or formula bar and update cell references or operations.

Tips for students

• Check what you edit: formulas recalculate automatically when referenced cells change.
• If a number isn't working, check for a leading apostrophe (') which makes it text.
• Save your work and use Undo if you remove something by mistake.

What is Formatting Cells?

Formatting cells means changing how the contents of spreadsheet cells look so the sheet is easy to read and understand. Formatting does not change the data itself — it only changes appearance (font, color, alignment, number style, borders, etc.).

Common formatting options

• Font: change font type, size, bold, italic, underline to make text clear (for example, make titles bold).
• Alignment: align text left, center or right; use top/middle/bottom vertically; wrap text so long text appears on multiple lines; change text orientation (rotate).
• Cell size: change column width and row height to fit content.
• Number formats: show numbers as General, Number (set decimal places), Currency, Percentage, or Date so values display correctly.
• Fill color and borders: add background colors and borders to separate sections (for example, highlight header row).
• Merge and Center: join several cells into one (useful for titles).
• Format Painter: copy formatting from one cell and apply it to others.
• Conditional Formatting (simple): automatically change cell color when a condition is true (for example, marks below 40 turn red).

Why formatting matters

Good formatting makes important information stand out, helps compare values quickly, and makes printed sheets neat (for example, a marksheet with headers, borders and percentage format is easier to read).

How to do basic formatting (steps)

1. Select the cell(s).
2. Use the toolbar options: choose font, size, bold/italic/underline, alignment, number format, fill color and borders.
3. For merge: select multiple cells and click Merge & Center to make one title cell.
4. For wrap text: select the cell and click Wrap Text so long sentences fit inside the cell.
5. To change number display: select cell > Number Format > choose Percentage, Currency, or Date.

What they are: A spreadsheet is made of rows (horizontal) and columns (vertical). Column width is how wide a column is so text or numbers fit inside a cell. Row height is how tall a row is so the cell contents can be read comfortably.

How they affect data:

• If column width is too small, text may be cut off or spill into the next cell (overflow) or display as ##### for numbers.
• If row height is too small, wrapped text may be hidden or look crowded.

How to change them (easy steps):

• Drag the boundary: Move the mouse to the line between column letters (e.g., A and B) or between row numbers; click and drag to resize.
• AutoFit (best fit): Double-click the column or row boundary — the spreadsheet adjusts to fit the longest entry or wrapped text.
• Set exact size: Right-click the column/row header and choose "Column Width" or "Row Height" and type a number.
• Wrap text and merge cells: Wrapping makes text use more lines in the same cell; you may need to increase row height. Merging combines cells and may require both width and height changes for good appearance.

Units and defaults (simple notes):

• Column width is often shown as number of standard characters or pixels depending on the spreadsheet program.
• Row height is usually shown in points (pt) or pixels. Common default row height in programs is about 15 points.

Tips for neat sheets:

• Use AutoFit for columns with names or short text.
• Reduce column width for numeric columns to make numbers align better.
• Increase row height for cells with wrapped text so all lines are visible.

Merging cells means joining two or more adjacent spreadsheet cells into one larger cell. This is a formatting action often used to create titles or headers that span several columns or rows. In most spreadsheet programs (Excel, Google Sheets) you select the cells and choose Merge & Center or Merge Cells. When cells are merged, only the value in the top-left cell is kept; other cell contents are discarded.

Splitting cells can mean two different things: (1) Unmerging a merged cell — returns the merged area back to individual cells (the content remains in the top-left cell); (2) Splitting text inside one cell into several cells (for example, separating a full name into first and last name) — this is done with tools like Text to Columns (Excel), the SPLIT function (Google Sheets), or with formulas (LEFT, RIGHT, MID, FIND).

Important points and cautions:

• Merged cells are for presentation (titles, labels). Avoid merging in the middle of a table you plan to sort or run calculations on — merging will break sorting and some formulas.
• Unmerge returns separate cells but keeps the content only in the first cell of the range.
• To distribute or split text across cells, use Text to Columns, SPLIT, or text formulas rather than trying to "split" the single merged cell itself.

Typical steps:

• To merge: select adjacent cells > choose Merge Cells / Merge & Center from the toolbar.
• To unmerge: select the merged cell > choose Unmerge.
• To split text into separate columns: select the cell(s) > Data > Text to Columns (Excel) or use =SPLIT(A1, " ") in Google Sheets.

What are formulas and expressions?

In a spreadsheet, an expression is a combination of values, cell references and operators (like +, -, *, /). A formula is an expression that begins with the equals sign (=) and tells the spreadsheet to calculate a value for a cell. Formulas can use simple arithmetic or built‑in functions (like SUM or AVERAGE).

How to write a formula

• Click a cell where you want the result.
• Type = then the expression or function (for example =A1+B1 or =SUM(A1:A5)).
• Press Enter — the spreadsheet calculates and shows the result.

Key ideas

• Cell references (A1, B2) let formulas use values from other cells. If those values change, the result updates automatically.
• Use ranges like A1:A5 to refer to many cells at once.
• Common operators: + (add), - (subtract), * (multiply), / (divide). Use parentheses to control the order.
• Follow order of operations (BODMAS): Brackets, Orders (powers), Division/Multiplication, Addition/Subtraction.
• Functions are prewritten formulas. Examples: SUM, AVERAGE, MIN, MAX.

Tips for young learners

• Always start formulas with =.
• Double‑click a cell with a formula to see which cells are being used.
• Use autofill (dragging the cell corner) to copy similar formulas to nearby cells.

What is a cell reference? A cell reference tells the spreadsheet where to find data. It uses the column letter and row number (for example A1, B2). When you write a formula you use cell references so the formula uses the values from those cells.

Why use cell references? Using references makes formulas flexible. If the numbers in the referenced cells change, the formula result updates automatically.

Types of cell references

• Relative reference (example: A2) — changes when you copy the formula to another cell. Useful for repeating the same calculation down a column.
• Absolute reference (example: $A$2) — does not change when copied. Use this for values that must stay the same (like a fixed tax rate).
• Mixed reference (examples: $A2 or A$2) — either the column or the row is fixed while the other changes.

Copying formulas

• Write the formula in the first cell (for example C2 = A2 * B2).
• Use the fill handle (small square at the cell corner) to drag the formula down or across. The spreadsheet adjusts relative references automatically.
• You can also copy (Ctrl+C) and paste (Ctrl+V) the cell to other cells.
• If you want some references to stay the same, add $ signs to make them absolute before copying.

Step-by-step example (table)

When you copy the formula from C2 to C3, the relative references A2 and B2 change to A3 and B3 automatically.

When to use absolute reference

If there is a fixed value used in every calculation (for example a discount rate in cell D1 = 0.10), write the formula using $D$1 (example: =A2*B2*(1 - $D$1)). When copied down, $D$1 remains the same.

Tips for young students

• Always check one result after copying to make sure references changed as expected.
• Use SUM to add many cells: =SUM(C2:C6) instead of adding each cell one by one.
• Use clear headings so you know which column is which when writing formulas.

What are functions? In a spreadsheet, a function is a built‑in formula that performs a calculation using the values in cells. Functions save time and avoid mistakes when you add, find averages, or look for the highest or lowest number.

How to use a function: Start by typing an equals sign, the function name, an opening bracket, the cell or range to use, a closing bracket and press Enter. Example: =SUM(A2:A6) adds the numbers in cells A2 to A6.

Common functions for Class 5 students

• SUM – adds numbers in a range (e.g. class fund, shopping list totals).
• AVERAGE – finds the mean of numbers (e.g. average marks of a student).
• MIN – gives the smallest number in a range (e.g. lowest temperature during the week).
• MAX – gives the largest number in a range (e.g. highest score in a test).
• COUNT – counts how many cells in a range contain numbers (e.g. number of students who took a test).
• COUNTA – counts non-empty cells (numbers or text) in a range (e.g. list of students present).
• IF (simple use) – checks a condition and returns one value if true and another if false (e.g. pass/fail).

Tips: Use ranges like A2:A10. You can select cells with the mouse when entering the function. Many spreadsheets have an AutoSum button to quickly insert SUM. Combine ranges with commas: =SUM(A2:A5, C2:C5).

AutoSum is a quick way to add a column or row of numbers. Most spreadsheet programs (like Microsoft Excel or Google Sheets) have an AutoSum button (Σ) that inserts the SUM formula for you. To use it: select the cell where you want the total (usually below a column of numbers), click the AutoSum (Σ) button and press Enter. The program will place a formula such as =SUM(B2:B6) that adds all numbers from B2 to B6.

AutoFill helps you copy cell contents or continue a pattern by dragging the fill handle (the small square at the bottom-right corner of a selected cell). AutoFill can:

• Copy values or formulas to adjacent cells.
• Continue simple sequences (1, 2, 3 ...), days of the week, months, or dates.
• Copy a formula and automatically adjust cell references (this is called relative referencing).

How AutoFill works with formulas: If a cell contains a formula like =B2*2 and you AutoFill it down one row, the next cell will change to =B3*2. The references change so the formula uses the corresponding row or column values. If you want a number or cell reference to stay the same when filling, use an absolute reference with dollar signs, for example $B$2.

Tips for Class 5 students:

• Use AutoSum to quickly find totals for marks, expenses, or scores.
• Use AutoFill to list months or days, or to copy a simple formula across several rows.
• Look for the small square (fill handle) and drag it to fill cells. A small pop-up usually shows what will be filled.

What are rows, columns and cells?
A spreadsheet is made of rows (horizontal), columns (vertical) and cells (the boxes at row–column intersections). Each cell holds data like text, numbers or formulas.

Inserting rows/columns/cells
When you insert a row, the whole row is added and rows below move down. When you insert a column, the whole column is added and columns to the right move right. When you insert a cell you can choose to shift cells right or shift cells down.

Basic steps (works in Microsoft Excel, Google Sheets, LibreOffice Calc): select a row number or column letter or a cell → right-click and choose Insert (or use the Insert option from the menu). You can also use keyboard shortcuts (for Windows Excel: Ctrl and "+" to insert; Ctrl and "-" to delete).

Deleting rows/columns/cells
Deleting removes the selected row/column/cell. Deleted rows cause rows below to move up; deleted columns shift left; deleting a single cell can shift neighboring cells left or up depending on the option chosen.

How formulas and references are affected
• Relative references (like A2) update when rows/columns shift, so formulas usually still point to the intended data.
• Absolute references (like $A$2) lock to a specific cell and do not change when you insert or delete around them.
• Range formulas (SUM(A2:A5)) will expand or shrink if you insert or remove rows/columns inside that range. Charts that use a range will update when the referenced cells change.

Tips for students
• Always select the full row or column if you want to keep table alignment.
• If you only need to add one piece of data, choose Insert Cell and the correct shift direction.
• Undo (Ctrl+Z) reverses mistakes.

What is Sorting? Sorting data in a spreadsheet means arranging rows (records) in a particular order so that the information is easier to read and use. You can sort alphabetically (A–Z or Z–A), numerically (smallest to largest or largest to smallest), or by date (earliest to latest or latest to earliest).

Why sorting is useful:

• Makes it easy to find items (e.g., names or dates).
• Helps compare values (e.g., highest and lowest marks).
• Prepares data for charts and reports.

Types of sorting:

• Alphabetical sort: sorts text (names, items).
• Numerical sort: sorts numbers (marks, prices).
• Date sort: sorts dates (events, birthdays).

How to sort step-by-step (basic method):

1. Select the whole table or the range you want to sort. Make sure the header row is included or note which row has column titles.
2. Use the spreadsheet menu: Data → Sort or the Sort buttons (A→Z or Z→A).
3. Choose the column to sort by (for example, "Marks" or "Name").
4. Choose the order (ascending or descending) and apply the sort.

Sorting with more than one rule (multi-level sort): First sort by the primary column (e.g., Class), then sort by a secondary column (e.g., Marks) to organize within groups. Many spreadsheet programs let you add multiple levels in one Sort dialog.

Things to be careful about:

• Always select the entire table so rows stay together (so a student's name stays with their marks).
• If you have a header row, tell the program to treat it as headers so it won't be moved.
• Undo if the sort was wrong (Edit → Undo or Ctrl+Z).

Charts and graphs are pictures that show numbers in an easy-to-understand way. In spreadsheets, you turn rows and columns of data into visual shapes (bars, lines, slices) so you can compare values quickly and find trends.

Why use charts?

• Make data easier to read and remember.
• Compare groups (which is bigger or smaller).
• See changes over time (increasing or decreasing).

Common chart types and when to use them:

• Column/Bar chart — compare quantities across categories (e.g., marks of students).
• Line chart — show trends over time (e.g., monthly temperatures).
• Pie chart — show parts of a whole (e.g., favourite fruit share).
• Scatter plot — show relation between two number sets (more advanced).

Steps to create a chart in a spreadsheet program (e.g., MS Excel, Google Sheets):

1. Enter your data clearly: put category names in one column and numbers in the next.
2. Select the data range (including headers).
3. Choose Insert → Chart (or Chart icon).
4. Pick the chart type that suits your data.
5. Add a chart title, axis labels (X and Y), and legend if needed.
6. Format colors and labels to make the chart clear (use readable font and contrasting colors).

How to read a chart:

• Look at the title to know what the chart shows.
• Read axis labels and units (e.g., “Number of students”, “Months”).
• Compare heights/lengths of bars or positions of points to find larger or smaller values.
• For pie charts, check percentages or slice sizes to see shares.

Good practices and tips:

• Sort data if you want ascending/descending comparison.
• Use consistent colors; avoid too many slices in pie charts (better for 2–6 parts).
• Always label axes and add a clear title.
• Check that your data range is correct before creating the chart.

What this topic covers
How to save your spreadsheet file so you don’t lose work, how to open a file later, and how to print a worksheet so it looks correct on paper.

Saving a worksheet

1. Give the file a name that explains what it is (for example: Marks_Sept2025).
2. Choose a location (folder) on the computer where you will find it again (for example: Documents > School > Class5).
3. Use File > Save or File > Save As to save the file. Save As lets you change the name, folder, or file type.
4. Common file types: .xlsx (Excel), .ods (LibreOffice/Calc), .csv (comma-separated values for simple tables), .pdf (for sharing/printing so layout stays same).
5. Enable Autosave (if available) or save often (shortcut: Ctrl+S) so you do not lose changes.

Opening a worksheet

1. Start the spreadsheet program and use File > Open, or double-click the file in the folder, or use the Recent Files list.
2. Choose the correct file type if your program asks, then click Open.
3. If a file is from another program, check it after opening to ensure data and formulas look right.

Printing a worksheet

1. Use File > Print or Ctrl+P to open the print dialog.
2. Click Print Preview to see how the sheet will look on paper.
3. Set what to print: Selection (only selected cells), Active Sheet, or Entire Workbook.
4. Adjust page settings: Orientation (Portrait or Landscape), Paper Size, Margins, and Scaling (Fit Sheet on One Page or Adjust to %).
5. Set the Print Area (select cells > Page Layout or File options > Print Area > Set Print Area) to print only a part of the sheet.
6. Add Headers/Footers (for page numbers, file name, date) if needed.
7. Choose number of copies and the correct printer, then click Print.

Tips for students

• Before printing, use Print Preview — it saves paper and time.
• Use Save As > PDF to send homework that will look the same on any computer.
• Keep important spreadsheets in a named folder and back them up (USB, cloud storage).

Practical exercises help students learn how to use a spreadsheet to store data, perform simple calculations and present information visually. A spreadsheet is made of rows and columns. Each box is a cell and has an address (for example A1). You can type numbers or text in cells, use formulas to calculate results and create charts to show data clearly.

Typical steps for a practical exercise:

• Create a clear table with headings in the top row (for example: Name, Math, English, Science).
• Enter data for each row (student names and marks or items and prices).
• Use simple formulas that refer to cells (for example =SUM(B2:D2) to add marks).
• Copy formulas down to other rows using autofill so you don’t have to type the formula again.
• Format cells (bold headings, set number format) to make the sheet readable.
• Create a chart (bar, column, pie or line) from the table to show results visually.

While doing exercises, encourage checking results by looking at a few cells manually, using simple test data, and changing one value to see if the formulas update automatically. Practical tasks at Class 5 level focus on entering data, using +, -, * and /, the SUM and AVERAGE functions, and making basic charts.

What are basic errors? In spreadsheets, errors are messages a cell shows when a formula cannot return a correct result. They help you find problems like wrong data types, missing data or incorrect references.

Common error types and what they mean

• #DIV/0! — a formula tries to divide by zero or by an empty cell.
• #VALUE! — a function has the wrong type of argument (for example text where a number is needed).
• #NAME? — a formula uses an unknown function or a misspelled name (e.g., SUMM instead of SUM), or a named range that doesn't exist.
• #REF! — a formula refers to a cell that was deleted or a reference is invalid.
• #N/A — a lookup (like VLOOKUP) did not find a matching value.
• #NUM! — a formula has an invalid numeric value (for example, impossible calculation or too large a number).

Troubleshooting steps (quick checklist)

• Read the error message to identify the type.
• Click the cell and inspect the formula in the formula bar.
• Check referenced cells: are they blank, deleted, or contain text instead of numbers?
• Fix misspellings in function names and ensure named ranges exist.
• Use protective formulas (IF, IFERROR) to handle expected problems like empty cells or divide-by-zero.
• Use helper functions for diagnosis: ISNUMBER, ISTEXT, ISERROR, ERROR.TYPE, or IFERROR to return friendly messages.

Prevention tips

• Keep consistent data types in columns (e.g., all numbers in a "Marks" column).
• Use data validation to allow only allowed entries (numbers, dates, etc.).
• Use clear named ranges and avoid deleting cells used by formulas.
• Wrap risky calculations with IF or IFERROR so errors show helpful text (for example, "No data").

Short example of friendly handling

If you calculate average but the divisor may be zero, use a protective formula:

=IF(B2=0, "No data", A2/B2)

Or to hide any error and show 0 instead:

=IFERROR(A2/B2, 0)

What is Help?
Help is a built-in tool in spreadsheet programs that gives instructions, examples, and step-by-step guides. If you do not know how to use a function or feature, you can type a question into Help and get an answer quickly.

How to use Help

• Open the Help menu or click the question mark icon.
• Type a word or phrase like SUM, chart, or template into the search box.
• Choose a suggested article or example to read. Many Helps show pictures and simple steps.
• Try the examples inside Help to see how they change the sheet.

What are Templates?
Templates are ready-made spreadsheet files you can use instead of creating a sheet from scratch. They already have headings, formulas, and sometimes charts. You just replace example data with your own.

How to use Templates

• Open your spreadsheet program and pick New or Templates.
• Browse template categories like school, budget, timetable, or marksheet.
• Click a template to open it, then change the text and numbers to match your own information.
• Save the edited file with a new name so the original template stays as it was.

Why Help and Templates are useful for Class 5 students

• Help teaches you how to use functions and tools step-by-step.
• Templates save time and show how a good spreadsheet looks.
• Using both helps you learn faster by example: try a template, then use Help to understand its formulas and charts.