MAKE IT YOURS

A world for every learner

Choose a grade to discover its colours and creative world.

Grade 7 Spreadsheet Formulas Worksheet with Answers

Grade 7 (US) · Year 8 (UK) · Class 7 (India) · Computer Science

Unit 1: DataSpreadsheetsCSTA 2-DA-08

Working out what spreadsheet formulas like =SUM, =AVERAGE, =MAX and =B2*C2 will show. This free middle school worksheet has 12 questions and a full answer key. Print it or save it as a PDF — every answer is checked by code, not guessed.

Save to PinterestJump to answer key
  • Answer keys checked by code
  • No ads, ever
  • No student accounts needed
  • Safety & privacy
Practice Sheetaethelsystems.com

Spreadsheet Formulas

Grade 7 · Computer Science

Score___ / 12

Name

Class

Date

Learning goal: Spreadsheets · CSTA 2-DA-08

Directions: Read each question carefully and write your answer on the line. Use the diagram to help you.

RememberSpreadsheet formulas

=B2the value in B2=SUM(A1:A4)add A1 to A4=AVERAGE(…)sum ÷ how many=MAX / =MINlargest / smallest
  1. 1

    What will the formula =A2*B2 show?

    fx=A2*B2ABC1112322291831220284162412
  2. 2

    What will the formula =MAX(A1:A4) show?

    fx=MAX(A1:A4)ABC12720282232628323242419198
  3. 3

    What will the formula =SUM(A1:A4) show?

    fx=SUM(A1:A4)ABC192532121929351154241923
  4. 4

    What will the formula =A3*B3 show?

    fx=A3*B3ABC1928102303010327194222211
  5. 5

    What will the formula =SUM(C1:C4) show?

    fx=SUM(C1:C4)ABC11251929102347942126
  6. 6

    What will the formula =A1*B1 show?

    fx=A1*B1ABC1162521186312222848511
  7. 7

    What will the formula =A4*B4 show?

    fx=A4*B4ABC171929221221731225124301814
  8. 8

    What will the formula =SUM(C1:C4) show?

    fx=SUM(C1:C4)ABC131452217183231410419137
  9. 9

    What will the formula =MAX(B1:B4) show?

    fx=MAX(B1:B4)ABC17121022923132294112011
  10. 10

    What will the formula =MAX(C1:C4) show?

    fx=MAX(C1:C4)ABC1152426265283122234121828
  11. 11

    What will the formula =MAX(C1:C4) show?

    fx=MAX(C1:C4)ABC128311286213306184282725
  12. 12

    What will the formula =MAX(B1:B4) show?

    fx=MAX(B1:B4)ABC1192514224303352022418918

★ Challenge corner for fast finishers

How many different patterns can 4 bits make?

8421

How did I do?

Teacher's comments

Free printable worksheets with answer keys · aethelsystems.com/worksheets/computer/7/spreadsheet_formulas

Answer key (click to show)
  1. 1.58
  2. 2.27
  3. 3.50
  4. 4.14
  5. 5.36
  6. 6.32
  7. 7.540
  8. 8.40
  9. 9.22
  10. 10.28
  11. 11.25
  12. 12.30
  13. ★16 (challenge corner)

Need another Spreadsheet Formulas worksheet?

Generate unlimited fresh versions at easy, medium or hard difficulty, each with its own answer key. Free during our launch — no card needed.

Create a free account

How to use this worksheet

  • Works well as a bell-ringer, exit ticket, homework set or quick quiz.
  • Have students self-check with the answer key, then correct their own mistakes before you review.
  • Generate a new version of the same topic for a re-test, so students can't just memorise the answers.

Related worksheets

Spreadsheet Formulas at other grades

Grade 8

More Grade 7 Computer Science worksheets

Grade 7 Binary NumbersGrade 7 Bits, Bytes & Data SizesGrade 7 Robot Algorithms on a GridGrade 7 Tracing LoopsGrade 7 FlowchartsGrade 7 Boolean ExpressionsGrade 7 Logic GatesGrade 7 Networks & the Internet

Can't find what you need? Tell us which worksheet to make next.

Frequently asked questions

Does this Grade 7 Spreadsheet Formulas worksheet come with answers?

Yes. The full answer key is on this page, and it prints on its own page after the questions. Every answer is calculated or checked by code rather than written by an AI model, so the key is always correct.

How do I print it or save it as a PDF?

Click "Download PDF" to save a ready-to-print PDF with the answer key on the last page, or click "Print" to send the worksheet and answer key straight to your printer.

Can I get a different Spreadsheet Formulas worksheet?

Yes. Create a free account to generate as many fresh Grade 7 Spreadsheet Formulas worksheets as you like, at easy, medium or hard difficulty, each with its own answer key.

Is this worksheet free?

Yes. This worksheet is free to print, and Practice Sheet is free to use during our launch with no card needed.