Search Header Logo

Paper 3 - Data Analysis and Website Authoring

Authored by Laura Sherrington

Computers

10th - 11th Grade

Used 29+ times

Paper 3 - Data Analysis and Website Authoring
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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

Media Image

A1:D4 is an example of a cell...

Range
Selection
Highlight
Choice

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which of the following is a valid formula?

=sum(A1:A6)
sum=(A1:A6)
=sum[A1:A6]
=sum(A1,A6)

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?
#####

Check your function syntax
Re-enter the function formula
Widen the column
Use a different function

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?