SOLVED

1) Which of the following symbols is used to represent exponents in Excel? A) ^ B) * C) # D) ! 2) Which of the following ways would × /100 – 73 be represented in an Excel spreadsheet? A) 10(2) * 5(3) / 100 ^ 73 B) 10(2) ^ 5(3) / 100 – 73 C) 10^2 * 5^3 / 100 – 73 D) 10*2 ^ 5*3 / 100 – 73 3) Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel? A) A relative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label. B) A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference. C) A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label. D) A relative address uses only the column label in the cell reference; an absolute address uses the row. Use the data given below to answer the following question(s) Below is the spreadsheet for demand prediction of a company that sells chocolates. A B C 1 Demand Prediction Models 2  3 Linear Model 4 a 10,000 5 b 10 6 7 Price Demand  8 $50 9,500 9 $55 9,450 10 $45 9,550 11 4) 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? A) B4-B5*A9 B) C5-C6*A10 C) B4-B5*A10 D) B5-B6*A10 5) If a dollar sign is used after the column in B5 (B$5), how will the formula at B8 be represented in C9 using absolute addressing? A) C3-B5*C9 B) C5-C6*B9 C) C5-C6*C9 D) C5-C5*B9 6) If a dollar sign is used before the column label B4 ($B4), how will the formula at B10 be represented in C11 using absolute addressing? A) B5-C6*B11 B) C5-C6*A10 C) B4-C5*B11 D) A5-C6*B11 7) If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas should be entered in B8 so that the formula can be dragged to B9 and B10 to obtain their correct values? A) B4-B5*A8 B) B4-B5*$A8 C) $B4-B5*$A8 D) $B$4-$B$5*$A8