Week 6 Written Assignment

 

Week 6 Written Assignment

Application Exercise 3: Using your Office book’s Excel chapter and learning videos, complete three Excel exercises in the attachment below. Submit one Excel file (in it will be three separate sheets) for grading.

EXCEL Week 6 Assignment EXCEL Week 6 Assignment – Alternative Formats  

Click on the link directly above entitled “Week 6 Written Assignment (Application Exercise 3)” to submit your Week 6 Written Assignments (Application Exercise 3) to receive a grade.  You will submit only 1 workbook with each of the three exercises on separate sheets in the same workbook. You have 3 chances to upload your assignment, return to check the SafeAssign score, make corrections if needed, and press START NEW for the next upload.  When you are satisfied with the last upload, stop submitting.  The last submission will be graded.  When you select START NEW, you will lose access to the previous versions and their SafeAssign scores.  So, copy these if you need them while you are making corrections.

MBA500 Microsoft Excel Assignment Page 1

NOTE: All three of these exercises will be saved in ONE workbook, but on different sheets.
Submit only one workbook for grading.

Beginning Microsoft® Excel: Practice 1
RUBRIC
0 3 5 8 10
Less than 25% of
items completed
correctly.

More than 25%
of items
completed
correctly

More than 50%
of items
completed
correctly

More than 75%
of items
completed
correctly

All items
completed
correctly

Each step to complete is considered a single item, even if it is part of a larger string of steps.

Objectives:
The Learner will be able to:
1. Enter data into spreadsheet cells at least 75% of the time
2. Move between spreadsheet cells
4. Explain the names of cells (A1, B1) at least 75% of the time
5. Format cell text at least 75% of the time
6. Format cell text alignment at least 75% of the time
7. Explain that many commands from Word are the same in Excel

Working with Spreadsheets

Working with data in a Spreadsheet
Open a new Microsoft Excel Spreadsheet
Enter the following information:
Type “January” in Cell A1, press TAB

Type “February” in Cell B1, press TAB
Type “March” in Cell C1, press TAB

Selecting Ranges
Practice using holding your left mouse button to select a range (block) of cells.

Select A1 through C1

Formatting Cells
Format the labels in Cell A1 through C1: Bold
In Cell D1 type: TOTAL
Format the text in Cell D1: Bold, Centered and Blue

Save your practice spreadsheet and name it: ApplicationExercise_YOUR NAME. Name the
first tab of the workbook with this exercise: A1.

You can easily rename a worksheet tab in Excel to whatever helps you remember what you put
on the worksheet. The sheet names that Excel comes up with for the tabs in a workbook (Sheet1,
Sheet2, Sheet3).To rename a worksheet tab, just follow these steps:

Double-click the sheet tab or right-click the sheet tab and then click Rename on its
shortcut menu.
The current name on the sheet tab appears selected.
Replace the current name on the sheet tab by typing the new sheet name.
Press Enter.

MBA500 Microsoft Excel Assignment Page 2

Excel displays the new sheet name on its tab at the bottom of the workbook window. When you
finish all three of these assignments you will have three differently named tabs with each
assignment on a different sheet. All three assignments will be in the one worksheet Excel
document for grading.

Beginning Microsoft® Excel: Practice 2

Objectives:
The Learner will be able to
1. Enter data into Excel at least 75% of the time
2. Select specific data for use in a chart at least 75% of the time
3. Create a chart as a new page at least 75% of the time
4. Apply a name to a chart
5. Include labels in a chart
6. Format fill, background fill, and shape effects on a chart

Click on the SECOND tab (at the bottom) of your worksheet to begin this new exercise.
When you complete all three practice assignments your one workbook will have three
separate sheets of work labeled with different tabs.

Create a Chart

Enter the following data into Excel.
Labels: January, February, March, April, May, June, July, August, September, October,
November, December

Average Temperature:
January was 15°
February was 27°
March was 45°
April was 58°
May was 64°
June was 72°
July was 79°
August was 83°
September was 78°
October was 57°
November was 42°
December was 33°

Total Precipitation
January got 18″
February got 12″
March got 32″
April got 29″
May got 21″
June got 6″
July got 10″
August got 15″
September got 12″
October got 8″
November got 10″
December got 10″

Create Charts from the Data
Chart 1:
Create a Column chart that shows JUST the Average Temperature.
Make sure to include the labels on your chart
Name the chart “Average Temperature”

