Reference no: EM132506136
BIT100 Introduction To Information Technology Skills Assignment - Emirates College of Technology, UAE
Instructions - This assignment contains two separate questions: the first related to the Word processing and the second related to the Excel sheet. You are required to submit two files - word file for the first question and excel file for the second question.
Question 1 - Word Processing
Create a new document using Ms. Word and apply the following requirement on your document:
1. Save the document with your name and ID.
2. Add a header with your name and insert the date (do not type it.).
3. Select or type a paragraph with 4 lines and apply the following format:
a. Make the paragraph as two columns with line between.
b. Change the font type to "Arial" and the font size to "14" point.
c. Justify the paragraph.
d. Bold (e.g. X).
e. Double underline (e.g. X).
f. Subscript (e.g. X2).
g. Strikethrough (e.g. X).
4. Insert multilevel lists (level 1 with numbering format and level 2 with bullets format).
5. Add word art with the text "Assignment#2" with the transform effect.
6. Add a picture with style effect; you can download the picture from the internet.
7. Shape with your name and apply a glow effect.
8. Insert table that contains three columns with five rows and fill it with related words.
a. Merge the first row as one cell.
b. Apply a text direction on any text cell.
c. Apply different borders on the table border.
9. Add page border.
10. Write your name as "Watermark".
Question 2 - Excel Sheet
Create a new spreadsheet as shown in the figure 1. This sheet represents the expenses spend on each month. Apply the following requirement on your spreadsheet:
1. Save the spreadsheet with your name and ID.
2. Rename the sheet1 by your name.
3. Merge Across cells of range A12:C14.
4. Wrap text cells in the row 13.
5. Put borders in the two tables as shown in the figure below.
6. Enter all name of expenses and theirs numbers of each month.
You are free to choose the expenses following the domain that you like.
All numbers should be between 50 and 500.
Change the formatting of the numbers to dollars with two decimal places.
7. Insert new row and write the title "Monthly Budget".
To be with a good look, Center and merge it.
Change the font to Baskerville Old Face, size 18.
Make the text white and the fill black.
8. Insert below, another row and write the subtitle "January 2005 - June 2005."
To be with a good look, Center and merge it.
Change the font to Baskerville Old Face, size 10.
Make text white and fill black.
9. Center, bold and gray shading for the headings (months and average) and change the font to Baskerville Old Face.
10. Bold the first column of the two tables and change the font to Baskerville Old Face and make all numbers center.
11. Calculate the total of the expenses at the bottom of each month and widen columns if necessary so numbers can be seen.
12. Calculate the average for each row as shown in the figure below.
13. Find the appreciation for each month with total more than or equal to 1000 is called "High", otherwise is called "Low" and make them center.
14. Below your total row, enter freely the values to the income for each month. Each value should be more than or equal its corresponding expenses total.
15. In the benefit row, calculate the difference between the income and the expenses (total).
Benefits=Income-Total.
16. Calculate the maximum of an expense that you choose.
17. Calculate the number of month expenses that you choose more than 300$.
18. Calculate the number of expenses.
19. Create a bar chart in a new sheet named "income-expenses" that looks like the example of the figure 2. This will be for income and total expenses for each month
Write the title.
Add data label on each bar.
Attachment:- Introduction To Information Technology Skills Assignment File.rar