Introduction to spreadsheets

Hello students, welcome to Kwickprep. A class teacher adds marks for forty students on a calculator. One mark changes, and she adds everything again. Is there a better way? Yes, a spreadsheet. Today we learn what it is, what it can do, and its main parts.

Let us begin with the meaning. A spreadsheet is a program that shows a large grid of rows and columns on the screen. Each box of the grid can store numbers, text or dates. It can calculate totals and averages using formulas. Best of all, when you change any value, every answer updates by itself.

The idea is older than computers. Shopkeepers kept paper ledgers, which are account books with ruled rows and columns. The first popular spreadsheet program, VisiCalc, came in nineteen seventy nine. Lotus one two three became very popular in the nineteen eighties. Today we use Microsoft Excel, Google Sheets, and LibreOffice Calc, which is free.

Here are the common spreadsheet programs. Microsoft Excel is paid software, used on computers and on the web. Google Sheets is free and runs in a web browser with a Google account. LibreOffice Calc is free, open source software that you install. Numbers is free on Apple devices. The basic ideas are the same in all of them.

Spreadsheets are used almost everywhere. Schools prepare marks and class results. Shops track stock and daily sales. Offices make salary sheets and bills. At home, families plan a monthly budget. Banks use them for loan and interest tables, like an EMI table.

Now, the main features. Formulas and ready made functions, like SUM and AVERAGE, do the calculations. Automatic recalculation updates answers when data changes. Sorting arranges data in order, and filtering shows only the rows you need. Charts turn numbers into pictures, such as bar charts. Formatting makes a sheet neat, with fonts, borders and colours.

Here is a tiny marks sheet. Riya scored seventy eight in Maths and eighty five in Science. Aman scored sixty four and seventy. In the Total row, the formula equals B two plus B three adds the Maths marks, and shows one hundred forty two. Every formula starts with an equals sign.

Pause and predict. The Maths total is one hundred forty two. Now Aman's Maths mark is corrected from sixty four to seventy four. What does the total show? It shows one hundred fifty two at once, with no retyping, and that is automatic recalculation.

Let us look at the Excel window. The ribbon at the top holds commands in tabs, like Home and Insert. The Name Box, on the left above the grid, shows the address of the selected cell. The formula bar next to it shows what is inside that cell, including any formula. Sheet tabs at the bottom left switch between worksheets. The status bar at the bottom shows quick results like sum, and the zoom slider.

Exams often ask how a spreadsheet differs from a word processor. A word processor is mainly for text, like letters and reports, while a spreadsheet is mainly for numbers and tables. A word processor works in pages, but a spreadsheet works in rows and columns. A word processor calculates very little, while a spreadsheet calculates with formulas. Microsoft Word is a word processor, and Microsoft Excel is a spreadsheet.

Finally, starting and saving. Open Excel and choose Blank workbook to begin. Ctrl+S saves the file, and the first time it asks for a name and a folder. Excel files end with the extension dot xlsx. LibreOffice Calc saves as dot ods by default, and it can also open and save xlsx files.

Let us revise. A spreadsheet is a grid of rows, columns and cells. Formulas start with an equals sign and update by themselves. Spreadsheets are used for marks, bills, budgets and sales. Popular programs are Excel, Google Sheets and LibreOffice Calc. The Name Box shows the cell address, and the formula bar shows its content.