With reference to spreadsheets, differentiate between a range and a cell.

With reference to spreadsheets, differentiate between a range and a cell.   

A range is a block of selected or named cells in the worksheet while a cell is an intersection between arrow and a column.

Convert the formula ” = Sum (K11: H20)” into its absolute form      

= sum ($ K $ 11: $H $ 20)

icon envelope tick round orange animated no repeat v1 Virus-free.www.avast.com

Print Friendly, PDF & Email
Post Views: 23

Related posts:

  1. KCSE ENGLISH GRAMMAR AND LITERATURE NOTES
  2. FATHERS OF NATIONS STUDY GUIDE PDF
  3. Unifying Africa: Exploring the Ideals and Impact of Pan-Africanism
  4. CO-OPERATION IN AFRICA NOTES
  5. INTERNATIONAL RELATIONS NOTES
  6. AFRICAN MORAL AND CULTURAL VALUES
  7. Definition of Mutation and other biology questions and answers
  8. CHRISTIAN APPROACHES TO HUMAN SEXUALITY,MARRIAGE AND FAMILY
  9. DEVELOPMENT OF TRANSPORT AND COMMUNICATION NOTES
  10. LESSON THREE: CHRISTIAN VIEW ON ISSUES RELATED TO SCIENCE AND TECHNOLOGY.
  11. PROPHET JEREMIAH
  12. THE SINAI COVENANT AND MOSES
  13. Causes of Disunity in the Early Church
  14. CREATION AND THE FALL OF HUMAN KIND
  15. POLITICAL DEVELOPMENTS AND THE STRUGGLE FOR INDEPENDENCE IN KENYA (1919 – 1963) NOTES
  16. FAITH AND GODS PROMISES TO ABRAHAM NOTES
  17. CRE Standard 8 Notes
  18. Differentiate the function SUM and SUMIF as used in spreadsheet.
  19. TSC NEW REQUIREMENTS FOR REGISTRATION OF TEACHERS
  20. DEVELOPMENT OF INDUSTRY NOTES
  21. TSC will spend Sh1.4 billion to promote 15,000 teachers says Macharia
  22. LOYALTY TO GOD ELIJAH
  23. APPROACHES TO LAW, ORDER AND JUSTICE
  24. CHRISTIANS APPROACHES TO LEISURE
  25. CONTACT BETWEEN EAST AFRICA AND THE OUTSIDE WORLD UP TO 19TH CENTURY NOTES
people found this article helpful. What about you?
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x