joi, 25 noiembrie 2010
My lab no 8
In this laboratory I have learned how to make a chart. We should select the Data Series and then go to Insert tab - Charts Group of Buttons and select there the chart we want to be created, also I have learned how to "design" the charts, to change colours, to add the title for horizontal and vertical axis etc.
joi, 18 noiembrie 2010
My lab no 7
At this laboratory I have exercised fomatting a table, formulas like CONCATENATE and others. Also I have solved first 4 problems, as can be seen on my site in the attachment called My lab no 7.
joi, 11 noiembrie 2010
My lab 6
Today, at the laboratory I have learn how to sort data -> Home - > Sort & Filter, from A to Z.
Also, I have exercised Subtotals: Data -> Subtotal -> use functin Sum, select County and Sales, and Summary Data Below for the Question 1 (? the total sales for each county). If we want to know how many records (lines) are for each type of product that was recorded on list we use the function Count.
Also, I have exercised Subtotals: Data -> Subtotal -> use functin Sum, select County and Sales, and Summary Data Below for the Question 1 (? the total sales for each county). If we want to know how many records (lines) are for each type of product that was recorded on list we use the function Count.
marți, 2 noiembrie 2010
my 3rd laboratory
I continued working in Excel. I have learnt how to define a range of cells. For eg. if we write A3:C3 it will take every cell from A3 to C3 (A3, B3, C3) and when we take A1:C3 we will have (A1, A2, A3, B1, B2, B3, C1, C2, C3). Than I have exercised to work with formulas such as SUM. After that I spoke with my coleg about our project.
my 2 laboratory
In my first laboratory at economic informatics I have seen that there ar important diferences between Excel 2003 and Excel 2007 wich I thaught I know to work in. First of all I tried to find diferences between those two... there are a lot... So, I started to work on general application in Excel 2007, like deleting cells, shift cell left, shift cell up, deleting entire row, entire column, merge and center, merge across, merge cell, unmerge cell.
joi, 28 octombrie 2010
sâmbătă, 23 octombrie 2010
Abonați-vă la:
Postări (Atom)