Search Header Logo

Year 12 - end of 2nd half term

Authored by undefined Dean

Computers

6th Grade

Used 15+ times

Year 12 - end of 2nd half term
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have created a spreadsheet to budget for your summer holiday. What function would you use to find the total cost?

=AVERAGE

=MIN

=MAX

=SUM

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the following: =(A1/A2)*100

A statement

A formula

A function

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What type of lookup would you use if the data in the lookup table is set out in columns like the image?

=VLOOKUP

=LOOKUP

=HLOOKUP

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What type of lookup would you use if the data in the lookup table is set out in rows like the image?

=VLOOKUP

=LOOKUP

=HLOOKUP

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to count up the number of students entered into a spreadsheet and just have their names. Which function would you use to do this?

=COUNT

=COUNTA

=COUNTIF

=SUM

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

You want to use an if statement to show the grade a student has attained for their last Math's assessment. They took the higher paper so can only get A*-C. How many IF's will there be in this function - in other words how many true values are there?

1

2

3

4

5

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have a list of student numbers for each form group in the school and want to see the biggest group size. What function will you use to do this?

=MIN

=MAX

=COUNT

=SUM

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?