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

Sound localization ap psychology - Special consideration for exams - Chebyshev's theorem excel - Planning for change in an organization report - Forbes global 2000 list 2015 pdf - Fahrenheit 451 ending summary - Deliverable 6 - Actionable Insights and Business Problems TABLEAU Presentation and WORD Doc - Identification of Research Topic - Mount baw baw snow cam - Determination of the ka for a weak acid lab - Discussion: Quantitative Research Designs - National association of social workers code of ethics apa citation - Edautils - No soil cultivation crossword - Claim Denial: Sorry-Smokers Must Cough Up Cash - Assignment 2 - Megan A 6 pages need to REVISE A WRITE PAPER (DUE BY 16 HOURS) - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI - Linear circuit design handbook - Nurse drug diversion and nursing leader's responsibilities - "implementation" model & "mental" model - Short answer - What is the significance of daniel felsenfeld literacy narrative - Responsibilities of advanced practice nursing staff - Wagner kyolic aged garlic extract - HRM 300 Week 1-5 Discussions Questions - Deconstructing trails heads: mediated nature - Golf calcutta auction spreadsheet - Nursing - Help with my assignment - Amp lost policy declaration form - Boral silkwood engineered flooring - Www healthknowledge org uk public health textbook - Cassowary plum life cycle - Roach v electoral commissioner - Ideal citizen in a totalitarian government - Renault master wheel nut torque - Amway atmosphere mini ppt - Media ethics issues and cases 9th edition - 1 mole of aluminum - Assignment 2 - Aristotle with a bust of homer analysis - Hydrostatic force on a plane surface experiment - News reflection: Cyber Security, Privacy or Ethics - Japanese and literature hsc - Elizabeth olten - Last chance company offers legal consulting - Product Design Philosophy dicussion question due today!! - 12 bar blues composition project - Diet wellness plus - Formulating Leadership - Setting up a Presentation - Leadership in Healthcare Organization W2 Project - Intel itanium 2 processor - Hno3 is a stronger acid than hno2 - Recognizing Sources of Innovation Opportunity - Aaron h devor becoming members of society - Dulce et decorum est poem questions and answers - Tim hortons management structure - Computer networking basics pdf book - Mcdonald's darling quarter haymarket nsw - Interpersonal process recording sample - Anthropology si edu writteninbone forensic files html - Eng 225 introduction to film - Welding code of practice - Mountain view realty excel assignment - Cert 4 security risk management - Criterion contamination psychology example - Captone project - Lame v3 99.3 for windows exe - Getifydeals scam - Development of vedic architecture - Alternative conceptions about living things - Sweet quiz questions and answers - What is an arrangement in which the supplier maintains title to the inventory until it is used? - Reflection paper on human relations - How much to charge for snow cones - Revalorism - 0.305 as a fraction in simplest form - Flowchart of instruction cycle - Differences between proprietary and contract guard services - Transmission line parameters notes - Sharepoint 2013 variations step by step - Cloud computing - Independent events venn diagram - WEEK 2 DISCUSSION BUSINESS ETHICS - Sacred time in indigenous religions is - Hungarian vizsla club qld - Timegate eurotech employee portal - As of 2013 who is the ceo of mcdonald's - Qca science year 1 - How do you make the distinction between doing a safety plan and a harm reduction plan? - Word memo - Pit and crevice corrosion - Dbmss typically include report generating tools in order to - Richard rodriguez hunger of memory pdf - Sec questions starbucks about revenue recognition policy - Micro mezzo and macro levels - Snagit not recording microphone - Act government land rent scheme - Formal Report