Paper 3 - Data Analysis and Website Authoring
Quiz
•
Computers
•
10th - 11th Grade
•
Practice Problem
•
Medium
Laura Sherrington
Used 29+ times
FREE Resource
Enhance your content in a minute
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An individual box within a spreadsheet worksheet is known as?
square
range
refernce
cell
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SUM, AVERAGE, MAX, IF and VLOOKUP are examples of what?
Functions
Tables
Formulae
Statistical tools
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A1:D4 is an example of a cell...
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a valid formula?
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Zoe wants to add together a range of cells in her spreadsheet. She would like Excel to add only the cells in the range that are greater than 50. What function should she use?
SUMIF
AVERAGEIF
TOTALIF
COUNTIF
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you see this code, what do you need to do?
#####
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If a student scores over 20 in the exam, the adjacent cell must state PASS otherwise it should say FAIL.
Select the correct formula that must be typed in cell C4.
=IF(B4>20,"PASS","FAIL")
=IF("PASS"=>20,B4,"FAIL)
=IF(<20,B4,"PASS","FAIL")
=IF(B4<20 "PASS","FAIL")
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
25 questions
Introduction to IT
Quiz
•
5th - 10th Grade
25 questions
Common Algorithms
Quiz
•
9th - 12th Grade
25 questions
EmpTech: ICT Intro Long Quiz
Quiz
•
11th Grade
25 questions
Journey Inside
Quiz
•
9th - 11th Grade
25 questions
Inteledge'22 - First Round
Quiz
•
9th - 12th Grade
25 questions
Understanding Input, Selection and Loops in Python
Quiz
•
7th Grade - University
25 questions
Ujian Teori
Quiz
•
11th Grade
25 questions
INFORMATIKA X
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
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
