اردو

Home / Practice / Spreadsheets / Worksheet

Practise online

Spreadsheets

Class 10 · Computer Science · 5 questions

Name: ____________________   Date: ____________

  1. A formula in a spreadsheet starts with:

    • A #
    • B =
    • C ?
    • D @

  2. Which function adds the numbers in a range?

    • A MAX
    • B SUM
    • C AVG only
    • D COUNT

  3. The intersection of a row and a column is a:

    • A Cell
    • B Workbook
    • C Range
    • D Sheet

  4. What does =A1+B1 do?

    • A Adds the values in A1 and B1
    • B Multiplies A1 and B1
    • C Joins the texts
    • D Deletes A1

  5. Which function finds the largest value in a range?

    • A MAX
    • B SUM
    • C MIN
    • D COUNT

Answer key

1. B, 2. B, 3. A, 4. A, 5. A

  1. All formulas begin with an equals sign.

  2. SUM adds values.

  3. It is called a cell.

  4. It adds the two cell values.

  5. MAX returns the largest value.