MS Excel 1. In the following Exel table, what formula could be typed (in cell C9) to determine the Mass vae if de Eanb was multiplied by he Mass (Me) for the planet Mars ? Use only cell locations...
MS Excel 1. In the following Exel table, what formula could be typed (in cell C9) to determine the Mass vae if de Eanb was multiplied by he Mass (Me) for the planet Mars ? Use only cell locations m your formula (Le, no เสแฝ wlusi Ast. Unit 99E430 Sun Mass 0.0550 1.0000 317.8000 Mercury enus Earth Jupiter 10 TOTAL RITE YOUR CORRECT FORMULA IN THE SPACE BELOW one copied this new formula (cell C9 from Problem #1) and pasted it to cell C11. What would this new Now, s rmula in cell C11 be after it was pasted there? WRITE YOUR CORRECT FORMULA IN THE SPACE BELOW Ii the formula in cell C9 was modified using the absolute static symbol (S) for the Earth Mass value (i.e S for only the row). d the Mass (kg) formula be for the planet Saturm be calculated correctly if this new cell C9 formula was copied to cel TRUE or FALSE Next, if the total for all of the planet Mass (Me) values was required to be written in cell C12, what would this formula like? NOTE: in this formula you cannot use the +symbol or any of the actual values in this formula...and you canno list any of the the cell locations individually. You MUST use the range format which uses the colon. Use all symbols required or it will be marked fully incorrect (i.e., all points will be deducted). Wrnite your coroct formula bclow YOUR CORRECT FORMULA IN THE SPACE BELOW
MS Excel 1. In the following Exel table, what formula could be typed (in cell C9) to determine the Mass vae if de Eanb was multiplied by he Mass (Me) for the planet Mars ? Use only cell locations m your formula (Le, no เสแฝ wlusi Ast. Unit 99E430 Sun Mass 0.0550 1.0000 317.8000 Mercury enus Earth Jupiter 10 TOTAL RITE YOUR CORRECT FORMULA IN THE SPACE BELOW one copied this new formula (cell C9 from Problem #1) and pasted it to cell C11. What would this new Now, s rmula in cell C11 be after it was pasted there? WRITE YOUR CORRECT FORMULA IN THE SPACE BELOW Ii the formula in cell C9 was modified using the absolute static symbol (S) for the Earth Mass value (i.e S for only the row). d the Mass (kg) formula be for the planet Saturm be calculated correctly if this new cell C9 formula was copied to cel TRUE or FALSE Next, if the total for all of the planet Mass (Me) values was required to be written in cell C12, what would this formula like? NOTE: in this formula you cannot use the +symbol or any of the actual values in this formula...and you canno list any of the the cell locations individually. You MUST use the range format which uses the colon. Use all symbols required or it will be marked fully incorrect (i.e., all points will be deducted). Wrnite your coroct formula bclow YOUR CORRECT FORMULA IN THE SPACE BELOW