Fiverr Microsoft Excel Test Answers 2023
Question: 1 In Microsoft Excel 2016, which of the following options can be locked in a worksheet? i) Ranges ii) Formulas a. Only option i). b. Only option ii). c. Both options i) and ii). d. Neither option i) nor ii). Answer: a. Only option i). Question: 2 This question is based upon the figure shown below. Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9? a. 5 b. 6 c. 8 d. 12 e. It will return an error because the formula is incorrect. Answer: d. 12 Question: 3 This question is based upon the figure shown below Consider the given image for the following question. There are red triangles in the upper-right corner of each cell under the column titled 'Class'. What do they signify? a. They represent that the cells are containing formatted data. b....