How2Excel 3 - Basic functions
9th Grade
•10 Qs
Similar activities
Latihan Fungsi Excell
9th - 12th Grade
•10 Qs
Les Komputer
9th - 12th Grade
•15 Qs
Moving in a Worksheet
9th Grade
•12 Qs
BT và thuật toán
8th - 10th Grade
•10 Qs
Электронные таблицы
9th Grade
•10 Qs
Google Sheets Review 1
9th - 12th Grade
•15 Qs
Электронные таблицы. Основные понятия.
5th - 11th Grade
•10 Qs
Kuis Model Komputasi Umum Kelas 9 Sem 2
9th Grade
•12 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
15 questions
Code.org CSP Unit 1 Review
Quiz
•
9th - 12th Grade
10 questions
Inserting hyperlinks
Quiz
•
9th Grade
10 questions
Programming - Syntax & Logic Errors
Quiz
•
3rd - 12th Grade
12 questions
Excel Basics
Quiz
•
5th - 10th Grade
10 questions
Excel
Quiz
•
7th - 11th Grade
11 questions
AP CSP Vocab Quiz BI 1, 2
Quiz
•
9th - 12th Grade
8 questions
Binary Basics
Quiz
•
7th - 11th Grade
15 questions
Y9 Spreadsheets
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
