
ADVITT EXCEL
Authored by subba G
Other
Professional Development
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
In Excel, which function is used to count the number of cells in a range that contain numbers?
sum
count
countif
counta
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
In Excel, what does the formula =A1&B1 do?
Adds the values in cells A1 and B1
Concatenates the values in cells A1 and B1
Divides the values in cells A1 and B1
Multiplies the values in cells A1 and B1
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What does the NOW() function in Excel do?
Returns the current time
Returns the current date and time
Returns the current date
Returns the current month
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which Excel feature allows you to automatically fill in a series of data?
AutoFill
AutoComplete
AutoSum
AutoFormat
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What does the VLOOKUP function do?
Looks up values in a horizontal lookup table
Looks up values in a vertical lookup table
Looks up values in a matrix
Looks up values in a sorted table
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which function would you use to calculate the number of working days between two dates?
WORKDAY
NETWORKDAYS
WORKDAYS
WORKINGDAYS
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What does the formula =IF(A1>B1, "Yes", "No") do?
Adds the values in cells A1 and B1
Concatenates the values in cells A1 and B1
Compares the values in cells A1 and B1
Compares the values in cells A1 and B1 and returns "Yes" if A1 is greater than B1, otherwise "No"
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
19 questions
Feel good movies... or not
Quiz
•
Professional Development
20 questions
Digital Payments Awareness
Quiz
•
Professional Development
15 questions
LIQUID LIQUID EXTRACTION
Quiz
•
University - Professi...
15 questions
Football Quiz
Quiz
•
KG - Professional Dev...
20 questions
Information Security Awareness
Quiz
•
University - Professi...
20 questions
CryptoFactories.io v1.0
Quiz
•
KG - Professional Dev...
16 questions
Surf Awareness Deep Dive
Quiz
•
Professional Development
20 questions
123Go
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Other
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
12 questions
Mardi Gras Trivia
Quiz
•
Professional Development
7 questions
Copy of G5_U5_L14_22-23
Lesson
•
KG - Professional Dev...
12 questions
Unit 5: Puerto Rico W1
Quiz
•
Professional Development
42 questions
LOTE_SPN2 5WEEK2 Day 4 We They Actividad 3
Quiz
•
Professional Development
15 questions
Balance Equations Hangers
Quiz
•
Professional Development
31 questions
Servsafe Food Manager Practice Test 2021- Part 1
Quiz
•
9th Grade - Professio...