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
Unit 1: Post Test: Fundamentals of Computer Systems
Quiz
•
10th Grade - University
25 questions
Menerapkan Pembuatan Blog (BO KD 3.15)
Quiz
•
11th Grade
25 questions
Crash Course Computer Science #19 - Memory & Storage
Quiz
•
9th - 12th Grade
25 questions
Electronic Components
Quiz
•
9th - 12th Grade
25 questions
2.6 The Internet Address (IPv4 & IPv6)
Quiz
•
11th - 12th Grade
25 questions
Modern Technologies
Quiz
•
10th - 11th Grade
25 questions
Operating Systems
Quiz
•
9th - 12th Grade
27 questions
Functions of Operating Systems
Quiz
•
8th - 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
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
