Information
AI Chat

Excel Lab 1 - Basics

thanks

Course

Computer Aided Design (MEE327)

3 Documents

Students shared 3 documents in this course

University

Karabük Üniversitesi

Academic year: 2016/2017

Uploaded by:

Anonymous Student

This document has been uploaded by a student, just like you, who decided to remain anonymous.

Karabük Üniversitesi

Comments

Please sign in or register to post comments.

Preview text

Excel Lab 1 - Excel Basics

References if Needed

Here is a good website to learn more about Excel if you need extra help with these assignments.

GCFlearnfree lessons 1 – 6 (appropriate sections)

gcflearnfree/excel

Part1 – The Basics

Skills

 Creating a new workbook

 Entering data into a spreadsheet

 Resizing columns to show all contents

 Saving a spreadsheet

 Printing a spreadsheet

Assignment

1. Start Excel to create a new workbook. (Lesson 1:1, 2, 5, 6 from the website above covers this skill

if you need help. For the rest of the lab assignment the corresponding lesson from the website that

will help with that step will be listed in parenthesis. You may use the website if you need to learn

more about a particular skill.) There may be an icon on the desktop for Excel or you can also start

it from the main Start menu icon in the bottom left.

2. Save the workbook file with the name Excel1YourName. (Lesson 5:2) Put the file in your

Documents folder for now. You do not need to type in the file extension. It will use .xlsx by default.

3. Enter the following information in cells A1 – C9. Replace yourname with your first and last name.

Name Genre Number of Songs

J Smith Blues 50

B Doe Country 110

S Spade Country 200

F Zappa Blues 1400

F Zappa Alternative 2300

J Smith Alternative 150

B Doe Blues 75

yourname Blues 800

4. Ensure that all the information is visible within the column boundaries. This will require you to

resize columns. (One way to resize the column is to hover your mouse between the letter column

headers (A and B) until your cursor looks like an arrow pointing left and right, then simply double

click.) (Lesson 2:11,2)

Your spreadsheet will look as follows in Excel.

A B C

1 Name Genre Number of Songs

2 J Smith Blues 50

3 B Doe Country 110

4 S Spade Country 200

5 F Zappa Blues 1400

6 F Zappa Alternative 2300

7 J Smith Alternative 150

8 B Doe Blues 75

9 yourname Blues 800

5. Print the spreadsheet. You will staple it to a second printout after you finish Part 2.(Lesson 8:2)

6. You will continue to use this file for Part 2, so leave it open.

Your spreadsheet should look as follows (no borders will show when it’s printed, this is the default setting

and it can be changed)

Name Genre Number of Songs

J Smith Blues 50

B Doe Country 110

S Spade Country 200

F Zappa Blues 1400

F Zappa Alternative 2300

J Smith Alternative 150

B Doe Blues 75

yourname Blues 800

9. Calculate Total Cost (column F) as column D times Column E. You will type in a formula like this

into cell F2: =D2*E2 (Be sure to begin the formula with an equal sign)(Lesson 6:2, 3, 4, 5)

10. Use the AutoFill (skinny plus sign) again to copy the formula down column F; down to F10. Double

check the picture below to make sure yours has the correct values

11. Add a border to all of the cells (A1-f10) using the Borders tool in the Fonts group on the Home Tab.

(Lesson 4:3)

12. Change the page layout to landscape. (Lesson 8:4) Do this by clicking the Page Layout tab on the

ribbon and then to Orientation to Landscape.

13. Save the file.

14. Click in cell F11 and Use the sum function or the shortcut icon that looks like ∑ to get the total of

the Total Cost column. (Lesson 10:2)

15. Ensure that the data is all visible within the column boundaries. Make the columns wider if needed.

16. Save the workbook.

17. Print out and turn in the two spreadsheets stapled together.

18. Drag a copy of your file to your Student Folder. Leave a Documents window open, then go to

START and type \161.45.160\Bucher1150. Open your class section folder and then open your

folder. Drag your file from the Documents window into your Folder.

Your final spreadsheet should look like the following when printed.

Name Male/Female Genre Number of Songs Unit Price Total Cost

J Smith F Blues 50 $ 0 $ 49.

B Doe M Country 110 $ 0 $ 108.

S Spade F Country 200 $ 0 $ 198.

F Zappa M Blues 1,400 $ 0 $ 1,386.

F Zappa M Alternative 2,300 $ 0 $ 2,277.

S Spade F Blues 1,000 $ 0 $ 990.

J Smith F Alternative 150 $ 0 $ 148.

B Doe M Blues 75 $ 0 $ 74.

yourname M Blues 800 $ 0 $ 792.

$ 6,024.

Was this document helpful?

Excel Lab 1 - Basics

Course: Computer Aided Design (MEE327)

3 Documents

Students shared 3 documents in this course

University: Karabük Üniversitesi

Was this document helpful?

Excel Lab #1 2018

Excel Lab 1 - Excel Basics

References if Needed

Here is a good website to learn more about Excel if you need extra help with these assignments.

GCFlearnfree.org lessons 1 – 6 (appropriate sections)

