Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Center the worksheet horizontally on the page

08/11/2021 Client: muhammad11 Deadline: 2 Day

Excel 2016 Chapter 1 Creating and Editing Workbooks Last Updated: 9/1/16 Page 1

USING MICROSOFT EXCEL 2016 Independent Project 1-4

Independent Project 1 -4 As staff at Blue Lake Sports Company, you are expected to prepare the monthly sales worksheet. You edit and format data, complete calculations, and prepare the workbook for distribution. You also copy the sheet for next month’s data.

Skills Covered in This Project

Open and save a workbook. Choose a workbook theme. Edit and format data. Merge & Center. Use SUM and the Fill Handle.

Adjust column width and row height. Insert a header and a footer. Adjust page layout options. Copy and rename a worksheet.

1. Open the BlueLakeSports-01.xlsx start file. If the workbook opens in Protected View, click the

Enable Editing button so you can modify it.

2. The file will be renamed automatically to include your name. Change the project file name if

directed to do so by your instructor, and save it.

3. Apply the Slice theme to the worksheet.

4. Edit worksheet data.

a. Edit the title in cell A2 to display Monthly Sales by Department. b. Edit cell D6 to 1950.

5. Select cells A1:F2 and click the Alignment

launcher [Home tab]. Click the Horizontal

arrow, choose Center Across Selection,

and click OK.

6. Select and delete row .

7. Use the Fill Handle to complete a series.

a. Select cell B3.

b. Use the Fill Handle to complete the

series to Week 4 in column E.

c. AutoFit the columns to display the

complete label.

8. Use SUM and the Fill Handle to calculate

totals.

a. Use the AutoSum button to build a SUM

function in cell F4.

b. Use the Fill Handle to copy the formula

in cell F4 to cells F5:F16.

c. Delete the contents of cell F17 if you

copied the formula to that cell.

d. Select cells B17:F17 and click the

AutoSum button. The SUM formula is inserted, and a Quick Analysis options button appears

(Figure 1-98).

e. Press to ignore the Quick Analysis options.

9. Format labels and values.

a. Select cells A1:A2 and increase the font size to 18.

b. Increase the row height of rows 1:2 to 24 (32 pixels).

c. Format cells A3:F3 as Bold and increase the row height to 18 (24 pixels).

d. Center the data in cells B3:F3.

e. Format all values with Comma Style and decrease the decimal two times.

Download start file

Excel 2016 Chapter 1 Creating and Editing Workbooks Last Updated: 9/1/16 Page 2

USING MICROSOFT EXCEL 2016 Independent Project 1-4

f. Apply the All Borders format to cells A3:F17.

g. Select cells B17:F17 and apply the Accounting Number Format with no decimal places.

h. AutoFit each column that does not display all data.

10. Finalize the worksheet.

a. Click the Insert tab and click the Header & Footer button.

b. In the right header section, insert the Sheet Name field.

c. Go to the footer and click the right section.

d. Type [your first and last name] (Figure 1-99).

e. Click a cell in the worksheet and return to Normal view.

f. Center the worksheet horizontally on the page.

11. Copy and rename a worksheet.

a. Right-click the January sheet tab and choose Move or Copy.

b. Make a copy of the sheet at the end.

c. Rename the copied sheet February. d. Format the February sheet tab color to Dark Blue, Accent 1.

e. Delete the values in cells B4:E16 and press Ctrl+Home.

f. Return to the January sheet.

12. Preview the January sheet.

13. Save and close the workbook (Figure 1-100).

14. Upload and save your project file.

15. Submit project for grading.

Upload & Save

Grade my Project

Excel 2016 Chapter 1 Creating and Editing Workbooks Last Updated: 9/1/16 Page 3

USING MICROSOFT EXCEL 2016 Independent Project 1-4

1-100 Excel 1-4 completed

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quick N Quality
Assignments Hut
Buy Coursework Help
Professional Coursework Help
Online Assignment Help
Top Grade Tutor
Writer Writer Name Offer Chat
Quick N Quality

ONLINE

Quick N Quality

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$25 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$36 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$15 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$47 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$25 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$44 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

CONVERSATION RECAP - Personality prediction system through cv analysis ppt - The natural edge project - ART - Novated lease luxury car tax limit - Ucas personal statement worksheet - Integrating Sources - When was the merchant of venice written - There's a sea in my bedroom worksheets - Accor strengthening the brand with digital marketing solution - Geometry midterm answers - In ipsg goal 5 is indicating that - Matlab - One solution infinitely many solutions or no solution - Lame v3 99.3 for windows exe - How is energy stored in a plant - Walden university nurs 6541 final exam - How to register a business in saskatchewan - Qnt 561 signature assignment hospital - Portfolio Project: Milestone 1: Project Introduction - Critique of orem's theory - 2 short paras 150 each - Individual proactiv products - Chapter 3 recordkeeping lesson 3.2 preparing a budget sheet answers - An emission fee levied against polluters will tend to - Time varying electric field - The scotsman theatre reviews - Power Point Presentation with small essay attached to reflect presentation - The armadillo poem analysis - East ocean restaurant set menu - Information Systems - Python dissertation - Prestige kitchen cabinet handles - Full adder ic 7483 datasheet - Teletech corporation case study solution - Legacy brut non vintage dan murphy's - Icris csc companies registry - 300 cola street pittsburgh pa - Class 2 Assessment 2,3, and 4 - Louisa may alcott religion - Newton's version of kepler's law - Mission printing arlington tx - Need a report that answers all the questions below which no less than 10 pages of "content" - Leading edge flying club - The proverbs tell us how to live life successfully - Salvadore inc., a local retailer, has provided the following data for the month of september: - Duplicate - Ignore English 2 Page work - Phases of kicking a soccer ball - The awakening chapter 1 - What is the theme of the play trifles - Perie public health - Learning to write by russell baker - WP3 - Business decision making project part 3 powerpoint - COMMUNITY AND NURSING (DUE 24 HOURS) - Inova fairfax human resources contact information - EDU-534 Lesson Plan - Singapore airlines case study solution - Non inverting summing amp - Open channel flow lab report - National core standards definition - Substance abuse act of 1970 - 63 alec avenue mermaid waters - Land registry form djp - Anyone have a course hero account - Parallel axis theorem for i beam - Geberit mapress installation guide - Sylvia plath poem daddy analysis - Why is it important that statistical research follow ethical guidelines - Relational Stages - Assignment - Currys elgin telephone number - Red hill greek church easter - Trinity school leamington spa - Case 43 american greetings excel - Victoria's secret employee training program - Film theory an introduction through the senses pdf - Life of pi chapter 80 summary - Assignment - Is it ever morally obligatory to break a promise - Schott duran glass bottles - Coke and mentos facts - London zoo educational visits - Nye social control theory greg doucette deadlift record - Determine the expected count for each outcome statcrunch - Burning a book poem pdf - Transgenerational family therapy techniques - Strengths Report - Sonance outdoor speaker removal - 2005 levee failures in greater new orleans - 7 1 final project submission presentation to investors assignment - Construction progress meeting minutes template - 1 pages due by 10 hours - Fabrikator mini v2 manual - Wadkin straight line edger - Tertia optica area of the brain - PRETORIA ABORTION CLINIC +27717852514 ABORTION PILLS FOR SALE IN MAMELODI, PRETORIA, ATTERIDGEVILLE, ACADIA, SUNNYSIDE, - 7 segment display multisim - Relaxing music with water sounds meditation deep sleep music 429 - How to draw men's moe characters face & body pdf