HomeTech infoQuiz technology

Test Microsoft Excel P13

  1. Question 1. For the following table of data in MS Excel 2010:
    Test Microsoft Excel P13 Picture 1
    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

    Test Microsoft Excel P13 Picture 2

    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)
4 ★ | 1 Vote
quizzesexcelbasic knowledgefun testsinformatics quizzesexcel learningapplying excel for workcalculating on excelexcel 2010

You should read it

May be interested

  • Microsoft Excel Test P11Microsoft Excel Test P11
    the excel 2010 interface changes very little compared to excel 2007 with the rearrangement of some on-screen components and the return of the file pane instead of the confusing office button. here, the network administrator will join readers to learn about new features in excel 2010 through the multiple choice questions below.
  • Link download Microsoft Excel 2019Link download Microsoft Excel 2019
    microsoft excel is a software program created by microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.
  • Microsoft Excel P12 testMicrosoft Excel P12 test
    the quiz on excel with many interesting questions will give you useful knowledge around this topic. the question set consists of 10 questions with 4 answers to choose from.
  • Microsoft Excel Test P7Microsoft Excel Test P7
    proficiency in using excel and mastering excel tips will greatly help your promotion or study. in the article below, network administrator will help you add knowledge about this topic through multiple choice questions.
  • Microsoft Excel Test P14Microsoft Excel Test P14
    excel is a spreadsheet program that is extremely useful for people who work as an office or a teacher. to help you gain more useful knowledge, in the following quiz network administrator has edited very interesting questions to help you expand your knowledge. let's try it together.
  • 5 useful Microsoft Excel formulas for calculating taxes5 useful Microsoft Excel formulas for calculating taxes
    you can spend big money to hire an experienced accountant handles this, or make use of excel power immediately to arrange things in order. here are five recipes that can make your life 'breathable' than in 'season' tax.
  • Summary of expensive shortcuts in Microsoft ExcelSummary of expensive shortcuts in Microsoft Excel
    in the work, especially when you have to perform many calculations, the formula in microsoft excel documents, the use of the mouse is strictly tortuous. not wrong, because when you master the formulas, shortcut keys on excel, using the keyboard will be fast and convenient a lot.
  • Z.TEST function - The function returns one-sided value of the z test in ExcelZ.TEST function - The function returns one-sided value of the z test in Excel
    z.test: the function returns the one-sided p value of the z test. support functions from excel 2010 onwards. syntax: z.test (array, x, [sigma])
  • Excel computer test - Part 3Excel computer test - Part 3
    after the second part of the excel test, the network administrator will continue to send you the 3rd part of the quiz series on this topic. let's work together to test your knowledge.
  • T.TEST function - The function returns the probability associated with Student's t-Test in ExcelT.TEST function - The function returns the probability associated with Student's t-Test in Excel
    t.test: the function returns the probability associated with student's t-test. support functions from excel 2010 onwards. syntax: t.test (array1, array2, tails, type)

Quiz technology