excel mock test - Quiz Questions (Page 1 of 2)
This quiz contains 20 questions.
Question 1: What symbol is used to start a formula in Excel?
Question 2: What is the shortcut for saving a file?
- Ctrl + X
- Ctrl + S (Correct Answer)
- Ctrl + P
- Ctrl + C
Question 3: Which feature allows you to repeat the last action?
- Redo
- Save
- Copy
- Repeat (Correct Answer)
Question 4: How do you select an entire row in Excel?
- Click on the row number (Correct Answer)
- Click on the column letter
- Press Shift + Enter
- Press Ctrl + A
Question 5: Which function returns the average of a range?
- AVERAGE (Correct Answer)
- SUM
- COUNT
- MIN
Question 6: What does 'Ctrl + Z' do in Excel?
- Undo (Correct Answer)
- Redo
- Paste
- Save
Question 7: Which feature is used to organize data in ascending or descending order?
- Sort (Correct Answer)
- Filter
- Pivot Table
- Chart
Question 8: What is the cell reference for a range covering from B2 to D10?
- B2:D10 (Correct Answer)
- D10:B2
- B2 to D10
- B2:D9
Question 9: What's the function of the Fill Handle in Excel?
- Copy the cell contents (Correct Answer)
- Insert a chart
- Set a formula
- Print the sheet
Question 10: Which function would you use to find the highest number in a range?
- MAX (Correct Answer)
- MIN
- AVG
- LOW
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.
