Tasks Sessions

Tasks Sessions

Tasks MS WORD

1- Save the file with password "success".
2- Split page to 3 columns as newspaper.
3-Make the first letter "drop cap".
4- Change case to upper case.
5- Change line space to 1.3.
6- Insert page number start at 73.
7- Make border of the page with color blue.
8- Write "work hard play hard" and make border for it.
9-Make header of page to be "Human Resources" and footer
"Edu.Master"
10- Write A2 A5 , H2O , X2 , © ® 

Fail Success
11- Insert table 5 columns, 4 rows.
12- Merge two cells .
13- Split cell to
14- Change text direction in any cell.
15- Alight the text in the first row to center.
16- Make shading for the first row and first column.
17- Add column after column 1.
18- Make border for the table.
19-Hide border of the table when print it.

20- Insert image from clipart and make it washout and write Egypt
on it.
21- Insert picture from word art with name
"You must change life"
22- Change the language of the number to Hindi.
23- Insert picture as background.
24- Change the language of the number to be able to change it from
key board.
25- Change properties of page setup to print 2 pages on one sheet.
26- Make background of the page Edu.Master.
27-Make 10 Certificates by mail merge

Tasks Excel

Tasks MS EXCEL
1- Save the file with password p@ssword.
2- Add custom list [lcd- laptop – monitor]
3- Hide the value of cell when equal to zero.
4- Make column "D" accept number from 50 to 100 only and if you enter invalid
number show massage with
"The number you enter is not valid please type numbers from 50 to 100 ".
5- Make format of column "E" with currency format.
6- Change orientation of the page to landscape.
7- Change the scale of the page to be 1 page wide 2 page tall
(Explain what this mane).
8- Center the data on page while printing.
9- Repeat row one on printing on every page.
Write this values in excel sheet

70      175      55      100
85       30      200      50
10      220      20      150

Using conditional format
a- The values greater than or equal 50 with red color.
b- The values less than 50 with blue color.
c- The values greater than 100 with color green.

Application

Category     Price      Amount     Fees     Sale     New Sale
Cat1             45            20          10        70
Cat2             40            25           8         60
Cat3             52            20          12        75
Cat4             55            30           7         73
Cat5             40            35          10        45

1- Calculate the earn for every category.
2- Calculate the total earn.
3- Calculate the maximum of the price .
4- Calculate the average of fees and round it to one decimal places.
5- If fees exceed or equal 10 add the difference to to sale to be new sales .
6-Calculate the number of category that it's price exceed 45.
7- Calculate the price of category if price exceed 47 .

Chart
A-Draw chart between (Category – Price –Amount - Fees)
B-Show values on the columns.
C-Show data table below chart.

Tasks Access

1- Create database called Emp.
2-Create table named Employee.

a- Job lookup wizard with jobs (admin – it – sales – marketing)
b-the name of company is auto (Edu Master)
c-salary don't less than 2000 and message if any wrong salary
d- Date of today auto.
e- Code of employee 3 numbers only.
3- Make a query on staff population Alex .
4- Make a query from the staff salary greater than or equal to 2500 .
5- Make a form to enter data in the Employees table.
6- Create a report on staff that salary is greater than 2700 .
7- Create table varieties, and linking it with Employee Table.

8-
a- Make a report on items bought by the staff.
b- So that it appears (the name of the employee - salary – product he bought - the price of
product)
c- Groups by salary.
d- Sort depending on the employee's Price.