http://www.gcflearnfree.org/excel2010

Part1 – The Basics

Skills

 Creating a new workbook

 Entering data into a spreadsheet

 Resizing columns to show all contents

 Saving a spreadsheet

 Printing a spreadsheet

Assignment

1. Start Excel to create a new workbook. (Lesson 1:1, 2, 5, 6 from the website above covers this skill

if you need help. For the rest of the lab assignment the corresponding lesson from the website that

will help with that step will be listed in parenthesis. You may use the website if you need to learn

more about a particular skill.) There may be an icon on the desktop for Excel or you can also start

it from the main Start menu icon in the bottom left.

2. Save the workbook file with the name Excel1YourName . (Lesson 5:2) Put the file in your

Documents folder for now. You do not need to type in the file extension. It will use .xlsx by default.

3. Enter the following information in cells A1 – C9. Replace yourname with your first and last name.

Name

Genre

Number of Songs

J Smith

Blues

B Doe

Country

110

S Spade

Country

200

F Zappa

Blues

1400

F Zappa

Alternative

2300

J Smith

Alternative

150

B Doe

Blues

yourname

Blues

800

4. Ensure that all the information is visible within the column boundaries. This will require you to

resize columns. (One way to resize the column is to hover your mouse between the letter column

headers (A and B) until your cursor looks like an arrow pointing left and right, then simply double

click.) (Lesson 2:11,2)

Your spreadsheet will look as follows in Excel.

Excel Lab 1 - Basics

Computer Aided Design (MEE327)

Karabük Üniversitesi

Comments

Students also viewed

Related documents

Preview text

Excel Lab 1 - Excel Basics

References if Needed

Here is a good website to learn more about Excel if you need extra help with these assignments.

GCFlearnfree lessons 1 – 6 (appropriate sections)

gcflearnfree/excel

Part1 – The Basics

Skills

 Creating a new workbook

 Entering data into a spreadsheet

 Resizing columns to show all contents

 Saving a spreadsheet

 Printing a spreadsheet

Assignment

1. Start Excel to create a new workbook. (Lesson 1:1, 2, 5, 6 from the website above covers this skill

if you need help. For the rest of the lab assignment the corresponding lesson from the website that

will help with that step will be listed in parenthesis. You may use the website if you need to learn

more about a particular skill.) There may be an icon on the desktop for Excel or you can also start

it from the main Start menu icon in the bottom left.

2. Save the workbook file with the name Excel1YourName. (Lesson 5:2) Put the file in your

Documents folder for now. You do not need to type in the file extension. It will use .xlsx by default.

3. Enter the following information in cells A1 – C9. Replace yourname with your first and last name.

Name Genre Number of Songs

J Smith Blues 50

B Doe Country 110

S Spade Country 200

F Zappa Blues 1400

F Zappa Alternative 2300

J Smith Alternative 150

B Doe Blues 75

yourname Blues 800

4. Ensure that all the information is visible within the column boundaries. This will require you to

resize columns. (One way to resize the column is to hover your mouse between the letter column

headers (A and B) until your cursor looks like an arrow pointing left and right, then simply double

click.) (Lesson 2:11,2)

Your spreadsheet will look as follows in Excel.

A B C

1 Name Genre Number of Songs

2 J Smith Blues 50

3 B Doe Country 110

4 S Spade Country 200

5 F Zappa Blues 1400

6 F Zappa Alternative 2300

7 J Smith Alternative 150

8 B Doe Blues 75

9 yourname Blues 800

5. Print the spreadsheet. You will staple it to a second printout after you finish Part 2.(Lesson 8:2)

6. You will continue to use this file for Part 2, so leave it open.

Your spreadsheet should look as follows (no borders will show when it’s printed, this is the default setting

and it can be changed)

Name Genre Number of Songs

J Smith Blues 50

B Doe Country 110

S Spade Country 200

F Zappa Blues 1400

F Zappa Alternative 2300

J Smith Alternative 150

B Doe Blues 75

yourname Blues 800

9. Calculate Total Cost (column F) as column D times Column E. You will type in a formula like this

into cell F2: =D2*E2 (Be sure to begin the formula with an equal sign)(Lesson 6:2, 3, 4, 5)

10. Use the AutoFill (skinny plus sign) again to copy the formula down column F; down to F10. Double

check the picture below to make sure yours has the correct values

11. Add a border to all of the cells (A1-f10) using the Borders tool in the Fonts group on the Home Tab.

(Lesson 4:3)

12. Change the page layout to landscape. (Lesson 8:4) Do this by clicking the Page Layout tab on the

ribbon and then to Orientation to Landscape.

13. Save the file.

14. Click in cell F11 and Use the sum function or the shortcut icon that looks like ∑ to get the total of

the Total Cost column. (Lesson 10:2)

15. Ensure that the data is all visible within the column boundaries. Make the columns wider if needed.

16. Save the workbook.

17. Print out and turn in the two spreadsheets stapled together.

18. Drag a copy of your file to your Student Folder. Leave a Documents window open, then go to