Feb 12: UNIT: Spreadsheets and Databases

Lesson 1: Exercise 1
Page 205

Questions
a) How are rows labelled?
The rows are labelled numerically

b) How are columns labelled?
The columns are labelled alphabetically.

c) How are cells labelled?
The cells are labelled as alphanumeric coordinates.
e.g. A6, F13, G28

Vocabulary
Spreadsheet/Worksheet            Row
Column                                          Cell Address
Cell                                                 Go To
Cell Cursor                                    Scrolling
Status Area                                   Cell Coordinate
Active Cell                                     Home
Name Box
Lesson 1:Exercise 2
Page 207

   Bit-Byte Computer Company – Invoice

INVOICE

Vocabulary
Label                                   Cell Erase
Alphabetical Label            Cut vs. Clear a Cell
Numeric Label                   Invoice
Strikeover                          Unit
Save                                    Wrap Text

Lesson 1: Exercise 5
Page 210

INCOME

Vocabulary
Income Statement           Profit
Fixed Expense                  Variable Expense
Gross Profit                       Net Income
Merchandise                     Gridlines
Column/Row Headings

Lesson 1: Exercise 6
Page 211

FIXIT

Lesson 1: Exercise 8
Page 213

TRAFFIC

Questions
a)  How is text displayed by default (how is the text justified – ie right justified, left justified, center justified)?
Text is left justified by default.

b)  How are values displayed by default (how are they justified)?
Values are right justified by default but they can be entered as numeric labels by adding an apostrophe(ie ‘456-22) and it will be left justified and shown without the apostrophe.

c)  Is there a way to change the justification from the default and how is it accomplished – for example can you change text so it has center justification?
As mentioned above an apostrophe can be used to change a value to a label and the Alignment section of the tool bar allows you to left right and center justify, as well as top and bottom and wrap text in the same section of the tool bar.

*All spreadsheets are saved to H: Drive.

****

Feb 12

1)  Create a Unit 2 folder – unit2spreadsheets on H: Drive to store the files from all exercises in this unit

Start Microsoft Excel   (part of Office 2010)

Get a textbook:   Computer Applications for Business – back shelf of classroom

2) Read Lesson 1 Exercise 1 on page 205 and the top of page 206 to get a look at the areas of a Microsoft Excel window

Answer the following questions in your notebook:

a) How are rows labelled?

b) How are columns labelled?

c) How are cells labelled?

3)  Try: Exercise 2 page 207, Exercise 5 page 210, Exercise 6 page 211 and Exercise 8 page 213

These exercises demonstrate simple data entry of values (numerics) and text.  Notice the default formatting difference between values and text and answer the following questions in your notebook:

a)  How is text displayed by default (how is the text justified – ie right justified, left justified, center justified)?

b)  How are values displayed by default (how are they justified)?

c)  Is there a way to change the justification from the default and how is it accomplished – for example can you change text so it has center justification?

(if finished start on work outlined for next class)

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s