Competence-Based ICT Question Bank

Objectives: Competence-Based ICT Question Bank

Competence-Based ICT Question Bank

Competence-Based ICT Question Bank

WORD

  1. Create a professional letter with proper headings and date. What steps would you follow? Answer: Open Word → Choose a template or blank document → Insert Date → Write Sender and Receiver details → Type content → Format headings and paragraph → Save document.
  2. How can you insert a table and merge cells in Word? Answer: Insert → Table → Choose number of rows/columns → Select cells to merge → Right-click → Merge Cells.
  3. Explain how to use styles to format headings consistently. Answer: Home → Styles → Choose heading style → Apply to section titles for consistency throughout the document.
  4. How do you insert a page number at the bottom center of each page? Answer: Insert → Page Number → Bottom of Page → Choose Center alignment.
  5. Describe the process of creating a mail merge for sending letters to multiple recipients. Answer: Mailings → Start Mail Merge → Select Document Type → Select Recipients (Excel or Access) → Insert Merge Fields → Finish & Merge → Print or Email.

EXCEL

  1. Create a grade sheet for a class of 30 students. How would you calculate average, total, and assign grades? Answer: Enter student names and marks → Use =SUM() for total → =AVERAGE() for average → Use IF() function to assign grades based on marks → Format cells for clarity.
  2. How do you create a chart to compare sales data for 6 months? Answer: Select data → Insert → Charts → Choose chart type (e.g., Column Chart) → Add labels and title → Format chart for readability.
  3. Explain how to use conditional formatting to highlight students who scored below 50. Answer: Select marks → Home → Conditional Formatting → Highlight Cell Rules → Less Than → Enter 50 → Choose format → Apply.
  4. How can you protect your Excel sheet from editing? Answer: Review → Protect Sheet → Set password and select permissions → OK.
  5. Explain the use of VLOOKUP to find a student’s mark from a large table. Answer: =VLOOKUP(student_name, table_range, column_number, FALSE) → returns the mark corresponding to the student.

ACCESS (DATABASE)

  1. Create a student database with tables for students, courses, and results. What steps would you take? Answer: Open Access → Create Tables: Students (ID, Name, Class), Courses (ID, Name), Results (StudentID, CourseID, Marks) → Define Primary Keys → Establish Relationships → Save.
  2. How do you create a query to find students who scored more than 70 in Mathematics? Answer: Create → Query Design → Add Students & Results tables → Set criteria Marks > 70 and Course = “Mathematics” → Run query.
  3. Explain the difference between a form and a report in Access. Answer: Form → used to enter and view data interactively. Report → used to format and print data neatly.
  4. How do you prevent duplicate Student IDs in the database? Answer: Set StudentID as Primary Key → Access automatically prevents duplicates.
  5. Explain how to create a relationship between Students table and Results table. Answer: Database Tools → Relationships → Drag StudentID from Students to Results → Enforce Referential Integrity → Save.

POWERPOINT

  1. Create a presentation of 10 slides on school events. What is your workflow? Answer: Open PowerPoint → Choose design/theme → Insert slides → Add titles, content, images → Apply animations/transitions → Review → Save.
  2. How do you insert a video into a slide? Answer: Insert → Video → Choose file or online video → Resize/move → Set playback options.
  3. Explain how to apply the same format to all slides. Answer: Use Slide Master → Apply desired formatting → Close Master View → All slides update automatically.
  4. How can you set the slideshow to run automatically without clicking? Answer: Slide Show → Set Up Slide Show → Browsed at a kiosk (full screen) → Apply timing per slide → Start Slide Show.
  5. Explain how to print slides with notes for a meeting. Answer: File → Print → Select “Notes Pages” → Adjust settings → Print.

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅ ➡