Fiverr Test Answer

  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....