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 Quizzes
Basic Excel
22110
Excel Quiz
630
Excel 2016: Working with Charts and Graphics Test
1260
Lesson 9
4259
Type of User
520
Excel Mastery Quiz
10526
MCHF Analyst Assessment
11610
PFC - Got What It Takes to Become an Analyst?
1477
Storyteller
1585
Conceptual Test
10525
Are you digitally literate?
520
Monitoring and Motivation
10562