Introduction to Spreadsheets Essay Sample
A spreadsheet is an electronic file that contains a grid of columns and rows used to form related informations and execute computations.
Excel is a spreadsheet plan used to make and modify electronic spreadsheets.
An electronic spreadsheet makes data-entry alterations easy. and if the expressions are right constructed. the consequences recalculate automatically and accurately.
A worksheet is a individual spreadsheet that typically contains descriptive labels. numeral values. expressions. maps. and graphical representations of informations.
A workbook is a aggregation of one or more related worksheets contained within a individual file. Each worksheet is identified by a sheet check. By default. new workbooks have three worksheets.
The whole file is a workbook
Worksheet
Planing Structure of Worksheets
1. State the intent of the worksheet
2. Decide what input values are needed
An input country is a scope of cells incorporating values
3. Decide what end products are needed
An end product country is a scope of cells incorporating consequences
4. Delegate the worksheet inputs and consequences
Use rows and columns
5. Enter the labels. values. and expressions
6. Format the numerical values
7. Format the descriptive rubrics and labels
8. Document the worksheet
9. Salvage the completed workbook
Researching the Excel Window
• Worksheet rows lie horizontally
• Worksheet columns prevarication vertically
• A cell is the intersection of a row and column
• A cell reference or cell mention names a cell
Column
Cell
Row
Geting to cognize excel
hypertext transfer protocol: //www. gcflearnfree. org/excel2010/1. 2
Travel to the above nexus and watch the picture
Row headers appear on the left side and are numbered 1. 2. 3. etc. Column headers appear above the columns and are labeled A. B. C. etc. Sheet tabs display the name of worksheets
The illustration here is D11
Entrance and Editing Cell Data
• Excel supports text. values. day of the months. and formula consequences
• Cells are the basic edifice blocks of a worksheet. Cells can incorporate a assortment of content such as text. arranging properties. expressions. and maps. To work with cells. you’ll need to cognize how to choose them ; insert content ; and cancel cells and cell content.
Cell Basicss
hypertext transfer protocol: //www. gcflearnfree. org/excel2010/2
Visit the above nexus. read the 6 pages.
and make the exercising
Tutorial 2
Modifying Columns. Rows. and Cells
hypertext transfer protocol: //www. gcflearnfree. org/excel2010/3. 1
Visit the above nexus. read the 6 pages.
and make the exercising
Tutorial 3
Formating Cells
hypertext transfer protocol: //www. gcflearnfree. org/excel2010/4. 1
Visit the above nexus. read the 6 pages.
and make the exercising
Tutorial 4
Salvaging
hypertext transfer protocol: //www. gcflearnfree. org/excel2010/5
Visit the above nexus. read the 4 pages
and make the exercising
Making Simple Formulas
hypertext transfer protocol: //www. gcflearnfree. org/excel2010/6. 2
Visit the above nexus. read the 6 pages.
and make the exercising
Mentions
Grauer. R. et Al ( 2013 ) Exploring Microsoft Office 2010. Volume 1. 2/E. Prentice Hall Goodwill community foundation: hypertext transfer protocol: //www. gcflearnfree. org/excel2010