Answered step by step
Verified Expert Solution
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 !
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started