1,772
5
Essay, 2 pages (400 words)

Introduction to spreadsheets essay sample

Advertising We'll write a high-quality original custom paper on Introduction to spreadsheets essay sample just for you with a 15% discount for the 1st order Use a Discount Use a Discount

Introduction to Spreadsheets Essay Sample

A spreadsheet is an electronic file that contains a grid of columns and rows used to organize related data and perform calculations.

Excel is a spreadsheet program used to create and modify electronic spreadsheets.
An electronic spreadsheet makes data-entry changes easy, and if the formulas are correctly constructed, the results recalculate automatically and accurately.

A worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data.

A workbook is a collection of one or more related worksheets contained within a single file. Each worksheet is identified by a sheet tab. By default, new workbooks have three worksheets.

The whole file is a workbook

Worksheet

Planning Structure of Worksheets
1. State the purpose of the worksheet
2. Decide what input values are needed
An input area is a range of cells containing values

3. Decide what outputs are needed
An output area is a range of cells containing results

4. Assign the worksheet inputs and results
Use rows and columns

5. Enter the labels, values, and formulas
6. Format the numerical values
7. Format the descriptive titles and labels
8. Document the worksheet
9. Save the completed workbook

Exploring the Excel Window
• Worksheet rows lie horizontally
• Worksheet columns lie vertically
• A cell is the intersection of a row and column
• A cell address or cell reference names a cell

Column

Cell

Row

Getting to know excel

http://www.gcflearnfree.org/excel2010/1.2

Go to the above link and watch the video

Row headings appear on the left side and are numbered 1, 2, 3, etc. Column headings appear above the columns and are labeled A, B, C, etc. Sheet tabs display the name of worksheets
The example here is D11

Entering and Editing Cell Data
• Excel supports text, values, dates, and formula results
• Cells are the basic building blocks of a worksheet. Cells can contain a variety of content such as text, formatting attributes, formulas, and functions. To work with cells, you’ll need to know how to select them; insert content; and delete cells and cell content.

Cell Basics

http://www.gcflearnfree.org/excel2010/2

Visit the above link, read the 6 pages.
and do the exercise

Tutorial 2
Modifying Columns, Rows, and Cells

http://www.gcflearnfree.org/excel2010/3.1

Visit the above link, read the 6 pages.
and do the exercise

Tutorial 3

Formatting Cells
http://www.gcflearnfree.org/excel2010/4.1

Visit the above link, read the 6 pages.
and do the exercise

Tutorial 4

Saving
http://www.gcflearnfree.org/excel2010/5

Visit the above link, read the 4 pages
and do the exercise

Creating Simple Formulas
http://www.gcflearnfree.org/excel2010/6.2

Visit the above link, read the 6 pages.
and do the exercise

References
Grauer, R. et al (2013) Exploring Microsoft Office 2010, Volume 1, 2/E, Prentice Hall Goodwill community foundation: http://www.gcflearnfree.org/excel2010

Thanks for voting and helping us improve!
Introduction to spreadsheets essay sample. Page 1
Introduction to spreadsheets essay sample. Page 2
Introduction to spreadsheets essay sample. Page 3

The paper "Introduction to spreadsheets essay sample" was contributed to our database by a real student. You can use this work as a reference for your own writing or as a starting point for your research. You must properly cite any portion of this sample before using it.

If this work is your intellectual property and you no longer would like it to appear in our database, please request its deletion.

Ask for Removal

Create a Citation on Essay

References

PaperPrompt. (2021) 'Introduction to spreadsheets essay sample'. 21 December.

Reference

PaperPrompt. (2021, December 21). Introduction to spreadsheets essay sample. Retrieved from https://paperprompt.com/introduction-to-spreadsheets-essay-sample/

References

PaperPrompt. 2021. "Introduction to spreadsheets essay sample." December 21, 2021. https://paperprompt.com/introduction-to-spreadsheets-essay-sample/.

1. PaperPrompt. "Introduction to spreadsheets essay sample." December 21, 2021. https://paperprompt.com/introduction-to-spreadsheets-essay-sample/.


Bibliography


PaperPrompt. "Introduction to spreadsheets essay sample." December 21, 2021. https://paperprompt.com/introduction-to-spreadsheets-essay-sample/.

Work Cited

"Introduction to spreadsheets essay sample." PaperPrompt, 21 Dec. 2021, paperprompt.com/introduction-to-spreadsheets-essay-sample/.

Get in Touch with Us

Do you have more ideas on how to improve Introduction to spreadsheets essay sample? Please share them with us by writing at the [email protected]