Microsoft Excel P8 test

Multiple choice questions around the topic of Excel, invite readers to test their knowledge with the Network Administrator. The question set consists of 10 sentences, 4 answers each, find the most accurate answer.

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