HomeTech infoQuiz technologyTest Microsoft Excel P16

Test Microsoft Excel P16

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

You should read it

May be interested

  • Multiple choice questions about Photoshop P15Photo of Multiple choice questions about Photoshop P15
    you often use photoshop. so you have confidence with your knowledge and skills for a long time. let's try a test with the network administrator on this topic.
  • Multiple choice questions about Photoshop P16Photo of Multiple choice questions about Photoshop P16
    a set of multiple-choice questions with basic knowledge about photoshop, invite readers to check their knowledge with the questions that we have edited and synthesized below.
  • JAVA test on P4Photo of JAVA test on P4
    the multiple choice questions about java programming will provide you with useful knowledge in the process you apply to learning as well as working with java. invite your reference.
  • Test on JAVA test P5Photo of Test on JAVA test P5
    do you like java programming and want to learn useful knowledge to apply to work? to meet the needs of readers, network administrators have collected and sent a series of quiz questions about java programming. invite your reference.
  • P13 programming set of multiple choice questionsPhoto of P13 programming set of multiple choice questions
    you are a fan of programming languages ​​and want to learn more about this topic. to give you an interesting reading about programming, in this article, the network administrator will send you a good quiz about this topic. invite your reference.
  • What test you know about operating system P11Photo of What test you know about operating system P11
    please read your knowledge and the following multiple choice questions of network administrator. hope with these questions will give you lots of useful information.

Quiz technology