class 8 chapter 2
a) Check B5 cell mark; if below 75, show “Denied” Use the IF function =IF(B5<75,"Denied","Allowed") b) You have daily temperature readings for a month and want the average Use the AVERAGE function =AVERAGE(A1:A30) c) Sales tax is always 8% of the price and must remain constant when dragging the formula Use Absolute Cell Reference with $ If 8% is in cell C1: =A1*$C$1 d) Determine the lowest price offer for a particular item from various sellers Use the MIN function =MIN(B1:B10) e) Need to combine F2 cell “Anima” and G2 cell “Report” in one cell Use the CONCATENATE function (or & ) =F2&" "&G2 1) Rules of using Functions in MS Excel Every function starts with = (equal sign) . The function name is written after = (e.g., SUM, AVERAGE). Arguments are written inside brackets ( ) . Cell ranges are written with a colon ( : ) (e.g., A1:A10). Multiple arguments are separated by a comma ( , ) . Example: =SUM(A1:A10) 2) Difference between Formula a...