Test Microsoft Excel P16

This article presents Test Microsoft Excel P16 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Test Microsoft Excel P16

• Question 1. To count the number of characters in cell A7, enter the command:
  • = LENGTH (A7)
  • = COUNTA (A7)
  • = LEN (A7)
  • = COUNT (A7)
• Question 2. To select discontinuous cells in the worksheet, which key do you need to use the mouse with?
  • Ctrl and Shift
  • Ctrl
  • Shift
  • Alt
• Question 3. In Microsoft Excel spreadsheet, if you want to sort the data list in alphabetical order, we need to manipulate the steps:
  • Data -> Sort
  • Data -> Filter
  • Insert -> Sort
  • Insert -> Filter
• Question 4. In MS Excel, which function is used to count cells with data in a list:
  • COUNT
  • COUNTBLANK
  • COUNTIF
  • COUNTA
• Question 5. In Excel, AND, OR, NOT are:
  • Function of numeric data type
  • Function of Logic data type
  • Function of date data type
  • All is wrong
• Question 6. The formula = MAX (6; -2; 2; SUM (4; 7; -2); 4; 0; -3) has the following result:
  • 0
  • 9
  • 5
  • 7
• Question 7. In cell A3, there is a value of 3HOC. Cell B4 with formula = LEFT (A3; 3) will show the result:
  • 3
  • HOC
  • 3HO
  • 3HC
• Question 8. When entering the formula: = "32" - "2" into a cell, we get the result:
  • 3
  • 30
  • 32
  • ERROR
• Question 9. Ô A1 of the spreadsheet with date format and value is December 11, 2013. What is the function result = MONTH (A1)?
  • 11
  • twelfth
  • 13
  • Depending on the date format type in cell A1.
• Question 10. To display the current date of the system in cell A7, select cell A7 and enter the formula:
  • = TODAY
  • = TODAY (A7)
  • = TODAY ()
  • All three are wrong