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

Negligent disclosure of health information - Against school john taylor gatto analysis - Sanyo ductless heat pump - Which of the disks have positive initial angular velocity - Nova 937 mystery voices - Salutation and complimentary close - Mary kay sales tax - Cmit 451 final exam - Southwest airlines case study - Discussion Response - Discussion - The out of control interview case study answers - Types of special occasion speech - Harris teeter cognition lms - Community nursing questions - It planning at modmeters case study - Biointeractive virus explorer answer key - Application of a Shared Theory or Model to Family Nurse Practitioner specialty - How to increase working capital in capsim - Nursing discussion - Hero's journey in the hunger games - What is an example of blank verse - North sydney bus depot - Immigrants in our own land poem - City of sydney dcp - Fair pharmacare registration status - Duct through which the ovum travels to reach the uterus - Social work cover letter - Pvc - Ethics_Discussion - Contaminated groundwater cannot cleanse itself why - Difference between pragmatism and realism - Groenland ctl 175 camping fridge manual - Performance lawn equipment case study solution - Cip to soc crosswalk - North shore private hospital visiting hours - 44 andalusian retreat brigadoon - Silas marner chapter 16 - Linda albert cooperative discipline quotes - Overhead ground wire lightning protection - Parallel and counterflow heat exchanger pdf - Andy warhol death reason - Characteristics of tourism industry - D arabinose to d glucose - Order 2274699: Read Instructions - Occasional care caroline springs - What are the seed leaves that provide energy - Beliefnet love language - 2al 3br2 2albr3 what type of reaction is this - How many corners in a cuboid - How to find the nullity of a matrix - The sun for sorrow will not show his head - Exp 105 personal dimensions of education - Theories and constructs of race rereading america summary - Summary of the tempest by william shakespeare - Molecular weight of zinc gluconate - A comparative balance sheet for shabbona corporation - Apa citation for naadac code of ethics - Personal communication devices and nursing - Beeston castle livestock market - Iron law of responsibility definition - Calculate the following amounts for a nonpar who bills medicare - Have fun teaching letter s song - PERSONAL NARRATIVE - Nsw health code of conduct agreement for students - Block chain discussion - Sam patch the famous jumper essay - Why is it best to have six or less life-cycle phases in an epm system - Number of primes less than 10000 - Module 2 wellness plan flvs answers - Library thinkquest org 19537 - Decontamination - Module 04: Managing Employee Benefits Paper - 1 2 dilution calculator - Who developed the first personal computer called the altair - Slp 3 537 - Discussion Post 4 - Bromide detox symptoms iodine - Go getters high crossword clue - 10 reasons why students should wear uniforms - Balsa wood bridge plans - Discussion - Limiting and excess reactants worksheet answers race car - The Ethics Behind Assessment - Cardinia shire fire restrictions - Dawn house school term dates - Select a transaction that effects the accounting equation as follows - Socratic method of discussion - Citron's id card generator product key - Edu- 548 topic 5 curriculum design - How to make a moving ferris wheel - What is the primary purpose of the joint commission - Weasel claim advertisement - How to calculate total connected load - Film review - Lord we worship you - Medieval punishment for stealing - Big mac index china - Qantas case study textbook - A rose for emily shmoop