Excel functions, Excel formulas - take the quiz
Excel Functions Mastery Quiz
Test your knowledge of Excel fun
Key Features:
- 11 multiple-choice questions
- Instant feedback on your answers
- Learn and improve your Excel capabilities
What does the VLOOKUP function do in Excel?
Looks up a value in the leftmost column of a table and returns a corresponding value from a specified column
Calculates the sum of a range of cells
Counts the number of cells in a range that meet a specific condition
Finds the maximum value in a range of cells
Which Excel function can be used to count the number of cells in a range that meet a specific condition?
COUNTIF
AVERAGE
SUMIF
MAX
What is the result of the formula =IF(A1>10, "Yes", "No") when A1 contains the value 5?
No
Yes
True
False
What is the result of the formula =SUM(A1:A5) when A1 contains the value 2, A2 contains 4, A3 contains 6, A4 contains 8, and A5 contains 10?
30
20
10
40
Which Excel function can be used to round a number to a specified number of decimal places?
ROUND
TRIM
LEN
LOWER
What is the result of the formula =SUMIF(A1:A5,">5") when A1 contains the value 2, A2 contains 4, A3 contains 6, A4 contains 8, and A5 contains 10?
24
20
16
30
What function would you use to to tally a subset of data that is comprised of the following: "YES, X, X, 1, _, YES"
COUNT
COUNTA
COUNTIF
{"name":"Excel functions, Excel formulas - take the quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of Excel functions and formulas with our engaging quiz! Whether you're a beginner or an advanced user, this quiz is designed to challenge and enhance your Excel skills.Key Features:11 multiple-choice questionsInstant feedback on your answersLearn and improve your Excel capabilities","img":"https:/images/course1.png"}
More Surveys
Safety Analyst Training
17835
Excel Training
5230
Let's know more about you
4267
Chart visualization 101
12622
Questionnaire
3225
CA process
1366
Free Day of PTO competition
1269
How many Endo interviews do you have so far?
3229
HR INTERVIEW MAROBI
1476
Are you ready to learn?
5221
ANC Parliamentary Caucus- Media & Communications
6326
Introduction into Medical Interpretation
9416