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 worksheet horizontally excel 2016

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

COMPUTERS EXCEL

Excel 2016 Chapter 1 Creating and Editing Workbooks

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

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:

WRITING LAND
Professional Coursework Help
Instant Homework Helper
Top Class Results
Top Academic Tutor
Assignments Hut
Writer Writer Name Offer Chat
WRITING LAND

ONLINE

WRITING LAND

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$47 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

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.

$27 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$21 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$25 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

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

$38 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

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.

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

COMS 301 - VT #6 - When the government imposes price floors or price ceilings quizlet - Public health - LDR531 Week 3 Communications Challenges and Strategies - Maytow multi weigh jack - Nvq assessment plan template - Archetype examples in movies - Concert report paper - Q & Q D7 - Under armour turnaround strategy in - Äppelknyckarjazz translation - Low pass filter calculator excel - Climate of the chaparral biome - Whats a catch 22 - What term best describes conditions immediately following the big bang - Discussion with referenes - Sociology of gender - The widow of ephesus full text - Impaired home maintenance nursing care plan - Csi wildlife tracking poachers worksheet answers - 180 willoughby road wamberal - In fusion cloning protocol - Identifying hazards in occupational environments ati - Formic acid and sodium formate equation - Is trevor noah's mom alive - Babyliss paris ipro 235 intense protect - Psychosocial presentation - Convert to conjunctive normal form example - Lab # 5 - How to approve teacher account in homework market - Osaka international peace center - Cow calf operation layout - Business Ethics Assignment 2 Week 4 - Fayol classical management theory - High hurlands care home - Change the course of history - 93 little hobart st welch wv - Dean tennis club booking - Queensland kindergarten learning outcomes - Why did you choose nursing as your major? - Hdm 4 full form - Ann balon stockists australia - There was an old lady who swallowed a fly sequencing - The remote dns server is vulnerable to cache snooping attacks - Duncan and duncan walgett - Wk8-15 - Ethical standards human service professionals - NR632 week 6 SR - Assignment 300 words - Crimelibrary com serial killers - These hands andrew chinn - Williams machine tool company case study - Lviv opera house tour - Royal dick school of veterinary studies - 502- Week 9 - #2 Two Discussion Responses Needed 100 words each 200 words - Physics aqa data sheet - 16 career clusters description - When did bank of america acquired merrill lynch - What is the half life of hydrogen 3 - How to write an introduction for an oral presentation - Capsim (All Rounds) - 27 razorback road flinders - Computercraft password protected computer - Mitel asu ii datasheet - Child psychologist sutherland shire - Ondemand questionmark com home - Project - MC WK1 - Falstaff speech on honor - I need a powerpoint in spanish - Challenger institute of technology rockingham - Faust prologue in heaven - Assessment 1 due in 48 hours - Freedom writers comprehension questions - Using your knowledge exercise 17 answers - Ethical Considerations in research - Myob payables reconciliation out of balance - Motivation-Due in 4 hours - Noredink cheat sheet arranging a sentence in either voice - Week 14 - Selection criteria of engineering materials - Sex lies and conversation by deborah tannen - Person vs supernatural definition - As04 salary south australia - 8109 sloughhouse rd elk grove ca 95624 - Wellness inventories - Discussion Post 2 B - Its enough to make kings and vagabonds meaning - Keith rn case studies - Queen mary 2 fremantle - Cpu scheduling algorithms questions and answers - What is 280 ucas points in btec grades - Anthm - National scan inc sells radio frequency inventory tags monthly sales - We look forward to hearing from you business letter - Wk 9 cip reply 1 - Lock service 3g power opentoken - Jk rowling harvard speech rhetorical analysis - Paper