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

Independent project 4 5 excel 2016

29/12/2020 Client: saad24vbs Deadline: 12 Hours

Excel 2016 Chapter 4 Formatting, Organizing, and Getting Data Last Updated: 4/3/18 Page 1


USING MICROSOFT EXCEL 2016 Independent Project 4-5


Independent Project 4-5 Boyd Air is monitoring flight arrival status as well as capacities. Before formatting the data as an Excel table, you will export it as a text file for use in the reservation software. You will filter the data in the table, build a PivotTable, and create a PivotChart. This project has been modified for use in SIMnet.


Skills Covered in This Project • Format data as an Excel table.


• Use a number filter in a table.


• Set conditional formatting with an icon set.


• Filter data by cell icon.


• Create and format a PivotTable.


• Create and format a PivotChart.


This image appears when a project instruction has changed to accommodate an update


to Microsoft Office 365. If the instruction does not match your version of Office, try using the alternate


instruction instead.


1. Open the BoydAir-04 start file.


2. Click the Enable Editing button.


3. 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.


4. Rename the sheet tab Stats.


5. Select cell A4 and format the data as an Excel table using Green, Table Style Medium 21.


Select cell A4 and format the data as an Excel table using Style Medium 21.


6. Copy the Stats sheet to the end and name the copy PM Flights.


7. Select the PM Flights sheet and use a Greater Than filter to display flights with a departure time


after 12:00 PM (Figure 4-102).


8. Select the Stats worksheet, select cells I5:I32, and set conditional formatting to use 3 Stars from


the Icon Sets in the Ratings group.


9. Build a two-level Custom Sort for the Capacity column to sort by icon. Show the solid gold star


at the top, followed by the half-gold star. The silver star will default to the bottom


(Figure 4-103).


Step 1: Download start file


Excel 2016 Chapter 4 Formatting, Organizing, and Getting Data Last Updated: 4/3/18 Page 2


USING MICROSOFT EXCEL 2016 Independent Project 4-5


10. Select the Stats worksheet, select cells A4:I32, and use the Quick Analysis tool to create a


PivotTable to display average of capacity by origin (Figure 4-104).


11. Rename the sheet PivotTable&Chart.


12. Select cell B3 in the PivotTable and use Field Settings to set a Number Format of Percentage


with two decimal places. Edit the Custom Name to display Average Capacity.


13. Add the Passengers field to the PivotTable VALUES area with a sum calculation. Edit the field


settings to display # of Passengers as the custom name. Set the number format to Number with


zero decimals and a thousand’s separator.


Excel 2016 Chapter 4 Formatting, Organizing, and Getting Data Last Updated: 4/3/18 Page 3


USING MICROSOFT EXCEL 2016 Independent Project 4-5


14. Use White, Pivot Style Light 8 for the PivotTable and show banded columns and rows.


Use Pivot Style Light 8 for the PivotTable and show banded columns and rows.


15. Add a 3-D Pie PivotChart to the sheet and position the chart object to start in cell E3. Size the


chart to reach cell N22.


16. Select the legend in the chart and set its font size to 11 from the Home tab.


17. Show Data Labels on the chart positioned at the Inside End. Select a data label and format all


labels from the Home tab as bold and 10 pt. (Figure 4-105).


18. Save and close the workbook.


19. Upload and save your project file.


20. Submit project for grading.


Step 2: Upload & Save


Step 3: Grade my Project


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Best Coursework Help
Homework Guru
University Coursework Help
Helping Hand
Writer Writer Name Offer Chat
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$75 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$77 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$77 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

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

Management reporting for decision making - Latisha experienced menarche when she was 8 years old. she experienced: - Discussion - Urinary system case study answers - Cambridge gcse computing worksheet answers - Traits of visual learners - My wiltshire pension fund - Company Privacy Policy - Operations Security - The story of seabiscuit - Cavarno 2 for sale - Econ 101 offline homework 2 - Manage diversity in the workplace bsbdiv501 - States of matter analogy - The task of crafting a strategy is - **Affordable**@@ Quick & Safe Abortion +27835179056 CLINIC//PILLS Montrose lions river wembley mkondeni Ashdown chesterville - Calibration of volumetric flask lab report - What is an interpretive text - Managerial practices executive summary - Jm barrie net worth - Persuasive speech on health care - R programming - Upload Assignment: Homework 1 - History essay - Romeo and juliet 2014 - What is the specific charge of electron - Psychological Theories of Crime - 1 19 torrington place ucl - Superfun toys case study - Determination of ethanol by gas chromatography - Interpret and apply medical terminology appropriately - Nursing and the aging Family DQ week 1 - Bioline aust pty ltd - How to do trigonometry word problems - What is the south african government providing and to whom - Bass clef note recognition worksheet answers - Listen and indicate whether the questions and responses are lógico or ilógico. - What effect does creativity have on society and culture - Dr peter floros ent - Say no to 0780 - Av200 powerline ethernet adapter - Week 3 discussion - Social Work- Indicators of Suicide - James sheahan catholic high - Unit numbering filing system - 10 strategic operations management decisions on mcdonalds - What does dgl mean on gold - Mechanical engineering projects title - Negotiation skills for nurse leaders - Lf meaning in construction - Maggie carey narrative therapy - Tool to generate sap fiori extension project - Connected mcgraw hill school c3p0 - Why is Cybersecurity Important for University Students? - Hamlet act 5 themes - Information governance - 3874 chapter 1-2 3 assignments - The greek way summary - In crafting a company's strategy managers - Minster medical practice lincoln - Fin 100 week 5 homework - Dulux 72yy 47 743 - Translate the following c code to mips assembly code - Personal Marketting plan - Bank albilad annual report - Sleeve adornment crossword clue - Write 1500 words for this task: - Assume that the ages of first year college students - Lesson 2 BMGT - Proofreading marks handout pdf - Initiating the Project-Problem set 4 - Ordinary annuity and annuity due difference - Margin call movie based on goldman sachs - Elliot brown geography - Two houses connected together - Proposal 2 - Should self driving cars replace human drivers essay - Safe drivers in Dubai - Syringe titrator stopcock - Tamil oral test topics - Downstream processing of penicillin - Multifactor leadership questionnaire rater form mlq rater form - Original sleeping beauty story - Ian freeman vs frank mir full fight - Determination of molecular weight by boiling point elevation - Casestudy - University of phoenix mth 217 - Civil rights movement outline for a paper - Belmore boys high school teachers - Hp z230 sff workstation specs - Prepare a diagram 0 dfd for the new system - NURS6050 - Creswell and creswell research design pdf - Doctor role play script - Can you answer this question ? - Abc classic fm cd of the week - Perfect substitutes production function - Golden flax meal coles - Ibm global technology outlook - Lysis medical term suffix - The power of optimism alan loy mcginnis pdf