Pshoriasis And Swollen Lymph Nodes

period of 2 Activities

MICROSOFT EXCEL

BASIC CONCEPTS

ACTIVITY (1) ...

Ratings Make a spreadsheet where it is determined in accordance at the age of 10 people if they can or not to vote for the election. The program should ask for data sigueintes:

• Name
• Last
• Sex
• Age
• State.

Note: The status field should display a message automatically after typing the age as to whether this may vote or not.

ACTIVITY (2) ... Bill
In a data warehouse need to organize relevant to procurement, through a daily invoice data required are: quantity of paper, detailed article, unit value and total value per item, you must calculate the total bill considering the amount per article should not exceed 5 or be below 3 plus the unit value must be between $ 1500 and $ 9000. Note: The invoice must determine the total purchase taxes.

NOTE: The invoice must respond to 10 items comestibes.Formulas Used:

Total Value Per Item = Number of Item Unit Value
* Subtotal = Sum (Total value per item)
Iva = Subtotal * 16%
Invoice Total = Subtotal + Iva

• .... SEE INVOICE TEMPLATE
• SEE INVOICE TEMPLATE 2

ACTIVITY (3) Centro Clinico

In a clinical center is required to know the people who may or may not donate blood, considering that the blood type that requires the entity's health (O-). The data should ask are: Name, Surname, Sex, Age, Height, weight, blood type and state. encuenta should be a parameter of age and that people must be over 17 years old but should not exceed 60 years. eventually must calculate the most weight, lower height and average age of donors ...

Note: " The template must corespond for a listing 10 people "

• View Clinical Center Template ... 1 ....... Name and Age Plot
• View template ... 2 Clinical Center. Plot name and weight ......

ACTIVITY (4)

MENU OPTIONS ...... ................ <<<>>>