Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can somone please help me with this assignment and show the formulas thank you ! Cikk on the Hatios tab and enter your name in

can somone please help me with this assignment and show the formulas thank you !
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Cikk on the "Hatios" tab and enter your name in cell C1. If Cell Ci is left blank, you will not be able to ine your icace. rach velow crillepures formula. The forrula muit only cortain cell addreves. Fuch corroct foriva wa beela whin w, tor ? The bask mathematical operatoriare th. "and / Addition To add the values in chis At and Es, that formula is a At+B4 Sotraction: To subtract the value in ceb B4 foom the value in cell As, the formula la a A1-at Mulipication: 10 multioly the values in celis At and 14, the formia is wAt'B4 Divalon: To divise the valae in cet A) by the value in cell B4, the formula is aA1/34 Whine the Avrlugar function Order of eperations Rementber the acrowyt HEMBAS wesh creating your formulas. Parentheses Exponents Mutiplication Divion Addaien Subtraction When cakulatiry a fraction, make wre to pet paremthes around any formula used in either the numerator or senomiator; Ushe absolute addreises Whing alatalute addresses Orce a formula is created, you will otten want to copy the formula to other columns and rows. It's important to understand that excel ahays uses "reative addresyes" Lhless you indicate otherwise by creating an "absclute addres". For example, if you are calculating the cout of purchasing 2 boses of cereal at a cont of 53.95 per boo, the formula in cell B28 is =825027. Atheugh we read cell b28 as "Multiply 2 boues try 53.95, Excel a actualy calculating the value in cell a2s as "Multiply the value in the cell in the same column (column B) 2 rows above (row 26 ) by the vaLue in the celi in the sarre column 1 row abovi (row27). This worksiat fre to calculate the cont of 2 boues, but if we copy the formula in celi is 28 to fzit, Excel will assume relative ruferences. The formida in celt Cag will become wC26*C27. Sive Cell CH is blank, the formida will return a value of 50 fwhich is an excelent deal for 6 boves of cereal, bet it an't acciratel) Adirge a 5 aign before the column of row reference locks the formula to a specifc losation. If we modfy the formula in cell B 28 to in 37558527 before we copy the formula, Exsel will not charee the row or the column of the second yariabin. Whed the fornula is copied to columins C through E,the tormulas become: Cetca8=C26*58527Cel02802658527Cell628=62658527 Somethes, you will wart the colurnh to stay foed, but atow the row to remain relative when it's copitd, if wo, ade a do iar sign before the column, but not The Angle Company begar operations in 2004. The comparative income stasenterts and baimoe shoets foliow. Use a formula to calculale the ration bolow. The AVERAGE formula must be used in any ratios using averege accounts rocovabie, averege ineotiory or averige told assets

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_2

Step: 3

blur-text-image_3

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

Primary English Audit And Test

Authors: Sue Reid, Angela Sawyer, Mary Bennett-Hartley

4th Edition

1446282759, 978-1446282755

More Books

Students also viewed these Accounting questions