Microsoft Word is primarily for working with words while Microsoft
Excel is primarily used for working with numbers.
Okay, but what is a spreadsheet? From Webopedia,
a spreadsheet is:
A table of
values arranged in rows and columns.
Each value can have a predefined relationship to the other values.
If you change one value, therefore, you may need to change other
values as well.
Spreadsheet applications (sometimes referred to simply as spreadsheets)
are computer
programs
that let you create and manipulate spreadsheets electronically. In a
spreadsheet application,
each value sits in a cell.
You can define what type of data
is in each cell and how different cells depend on one another. The
relationships between cells are called formulas,
and the names
of the cells are called labels.
So, that means that Microsoft Excel is a Spreadsheet application.
Documents in Word are called documents while in Excel they are
known as workbooks. A single sheet in Word is known as a page
while in Excel they are called a worksheet. A worksheet can
contain up to 256 columns and 65,536 rows with up to 32,000 characters
in a single cell therefore a worksheet can extend over multiple
printed pages.
Let's take a look at a Spreadsheet
Diagram to see the basic parts of a spreadsheet. To help
understand these parts, we're going to complete the following
assignment:
-
Open
Microsoft Excel
-
You
will see a blank grid on the screen with columns (labeled by
letters) and rows (labeled by numbers). Label each cell 5 columns
across and 6 rows deep (from cell A1 through cell E6) with it's
cell address. There should be a label in each cell in rows 1-6 and
each cell in columns A-E.
-
Put your Name - Excel Lesson 1 in the
Header of the workbook. For example, John Smith would put John
Smith - Excel Lesson 1 in the header. To do this:
-
Save your workbook as YourName - Excel1. For example, John Smith would
save as John
Smith - Excel1.
Go to Lesson
2