excel mock test - Quiz Questions (Page 2 of 2)
This quiz contains 20 questions.
Question 11: What is the default file extension for Excel 365?
- .xlsx (Correct Answer)
- .xls
- .csv
- .doc
Question 12: How can you create a chart from selected data?
- Insert Tab (Correct Answer)
- Home Tab
- View Tab
- File Tab
Question 13: Which key combination is used for copying cells?
- Ctrl + C (Correct Answer)
- Ctrl + X
- Ctrl + V
- Ctrl + S
Question 14: What feature allows text to continue on the next line within a cell?
- Wrap Text (Correct Answer)
- Merge Cells
- Center Align
- Shrink Text
Question 15: Which tool helps to summarize data quickly by columns and rows?
- Pivot Table (Correct Answer)
- VLOOKUP
- Data Validation
- Conditional Formatting
Question 16: What's the maximum number of worksheets in a workbook by default?
- There is no limit (Correct Answer)
- 1
- 255
- 10
Question 17: How do you add a new worksheet in Excel?
- Click the plus icon (Correct Answer)
- Press Ctrl + W
- Use the Save As option
- Drag and drop a sheet
Question 18: Which key is used to edit the active cell?
- F2 (Correct Answer)
- F4
- Enter
- Esc
Question 19: What does a red triangle in the corner of a cell indicate?
- A comment (Correct Answer)
- An error
- A hyperlink
- Cell locked
Question 20: How do you apply a filter to a data range?
- Data Tab -> Filter (Correct Answer)
- Home Tab -> Format
- Insert Tab -> Chart
- File Tab -> Open
Give our Excel mock test a try and boost your skills in managing sheets, working with data, and using formulas. This fun practice test is made to help you become better in Microsoft Excel, whether you study or work in India. Get hands-on practice to master real tasks in spreadsheet management and data analysis. It’s easy, straightforward, and perfect for anyone looking to improve their Excel knowledge.
