Excel Practice Section – 20 Questions + 1 Practical Task
Comprehensive Excel Assessment for Delhi Police / SSC Exams
After learning all Excel topics — Interface, Formulas, Charts, Formatting, Sorting, Filtering, Shortcut Keys — it's time to test your skills.
Objective Questions (PYQs & Practice)
Which shortcut is used to create a new workbook?
Options: (a) Ctrl + O (b) Ctrl + N (c) Shift + F11 (d) Ctrl + S
Category: Shortcuts
Show Answer
Ctrl + N
What does the shortcut Alt + = do in Excel?
Options: (a) Copy (b) AutoSum (c) Paste (d) Filter
Category: Shortcuts
Show Answer
AutoSum
Which of the following is NOT an Excel data type?
Options: (a) Number (b) Text (c) Date (d) Paragraph
Category: Data Types
Show Answer
Paragraph
To apply conditional formatting, you go to which tab?
Options: (a) Home (b) Insert (c) Data (d) Review
Category: Ribbon Navigation
Show Answer
Home
Which formula gives the average of numbers in Excel?
Options: (a) =SUM(A1:A5) (b) =AVG(A1:A5) (c) =AVERAGE(A1:A5) (d) =MEAN(A1:A5)
Category: Formulas
Show Answer
=AVERAGE(A1:A5)
To display formulas in a worksheet, which shortcut is used?
Options: (a) Ctrl + F (b) Ctrl + ~ (c) F2 (d) Ctrl + H
Category: Shortcuts
Show Answer
Ctrl + ~
Which chart type is best for showing percentage distribution?
Options: (a) Line Chart (b) Pie Chart (c) Column Chart (d) Area Chart
Category: Charts
Show Answer
Pie Chart
Which of the following filters is used to show rows containing specific text?
Options: (a) Number Filter (b) Date Filter (c) Text Filter (d) Color Filter
Category: Filtering
Show Answer
Text Filter
To select the entire column in Excel, which shortcut is used?
Options: (a) Shift + Space (b) Ctrl + Space (c) Ctrl + A (d) Alt + Space
Category: Shortcuts
Show Answer
Ctrl + Space
Which shortcut inserts the current date in a cell?
Options: (a) Ctrl + ; (b) Ctrl + Shift + ; (c) Ctrl + D (d) Ctrl + T
Category: Shortcuts
Show Answer
Ctrl + ;
Practical Task – Make a Marksheet
Task: Create an Excel marksheet for 5 students
Required Structure:
| Student Name | Roll No | Maths | English | Science | Total | Percentage | Grade |
|---|
Instructions:
Conditional Formatting Requirements:
Marks < 33 → Red fill
Marks ≥ 75 → Green fill
Pro Tips:
- Use AutoSum for Total column
- Use IF formula to assign Grades (e.g.,
=IF(F2>=75,"A",IF(F2>=50,"B","C"))) - Use Color Scales to visualize highest and lowest marks
- Apply Borders, Bold Headings, and Center Alignment
- Save the file as Marksheet_Practice.xlsx
Recap & Tricks
20 PYQs cover Shortcuts, Formulas, Formatting, Charts, Filtering, Sorting, Conditional Formatting
Practical task simulates a real exam scenario — marking sheet for students
Conditional Formatting + Formulas = Score booster in exams
Practice task helps remember multiple Excel tricks in one go
Always check shortcuts & formulas before submission
Master Excel for Delhi Police Exam!
Join Courage Library for comprehensive study materials and expert guidance.
Be a Couragian!