Any2Quiz
CBSE / 11 / ICT / Electronic Spreadsheet

Introduction to Electronic Spreadsheet Quiz - CBSE Class 11 ICT

Free practice quiz: Introduction to Electronic Spreadsheet (CBSE Class 11 ICT). 20 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

Play all 20 questions free

Sample questions

  1. What is an electronic spreadsheet?

    1. A program for creating presentations
    2. A program for creating documents
    3. A program for organizing data in rows and columns
    4. A program for browsing the internet
    Show answer

    Answer: C. A program for organizing data in rows and columns

    An electronic spreadsheet is a software application designed to organize and manipulate data in a grid format of rows and columns.

  2. What is the purpose of a formula in a spreadsheet?

    1. To display text
    2. To perform calculations
    3. To format cells
    4. To insert images
    Show answer

    Answer: B. To perform calculations

    Formulas are used to perform calculations and manipulate data within the spreadsheet.

  3. Explain the difference between a relative and absolute cell reference.

    1. There is no difference
    2. Relative references change when copied, absolute references don't
    3. Absolute references change when copied, relative references don't
    4. They are used for different data types
    Show answer

    Answer: B. Relative references change when copied, absolute references don't

    Relative references adjust when copied to new locations, while absolute references remain constant.

  4. How can you sort data in a spreadsheet?

    1. Manually rearranging cells
    2. Using the built-in sorting feature
    3. Using a formula to reorder data
    4. There is no way to sort data
    Show answer

    Answer: B. Using the built-in sorting feature

    Most spreadsheet software provides a built-in sorting tool to organize data.

  5. Explain the concept of 'what-if' analysis in spreadsheets and how it is useful.

    1. It's a way to predict future outcomes based on different inputs
    2. It's a way to format cells
    3. It's a way to sort data
    4. It's a way to print spreadsheets
    Show answer

    Answer: A. It's a way to predict future outcomes based on different inputs

    'What-if' analysis lets you change input values to see how they affect the results of formulas.

Take the full quiz

More quizzes

Browse all Electronic Spreadsheet quizzes