Test Microsoft Excel P13

By Update

In this article, network administrators will continue to learn about Excel software through extremely interesting multiple-choice questions below. Try to see how many questions you will make..

  1. Question 1. For the following table of data in MS Excel 2010:
    images 1 of Test Microsoft Excel P13
    Requirements: Calculate value = Quantity * Unit price * (1 - Reduction level). In particular, the reduction is calculated as follows: If the quantity sold is less than 50, the reduction is 0; conversely, the reduction will be 10%. What is the formula in cell F2?
    1. D2 * E2 * (1-If (D2 <50; 10%; 0%))
    2. D $ 2 * E $ 2 * (1-If (D2 <50; 0%; 10%))
    3. D2 * E2 * (1-If (D2 <50; 0%; 10%))
    4. D2 * E2 * 1-If (D2 <50; 0%; 10%)
  2. Question 2. When entering the value 3 + 4 in cell A3 of Sheet 1 in MS Excel 2010 and Enter, what is the content displayed in cell A3?
    1. 3 + 4
    2. #NAME?
    3. No display at all
    4. 7
  3. Question 3. In MS Excel 2010, cell F8 contains the content "06KT5A002". Formula = RIGHT (F8; 4) will result in:
    1. "06KT"
    2. "0012"
    3. "twelfth"
    4. twelfth
  4. Question 4. In order to combine multiple regions at the same time on MSExcel, what key combination do we press while selecting?
    1. Alt
    2. Shift
    3. Ctrl
    4. Esc
  5. Question 5. With the formula = MAX (20, MIN (5,100)) the result is
    1. 5
    2. 100
    3. 20
    4. All is wrong
  6. Question 6. Suppose the formula in cell F3 is A5 + Sheet3! G $ 4. After copying this formula from cell F3 to cell F4, what is the formula in cell F4?
    1. A5 + Sheet 3! G $ 5
    2. A5 + Sheet 3! G $ 4
    3. B5 + Sheet 3! H $ 4
    4. A6 + Sheet 3! G $ 4
  7. Question 7. In MS Exel 2010, give the following table of employee salary data:
    This data sheet applies from vv. 7 to 10

    images 1 of Test Microsoft Excel P13

    Use the last two characters of the employee code to look up the code to fill in the BOARD. Which of the following formulas is created in cell F6?

    1. = HLOOKUP (LEFT (D6; 2); $ H $ 15: $ K $ 16; 2; 0)
    2. = VLOOKUP (LEFT (D6); $ H $ 15: $ K $ 16; 2; 0)
    3. = HLOOKUP (LEFT (D6); $ H $ 15: $ K $ 16; 2; 0)
    4. All answers are wrong
  8. Question 8. In the Code Type column, set up the formula to extract the first symbol of the Employee code. Which of the following formulas in cell H6 is correct?
    1. = LEFT (D6)
    2. = LEFT (D6; 1)
    3. = MID (D6; 1; 1)
    4. All right
  9. Question 9. The number of working years is taken from the 2nd and 3rd characters. Which of the following formula in cell I6 is the best?
    1. = RIGHT (D6; 2)
    2. = MID (D6; 2; 2)
    3. = VALUE (MID (D6; 2; 2))
    4. All is wrong
  10. Question 10. To calculate the number of employees in cell K12, how do we formulate?
    1. = COUNTA (E6: E10)
    2. = COUNT (E6: E11)
    3. = COUNTIF (E6: E10; "X")
    4. = SUM (E6: E10)
basic knowledge fun tests informatics quizzes excel learning applying excel for work calculating on excel excel 2010

Related Articles