Computer Skills MCQ

Correct answer: =. The equals sign tells Excel the cell contains a formula, not text.

Correct answer: $A$1. Dollar signs lock both column and row: $A$1 is an absolute reference.

Correct answer: Pass when B2 is at least 40, otherwise Fail. IF tests a condition and returns one value when true, another when false.

Correct answer: Filtering. Filters display matching rows without deleting the rest.

Correct answer: Line chart. Line charts are designed for values changing over time.

Microsoft Office, Excel, digital literacy and hardware questions.

Q21. Every Excel formula must begin with: Medium

Permalink →

Q22. Which reference stays fixed when a formula is copied to other cells? Medium

Permalink →

Q23. =IF(B2>=40,"Pass","Fail") returns: Medium

Permalink →

Q24. To show only rows where District = 'Kaski', you would use: Medium

Permalink →

Q25. Which chart type best shows a trend over months? Medium

Permalink →

Q26. COUNTIF is used to: Medium

Permalink →

Q27. In PowerPoint, fonts and logos for all slides are best set in: Medium

Permalink →

Q28. The 6x6 guideline in presentations suggests: Medium

Permalink →

Q29. Freeze Panes in Excel is used to: Medium

Permalink →

Q30. Before printing a spreadsheet you should always: Medium

Permalink →

🎯 Want a real test?

Take a timed quiz on this topic and see your rank on the leaderboard.

Browse Quizzes