Excel: more functions

Quiz
•
Computers
•
9th - 12th Grade
•
Hard
Nicola Woods
FREE Resource
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To find the highest number
=max(a1:a8)
=max(a2:a8)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To sum all the numbers less than 33
=sum(a2:a8,<33)
=sumif(a2:a8,"<33")
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To count all the numbers
=countif(a2:a8)
=count(a2:a8)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To find the average of all the numbers
=avg(a2:a8)
=sum(a1+a2+a3+a4+a5+a6+a7+a8)/7
=average(a2:a8)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To add 2 numbers 12 and 55
=sum(a2:a6)
=a2+a6
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
According to a given criteria if age is greater than or equals to 18 display "License Granted" else "Denied". The age is in cell a4
=if(a4>=18,"License Granted","Denied")
=if(a4 >=18,License Granted,Denied)
=if(a4>18,"License Granted","Denied")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to count the number of text values
=COUNTA(A1:C1)
=COUNT(A1:C1)
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Entendendo funções no Excel

Quiz
•
10th - 12th Grade
10 questions
Excel

Quiz
•
7th - 11th Grade
10 questions
Bài 11a. Sử dụng hàm Sumif Tin 9

Quiz
•
9th Grade
10 questions
Câu hỏi về hàm SUMIF trong Excel

Quiz
•
9th Grade - University
8 questions
BÀI 11a. SỬ DỤNG HÀM SUMIF

Quiz
•
9th Grade
10 questions
Tin 9- Bài 10 Sử Dụng Hàm COUNTIF trong Excel

Quiz
•
9th Grade
15 questions
EX_Class(Sum,SumIF,Max,Min,Average)

Quiz
•
12th Grade
10 questions
TRẮC NGHIỆM HÀM TRONG EXCEL

Quiz
•
11th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade