All Nighter Stove Review

REVIEW: COMPUTERS

EXCEL EXERCISE:

1) Open the Excel workbook. Place name and surname as a header. Enter the following columns and complete the form with 10 employees.






then make the points below:
2) Insert the title of it (in front) the following "Clover Company SA" in Comic Sans font of 18 pts and red.
3) Perform the following improvements in appearance to that form:
a) Apply to the column headings 12 pt Courier font and blue. Focus in their cells the same labels.
b) Apply borders and shading to improve the presentation of the return.
c) Date Formatting cell to F_Nac column data (eg, 12/12/1975).
d) Format the cell number data from the Salary column, with thousands separator and 2 decimal places.
4) At the end of the Salary column values \u200b\u200band a total free cell below average the same rounding the result to a decimal.
5) Change the order of the columns for Last Name and First Name.
6) At the end of this form, in a column labeled as Prizes, calculate
5% of salary for each employee. Subsequently copied to the data format of the Salary column.
7) Name Sheet1 as employees and remove the leaves without the use of this book.
8) Save the current workbook with the name Personal.xls on the Windows desktop. After closing the program.
9) Reopen the book Personal.xls and it do the following:
a) Select the columns in an interleaved data and apply fill color gray and blue font.
b) At the end of the existing pages in this book, add a new sheet named as Settlement. In the sheet to copy only the columns Name and salary employees.
c) In two free cells of the leaf clearance, get the highest and lowest salaries of employees
. To the right of these cells to add text to describe these values.
10) To enter the data file summary of the current book. Afterwards save the workbook called Personal2.xls on the Windows desktop.

Note: to complete the tasks to send the two files and personal2.xls Personal.xls the mail from the teacher:
prof.patriciazurita @ gmail.com