PDF paper 01

  • by

 58 total views,  1 views today

ICT Answers | Revision Papers – PDF


Paper 01 : Excel Paper Download


i) =SUM(B2:E2)  හෝ  =SUM(B2,C2,D2,E2)
ii) F2 Select (තෝරන්න) –> F2 හි Fill Handle Click කර F7 දක්වා Drag කරන්න

හෝ

F2 Select (තෝරන්න) –> Copy Click (CTRL+C) –> F3 සිට F7 දක්වා Select –> Paste Click (CTRL+V)

iii) =AVERAGE(B2:E2)  හෝ  =AVERAGE(B2,C2,D2,E2)
iv)
  • උපරිම ලකුණු:  =MAX(B2:B7) හෝ  =MAX(B2,B3,B4,B5,B6,B7)
  • අවම ලකුණු:  =MIN(B2:B7)   හෝ =MIN(B2,B3,B4,B5,B6,B7)
v)
  • Column chart
  • Bar Chart
  • Line Chart
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments