# 2019 Skills Approach – Ch 1 Skill Review 1.2

COURSE NAME COSA_2_F21_T/R

START DATE

08/13/2112:00 AMUS/Pacific

DUE DATE

12/13/2111:59 PMUS/Pacific

END DATE

12/14/2111:59 PMUS/Pacific

## Steps required for project completion

Click the Start File link, then complete the project using the instructions below.

#### Required:

Save your in-progress and completed work by dragging your file onto this section or clicking below.

### 3. Submit

Click the “Grade my file” button to submit and grade attempt 1 of 3.

NOTE: You must upload a file before you can submit it for grading.

## PROJECT SUB-VIEW:

Instructions

Previous Attempts

Best Practices

### Project Instructions

In this project you will create a new workbook to track the cost of books for your college classes. For each book, you will enter the purchase price, the potential sell-back price, and the cost difference. You will calculate totals using AutoSum. You will then create a new workbook from a template, and practice changing the zoom level and arranging the workbooks.

Skills needed to complete this project:

• Entering and Editing Text and Numbers in Cells (Skill 1.4)
• Navigating a Workbook (Skill 1.2)
• Inserting Data Using AutoFill (Skill 1.7)
• Applying Number Formats (Skill 1.5)
• Using the Status Bar (Skill 1.15)
• Using AutoSum to Insert a SUM Function (Skill 1.13)
• Entering Simple Formulas (Skill 1.10)
• Using the Recommended Charts Feature (Skill 1.9)
• Exploring Charts (Skill 1.8)
• Creating a New Workbook Using a Template (Skill 1.17)
• Checking Spelling (Skill 1.19)
• Arranging Workbooks (Skill 1.18)
• Changing the Zoom Level (Skill 1.16)

1. Enter data in the worksheet as follows:
 A B C D 3 Book Cost Value Difference 4 Book1 85 45 5 Book2 100 80 6 Book3 250 125 7 Book4 80.95 24.25
3. Book 5 cost \$125.00 and can be sold for \$75.00. Book 6 cost \$175.00 and can be sold for \$100.00. Add these data to the worksheet.
4. Modify the status bar to display the minimum value.
5. Use the status bar to check the total value of the books and the minimum value.
6. Use AutoSum to calculate total cost and total value. The totals should be placed in cells B10 and C10.
7. Change the number format for the cost and value numbers to the Accounting Number Format.
8. Enter a formula in cell D4 to calculate the difference between the cost and the value for Book1. The formula will use only relative references because in the next step, you will use AutoFill to copy the formula down the column.
9. Use AutoFill to copy the formula to calculate the difference for books 2 through 6 and the total.
10. Use the Quick Analysis tool to insert a pie chart representing the cost of books.
11. Change the chart title.
12. Create a new file from a template called Personal Monthly Budget. NOTE: If you are unable to find the Personal Monthly Budget template or are unable to complete this step due to your school’s computer lab restrictions, download the template from the Resources link. Open the template and move on to step 18.
1. Open a new file based on the Personal Monthly Budget template. (This step may require an active Internet connection.)
13. The workbook based on the Personal Monthly Budget template opens. This is a complex workbook using many advanced techniques. The good news is that you don’t have to understand how this workbook was created in order to use it.
14. You should still have two workbooks open: the textbooks workbook from the beginning of the project and the Personal Monthly Budget workbook based on the template. Arrange the workbooks so you can see both at the same time.
15. The Personal Monthly Budget workbook should be active. If not, click the title bar for that window. Review the Personal Monthly Budget sheet and change the zoom level to 50% so you can see more of the data at once.

## "Get a Free Quote/Consultation for a Similar Assignment"

#### Proficient Writer Editorial Team

Proficient Writer is a team of professionals that offer academic help. We write fresh, unique, and premium quality academic papers. Our professional academic experts write for a wide range of subjects. Do you need help with your essay or any academic work? Please chat with us or send us an email (support@proficientwriter.com)