Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets vipck Lp, sunproduct Cath Quant Price piece of Total Cath Type 10.00% 12,00% 15,00% 3 1 B Product Chairs Laptop Table Wardrobe Pub It. Clothing 1 Cathegory Net Price VAT 128,00 780,00 350,00 B 167,00 60,00 150,00 Total Spent 2 4 3 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 sumproduct % Bond Value Price Stock A 5,90 Stock B Bond 12,00 10,00 1 2 3 4 5 6 7 8 9 10 Portofolios % Stock A 13,00% 16,00% 35,00% 23,00% 11,00% 6.00% 76,00% 54,00% 33,00% 23,00% % Stock B 54,00% 63,00% 62,00% 44,00% 5,00% 76,00% 4,00% 18,00% 22,00% 10,00% Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 sumproduct Stock prices Name ID Price Change Change 125 Average price Max price Min price ID Company name 123 Exelis Inc 124 Raytheon Company 125 L-3 Communication 126 BAE Systems PLC 127 Harris Corporation 128 The Boeing Company 129 Thales SA (ADR) 130 Lockheed Martin C 131 Wells Fargo Adv 132 Northrop Grumman 133 General Dynamics Price 15,97 76,32 94,68 29,38 59,8 121,94 34,65 127,69 8,94 100,69 88,44 Change Change % -0,01 -0,54 -0,09 0,38 0,3 -0,58 0 - 1,21 0 -0,9 0,04 Total number of companies Number of companies with change Number of companies with pozitive change Number of pompanies with negative change Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Month of the year Week of Day of the the year week size ME a Total: Nr Avg. Exp b Range: C d Nr of exp small big less than ) (greater or to 100) @ 1 g less than poe) greater or to 1000) h 1 woahael Expenses nr Date Comment 1 1/9/03 2 7/10/03 3 12/11/03 4 18/12/03 5 23/1/04 6 28/2/04 7 4/4/04 8 10/5/04 9 15/6/04 10 21/7/04 11 26/8/04 12 1/10/04 13 6/11/04 14 12/12/04 15 17/1/06 16 22/2/05 17 30/3/05 18 5/5/05 19 10/6/08 20 16/7/05 21 21/8/05 22 26/9/05 Sum of smal big Search for pense comment amount b - Amount 28,830 70,47 154.99 154,07 77,120 170,65 166,47 2,03 39.15 180,18 89,01 30,97 107,94 146,36 37.42 160,14 103,85 166,42 42.486 192.62 129,74 152,65 K 1 m n 0 *size: "big" it the amount is greater or equal to 100. Otherwise "small" 4 1 u 1) Use the IF function to decide the following: Answer 3 10 4 9 Is this number greater than 4? Does this number equal 10? Does this number equal 10? Is this number less than 7? Is this number greater or equal to 5? Is this number less or equal to 7? Is this text "red"? Is the following text "YES" 3 7 red NO 2) Use the IF function to decide which numbers are positive of the following: Numbers Answer 1 -3 5 2 -10 14 -6 -9 -11 4 3 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets E for exible Sultal (without ) quantity 600,00 50,00 43,00 9.00 240,00 ! Total 1) Multiply these mbers by 11 TO 201 12 12 43 IS 16 17 14 Sum Add AVG 105 Mimply AVG Divide AVG Fill the multiplication table ANG 6 Sum Fill the multiplication table And divide everything by 4 3 6 7 9 To AVG/B Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Exercises for: 7 Example: Restaurant Starter Main dish Drinks Dessert Total: 6,00 12.00 16.00 6.00 -D3-D4+05+06 1) Spent yesterday 2) This month 3) This month Metro Food Drinks 3.50 21.00 4.20 Salary Food Housing Pulbic Transp Bonus 1 450,00 -450,00 -540,00 -50,00 120,00 Income Salary Bonus 1 535,00 200,00 Expenses Food Housing Public Transp 435,00 395,00 62,00 Total Total: Total: Sarved: Saved price price Example: Restaurant 2 Starter Main dish Drinks Dessert Total: quantity 6.00 12.00 16.00 6,00 3 1 --G23 G24+G25+G26 -E23E24.E25-E26 Total quant Average price G27/29 spent 4) Spent yesterday I price Metro Ticket Food Coffee quantity 1,20 800 1,50 5 3 Total Total quant Avg. price 5) This month quantity spent 2 Salary Food Housing Pulbic Transp 1 450,00 -450,00 -540,00 -50.00 120.00 3 1 4 Bonus 2 Saved: Sheet1 Sheet2 Sheet3 Sheet Sheets Sheets Sheet7 Sheets LN Man Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets vipck Lp, sunproduct Cath Quant Price piece of Total Cath Type 10.00% 12,00% 15,00% 3 1 B Product Chairs Laptop Table Wardrobe Pub It. Clothing 1 Cathegory Net Price VAT 128,00 780,00 350,00 B 167,00 60,00 150,00 Total Spent 2 4 3 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 sumproduct % Bond Value Price Stock A 5,90 Stock B Bond 12,00 10,00 1 2 3 4 5 6 7 8 9 10 Portofolios % Stock A 13,00% 16,00% 35,00% 23,00% 11,00% 6.00% 76,00% 54,00% 33,00% 23,00% % Stock B 54,00% 63,00% 62,00% 44,00% 5,00% 76,00% 4,00% 18,00% 22,00% 10,00% Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 sumproduct Stock prices Name ID Price Change Change 125 Average price Max price Min price ID Company name 123 Exelis Inc 124 Raytheon Company 125 L-3 Communication 126 BAE Systems PLC 127 Harris Corporation 128 The Boeing Company 129 Thales SA (ADR) 130 Lockheed Martin C 131 Wells Fargo Adv 132 Northrop Grumman 133 General Dynamics Price 15,97 76,32 94,68 29,38 59,8 121,94 34,65 127,69 8,94 100,69 88,44 Change Change % -0,01 -0,54 -0,09 0,38 0,3 -0,58 0 - 1,21 0 -0,9 0,04 Total number of companies Number of companies with change Number of companies with pozitive change Number of pompanies with negative change Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Month of the year Week of Day of the the year week size ME a Total: Nr Avg. Exp b Range: C d Nr of exp small big less than ) (greater or to 100) @ 1 g less than poe) greater or to 1000) h 1 woahael Expenses nr Date Comment 1 1/9/03 2 7/10/03 3 12/11/03 4 18/12/03 5 23/1/04 6 28/2/04 7 4/4/04 8 10/5/04 9 15/6/04 10 21/7/04 11 26/8/04 12 1/10/04 13 6/11/04 14 12/12/04 15 17/1/06 16 22/2/05 17 30/3/05 18 5/5/05 19 10/6/08 20 16/7/05 21 21/8/05 22 26/9/05 Sum of smal big Search for pense comment amount b - Amount 28,830 70,47 154.99 154,07 77,120 170,65 166,47 2,03 39.15 180,18 89,01 30,97 107,94 146,36 37.42 160,14 103,85 166,42 42.486 192.62 129,74 152,65 K 1 m n 0 *size: "big" it the amount is greater or equal to 100. Otherwise "small" 4 1 u 1) Use the IF function to decide the following: Answer 3 10 4 9 Is this number greater than 4? Does this number equal 10? Does this number equal 10? Is this number less than 7? Is this number greater or equal to 5? Is this number less or equal to 7? Is this text "red"? Is the following text "YES" 3 7 red NO 2) Use the IF function to decide which numbers are positive of the following: Numbers Answer 1 -3 5 2 -10 14 -6 -9 -11 4 3 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets E for exible Sultal (without ) quantity 600,00 50,00 43,00 9.00 240,00 ! Total 1) Multiply these mbers by 11 TO 201 12 12 43 IS 16 17 14 Sum Add AVG 105 Mimply AVG Divide AVG Fill the multiplication table ANG 6 Sum Fill the multiplication table And divide everything by 4 3 6 7 9 To AVG/B Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Exercises for: 7 Example: Restaurant Starter Main dish Drinks Dessert Total: 6,00 12.00 16.00 6.00 -D3-D4+05+06 1) Spent yesterday 2) This month 3) This month Metro Food Drinks 3.50 21.00 4.20 Salary Food Housing Pulbic Transp Bonus 1 450,00 -450,00 -540,00 -50,00 120,00 Income Salary Bonus 1 535,00 200,00 Expenses Food Housing Public Transp 435,00 395,00 62,00 Total Total: Total: Sarved: Saved price price Example: Restaurant 2 Starter Main dish Drinks Dessert Total: quantity 6.00 12.00 16.00 6,00 3 1 --G23 G24+G25+G26 -E23E24.E25-E26 Total quant Average price G27/29 spent 4) Spent yesterday I price Metro Ticket Food Coffee quantity 1,20 800 1,50 5 3 Total Total quant Avg. price 5) This month quantity spent 2 Salary Food Housing Pulbic Transp 1 450,00 -450,00 -540,00 -50.00 120.00 3 1 4 Bonus 2 Saved: Sheet1 Sheet2 Sheet3 Sheet Sheets Sheets Sheet7 Sheets LN Man