Screenshot (5) - Windows Photo Viewer File Print E-mail Format Painter Clipboard 1 Font 07 fx A B Burn Open Alignment C D E F Formatting Table Number G H Styles J K L M N 1 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. 2 Each yellow cell requires a formula. 3 The formula must only contain cell addresses. 4 Each correct formula will begin with =, +, or -. 5 6 The basic mathematical operators are +, -, * and/ 7 Addition: To add the values in cells A1 and B4, the formula is =A1+B4 8 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 9 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 10 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 11 12 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 18 19 12,847.3387 To round to the nearest .01, the formula is =ROUND(A17,2) and returns >> 12,847.3387 To round to the nearest 1,000, the formula is =ROUND(A18,-3) and returns >> 20 Using absolute addresses 12,847.34 13,000.00 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 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). 23 24 25 26 Boxes of cereal 2 6 11 15 27 Price per box 28 Total cost $3.95 $7.90 $23.70 $43.45 $59.25 29 Type here to search D + O K e Cells Filter -Select Editing P O R S T O x 52F Partly sunny 11:27 AM 5/1/2022 ?