Question: Format values. a . Start Excel, open the file EX 3 - 2 . xisx from the location where you store your Data Files, then

Format values.
a. Start Excel, open the file EX 3-2.xisx from the location where you store your Data Files, then save it as EX 3-Health Insurance Premiums.
b. Use the Sum function to enter a formula in cell B10 that totals the number of employees.
C Createa formula in cell C5 that calculates the monthly insurance premium for the accounting department.
(Hint: Make sure you use the correct type of cell reference in the formula. To calculate the department's monthly
premium, multiply the number of emplayees by the monthly premium in cel B143
d. Copy the formula in cell CS to the range C6:C10.
e. Format the range CS C10 using Accounting number format.
f. Change the format of the range C6:9 to the Comma Style.
g. Reduce the number of decimals in cell B14 to 0 using a button in the Number group on the Home tab.
h. Save your work.
Change font and font sizes.
a. Select the range o

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

d. 5,555.55 Skills Review 1. Format values. a. Start Excel, open the file EX C-2.xlsx from the location where you store your Data Files, then save it as EX C-Life Insurance Premiums. b. Use the Sum...

Q:

You run a freelance accounting business, and one of your newest clients is Fresh To You, a small local grocery store. Now that youve converted the stores accounting records to Excel, the manager...

Q:

apply the challange on this excel sheet as a excel file 6 Independent Challenge 1 You run a freelance accounting business, and one of your newest clients is Fresh To You, a small local grocery store....

Q:

e. Save and close the workbook, submit the workbook to your instructor, then exit Excel. ndependent Challenge 1 ou are the manager for Smith \& Weston, an environmental consulting firm based in...

Q:

Module 9 - Skills Review Plan and enable a macro. a ) You need to plan a macro that enters a Total label in cell D 1 7 and a formula in cell E 1 7 that totals the managed assets in the range E 3 :E 1...

Q:

Start Excel, open IL_EX_6-6.xlsx from the location where you store your Data Files, then save it as IL_EX_6_BusinessServices.b. Group the US January and US February worksheets.c. With the worksheets...

Q:

a . Start Excel, open IL _ EX _ 8 - 4 . xlsx from the location where you store your Data Files, then save it as IL _ EX _ 8 _ Accommodations. b . Create a PivotTable on a new worksheet named...

Q:

Independent Challenge 1As the assistant to the clinic director at Riverwalk Medical Clinic, you have been asked to organize the billing information for the physical therapy department. Using data in...

Q:

Independent Challenge 1 You are the assistant to the vice president of marketing at the Metro-West Philharmonic located outside of Boston. The vice president has asked you to chart some information...

Q:

Old MathJax webview Old MathJax webview Kindly solve the problem on excel sheet A Jons Frog Legs franchise has just opened a new location in Ashville, NC, and you will be analyzing their sales and...

Q:

4. Examine whether the following statements are true or false. Give an expla- nation. (a) Serial correlation in the errors u leads to biased estimates and biased standard errors when the regression...

Q:

Based on the data in Exercise 10-13, determine the depreciation for the storage tank for each of the first two years, using the sum-of-the-years-digits depreciation method. Round to the nearest...

Q:

The ratio of annual debt repayments to gross income is known as

Q:

Complete a service blueprint for each of the following banking transactions. Use the service actions listed in the tables below each name of a transaction. a. Make a savings deposit using a teller