How2Excel 3 - Basic functions
9th Grade
•10 Qs
Similar activities
BÀI 14- THUẬT TOÁN TÌM KIẾM TUẦN TỰ
6th Grade - University
•14 Qs
Programming with Karel the Dog 2
6th - 9th Grade
•13 Qs
Lesson 01 Unit 1 Excel 2019/365 MOAC
9th - 12th Grade
•10 Qs
Електронні таблиці Exel
1st - 12th Grade
•12 Qs
sql per 4f
9th Grade
•12 Qs
Excel Test Eins
5th - 9th Grade
•13 Qs
BÀI 6: ĐỊNH DẠNG TRANG TÍNH
6th - 9th Grade
•10 Qs
Google Tips and Tricks
7th - 9th Grade
•15 Qs
How2Excel 3 - Basic functions
Quiz
•
Computers
•
9th Grade
•
Practice Problem
•
Hard
Konrad Meij
Used 20+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into A4 to add up of all the values in cell range A1:A3?
=SUM(A1,C3)
=ADD(A1:C3)
=SUM(A1:C3)
=(A1:C3)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into A4 to find the largest value in cell range A1:A3?
=SUM(A1:A3)
=MAX(A1:A3)
=MAX(A1,A3)
=MAX(A4)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into B4 to count all the values in cell range A1:C3 that contains NUMBERS?
=COUNTA(A1:C3)
=COUNT(A1:C3)
=COUNTIF(A1:C3)
=SUM(A1:C3)
4.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What function needs to be typed into A4 to find the average of all the values in cell range A1:A3?
REMEMBER: Use only capital letters. No spaces in between characters
5.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What function needs to be typed into A4 to find the smallest of all the values in cell range A1:C3?
REMEMBER: Use only capital letters. No spaces in between characters
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
What function needs to be typed into B4 to count all the values in cell range A1:C3 that contains ANYTHING (eg. are not empty)?
REMEMBER: Use only capital letters. No spaces in between characters
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function needs to be typed into B4 to count all the cells that contain the number 3 in cell range A1:C3?
=COUNTA(A1:C3,3)
=COUNT(A1:C3)
=COUNTIF(A1:C3)
=COUNTIF(A1:C3,3)
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
10 questions
If-Statements
Quiz
•
9th - 12th Grade
10 questions
2.4 IF, THEN, ELSE
Quiz
•
9th Grade
12 questions
9 кл. Табличний процесор. Підсумковий тест
Quiz
•
9th Grade
12 questions
Syllabus Quiz FA25
Quiz
•
9th Grade
15 questions
Quiz Aplikasi Perkantoran
Quiz
•
7th Grade - University
10 questions
Data validation and verification
Quiz
•
7th - 11th Grade
15 questions
UH2 Ms. Excel
Quiz
•
9th Grade
12 questions
9.1.6 - Starter Quiz
Quiz
•
8th - 9th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
