1. Which of the following is correct syntax for writing out the following expression in Excel?...

Transcribed Image Text:

1. Which of the following is correct syntax for writing out the following expression in Excel? Assume that the variable x has been named "x" in the Name Manager or Name Box. 5. (1+73) 5*(1+3)/(7+x) O=5*(1+3/(7+x)) (5*1)+3/(7+x) =5*1+3/(7+x) 2. What value will be displayed in cell A6 when the Enter key is pressed? Enter your answer as an integer (counting number, no decimals). 1 2 hi 23 4 A Enter answer here B 7 hello 4 12 3 yo C 1 D 5 6 =COUNTBLANK(A1:C4) *COUNTA(A1:C4) 3. We would like to set up a simple Excel worksheet to calculate the number of 24-packs of tiles that we need for a certain tiling job. Tiles are only sold in packs of 24, and we must round up to the nearest multiple of 24 tiles. For example, if we need 155 tiles, then we'd need to round up and purchase 7 x 24-packs (6 x 24-packs would only be 144 tiles, so we need 7 of them). C 155 tiles 7 packs Which of the following formulas (multiple answers possible, and all must be selected for credit) could we place into cell B2 such that the formula would automatically recalculate total number of 24-packs if we were to change the tile number in cell B17 HINT: 2 of these are correct! U A 1 Tiles needed: 2 Packs of 24 needed: =MROUND(B1,24)/24 ROUNDUP(B1/24.0) =CEILING(B1.24)/24 CEILING(B1.24) B 1 point 4. What will the value in cell B4 be when the Enter key is pressed? Leave your answer as an integer (counting number) with no decimals. 123 ti 4 Enter answer here A 2 4 B 12 3 C 1 7 =ROW()*LARGE(A1:C2,3) 1 poi 5. Whose name will appear in cell A1 when Enter is pressed? The name "dwarves" refers to cells A3:46. C 1 =CHOOSE(MOD(11,COUNTA(dwarves)),A3,A4,A5,A6) 2 3 Doc 4 Grumpy 5 Happy 6 Sleepy Doc Happy Sleepy Grumpy A B D E 1 point 1. Which of the following is correct syntax for writing out the following expression in Excel? Assume that the variable x has been named "x" in the Name Manager or Name Box. 5. (1+73) 5*(1+3)/(7+x) O=5*(1+3/(7+x)) (5*1)+3/(7+x) =5*1+3/(7+x) 2. What value will be displayed in cell A6 when the Enter key is pressed? Enter your answer as an integer (counting number, no decimals). 1 2 hi 23 4 A Enter answer here B 7 hello 4 12 3 yo C 1 D 5 6 =COUNTBLANK(A1:C4) *COUNTA(A1:C4) 3. We would like to set up a simple Excel worksheet to calculate the number of 24-packs of tiles that we need for a certain tiling job. Tiles are only sold in packs of 24, and we must round up to the nearest multiple of 24 tiles. For example, if we need 155 tiles, then we'd need to round up and purchase 7 x 24-packs (6 x 24-packs would only be 144 tiles, so we need 7 of them). C 155 tiles 7 packs Which of the following formulas (multiple answers possible, and all must be selected for credit) could we place into cell B2 such that the formula would automatically recalculate total number of 24-packs if we were to change the tile number in cell B17 HINT: 2 of these are correct! U A 1 Tiles needed: 2 Packs of 24 needed: =MROUND(B1,24)/24 ROUNDUP(B1/24.0) =CEILING(B1.24)/24 CEILING(B1.24) B 1 point 4. What will the value in cell B4 be when the Enter key is pressed? Leave your answer as an integer (counting number) with no decimals. 123 ti 4 Enter answer here A 2 4 B 12 3 C 1 7 =ROW()*LARGE(A1:C2,3) 1 poi 5. Whose name will appear in cell A1 when Enter is pressed? The name "dwarves" refers to cells A3:46. C 1 =CHOOSE(MOD(11,COUNTA(dwarves)),A3,A4,A5,A6) 2 3 Doc 4 Grumpy 5 Happy 6 Sleepy Doc Happy Sleepy Grumpy A B D E 1 point

Answer rating: 100% (QA)

Question 1 To get an output in excel we need to have symbol at the beginning of the comman... View the full answer