Adds the values in A4 and B7 together

Multiplies the number in A4 by B7

Multiplies A by 4 and adds it to B multiplied by 7

Finds the total of the numbers between A3 and A17

Adds the values in A3 and A17 together

Tells you how many cells there are between A4 and A17

Finds the mean of the numbers from B3 to B12

Tells you which number is closer to the average, B3 or B12

Adds all the numbers between B3 and B12

Multiplies the value in C16 by 10

Increases the number in C16 by 10%

Adds 2.50 to the number in D1 then multiplies by 100

Shows the number in D1 as a percentage of 2.50

Multiplies D1 by 100 then adds 2.50

Finds the biggest number in the cells between A4 and A27

Tells you which number is in A27

Shows the difference between the numbers in A4 and A27

=IF(F5>50,"Pass","Fail")

Displays Pass or Fail depending on whether a score in F5 is over 50

Displays Pass or Fail depending on whether the number in F5 is bigger than the number in 5O

Displays Pass or Fail depending on whether a score in F5 is equal to 50

Increases the number in D7 by 25%

Multiplies the number in D7 by 25

Shows whether the number in D7 is 25% of another number

Y8 Spreadsheets

Authored by Colin Smethurst

Computers

10th Grade

Used 25+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

25 questions

Show all answers

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Boxes in Spreadsheets are called

Excels

Cells

Cels

Sells

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Data Type for displaying someone's wages

Currency

Text

Number

Date

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Data Type for displaying someone's name

Currency

Text

Number

Date

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Data Type for displaying someone's age

Currency

Text

Number

Date

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Data Type for displaying someone's birthday

Currency

Text

Number

Date

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

=A4+B7

Formula

Function

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

=SUM(A3:A17)

Formula

Function

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

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

iGCSE Computer Science: Internet & WWW

Quiz

•

9th - 12th Grade

20 questions

AQA GCSE Computer Science - 3.2.10 Subroutines

Quiz

•

8th - 10th Grade

20 questions

Big Idea 2: Data Questions

Quiz

•

9th - 12th Grade

20 questions

IGCSE ICT Web Authoring M

Quiz

•

9th - 10th Grade

20 questions

Bài 5. Thao tác với bảng tính

Quiz

•

1st - 12th Grade

20 questions

OCR J276 - 1.1 Computer Architecture

Quiz

•

9th - 11th Grade

20 questions

Cambridge Nationals LO4

Quiz

•

10th Grade

20 questions

Informatika X SMK

Quiz

•

10th Grade

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

Exploring Valentine's Day with Charlie Brown

Interactive video

•

6th - 10th Grade

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

20 questions

-AR -ER -IR present tense

Quiz

•

10th - 12th Grade

10 questions

Valentine's Day History and Traditions

Interactive video

•

6th - 10th Grade

21 questions

Presidents Day Trivia

Quiz

•

6th - 12th Grade

10 questions

Valentine's Day: History and Modern Celebration

Interactive video

•

9th - 12th Grade

11 questions

Valentine's Day Trivia

Quiz

•

8th - 12th Grade

10 questions

Factor Quadratic Expressions with Various Coefficients

Quiz

•

9th - 12th Grade

Y8 Spreadsheets

Boxes in Spreadsheets are called

Data Type for displaying someone's wages

Data Type for displaying someone's name

Data Type for displaying someone's age

Data Type for displaying someone's birthday

=A4+B7

=SUM(A3:A17)

=AVERAGE(B3:B12)

=C16*10

=(D1+2.5)*100

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers