
BTEC DIT Component 2B
Quiz
•
Computers
•
9th - 11th Grade
•
Practice Problem
•
Hard
Dean Whittle
Used 16+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which one of these features is used to return values from a table
VLookup
Count If
SUMIF
Max
2.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A __________ is used to present data in an easy to understand way?
3.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Select all of the formatting tools
Colours
Border
Formulas
Alignment
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tool is used to ensure data entered is reasonable and sensible?
Validation
Verification
Freeze panes
Comments
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these functions would be used to find the largest number in a range of cells?
Max
Min
Average
Count
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
The ____________ function is used to find the smallest number in a range of cells
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these functions is used to add up the numbers if they meet a criteria
SumIf
CountIf
VLookup
Average
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
11 questions
Threats to Data
Quiz
•
9th - 12th Grade
11 questions
HEALTH AND SAFETY 9
Quiz
•
7th - 9th Grade
15 questions
1.1.1 The structure and function of the processor
Quiz
•
11th Grade - University
10 questions
Basic Parts of Speech EPS
Quiz
•
9th - 10th Grade
10 questions
Fundamentos PHP (Manejo de Fomularios y arreglos)
Quiz
•
9th Grade
15 questions
Quiz 1
Quiz
•
1st - 12th Grade
10 questions
PUNCTUATION SPACING RULES
Quiz
•
9th - 12th Grade
15 questions
# REVIEW 1 DATA TYPES
Quiz
•
10th 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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