Chart 2:
Create a Chart that shows the JUST the Total Precipitation.
Make sure to include the labels on your chart
Create the Chart as its OWN page

MBA500 Microsoft Excel Assignment Page 3

Name the chart “Total Precipitation”
Format the chart with the colors, shape effects, and background fill of your choice.

Re-Save your practice spreadsheet. Name the second tab of the workbook with this exercise:
A2.

You can easily rename a worksheet tab in Excel to whatever helps you remember what you put
on the worksheet. The sheet names that Excel comes up with for the tabs in a workbook (Sheet1,
Sheet2, Sheet3).To rename a worksheet tab, just follow these steps:

Double-click the sheet tab or right-click the sheet tab and then click Rename on its
shortcut menu.
The current name on the sheet tab appears selected.
Replace the current name on the sheet tab by typing the new sheet name.
Press Enter.

Excel displays the new sheet name on its tab at the bottom of the workbook window. When you
finish all three of these assignments you will have three differently named tabs with each
assignment on a different sheet. All three assignments will be in the one worksheet Excel
document for grading.

Beginning Microsoft® Excel: Practice 3

Objectives:
The Learner will be able to:
1. Enter labels and data into Excel at least 75% of the time
2. Enter an equation at least 75% of the time
3. Use Autofill (Fill Down) on a formula at least 75% of the time
4. Format text as big, bold, and centered at least 75% of the time
5. Apply Currency formatting to text at least 75% of the time

Click on the THIRD tab (at the bottom) of your worksheet to begin this new exercise. When
you complete all three practice assignments your one workbook will have three separate
sheets of work labeled with different tabs.

Set Up a Checkbook

Enter the Labels

• In Cell A1 type: Check No
• In Cell B1 type: Date
• In Cell C1 type: Description
• In Cell D1 type: Amount
• In Cell E1 type: Deposit
• In Cell F1 type: Balance

Select Row 1 and format the labels big, bold, and centered

MBA500 Microsoft Excel Assignment Page 4

Add the data
Type in six records

Such as:
Opening balance: $500
Office Supplies: 78.50, check number 100
Phone Company: 50, check number 101

Format the columns
Select column D, E, and F and use the Currency tool

Note: the numbers are aligned with two decimal places
Practice: use the toolbar to increase and decrease the decimal places

Set up the Equations
Select Cell F3 and enter the following equation: =F2-D3+E3
Select Cells F3 through F5 and ‘Fill Down’
Test your equations

A B C D E F
1 Check No Date Description Amount Deposit Balance
2 Opening Balance $ 500.00 $ 500.00
3 100 4/7/04 Office Supplies $ 78.50 $ 421.50
4 101 4/7/04 The Phone Store $ 180.98 $ 240.52

Re-Save your practice spreadsheet. Name the third tab of the workbook with this exercise: A3.

You can easily rename a worksheet tab in Excel to whatever helps you remember what you put
on the worksheet. The sheet names that Excel comes up with for the tabs in a workbook (Sheet1,
Sheet2, Sheet3).To rename a worksheet tab, just follow these steps:

Double-click the sheet tab or right-click the sheet tab and then click Rename on its
shortcut menu.
The current name on the sheet tab appears selected.
Replace the current name on the sheet tab by typing the new sheet name.
Press Enter.

Excel displays the new sheet name on its tab at the bottom of the workbook window. When you
finish all three of these assignments you will have three differently named tabs with each
assignment on a different sheet. All three assignments will be in the one worksheet Excel
document for grading.

Working with Spreadsheets
Click on the SECOND tab (at the bottom) of your worksheet to begin this new exercise. When you complete all three practice assignments your one workbook will have three separate sheets of work labeled with different tabs.
Create a Chart
Objectives:
The Learner will be able to:
1. Enter labels and data into Excel at least 75% of the time
2. Enter an equation at least 75% of the time
3. Use Autofill (Fill Down) on a formula at least 75% of the time
4. Format text as big, bold, and centered at least 75% of the time
5. Apply Currency formatting to text at least 75% of the time
Click on the THIRD tab (at the bottom) of your worksheet to begin this new exercise. When you complete all three practice assignments your one workbook will have three separate sheets of work labeled with different tabs.
Set Up a Checkbook
Add the data
Format the columns
Set up the Equations