Microsoft Excel P8 Test

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

Understanding Microsoft Excel P8 Test

• Question 1. What does Vlookup function in Excel use for?
  • Look up data
  • Calculate total by condition
  • Calculate the maximum value
  • Calculate the smallest value
• Question 2. What does Sumum in Excel do?
  • Calculate the derivative
  • Calculating cumulative conditions
  • Calculate total by condition
  • Calculate the maximum value by condition
• Question 3. What effect does Conuntif function in Excel have?
  • Integral calculus
  • Calculate the surplus value
  • Count the time of day
  • Count data that satisfies conditions
• Question 4. What are the parameters of the Date function?
  • day, month, year
  • year, day, month
  • month, day, year
  • year, month, day
• Question 5. What is the result of the function = if (3> 5, "ok")?
  • OK
  • TRUE
  • FALSE
  • "False"
• Question 6. Vlookup function can be replaced by:
  • Combine SUM and Product functions
  • Combine Min and IF functions
  • Combine Index and Match functions
  • Combine the HLOOKUP and Transpose functions.
• Question 7. Which formula is valid in Excel:
  • = SUM (R [-4] C [-2]: RC [-1])
  • = SUM (A1: B5)
  • Both answers above
• Sentence 8. Which formula allows a random number between 1 and 1000:
  • = RANDBETWEEN (1-1000)
  • = RANDBETWEEN (1/1000)
  • = RANDBETWEEN (1; 1000)
  • There is no right answer
• Question 9. To connect "Quan", "value", "network" to each other and have a space in the middle, we use the formula:
  • = "Admin" & "" & "value" & "" & "network".
  • = "Admin" & "" "" & "value" & "" "" & "network".
  • = "Admin" & "value" & "network"
  • = JOIN ("Admin", "value", "network")
• Question 10. What is the result of function = MID (A1,4,16) if A1 = 1234567890ABCDEFGHIJKLMN.
  • 34567890abcde
  • 4567890abcdefghi
  • 567890abcdefghij
  • All is wrong