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 across selection excel 2016

23/10/2021 Client: muhammad11 Deadline: 2 Day

COMPUTERS EXCEL

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:

Pro Writer
Phd Writer
Instant Assignments
Custom Coursework Service
Smart Tutor
WRITING LAND
Writer Writer Name Offer Chat
Pro Writer

ONLINE

Pro Writer

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.

$47 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$21 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$20 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$44 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

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.

$45 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$15 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

Pte coaching near me - Lab activity air masses and fronts answers - Module 2 Journal Article Analysis - How to set up an amortization schedule - 8.2 double object pronouns answers - Gizmo feel the heat answer key - Legislative worksheet sbar format how a bill becomes a law - Fe oh 2 h2o2 - Ambleside primary look cover write check - 110 plantain road shailer park - PS490 Assignment 8 Research Proposal - Fair pharmacare registration status - Ammonium hydroxide and silver nitrate reaction - What is donum vitae - How to win glo bus camera game - Skill builders occupational therapy - Www talentsmart com eiqb2 welcome - Above all e commerce is a ________ phenomenon - MATH - Persona 3 cursed card - Information Governance - The visible man chuck klosterman summary - 40 mcg to mg - Smyths glasgow fort website - Personal branding assignment - Where did onions come from in the columbian exchange - History exam - Module 03 - Leadership Assessment Paper - T of PN - Www householdresponse com torbay - Scaruffi boards of canada - Coart hair salon cary nc - How to solve corresponding angles - Ethical and legal implications of prescribing drugs for nurse practitioners - Social psychology definition paper psy 400 - Critically appraise a qualitative and quantitative research design. - Sunnyboys icy pole for sale - Electronics - Report - Contact lens instruction sheet - Square root of 36100 - Pico question examples for pressure ulcers - Evidence-base Practice - Technical Writing in Criminal Justice - Professor Question 3 - GLOBAL SOUTH - AUSTRALIA - Nursing assignment - What is a billing indicator in epic - Attic needlework last chance - Dulux natural white powder coat - Biomedical instrumentation projects list - Dulux micaceous iron oxide - Similarities between maslow and erg theory - Student support unit sussex - Is concrete an element compound or mixture - Anne sexton famous poems - Ilearn ucumberlands - Client assessment form template - Cigweld 200 ac dc - Homework for lab 4 batteries bulbs and current - M cotteleer electronics supplies microcomputer circuitry to a company - 13 roles of human service professionals - Punchbowl bus company 944 - Business Intelligence 14 - Vaping REVIEW literature - Ip444 - Brimbank council planning permit - Annotated bibliography - 250 words - Discussion: Treating Childhood Abuse (week 4) - Slla practice test app - Six images of change management - Character evolution essay - Swot analysis diversity workplace - MAC2233 [Business Calculus] - 66 Listed Questions. Choose 50! - Hurricane sandy barometric pressure - Seebeck coefficient of iron - Inspire education training and assessment - Final Assignment: Case Study - The words under god in the pledge of allegiance - Need by tomorrow 5pm central time - Raymond vernon product life cycle theory pdf - Four codes for radiological supervision and interpretation - Morse tool falls assessment - Tactus technology ppt - 3100 kj to calories - What's quag doing gum - Assignment 1 - Cipani and shock chapter 1 - Deep perineal pouch female - Duvall family life cycle - [#2] ARTHROTEC (0835179056 ) Approved Safe Abortion Pills for Sale IN DURBAN Amanzimtoti Kokstad Matatiele Swartberg Umzimkulu pongola secunda limpopo - Mgm4/2 - Performing automatic ide configuration dell optiplex 780 - Nsl xenon task light xtl x hw - Wade davis ted talk endangered cultures - Www footprintnetwork org en index php gfn page personal footprint - Simple regression models case study mystery shoppers - The campground will make the most economic profit when - The Impact of Demographics Changes - Social Media