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.

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.

Browse all Spreadsheet Basics quizzes