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

Fireball technology company excel

25/12/2020 Client: saad24vbs Deadline: 10 Days

Exploring Microsoft Office Excel 2013

Application Prepared Exam

Fireball Technology Company


Fireball Technology Company is a small startup company that performs accounting, computing, and financial work for nonprofit organizations. Your job was to create a spreadsheet that would keep track of salary expenditures including benefits. You need to complete the spreadsheet using lookup functions for the benefits. Fireball Technology pays a percentage of the employee’s salary into a pension fund and toward health insurance based upon the benefit code of the employee. The company also makes a monetary contribution for any employee using daycare based on the same benefit code. You will also need to create charts for management, and format the spreadsheet for easier understanding.


a. Open the e01_cumexam_data workbook and save the workbook as e01_cumexam_LastFirst. Make the Benefits sheet active.


b. Assign the range name benefits to the data for benefits. Make Employee Data the active sheet.


c. Insert a function in cell E5 to display the pension cost for the first employee, based on the Benefits Code.


d. Insert a function in cell F5 to display the insurance cost for the first employee, based on the Benefits Code.


e. Insert a function in cell G5 to display the daycare cost for the first employee, based on the Benefits Code.


f. Insert a function in cell H5 to calculate Total Employee Cost for the first customer. If the customer needs daycare, the total cost should include that column amount. If the customer does not need daycare the total cost should not include that column amount.


g. Copy the four formulas down their respective columns.


h. Merge and center the title on the first row over all data columns on the Employee Data sheet. Apply italic and 20 pt font size. Apply Orange, Accent 6, Darker 25% font color.


i. Merge and center the subtitle on the second row over the data columns. Apply italic and 16 pt font size. Apply Orange, Accent 6, Darker 25% font color.


j. Wrap text in the range A4:H4. Set the column widths for these columns to 11.


k. Apply Currency number format to the monetary values in columns D, E, F, G, and H.


l. Hide the Benefits Code column.


m. Freeze the panes so that the row of column labels does not scroll offscreen.


n. Apply the Green Fill with Dark Green Text conditional formatting to values in the Total Employee Cost column when the values are below average.


o. Insert a function to calculate the total employees in cell E49, the average total employee cost in cell E51 and the median total employee cost in cell E53.


p. Insert a function to calculate the lowest total employee cost in cell E50 and the highest total employee cost in cell E52.


q. Insert a function in cell E54 to display today’s date.


r. Copy the Employee data sheet and place to the right of the current sheet. Rename the sheet Filtered Data and remove the conditional formatting rule.


s. Convert the data range to a table, apply the Table Style Medium 18, and unhide the Benefits sheet.


t. Sort the table by Benefit Code, from smallest to largest, and then by Total Employee Cost, from largest to smallest.


u. Apply a filter to display Benefit Code 1.


v. Display a total row. Add totals for Salary and Total Employee Cost.


w. Create Line sparklines in column F in the Earnings sheet to show the trend by quarter for each division. Show the high point for each sparkline. Apply the Sparkline Style Colorful #5 style. Apply the Red, Accent 2 high point marker color.


x. Create a 3-D Clustered Column chart of the divisions and their quarterly earnings.


y. Move the chart to a new sheet named Earnings Chart.


z. Apply the Layout 3 chart layout.


aa. Type Quarterly Earnings for Each Division for the chart title.


ab. For all worksheets, add a footer with your name on the left side, sheet name code in the center and file name code on the right side.


ac. Select Landscape orientation for the Filtered Data and Earning Chart sheets. Set all sheets to print each sheet on one page.


ad. Save the workbook and exit Excel. Submit the workbook as directed by your instructor.


2


Copyright © 2014 Pearson Education, Inc.


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
University Coursework Help
Top Essay Tutor
Homework Guru
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.

$110 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$112 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

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

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

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

John donne holy sonnet 5 - Contemplation and Consideration- APA format and 2 references (1/2 page) - The snow child bloody chamber pdf - Strategic Planning - The lottery shirley jackson sparknotes - Klein isd two step equations distributive property answers - Tibco enterprise message service - Stupid america poem analysis - Socioautobiography essay examples - Thermodynamics enthalpy of reaction and hess's law lab calculations answers - Group therapy - Mericans by sandra cisneros - 12 types of tenses with examples and formula pdf - Indian standard ac voltage - The hedgehog and the fox pdf - The essentials of political analysis answer key - Water potential of potato - Artificial intelligence in power station ieee paper - Moreton bay council dog complaints - Voip monitor subsystem out of service - JCCMI- Phil Week 2 Dis 1 - Contra actions to a facial treatment - Biotic factors in the amazon rainforest - Rational Controversy assignment - Idiographic vs nomothetic approach - Corey corey and callanan decision making model - Lyddie chapter 12 readers notes - CJT202 DISCUSSION - How are bays formed - Is kiwisaver compulsory for employees - Which of the following is an implicit cost - Kinky copies may buy a high volume copier - Adequate standard of living - MANAGERIAL FINANCE - Type d adverse drug reactions - Wk 2 IOP 470: DQ - 15 salvana court taylors lakes - Phet electric field hockey - Folkway violations - Describe some social problems within educational institutions - Ps music continuing problem answers - Atomic radius of vanadium in nm - Identify The Violated Assumption, Principle,Or Constraint - Exercise 3.1 - 98 364 database fundamentals pdf - 4.1 identifying and graphing sequences evaluate homework and practice answers - Natural doc wetherill park - Cardiac protected electrical area - Managerial Accounting_Discussion_6 - Jane foss russell building usyd - Broken hill hospital nurses accommodation - Inductive and Deductive theory - In cold blood questions - Dunkin donuts financial ratios - Operation Security - Black and gold msds - Cpt laparoscopic partial gastrectomy procedure - Data mining query language in data mining - What is stp chemistry - MIS - DIscussion 14 - Management a practical introduction 7th edition ebook - Cell structure and function experiment - Mcis sau - Qualitative research techniques ppt - Free blank mar sheets - Project Scope Assignment - Space frame design software - Ucl isd service desk - Medisys case study - Jordan's furniture red sox promotion 2016 - Cooler meaning in the outsiders - Deliverable 6 - Corporate Culture and Change 5pages - Amoeba sisters the great divide answer key - Maryland board of cosmetology - Saikaku life of a sensuous woman - Psychology - Calculate ka from pka - Lesson 2 3 quiz business law - Penner company reported total manufacturing costs of - Frigel microgel chiller manual - Lee canter and marlene canter - IS WIKIPEDIA A RELIABLE SOURCE YES OR NO? WHY? sustain two just write ten sentences - Aisha bint abu bakr hsc - Acc 202 milestone 1 workbook - Perimeter with algebraic expressions worksheet - All iqbal open university - Forensic psychology Discussion 2 - You turn the page i burned the book meaning - C3h8 o2 co h2o - New hampshire technical college - Polo ralph lauren employee w2 - American gothic grant wood analysis - Case study - Hrm 300 week 5 trends in hr management analysis - Magnifica coffee machine manual - Thesis statement for the chimney sweeper - Nevada four guerrillas - The conduct of army prt follows the principles of - University of melbourne human research ethics committee - Which paas can allroad use