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
-
3.5 ★ | 2 Vote
You should read it
May be interested
- Microsoft Excel Test P11the 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 2019microsoft 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 testthe 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 P7proficiency 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 P14excel 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 taxesyou 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 Excelin 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: 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 3after 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: the function returns the probability associated with student's t-test. support functions from excel 2010 onwards. syntax: t.test (array1, array2, tails, type)