IT Apps - Exercise 5

1. Open a new workbook and develop a spread sheet shown below.
2. Linkup the two worksheet using VLOOKUP function.
3. Follow the following steps:
                                       i.      In worksheet 2, define the grade table.
                                     ii.      Name your table as ‘Grade’.
                                    iii.      Now, go to Worksheet 1, and click cell C5
                                   iv.      Then Fill in the blank, please refer to the notes on how to do so.
                                     v.      Click OK
4. The Cell C5 will be filling with the grade ‘P’, Use AUTOFILL to copy the formula to the other cells.

    Worksheet 1

Worksheet 2

http://mc.tt/a4KgCIv3QD

IT Apps - Exercise 4

Type in the following spreadsheet, and format it to look like the sample below.

1      Type in all text and numbers shown in the spreadsheet below.

2      Format all numbers with appropriate formats.

3      Center the spreadsheet heading 'Total Sales for the Month of November' across the spreadsheet.

4      Format all text as displayed in the sample below, including the rotated text labels.

5      Create formulas to display a total quantity for each fruit.

6      Create formulas to calculate the total sales to each fruit.

7      Apply all borders and shading (color) shown in the sample below, feel free to experiment with your own color schemes.

http://mc.tt/a3KfxmNs7B

IT Apps - Exercise 3

Type in the following spreadsheet, and format it to look like the sample below.

1) Type in all text and numbers shown in the spreadsheet below.
2) Format all numbers as a currency.
3) Center the spreadsheet heading 'Sales and Produce Department' across the spreadsheet.
4) Format all text as displayed in the sample below.
5) Create formulas to display the average sales.
6) Create formulas to display total sales for each salesperson. 

http://mc.tt/75Kfx8ghY9

IT Apps - Exercise 2

Type in the following spreadsheet, and format it to look like the sample below.

1.       Type in all text and numbers shown in the spreadsheet below.

2.       Format all numbers as a currency.

3.       Center the spreadsheet heading 'Sales for the Month' across the spreadsheet.

4.       Format all text as displayed in the sample below.

5.       Create formulas to display a total for each sales rep.

6.       Create formulas to display a total for each product.

7.       Create a formula to calculate the total sales for all sales rep's for the month. 

http://mc.tt/a8KfxHcVHf

IT Apps - Exercise 1

Reproduce the following spread sheet using the Microsoft Excel.
Use Auto fill to fill series for Months and Dates.

http://mc.tt/96KfwBw11Z

INTER-VTI ATHLETICS MEET 2012

THERE was no doubt who were the best team at the 3rd Athletics Championships between Technical and Vocational Institutes on 28th & 29th November at the Balapan Track and Field at the Hassanal Bolkiah National Sports Complex in Berakas.

The Sultan Bolkiah Vocational School (SVSB) were crowned champions after amassing a total of 332 points, almost 100 more than second placed Nakhoda Ragam Vocational School (SVNR) with 239 points.

Seven Institutes competed in the event, with Sultan Saiful Rijal Technical College (MTSSR) finishing third with 220 points.

Jefri Bolkiah Engineering College (MKJB) placed fourth with 179 points followed by Wasan Vocational School (SVW) with 126 points, Business School with 99 points and Mechanic Training Centre (PLM) with 68 points.

-Brunei Time-

Majlis Takzirah Sambutan Awal Tahun Baru 1434 Hijrah & Meraikan Saudara Baru MKJB

On 24th November, we had a function at 'Masjid RPN Kg Pandan' of celebrating the New Year of Hijrah, 1434 and also welcoming a new sister in the Muslim citizen of Brunei.