Using Microsoft Excel Quiz - CBSE Class 4 ICT

Free practice quiz: Using Microsoft Excel (CBSE Class 4 ICT). 20 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 4 ICT practice quiz has 20 multiple-choice questions on Using Microsoft Excel, 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 basic function of a spreadsheet?

   1. Word processing
   2. Data organization
   3. Graphic design
   4. Web browsing
   Show answer

   Answer: B. Data organization

   A spreadsheet is primarily used for organizing and manipulating data in tabular form.

2. How do you create a new worksheet in Excel?

   1. File > New
   2. Insert > Worksheet
   3. Home > New
   4. View > Worksheet
   Show answer

   Answer: B. Insert > Worksheet

   You can create a new worksheet by clicking on the 'Insert' menu and choosing 'Worksheet'.

3. In Excel, what does the CONCATENATE function do?

   1. Combines text from multiple cells
   2. Calculates totals
   3. Modifies cell format
   4. Sorts data
   Show answer

   Answer: A. Combines text from multiple cells

   The CONCATENATE function is used to join text from different cells into one cell.

4. What happens if you press Ctrl + Z in Excel?

   1. Redo the last action
   2. Undo the last action
   3. Save the file
   4. Open a new workbook
   Show answer

   Answer: B. Undo the last action

   Pressing Ctrl + Z will undo the last action taken in Excel.

5. In Excel, if you want to protect a workbook with a password, where do you find this option?

   1. File > Info
   2. Home > Protect
   3. Data > Security
   4. View > Password
   Show answer

   Answer: A. File > Info

   To protect a workbook with a password, go to 'File', click on 'Info', and find the protection options.

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which of the following is an example of a spreadsheet software?
2. What is the default file extension for a Microsoft Excel file?
3. In Microsoft Excel, what function would you use to add numbers?
4. Which of the following tools allows you to make changes to a cell?
5. What does the AutoSum button do in Excel?
6. If you want to sort data in Excel, which option do you use?
7. To create a chart from selected data in Excel, you would use which feature?
8. If you need to reference a variable in another sheet using a formula, what is the syntax?
9. How can you freeze panes in Excel?
10. Which key combination selects the entire worksheet in Excel?
11. What function in Excel would you use to find the maximum number in a range?
12. If you wanted to create a drop-down list in a cell, which feature would you use?
13. What is the maximum number of rows in a single worksheet in Excel 2016 and later?
14. How do you calculate the average of a range of cells in Excel?
15. If you need to display a message if a condition is true, which function would you use?

Browse all Spreadsheet Basics quizzes

More to play