Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help! I really just need to know the function to use in #3 3) Switch to the Faculty Data worksheet. Use one of the

Please help!
image text in transcribed
image text in transcribed
I really just need to know the function to use in #3 image text in transcribed
3) Switch to the Faculty Data worksheet. Use one of the Excel functions that we have secn to complete the workshect by calculating the matching retirement dollar amount for each faculty: member (column I). Note that not all faculty members participate in the retirement plan (column H). For any faculty member who is participating in the retirement plan, the institution will contribute (mateh) a percentage (found in cell B1) of the faculty member's salary, placing the contribution in the retirement fund If the faculty member is not participating, enter a zero in the appropriate cell of column I. If the retirement contribution amount is not a whole dollar amount, then format all currency amounts on the spreadsheet to display with the $ sign and two decimal places. 4) In cell B2, create a formula that shows the total amount of retirement contributions that are made to the employees. 5) Create a footer that displays your first and last name. Create a header that automatically displays the sheet name (in the beader). Make sure that the spreadsheet is formatted to fit on 1 page. 6) Make a sereenchot printout of the Faculty Data sheet. Label this screenshot printout as Faculty Data. 7) Display the formulas for the Faculty. Data sheet. Make a screenshot printout of the formulas. Labcl this screenshot printout as Faculty Data Formulas. 8) Switch back from the formulas view to the actual spreadsheet yiew: 9) Your next step is to duplicate the contents of your workshect. To do that, place your cursor over the sheet name (Faculty Data). While doing that, hit your RIGHT MOUSE BUTION. A number of options should appear. Select Move or Copy and the Move or Copy dialog box should appear. Click in the checkbox next to Create a Copy. Click (move to end) ,and then click OK. A new. worksheet (an exact duplicate of the original sheet) should now appear. It should be locoted after the original and its name should be Faculty Data (2). 10) Repeat the Move or Copy technique 4 additional times so that you have sheets named Faculty Data (3), Faculty Data (4), Faculty Data (5), Faculty Data (6). You will do something different on cach of those shects and each one will be a future printout. Save your work. 11) Go to the sheet called Faculty Data (2) Click in cell A5. Your next step is to format the data found in the range of \$AS4 S1 45 into a table (indicating that your table has headers). 12) Next, create a filier that displays only the accounting faculty with the rank of Full Professor hired after 1990. Sort your rewulis fromt high salary to low salary. Rename this sheet so that is new name is Acceunting Full. Save your work. Make a screenshot printout of this alhect and label the screenshot printoot as Acceubtieg Full

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions