Spreadsheet Application Quiz - CBSE Class 8 ICT

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

Sample questions

1. What is the cell reference for the cell located in the first column and second row of a spreadsheet?

   1. A2
   2. B1
   3. C1
   4. A1
   Show answer

   Answer: A. A2

   The columns are labeled alphabetically and rows are numbered. The reference A2 refers to the first column (A) and the second row (2).

2. What formatting can you apply to a cell in Excel to display numbers as currency?

   1. Bold
   2. Currency Format
   3. Italic
   4. Underline
   Show answer

   Answer: B. Currency Format

   To display numbers as currency, you need to apply a 'Currency Format'. This changes the numerical value to include a currency symbol and two decimal places.

3. How do you freeze the first row of a spreadsheet so that it is always visible?

   1. Use the 'Freeze Panes' option
   2. Highlight the row and press Alt + F
   3. Select 'Keep Visible' from the menu
   4. Lock the spreadsheet
   Show answer

   Answer: A. Use the 'Freeze Panes' option

   The 'Freeze Panes' feature in spreadsheet applications allows you to keep the first row visible as you scroll through the rest of the spreadsheet.

4. What is the shortcut key for 'Undo' in spreadsheet applications?

   1. Ctrl + Z
   2. Ctrl + Y
   3. Ctrl + U
   4. Ctrl + R
   Show answer

   Answer: A. Ctrl + Z

   Ctrl + Z is the universally adopted shortcut key command used to undo an action in most software applications, including spreadsheets.

5. Which function would you use to find the largest number in a set?

   1. MIN()
   2. MAX()
   3. AVERAGE()
   4. COUNT()
   Show answer

   Answer: B. MAX()

   The MAX() function calculates the maximum value, or largest number, in a selected range of cells.

Browse all ICT Tools quizzes