How2Excel 3 - Basic functions
9th Grade
•10 Qs
Similar activities
Викторина информатика "Компьютерные гении"
9th Grade
•15 Qs
Función CONTAR
KG - Professional Development
•10 Qs
Kiểu dữ liệu xâu kí tự - xử lí xâu kí tự
9th - 12th Grade
•14 Qs
DATA ANALYSIS 101 (Formulas / Functions)
8th - 9th Grade
•11 Qs
kiểm tra 15 phút tin 7
6th - 9th Grade
•10 Qs
Y8 Recap
7th - 9th Grade
•10 Qs
ÔN TẬP TIN HỌC 7 TUẦN 7 25-30/10/2021
6th - 9th Grade
•15 Qs
Python Basics
KG - University
•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
12 questions
9.1.6 - Starter Quiz
Quiz
•
8th - 9th Grade
10 questions
If-Statements
Quiz
•
9th - 12th Grade
12 questions
9 кл. Табличний процесор. Підсумковий тест
Quiz
•
9th Grade
12 questions
Syllabus Quiz FA25
Quiz
•
9th Grade
10 questions
Таблицы Excel
Quiz
•
7th - 9th Grade
13 questions
KS4 Python While Loops and For Loops
Quiz
•
9th - 11th Grade
10 questions
Data validation and verification
Quiz
•
7th - 11th Grade
10 questions
Make Pixel Art with Google Sheets
Quiz
•
7th - 12th 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
