Unit 4 Competency 2 - Discover the purposes of spreadsheet applications.

Suggested Objective a:  Define basic terminology relating to a spreadsheet program

 
Data Model Template - Excel spreadsheet

Excel is a spreadsheet application in the Microsoft Office Suite.  You can use it to manipulate data, especially numerical, into an organized manner for data analysis and planning.  This analysis and planning can be done for home or an office.  Let's take some time to look at tutorials from GCF Learn Free for how to use Excel 2010.  As you view each of the tutorials, take notes as necessary on important concepts.  Many of the key terms for Excel were presented on the Excel glossary page at the beginning of this module.  The first tutorials are written and picture.  The last tutorials are videos from GCF Learn Free that are posted on YouTube.  Once you have viewed all information, you will take a quiz  Links to an external site.from the GCF Learn Free website.

 

What Is a Spreadsheet? Links to an external site.

 

Suggested Objective b:  Identify parts of the spreadsheet window

 

Spreadsheet email

Some people wonder what a spreadhseet is and what is the purpose for using a spreadsheet.  A spreadsheet is program that is useful for storing, manipulating, and presenting data - especially numerical.  It is presented in a row and column format.  Where the row and column meet, this meeting creates a cell.  A cell holds data (written or numerical).  Using the spreadsheet can aid a person with analyzing performance or planning for the future.  Look at What Is the Purpose of Using a Spreadsheet? Links to an external site. from Small Business.   Links to an external site.

Ask.com Links to an external site. describes the purpose of a spreadsheet as a program that "displays text and numbers in a table, making the relationships among information easy to understand."  This site further relates how a spreadsheet is easily used in mathematics.  Take a look at this short article  Links to an external site.for an introduction to spreadsheets.

View the two introductory spreadsheet PowerPoints.  Click the links below.

Download Introduction to Spreadsheets (1).ppt

Download Intro to SS PPT.ppt

Let's watch a couple of videos that can help you better understand what a spreadsheet is and can do. These videos do not necessarily refer to Excel, the program we will use in this course.

What Is a Spreadsheet and What Does It Do? Links to an external site.

 How to Use Excel for Spreadsheets - Lesson 1 The Excel Window Links to an external site.

Slide1.GIF