Recommended Videos:
1) Create an Excel workbook named Actividad2.xls as the columns as shown in the picture below and the name of 5 people, their names, birth date, section or work area in the company and finally salary.
then make the points below.
2) Insert a row before, LAST and place as the title of the same the following "educational institution PEDRO OCTAVIO AMADO" in font or Arial 18 point size, bold and red.
3) Perform the following improvements in appearance to that form:
a) Apply to the column headings 12 pt Courier font (or similar) and blue. Focus in their cells the same titles.
b) Apply borders and shading to improve the presentation of the return.
c) Apply cell formatting to data Date column F_Nac (eg 12/12/1975). Giving right click on the cell and the cell format option.
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) At the end of this form, in a column positioned as title word Commission to calculate the 5% of salary for each employee. Later copy of this column committee data format of the column salaries.
7) Name Sheet1 as employees and remove the leaves without the use of this book.
8) At the end of existing sheets in this book, add a new sheet named as Settlement. In the sheet to copy only the columns Name and salary employees.
9) in two free cells of the leaf clearance, get the highest and lowest salaries of the employees using the function = MAX () and = MIN (). To the right of these cells to add text to describe these values, ie this is the higher salary and the salary is lower.
10) Share google docs document Actividad2.xls SUBJECT: Group Activity 2 901. In the bottom of the email put the name of the members.
2) Insert a row before, LAST and place as the title of the same the following "educational institution PEDRO OCTAVIO AMADO" in font or Arial 18 point size, bold and red.
3) Perform the following improvements in appearance to that form:
a) Apply to the column headings 12 pt Courier font (or similar) and blue. Focus in their cells the same titles.
b) Apply borders and shading to improve the presentation of the return.
c) Apply cell formatting to data Date column F_Nac (eg 12/12/1975). Giving right click on the cell and the cell format option.
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) At the end of this form, in a column positioned as title word Commission to calculate the 5% of salary for each employee. Later copy of this column committee data format of the column salaries.
7) Name Sheet1 as employees and remove the leaves without the use of this book.
8) At the end of existing sheets in this book, add a new sheet named as Settlement. In the sheet to copy only the columns Name and salary employees.
9) in two free cells of the leaf clearance, get the highest and lowest salaries of the employees using the function = MAX () and = MIN (). To the right of these cells to add text to describe these values, ie this is the higher salary and the salary is lower.
10) Share google docs document Actividad2.xls SUBJECT: Group Activity 2 901. In the bottom of the email put the name of the members.
0 comments:
Post a Comment