Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Lower Limit Upper Limit Result Limits Type Upper 60 Lower 40 50 45 62 D 59 75 vlookup, I countif Tests Type A A B B D D A D D B B D Nr Too low: Nr Too high Nr of OK Results 45 62 55 40 45 70 60 65 48 44 70 78 60 48 55 65 62 Result: "OK", "low" or "too high Difference from upper limit (+) or lower limit() Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 sumproduct % Bond Value Price Stock A 5,90 Stock B 12,00 Bond 10,00 1 2 3 4 5 6 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% 8 9 10 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Month of the year Week of Day of the the year week size" Total: Nr Avg. Exp Max Mine Range b c d Nr of exp small Dig less than poe) (greater or to 100) 1 g less than po (greater or to 100) 1 Expenses nr Date Comment 1 1/9103 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 13 6/11/04 14 12/12/04 16 17/1/06 16 22/2/05 17 30/3/05 18 5/5/05 19 1076/06 20 16/7/06 21 21/8/05 22 26/006 kwook Sum of smal big Search for apense comment amount b Amount 28 83 70,47 154,99 154,07 77,12 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.48 192620 120.14 16265 K ! 1/10/04 *size: "big if the amount is greater or equal to 100. Otherwise small m n 0 q 3 1 u V 17:35 al 4G Sheets S Done Excel 14 copy.xlsx Sheet1 Sheet2 Sheet3 Sheet4 1) Use the IF function to decide the following Is this number greater than 4? 3 Does this number equal 107 Does this number equal 10? Is this number less than ?? Is this number or equal to 5 3 Is this number less or equal to 17 Is this text red? ed Is the following text YES NO 2) Use the IF function to decide which numbers are positive of the following Numbers 1 5 2 -10 -6 -9 -11 4 3 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Lower Limit Upper Limit Result Limits Type Upper 60 Lower 40 50 45 62 D 59 75 vlookup, I countif Tests Type A A B B D D A D D B B D Nr Too low: Nr Too high Nr of OK Results 45 62 55 40 45 70 60 65 48 44 70 78 60 48 55 65 62 Result: "OK", "low" or "too high Difference from upper limit (+) or lower limit() Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 sumproduct % Bond Value Price Stock A 5,90 Stock B 12,00 Bond 10,00 1 2 3 4 5 6 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% 8 9 10 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Month of the year Week of Day of the the year week size" Total: Nr Avg. Exp Max Mine Range b c d Nr of exp small Dig less than poe) (greater or to 100) 1 g less than po (greater or to 100) 1 Expenses nr Date Comment 1 1/9103 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 13 6/11/04 14 12/12/04 16 17/1/06 16 22/2/05 17 30/3/05 18 5/5/05 19 1076/06 20 16/7/06 21 21/8/05 22 26/006 kwook Sum of smal big Search for apense comment amount b Amount 28 83 70,47 154,99 154,07 77,12 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.48 192620 120.14 16265 K ! 1/10/04 *size: "big if the amount is greater or equal to 100. Otherwise small m n 0 q 3 1 u V 17:35 al 4G Sheets S Done Excel 14 copy.xlsx Sheet1 Sheet2 Sheet3 Sheet4 1) Use the IF function to decide the following Is this number greater than 4? 3 Does this number equal 107 Does this number equal 10? Is this number less than ?? Is this number or equal to 5 3 Is this number less or equal to 17 Is this text red? ed Is the following text YES NO 2) Use the IF function to decide which numbers are positive of the following Numbers 1 5 2 -10 -6 -9 -11 4 3
