Excel Proficiency Assignment

Use the instructions below to complete the assignment.

Use of Excel for Organizing

Change the name of the “Dataset” worksheet to “Excel Proficiency Exam”

Insert a new column between Column A and Column B

Split the single column A data into two separate columns

Add a new heading name to these columns, “Last Name” and “First Name”

Format Column C, D, E, and G for currency

Format Column F for percentages

Use of Formulas in Excel

Create a formula in Column E to Add Columns C and D

Label Column G “Taxes Paid”

Create a formula in Column G to Multiply Column E and F

Label Column H “Net Pay”

Create a formula in column H to subtract G from E

Insert a new column between Column E and Column F

Label the new column F “Average Daily Wage Rate”

Create a formula in the new column F to divide “Total Weekly Wages” by 7

Merge cells K1 and L1 and name the cell “Employee Averages”

In column K, under the heading, copy the heading titles from C1:I1 to K2:K8. Use a formula to link the cells.

Create a formula in column L that calculates the averages for each matching category in K2:K8

Use of Complex Formulas in Excel

In cell K25, create a heading titled, “Thunder Occurrences”

In cell K26, create a formula that counts the number times “Thunder” occurs in the columns containing “Names”

Use of Excel to Create Graphs

Using data in the average table, create a pie chart that compares the amount of average weekday wages to the average weekend wages

Change the chart title to, “Weekday & Weekend Wage Comparison”

Position the chart so that it is placed between K10-L23

Use of Excel for Aesthetics

Change the font for your entire workbook to 12pt Arial

Widen or shrink all columns to the exact size of the words in the heading

Wrap text in headings with three or more words so that are no more than 3 words per line

Center the entire data set

Sort the entire data set according to last name

Add all borders to the entire data set along with the Employee Averages and Thunder Occurrences data set

Add a thick outside border to the first row of headings including the Employee Averages and Thunder Occurrences headings

Italicize and bold the text in the headings along with the Employee Averages and Thunder Occurrences headings

Add a Light Gray Background to all headings including Employee Averages and Thunder Occurrences

Insert an image of any GCU logo under the number of “Thunder Occurrences”

Scroll Below to View Our Previous Reviews

Calculate the price of your order

Continue with Order
Continue with Order
Continue with Order
Continue with Order

Simple Order Process

Fill in the Order Form

Share all the assignment information. Including the instructions, provided reading materials, grading rubric, number of pages, the required formatting, deadline, and your academic level. Provide any information and announcements shared by the professor. Choose your preferred writer if you have one.

Get Your Order Assigned

Once we receive your order form, we will select the best writer from our pool of experts to fit your assignment.

Share More Data if Needed

You will receive a confirmation email when a writer has been assigned your task. The writer may contact you if they need any additional information or clarifications regarding your task

Let Our Essay Writer Do Their Job

Once you entrust us with your academic task, our skilled writers embark on creating your paper entirely from the ground up. Through rigorous research and unwavering commitment to your guidelines, our experts meticulously craft every aspect of your paper. Our process ensures that your essay is not only original but also aligned with your specific requirements, making certain that the final piece surpasses your expectations.

Quality Checks and Proofreading

Upon the completion of your paper, it undergoes a meticulous review by our dedicated Quality and Proofreading department. This crucial step ensures not only the originality of the content but also its alignment with the highest academic standards. Our seasoned experts conduct thorough checks, meticulously examining every facet of your paper, including grammar, structure, coherence, and proper citation. This comprehensive review process guarantees that the final product you receive not only meets our stringent quality benchmarks but also reflects your dedication to academic excellence.

Review and Download the Final Draft

If you find that any part of the paper does not meet the initial instructions, send it back to us with your feedback, and we will make the necessary adjustments.