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

How to select cells a3 through f3 in excel

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

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:

Maths Master
Write My Coursework
Engineering Exam Guru
Math Guru
Professional Coursework Help
Coursework Assignment Help
Writer Writer Name Offer Chat
Maths Master

ONLINE

Maths Master

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$18 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

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.

$15 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

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.

$24 Chat With Writer
Math Guru

ONLINE

Math Guru

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$25 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.

$37 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

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

Lesson plan template with differentiation - Blood donation persuasive speech outline - 3 page essay - St maurice's high school - Blank running record sheet - Pkb values of bases table - You are pulling heaven down and raising up a whore - Agile working policy nhs - Papa johns swot analysis 2017 - Organizational culture writing assignment - Monash council abandoned cars - Dalhousie university economics - Resilience worksheets for adults - Rover control r1 java program - Year 11 and 12 at tafe gold coast - Dragon age inquisition ritual puzzle - North richmond community health dental - Hltap301b recognise healthy body systems in a health care context - Chapter 16 international pay systems - Networker command reference guide - Identify learning styles and generational characteristics - New zealand transition altitude - 2018 chemistry exam report - Ai weiwei school bags - Phi 103 week 4 journal - Create a construction project safety plan - Phi 208 ethics and moral reasoning - Discussion: Introductions and Operating System Comparisons - Mixtures can be uniform called - Michael porter generic strategies - Tower hamlets resident permit - HSE 7-2 - Norming forming storming performing pdf - NEED AN A+! Summative Assignment: Critique of Research Article NEED AN A+! - Discussion - Thigns to be grateful for - Luisa muchas presiones este año - Merriespruit tailings dam disaster - Jasper jones charlie's mother - Psychology homework help online free - Seth feye established reliance financial services - Correlation regression and chi square excel worksheet - Article reviews - Restricted earth fault protection theory pdf - Commonwealth coat of arms australia - Spotlight (2015) Movie Analysis - What is a fair test - So3 molecular compound name - Enduraseal premium toilet plunger - Blue badge west sussex - What does panem mean in latin - Two types of overall cost leadership strategy - Deliverable 3 - Classical Physics Compare/Contrast Paper - Encounter by jane yolen - Discussion paragraph - How to find out volume of a cuboid - What does ima stand for in accounting - Criminal law - To be valid, an agreement not to compete must be ancillary to a legitimate bargain. - Global supply chain management v2 simulation answers - Essay on use of mobile phones in campus - Diversity in the Workforce - Game informer subscription number - Firm risk scorecard risk classification system - Dolphin pool cleaner won t start - Laws - Caroma duoflow outlet valve - Essay nursing - Example of an adjectival phrase - Lyrics to circle of life - From pole to pole planet earth worksheet - Blue faced leicester sheep for sale - Children's sense of agency - Huron company produces a commercial cleaning - What are crocs core competencies - Las ruinas de machu picchu están al lado del mar - Strategic Plan - Pof private live stream - The idea of value-based marketing requires firms to charge a price that - Acs code of ethics pdf - Uber eats background check return needs attention - Suresh co. expects its five departments to yield the following income for next year. - LITERATURE - Module 2 Case BHA415 - Discussion - Appraise costing and financial strategies for manufacturing and service companies. - How to prepare naoh standard solution - Time for business workbook answers - 24 hour clock conversion table - Assignment due Sat. 9/26 - One pulse mode stm32 - HR_STR (U1_RPL) - Management by exception is a practice whereby managers focus more closely on ________. - Exploring smart contract deployment - Wk3/dis/reply/lj - Dr seuss wacky wednesday pdf - Cisco cucm license ordering guide - What are darwin's 5 points - Prepare a multiple step income statement wileyplus - Ielts simon com ielts speaking