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 Training Rapid Quiz- 1st
16826
Childcare
8423
Primary 5 Verbal Reasoning F1W2 (Day 1 CBT) (tklesson)
1050
Characteristics of Life: Test Your Biology Knowledge
201037127
Free Business Aviation Knowledge Test
201021370
Free Pop Culture Character Identification
201030099
Jordan Sweeto: Test Your Fan Knowledge Now
201054428
Advanced Child Welfare
15820806
What Level Skier Am I? Free Ski to Discover Yours
201026817
Free Connect: Test Your English Grammar & Vocabulary
201023516
Free PCT Practice Test: Questions & Answers
201025594