In Excel, which function is used to count the number of cells in a range that contain numbers?

ADVITT EXCEL

Quiz
•
Other
•
Professional Development
•
Medium
subba G
Used 1+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
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"
Create a free account and access millions of resources
Similar Resources on Quizizz
20 questions
Đi tìm Chiến thần Word/Excel

Quiz
•
Professional Development
17 questions
EALS

Quiz
•
Professional Development
20 questions
Examen practico Hojas de Cálculo

Quiz
•
Professional Development
17 questions
Funciones excel básicas

Quiz
•
Professional Development
15 questions
QUIZ - SETTORE GIOVANILE EMILIA-ROMAGNA

Quiz
•
Professional Development
25 questions
1st Excel Assessment Gibburion Analytics

Quiz
•
Professional Development
20 questions
Quiz - Data Analytic Projects

Quiz
•
Professional Development
20 questions
MS Excel Quizz

Quiz
•
Professional Development
Popular Resources on Quizizz
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade