please answer all the question

K B H Click on the "Horizontal" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each yellow cell requires a formula. The formula must only contain cell addresses, Each correct formula will begin with, or - The basic mathematical operators are +, and/ Addition: To add the values in cells AI and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is -A1-B4 Multiplication: To multiply the values in cells A1 and 84, the formula is =A1*B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 2 Using the ROUND function 13 The round function has the following syntax ROUND(Number, Number of digits) 14. The first variable, Number, may be either a value or a formula that returns a value. 15 Number of digits may be either a positive number (rounds to the right of the decimal point) or negative 16. number (rounds to the left of the decimal point), 17 12,847.3387 To round to the nearest .01, the formula is ROUND(A17,2) and returns >> 12,847.34 18 12,847.3387 To round to the nearest 1,000, the formula is ROUND(A18,-3) and returns >> 13,000.00 19 20 Using absolute addresses 21. Once a formula is created, you will often want to copy the formula to other columns and rows. It's important to understand that excel always uses "relative addresses" unless you indicate otherwise by creating an "absolute address". For example, if you are calculating 22 the cost of purchasing 2 boxes of cereal at a cost of $3,95 per box, the formula in cell 828 is -B26*827. Although we read cell 028 as "Multiply 2 boxes by $3.95", Excel is actually calculating the value in cell B28 as "Multiply the value in the cell in the same column 23 (column B) 2 rows above (row 26) by the value in the cell in the same column 1 row above (row 27). 24 25 26 Boxes of cereal 2 6 11 15 27 Price per box $3.95 28 Total cost 5790 S2320 5245 $59.25 Instructions Horwort Vertical B C D E F G H always uses "relative addresses" unless you indicate otherwise by creating an "absolute address". For example, if you are calculating the cost of purchasing 2 boxes of cereal at a cost of $3.95 per box, the formula in cell B28 is =B26*B27. Although we read cell B28 as "Multiply 2 boxes by $3.95", Excel is actually calculating the value in cell B28 as "Multiply the value in the cell in the same column (column B) 2 rows above (row 26) by the value in the cell in the same column 1 row above (row 27). S 26 Boxes of cereal 2 6 11 15 27 Price per box $3.95 28 Total cost $7.90 $23.70 $43.45 $59.25 29 30 This works just fine to calculate the cost of 2 boxes, but if we copy the formula in cell B28 to C28, Excel will assume relative references 31 The formula in cell C28 will become -C26C27. Since Cell C27 is blank, the formula will return a value of So (which is an excellent deal 32 for 6 boxes of cereal, but it isn't accuratel) Adding a sign before the column or row reference locks the formula to a specific location. 33 34 35 If we modify the formula in cell B28 to 326*$B$27 before we copy the formula, Excel will not change the row or the column of the 36 second variable. When the formula is copied to columns C through E, the formulas become: 37 38 Cell C28 -C26*$B$27 39 Cell D28 D26*$B$27 40 Cell E28 E26*$B$27 41 42 Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copied. If so, add a dollar sign before 43 the column, but not the row.e.$B27) if you want the row to stay fixed, but allow the column to remain relative when it's copied, add a 44 dollar sign before the row, but not the column (te, B$27). Tapping the F4 button while entering the formula for in the formula bar) 45 toggles among the 3 absolute options (Absolute Column and Absolute Row $B$28, Absolute Column and Relative Row $628, 46 Relative Column and Absolute Row B$28) 47 48 Instructions Horizontal Vertical wy I A G 0% Your score B D Name Enter name on prior tab Cash Accounts receivable net Merchandise inventory Plant assets, net Total assets Current liabilities Long term liabilities Common stock Retained earnings Total liabilities and equity 36 44 D E F G H BY B Name: Your score: ROUND function 2 decimal places K B H Click on the "Horizontal" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each yellow cell requires a formula. The formula must only contain cell addresses, Each correct formula will begin with, or - The basic mathematical operators are +, and/ Addition: To add the values in cells AI and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is -A1-B4 Multiplication: To multiply the values in cells A1 and 84, the formula is =A1*B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 2 Using the ROUND function 13 The round function has the following syntax ROUND(Number, Number of digits) 14. The first variable, Number, may be either a value or a formula that returns a value. 15 Number of digits may be either a positive number (rounds to the right of the decimal point) or negative 16. number (rounds to the left of the decimal point), 17 12,847.3387 To round to the nearest .01, the formula is ROUND(A17,2) and returns >> 12,847.34 18 12,847.3387 To round to the nearest 1,000, the formula is ROUND(A18,-3) and returns >> 13,000.00 19 20 Using absolute addresses 21. Once a formula is created, you will often want to copy the formula to other columns and rows. It's important to understand that excel always uses "relative addresses" unless you indicate otherwise by creating an "absolute address". For example, if you are calculating 22 the cost of purchasing 2 boxes of cereal at a cost of $3,95 per box, the formula in cell 828 is -B26*827. Although we read cell 028 as "Multiply 2 boxes by $3.95", Excel is actually calculating the value in cell B28 as "Multiply the value in the cell in the same column 23 (column B) 2 rows above (row 26) by the value in the cell in the same column 1 row above (row 27). 24 25 26 Boxes of cereal 2 6 11 15 27 Price per box $3.95 28 Total cost 5790 S2320 5245 $59.25 Instructions Horwort Vertical B C D E F G H always uses "relative addresses" unless you indicate otherwise by creating an "absolute address". For example, if you are calculating the cost of purchasing 2 boxes of cereal at a cost of $3.95 per box, the formula in cell B28 is =B26*B27. Although we read cell B28 as "Multiply 2 boxes by $3.95", Excel is actually calculating the value in cell B28 as "Multiply the value in the cell in the same column (column B) 2 rows above (row 26) by the value in the cell in the same column 1 row above (row 27). S 26 Boxes of cereal 2 6 11 15 27 Price per box $3.95 28 Total cost $7.90 $23.70 $43.45 $59.25 29 30 This works just fine to calculate the cost of 2 boxes, but if we copy the formula in cell B28 to C28, Excel will assume relative references 31 The formula in cell C28 will become -C26C27. Since Cell C27 is blank, the formula will return a value of So (which is an excellent deal 32 for 6 boxes of cereal, but it isn't accuratel) Adding a sign before the column or row reference locks the formula to a specific location. 33 34 35 If we modify the formula in cell B28 to 326*$B$27 before we copy the formula, Excel will not change the row or the column of the 36 second variable. When the formula is copied to columns C through E, the formulas become: 37 38 Cell C28 -C26*$B$27 39 Cell D28 D26*$B$27 40 Cell E28 E26*$B$27 41 42 Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copied. If so, add a dollar sign before 43 the column, but not the row.e.$B27) if you want the row to stay fixed, but allow the column to remain relative when it's copied, add a 44 dollar sign before the row, but not the column (te, B$27). Tapping the F4 button while entering the formula for in the formula bar) 45 toggles among the 3 absolute options (Absolute Column and Absolute Row $B$28, Absolute Column and Relative Row $628, 46 Relative Column and Absolute Row B$28) 47 48 Instructions Horizontal Vertical wy I A G 0% Your score B D Name Enter name on prior tab Cash Accounts receivable net Merchandise inventory Plant assets, net Total assets Current liabilities Long term liabilities Common stock Retained earnings Total liabilities and equity 36 44 D E F G H BY B Name: Your score: ROUND function 2 decimal places