Spreadsheets. Lecture 7 Introduction to Spreadsheets Introduction to MS Excel. Spreadsheets. A spreadsheet is a program that can represent data in column-and-row format and can manipulate and present that data in a number of ways
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Introduction to Spreadsheets
Introduction to MS Excel
Instead of having to type practically the same formula in E2, E3, E4 and E5, you can enter the formula in E2 and copy it to the other three cells. The spreadsheet understands that the copies are relative to the new location (so the logic of the formula is copied, rather than the formula itself). This is known as relative addressing
= H4 + F2 — 2 * E3
= B4 * $B$1 / 100
= B5 * $B$1 / 100 and so on