Below is the spreadsheet for demand prediction of a company that sells chocolates.
Given that D = a-bP, where D, is demand, "a" and "b," are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing?
Which EXCEL function is used to find the largest value in a range of cells?
________ is a logical function that returns one value if the condition is true and another if the condition is false.
OR(condition 1, condition 2…)
AND(condition 1, condition 2…)
TO(value if true, value if false)
IF(condition, value if true, value if false)
If cell G7 contains the function ________, it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.