excel test questions - Quiz Questions (Page 2 of 2)
This quiz contains 20 questions.
Question 11: How do you add a new worksheet?
- Click '+' sign next to sheets (Correct Answer)
- Delete a sheet
- Rename a sheet
- Close a sheet
Question 12: How do you apply a filter?
- Use Filter button (Correct Answer)
- Open Help
- Format Painter
- Use Conditional Formatting
Question 13: Where do you find 'Freeze Panes'?
- View tab (Correct Answer)
- Home tab
- Data tab
- Insert tab
Question 14: What is VLOOKUP used for?
- Search data vertically (Correct Answer)
- Create a graph
- Change text color
- Print a document
Question 15: Which key starts editing a cell?
- F2 (Correct Answer)
- F4
- F1
- F3
Question 16: How can you ensure data is accurate?
- Use Data Validation (Correct Answer)
- Change cell color
- Resize cells
- Print worksheet
Question 17: What does the 'Merge Cells' option do?
- Combines cells into one (Correct Answer)
- Splits data
- Hides cells
- Copies text
Question 18: Which function adds numbers automatically?
- AutoSum (Correct Answer)
- Data Sort
- Cell Align
- Print Function
Question 19: What does 'Ctrl+Z' do?
- Undo last action (Correct Answer)
- Save file
- Redo last action
- Open a new window
Question 20: Where is the 'Conditional Formatting' tool?
- Home tab (Correct Answer)
- Data tab
- View tab
- Insert tab
Try this quiz to check your Excel skills. It has questions on data organization, formula use, chart creation, and keeping your spreadsheets neat. This test is made to help you practice the basics and some advanced parts of Microsoft Excel, perfect for work or school in India. Spend a few minutes and see how comfortable you are with Excel!
