We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Introduction to Spreadsheets Essay Sample

essay
The whole doc is available only for registered users OPEN DOC

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

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

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

Microsoft and Google Companies

In business, there are the measurements of the firm degree in which the even extension, and the vertical extension, are pertinent. The Horizontal extension is the scope of an item and administration portions that are given by a business inside its central market. In this association, there is the even merger and in addition, the procurement methodologies which are utilized by the element. Live Nation...

Analyse Software Solutions

In order to make my database I am going to use Microsoft Access. Other possible systems I could have used are programmes such as Microsoft Excel and also a simple manual system where all the data is hand-written. I chose Microsoft Access, as this is more efficient and more professional as a whole. If I used a manual system I could have improved my problems...

ICT and an Adult in Employment

How my father uses it At work my father will use Microsoft access for many reasons. He may use it for registers to make sure everyone has turned up for work and to contact people if they are away so he can have profiles on each person in the company e.g. Date of birth, illnesses telephone number and email address. He could also use it...

Inside Pages: Using MS Publisher

Version 1 Front and Back page First I inserted a line; this indicates to me that it is splitting the front page and back page. This was then followed up by a textbox on the back page for the surgery times, emergencies and contact number. The last thing I did on the back page was inserting the logo, address, telephone number and surgery name these...

Management Improving

1.Identify three areas where IT could be applied to improve management of Ellington Galleries. a.Supplies Chain Management- ordering, pricing, shipping b.Customers Resource Management – orders, personal information, c.Accounting Information System - billing, invoices, stock, customers, employees 2.Explain how each solution would benefit the Galleries, specifically addressing how it could improve business intelligence (BI) and decision-making and/or overall management of the business . a.SCM would offer...

Get Access To The Full Essay
icon
300+
Materials Daily
icon
100,000+ Subjects
2000+ Topics
icon
Free Plagiarism
Checker
icon
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.

Your Answer Is Very Helpful For Us
Thank You A Lot!

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?