Computer Skills MCQ

Q: Three spellings of 'Kathmandu' in one column must be:

Correct answer: Standardised to one value before counting. Unstandardised categories split counts and silently corrupt every summary.

Q: A blank cell in a 'discount' column:

Correct answer: Needs a conscious decision: zero, unknown, or not applicable. Missing-value treatment changes results; each interpretation demands different handling.

Q: When one extreme value distorts the summary, prefer the:

Correct answer: Median. The median resists outliers; diverging mean and median also signal skew worth investigating.

Q: An average computed from 4 responses is best treated as:

Correct answer: An anecdote requiring more data. Tiny samples swing wildly; always report and respect the n.

Q: Change over time is best shown with a:

Correct answer: Line chart. Lines encode trends naturally; pies cannot show time at all.

Microsoft Office, Excel, digital literacy and hardware questions.

Q111. Three spellings of 'Kathmandu' in one column must be: Medium

Permalink →

Q112. A blank cell in a 'discount' column: Medium

Permalink →

Q113. When one extreme value distorts the summary, prefer the: Medium

Permalink →

Q114. An average computed from 4 responses is best treated as: Medium

Permalink →

Q115. Change over time is best shown with a: Medium

Permalink →

Q116. A bar chart starting its axis at 95 instead of 0: Medium

Permalink →

Q117. Sales jump every October. Concluding 'the new manager caused October growth' ignores: Medium

Permalink →

Q118. Surveying only current customers about satisfaction suffers from: Medium

Permalink →

Q119. The strongest opening for an analysis brief is: Medium

Permalink →

Q120. Before announcing a finding, a good analyst first: Medium

Permalink →

🎯 Want a real test?

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

Browse Quizzes