Spreadsheets Quiz - CBSE Class 12 ICT

Free practice quiz: Spreadsheets (CBSE Class 12 ICT). 15 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

Sample questions

1. Which function in a spreadsheet software is used to calculate the sum of a range of cells?

   1. AVERAGE
   2. COUNT
   3. SUM
   4. MAX
   Show answer

   Answer: C. SUM

   The SUM function adds all the numbers in a range of cells.

2. What is the difference between relative and absolute cell referencing?

   1. There is no difference
   2. Relative references change when copied, absolute references do not
   3. Absolute references change when copied, relative references do not
   4. They are both the same
   Show answer

   Answer: B. Relative references change when copied, absolute references do not

   Relative references (e.g., A1) adjust when copied to other cells, while absolute references (e.g., $A$1) remain constant.

3. What is the purpose of data validation in a spreadsheet?

   1. To ensure data accuracy and consistency
   2. To make the spreadsheet look better
   3. To increase the file size
   4. To slow down processing
   Show answer

   Answer: A. To ensure data accuracy and consistency

   Data validation helps enforce rules on the type of data entered into cells, preventing errors.

4. Explain the concept of array formulas in spreadsheets and give an example.

   1. They are not used in spreadsheets
   2. They are used for simple addition
   3. They perform calculations on a range of cells simultaneously returning a single result
   4. They perform calculations on a range of cells simultaneously, potentially returning multiple results or an array
   Show answer

   Answer: D. They perform calculations on a range of cells simultaneously, potentially returning multiple results or an array

   Array formulas process multiple cells simultaneously, performing complex calculations on ranges of data. For example, `{=SUM(A1:A10*B1:B10)}` multiplies corresponding cells and sums the results.

5. Explain how to create a complex spreadsheet model involving multiple sheets, data validation, lookup functions, and conditional formatting to simulate a business scenario (e.g., inventory management).

   1. It is beyond the scope of spreadsheet capabilities
   2. Requires extensive knowledge of spreadsheet features and business processes
   3. Requires use of external database software
   4. This cannot be done without programming knowledge
   Show answer

   Answer: B. Requires extensive knowledge of spreadsheet features and business processes

   This involves integrating multiple spreadsheet features including data validation on input sheets, using VLOOKUP or INDEX/MATCH for lookups between sheets, and conditional formatting to highlight key data points and simulate the flow of a real business scenario. A strong understanding of business logic is crucial for proper model design.

Browse all Data Handling and Analysis quizzes