Microsoft Excel
Chapter 1
Topics to be covered in this chapter include:
·
Looking at some of the basic formatting features of Excel.
·
Distinguishing between Landscape and Portrait page orientation.
·
Creating a spreadsheet.
·
Opening/saving a spreadsheet.
·
Inserting and deleting rows and columns in a spreadsheet.
·
Using the Average function.
·
Using the Autosum function.
Table of Contents:
Individual Projects:
Objective: To get a feel for the basics of Microsoft
Excel.
a)
Open Microsoft Excel.
b)
Enter your name in Column A, Row 1.
c)
Preview
printable area by selecting Print Preview.
d)
Close Print Preview.
e)
Change Page Setup orientation from
Portrait to Landscape.
f)
Notice
difference between Portrait page orientation and Landscape page orientation.
g)
Save as “(Your Name) –
Exc1Proj1Solution”.
Objective: To see how information is entered in Excel.
This
is a survey of people, their ages, and year in college. Please reproduce the information. Save your finished work as “(Your Name) –
Exc1Proj2Solution”.
Objective: To understand how to switch between sheets.
a)
Open Microsoft Excel.
b)
In Column A, Row 1, enter new heading
“Names”.
c)
Rename this sheet (Sheet1) to “ID”.
d)
Click on Sheet2.
e)
In Column A, Row 1, enter new heading
“Pets”.
f)
Rename this
sheet (Sheet2) to “Animals”.
g)
Click on Sheet3.
h)
In Column A, Row 1, enter new heading
“Birthplace”.
i)
Rename this
sheet (Sheet3) to “Country”.
j)
Change the
“ID” worksheet and the “Country” worksheet to Landscape page orientation.
k)
Save as “(Your Name) –
Exc1Proj3Solution”.
Objective: To reinforce the use of headings and
entering information in cells.
a)
Open Microsoft Excel.
b)
Compile a list of your family members,
your relationship with them, i.e. Father, and their ages.
c)
Enter appropriate headings and change
page setup to Landscape orientation.
d)
Save as “(Your Name) –
Exc1Proj4Solution”.
Objective: To work with some basic functions of a
spreadsheet.
a)
Create a spreadsheet of films you have
watched and books you have read within the past six months.
b)
Include appropriate headings, rename the
sheet (Sheet1) tab, choose a font style, and center the text in the columns.
c)
Save as “(Your Name) –
Exc1Proj5Solution”.
Objective: To reproduce given information.
It
is the first day of class. The students
were asked to introduce themselves to each other. This spreadsheet contains the information they gave to each
other. Reproduce this spreadsheet. Save your work as “(Your Name) –
Exc1Proj6Solution”.
Objective: To understand how to set things up in a table format.
Farmers
A, B, C, D, E are very competitive with each other. They constantly boast to each other about the diversity and
quantity of animals each one owns. Here
are the animals that each farmer owns.
Reproduce this information. Save
your work as “(Your Name) – Exc1Proj7Solution”.
Objective: To notice how the average formula
compensates for deleted cells.
a)
Open the file, Exc1Proj8Data, in the Data
folder under the Projects folder.
b)
In Column E, Row 1, enter new heading
“Overall Average”.
c)
Find the average score of the three exams
for each student.
d)
In Column A, Row 9, enter new heading
“Average Score”.
e)
Find the average score among the students
for each exam.
f)
Insert a
row between Row 3 and Row 4.
g)
Add new student, Joseph, in the newly
created row. He has test scores of Test
1 - 95, Test 2 - 98, and Final - 98.
h)
Delete Emmanuel’s information from the
class.
i)
Notice how
the average score for each exam automatically adjusts.
j)
Save as
“(Your Name) – Exc1Proj8Solution”.
Objective: To find the average number of students in a
class.
a)
Create a spreadsheet listing your classes
and the number of students in each class.
b)
What is the total number of students in
all your classes?
c)
What is the average number of students in
a class?
d)
Save as “(Your Name) –
Exc1Proj9Solution”.
Objective: To calculate your GPA.
This exercise demonstrates
how the
Objective: To use the Autosum function to help analyze
data.
a)
Open the file, Exc1Proj11Data, in the
Data folder under the Projects folder.
b)
In Column G, Row 2, enter new heading
“Total Animals”.
c)
Using the AutoSum function, find the
total number of animals that each farmer has.
d)
In Column A, Row 10, enter new heading
“Total”.
e)
Using the AutoSum function, find the
total number of goats, cows, chickens, sheep, and pigs between all the farmers.
f)
Which
farmer has the highest number of total animals on his farm? Put this farmer in bold.
g)
Which type of animal do most farmers own?
Put this animal in bold.
h)
Which farmer has the least number of
total animals on his farm? Put this farmer in italics.
i)
Which type
of animal is least owned by farmers? Put this animal in italics.
j)
Save as
“(Your Name) – Exc1Proj11Solution”.
Objective: To notice how the Autosum function adjusts
automatically to changes made in the spreadsheet.
a)
Open the file, Exc1Proj12Data, in the
Data folder that’s under the Projects folder.
b)
Increase the quantity of goats that each
farmer has by 2. What is the new total
number of goats owned by all farmers?
c)
Decrease the quantity of cows that each
farmer has by 1. What is the new total
number of cows owned by all farmers?
d)
Increase the quantity of chickens that
each farmer has by 3. What is the new
total number of chickens owned by all farmers?
e)
Increase the quantity of sheep that each
farmer has by 5. What is the new total
number of sheep owned by all farmers?
f)
Decrease
the quantity of pigs that each farmer has by 4. What is the new total number of pigs owned by all farmers?
g)
Which farmer has the highest number of
total animals on his farm? Put this farmer in bold.
h)
Which type of animal do most farmers own?
Put this animal in bold.
i)
Which
farmer has the least number of total animals on his farm? Put this farmer in italics.
j)
Which type
of animal is least owned by farmers? Put this animal in italics.
k)
Save as “(Your Name) –
Exc1Proj12Solution”.
Objective: To find the average amount of rainfall over
a period of time.
a)
Research the yearly amount of rainfall
from 1980-1990 in
b)
Record this information in a spreadsheet
with a column for the year and a column for the amount of rainfall.
c)
Find the average rainfall for the decade.
d)
Save as “(Your Name) –
Exc1Proj13Solution”.
Objective: To analyze weather patterns over a 25 year
period.
a)
Research the average temperature per year
between 1950-1975 in
b)
Record this information in a spreadsheet
with a column for the year and a column for the average temperature during that
year.
c)
Find the average temperature for the
25-year period.
d)
Save as “(Your Name) –
Exc1Proj14Solution”.
Objective:
To find the percentage of professors at the NUR with graduate degrees.
a)
Research the professors at the National
University of Rwanda to figure out which have graduate degrees.
b)
Record the names of the professors and
whether they have a graduate degree (1=yes they do have a graduate degree, 0=no
they do not have a graduate degree) in a spreadsheet.
c)
What is the average percentage of
professors with graduate degrees? (Multiply the average by 100 to find the
average percentage of professors with graduate degrees.)
d)
Save as “(Your Name) –
Exc1Proj15Solution”.
Objective: To find out and organize information about
your group members.
a)
Start with a blank worksheet.
b)
In Column A, Row 1, enter new heading
“Names”.
c)
Enter the names of everyone in the group
in Column A under the heading.
d)
In Column B, Row 1, enter new heading
“Age”.
e)
Enter the ages of everyone in the group
in Column B under the heading.
f)
In Column
C, Row 1, enter new heading “Siblings”.
g)
Enter the number of siblings each person
has in the group in Column C under the heading.
h)
In Column D, Row 1, enter new heading
“Height”.
i)
Enter the
height of each person under Column D under the heading.
j)
In Column
A, Row 9, enter new heading “Averages”.
k)
Find the average age for the group (Put
this value in Column B, Row 9).
l)
Find the
average number of siblings for the group (Put this value in Column C, Row 9).
m) Find the average height for the group
(Put this value in Column D, Row 9).
n)
Save as “(Your Name) –
Exc1Proj16Solution”.
Objective: To record expenses for members in the group.
a)
Start with a blank worksheet.
b)
In Column A, Row 1, enter new heading
“Name”.
c)
In Column B, Row 1, enter new heading
“Books”.
d)
In Column C, Row 1, enter new heading
“Food”.
e)
In Column D, Row 1, enter new heading
“Shoes”.
f)
Enter the
names of the group members under Column A.
g)
Under Column B, have group members enter
how much they spent on books this semester.
h)
Under Column C, have group members enter
how much they spent on food in the past 3 days.
i)
Under
Column D, have group members enter how much they spent on their last pair of
shoes.
j)
In Column
E, Row 1, enter new heading “Total Expenses”.
k)
In Column A, Row 9, enter new heading
“Sum”.
l)
In Column
A, Row 10, enter new heading “Average”.
m) Find the total expenses for each group
member.
n)
Find the sum expenses for books, food,
and shoes.
o)
Find the average amount spent on books,
food, and shoes.
p)
Save as “(Your Name) –
Exc1Proj17Solution”.
Objective:
To discover the average number of animals/pets owned by group members.
a)
Create a spreadsheet with the names and
number of animals/pets that each member in your group owns.
b)
What is the total number of animals/pets
owned?
c)
What is the average number of
animals/pets that each group member owns?
d)
What is the average number of each type
of animal/pet owned?
e)
Save as “(Your Name) –
Exc1Proj18Solution”.
Objective:
To find the average number of languages spoken by a random survey of people.
a)
Each group member should ask five people
other than your group members how many languages they can speak.
b)
Record your findings in a spreadsheet
with each group member's name and the names of the five people they asked, as
well as how many
languages each person interviewed can
speak.
c)
What is the average number of languages
spoken?
d)
Save as “(Your Name) –
Exc1Proj19Solution”.
Objective:
To create a daily log of your eating habits.
a)
Each member should record what he/she
eats for the next week.
b)
Create a spreadsheet where each member
logs what he/she ate for the week.
c)
Save as “(Your Name) –
Exc1Proj20Solution”.
