Notes, Exercises, Videos, Tests and Things to Remember on Spreadsheet
Please scroll down to get to the study materials.
www.baycongroup.com Fig: Format of Spreadsheet
A spreadsheet is a table value which is arranged in a row and column. Each value can have a predefined relationship to the other values. If one value is changed, other values need to change as well.
A spreadsheet is a computer application program that helps to create and manipulate spreadsheet electronically. In a spreadsheet application, each value sits in a cell. We can define what type of data is in each cell and how different cells depend on one another. Oncw we have defined the cell and the formulas for linking them together, we can enter the data. We can then modify selected values to see how all the other values change accordingly. What-if analysis makes the complex decision-making in a very easy process. MS-Excel is one of the most popular spreadsheet application.
A typical spreadsheet program provides all sorts of tools for arranging data, performing calculations, generating charts and reports. i.e. a spread program is a software tool for entering, calculating, manipulating, and analyzing a set of numbers. The spreadsheet has a wide range of uses from the family business to the corporate earnings statement. Examples of a spreadsheet are excel2007, lotus1-2-3, etc.
Fig: Formate of worksheet
A worksheet or spreadsheet is an electronic sheet. It is a grid of cell made up of vertical columns and horizontal rows that are combined to make a flat sheet-like Accounting Sheet, Banking Sheet, and Mark Sheet etc. A spreadsheet program is also called the accounting program.
The worksheet is a large working area where we can enter, edit data and perform various kinds of calculations. The worksheet can contain text, numbers, data, formula, chart, etc. In MS-Excel 2003, there are 65,536 rows and 256(A-IV) columns in a worksheet. There are 1,048,576 rows and 16,384 columns in a worksheet in MS-Excel 2007. Thus, the number of rows and column differ from package to package.
msofficesupport.blogspot.com Fig: Format of Workbook
An Excel workbook is composed of several pages of worksheets developed by Microsoft. Worksheets are combined together in workbooks to make location and organization of information easier. Sets of data and tables can be used to create a worksheet. Worksheets are important for organizing and finding data; they can be used for work information or personal information. They can be composed of numbers, words or other types of input systems. By default, there are three kinds of worksheets in a workbook.
The intersection between row and column is called cell, in which the data can be stored. Cells are surrounded by a light gray line known as gridlines. A cell can be identified by its own cell address, which is made up of a column heading and row number. The address of the first cell is A1. Only one can be active at a time and is shown by a thick black border, which is called the active cell. A cell can contain 32000 characters.
A cell’s location in the spreadsheet is referred to as its cell reference. To find a cell reference, simply look at the column headings to find which column the cell is in.
The cell reference is a combination of the column letter and row numbers such as A1, B3 or Z345. When writing on the cell reference, the column letter always comes first. Especially, cell reference is very important while writing a formula or addressing the cell to evaluate the values. For example, we want to add values which are at A1 and A2. So, instead of writing this formula in cell C1 = 3 + 2, write this instead, C1= A1+A2.
There are two types of cell reference which are described below:
In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group of cells. Cell references are used in formulas, functions, charts, and other excel commands. By default, a spreadsheet cell reference is relative. This means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function’s new location.
A relative cell reference consists of the column letter and row member that intersect at the cell’s location. An example of a relative cell reference would be C4, G15, or Z2345.
In Excel and another spreadsheet, an absolute cell reference identifies the location of a cell or group of cells. An absolute cell reference consists of the column letter and row number surrounded by dollar signs ($). An example of an absolute cell reference would be $C$4, $G$15, or $A$345.
An easy way to add the dollar signs to a cell reference is to click on a cell reference and then press the F4 key on the keyboard. An absolute cell reference is used when you want a cell reference to stay fixed on a specific cell. This means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function do not change.
Source:www.gcflearnfree.org Fig: Format of Cell Range
It is an area or collection of a number which defines cells into a worksheet e.g. A1:E15.
Source:www.atlaspm.com Fig: Active Cell
When you select a cell by clicking it with the mouse or moving to it using the keyboard, it becomes the active cell. The name Box, on the left of the formula bar, displays the reference of the active cell.
Dilli , S. P., Singh, k. E., Khadka , D., Bhatta, K. D., Baral, N., Saud, R. S., . . . Dangi, R. (2015). Fundamental of Computer Science. Kathmandu: KEC publication and Distribution.
Shrestha,Shrestha & Manandhar, s. (2014). Computer Essential.Kathmandu: Ashmita publication.
Types of Spreedsheet
Basic Fundamental of Spreadsheet