Class 9 Computer — MS Office Important Questions with Answers (Long answers)

Word: edit a notice, apply fonts, bullets, header, page setup, mail merge, shortcuts Ctrl+S/B/C/V. Excel: enter a mark list, =SUM, average, simple IF if taught, make a column chart, freeze header row. PowerPoint: 5–6 slides on a lesson, readable font, F5, slide sorter. Common errors: forgetting = in Excel, too much text on a slide, not saving. Mention file extensions .docx .xlsx .pptx so the OS opens the right app.

A formula starts with = and can use + − * /. Functions such as SUM, AVERAGE, MAX, MIN take ranges: =AVERAGE(B2:B31). Cell references change when you fill down if they are relative. Make a bar chart of subject averages. Freeze the header. Common error: typing SUM(A1:A5) without =. Save as .xlsx. This is the usual Class 9 practical pattern.

Slide 1 title and name. 2: strong passwords and OTP. 3: phishing example in words (no real scam kit). 4: cyberbullying — tell an adult. 5: bibliography and a thank-you. Large font, one image with credit, F5 to present, 3–4 minutes speech. Avoid copying whole websites onto the slide. Save as .pptx on the school drive and a backup.