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.

This CBSE Class 8 ICT practice quiz has 20 multiple-choice questions on Spreadsheet Application, and 20 of them come with an explanation. Try the 5 sample questions below (tap an option to check yourself), then play the full quiz 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.

More questions in this quiz

Answers and explanations are in the full quiz.

1. If a spreadsheet cell contains the formula '=A1+A2', what happens if you change the value in A1?
2. Which of the following is a valid function to sum a range of values in Excel?
3. What symbol is used to begin a formula in a spreadsheet?
4. Which keyboard shortcut is used to insert a new worksheet in Excel?
5. In a spreadsheet, which operation would you use to combine text from two cells into one?
6. Which sheet view allows you to see the physical page breaks in your spreadsheet?
7. What is the default extension for an Excel 2010 file?
8. In Excel, what is the maximum number of characters a single cell can contain?
9. What is meant by 'cell formatting' in spreadsheets?
10. In Excel, what does the IF function allow you to do?
11. How can you apply the same formatting from one cell to another in Excel?
12. What does it mean when a cell displays '#####'?
13. Which type of chart would be best to show trends over time in spreadsheet data?
14. Which function calculates the median value in a dataset?
15. Which of the following formulas uses absolute references?

Browse all ICT Tools quizzes

More to play