1. **Problem Statement:** The user requests instructions for formatting a document in MS Word and creating tables and calculations in MS Excel. 2. **MS Word Formatting (Question 1a):** - Use Tahoma font, size 12. - Write "WELCOME ADDRESS" in uppercase, bold, and center-aligned. - Write the welcome message with the candidate's name and chairman's name. - Start the letter with a Drop Cap. - Set line spacing to 1.15. - Set paragraph spacing after each paragraph to 12 points. - Replace italicized placeholders with actual names. 3. **MS Word Layout (Question 1b):** - Change page orientation to landscape. - Set the page to two columns with a line between. - Copy the letter and paste it into the second column. 4. **Printing (Question 1c):** - Print the document on A4 paper. 5. **MS Excel Tasks (Question 2):** - Launch Excel. - Replace spreadsheet data starting from cell B5. - In cell B3, type your full name in uppercase. - Reproduce the given tables starting from cell B4. - Use formulas to calculate Continuous Assessment (CA) and TOTAL for each record. 6. **Formulas Explanation:** - CA is calculated as $$\text{CA} = 0.15 \times \text{Test 1} + 0.10 \times \text{Test 2} + 0.40 \times \text{Quiz/Assignment}$$ - TOTAL is calculated as $$\text{TOTAL} = \text{CA} + 0.60 \times \text{Exam}$$ 7. **Excel Implementation:** - Enter the formula for CA in the CA column for each row, e.g., for row 5: $$=0.15*C5 + 0.10*D5 + 0.40*B5$$ - Enter the formula for TOTAL in the TOTAL column for each row, e.g., for row 5: $$=E5 + 0.60*F5$$ - Below the table, type the formulas used for the 3rd record (row 7) for CA and TOTAL. - Enter any five names starting from cell A5. 8. **Printing (Question 2f):** - Print the Excel sheet on A4 paper in landscape orientation. - Ensure row and column headings are visible. **Summary:** - The tasks involve document formatting in Word and data entry and formula application in Excel. - The formulas for CA and TOTAL are weighted sums of test scores and exam scores. - Printing instructions specify A4 paper and landscape orientation.