Accounting Information Systems in a Computer Environment

AIN1501 — SEMESTER 1 2026




Assessment 4
Step-by-Step Guide
Microsoft Excel & Microsoft Teams Portfolio




Total Marks: 50 (Excel: 40 | Teams: 10)
Document Type: Complete Walkthrough Guide
Date: May 2026

,Table of Contents


1. Assessment Overview & Preparation

1.1 Files to Download

1.2 Naming Conventions

1.3 Submission Checklist

2. Question 1: Microsoft Excel (40 Marks)

2.1 Save Your File (Critical)

2.2 Rename the Worksheet

2.3 Merge and Center Cells G1:N1

2.4 Set Column B Width

2.5 Add Your Details in Cell B2

2.6 Text Wrap Cell O1

2.7 Hide Column F

2.8 Calculate Magazine Shop Pay (D6)

2.9 Total Expenses Function (N6)

2.10 Insert Comment in E3

2.11 Count Months Function (E15)

2.12 Add Average Income Label (A16)

2.13 Correct Error in E16

2.14 Lowest Income Function (E17)

2.15 Total Savings Formula (E18)

2.16 Calculate Bonus (E19)

2.17 Save Final Document

3. Question 2: Microsoft Teams (10 Marks)

3.1 Create a Future Meeting

3.2 Start an Instant Meeting

3.3 Raise Your Hand

, 3.4 Share Your Excel Screen

3.5 Save as PDF

4. Formula Quick Reference

5. Troubleshooting Tips