Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers

Or go directly to:

Class notes Holiday assignments Topical questions Other resources

What is the difference between external and remote cell references?

Distinguish between external and remote cell references.

Answers

(i) External reference refers to reference of cells in other workbook.

(ii) Remote cell reference refers to cell reference in other programs.

maurice.mutuku answered the question on April 9, 2018 at 12:28

Answer Attachments

Next: What is cell referencing?

Previous: Give the problems of external sources of revenue.

View more Computer Studies Questions and Answers | Return to Questions Index

Exams With Marking Schemes

Related Questions

What is cell referencing? (Solved)

Define 'cell referencing'

Date posted: April 9, 2018 . Answers (1)
What is an argument? (Solved)

Describe the meaning of an argument.

Date posted: April 9, 2018 . Answers (1)
What are the advantages of functions over formulae in spreadsheets? (Solved)

Highlight the advantages of functions over formulae in spreadsheets.

Date posted: April 9, 2018 . Answers (1)
What is the meaning of 'Label' as used in data processing? (Solved)

Explain the meaning of 'Label' as used in data processing.

Date posted: April 9, 2018 . Answers (1)
What is the meaning of 'Value' (Solved)

Explain the meaning of 'Value'

Date posted: April 9, 2018 . Answers (1)
How would you select non adjacent cells for formatting? (Solved)

Describe how you would select non adjacent cells for formatting.

Date posted: April 9, 2018 . Answers (1)
What is a cell range in spreadsheets? (Solved)

Explain the meaning of a cell range in spreadsheets.

Date posted: April 9, 2018 . Answers (1)
How can you rename a worksheet in Ms Excel? (Solved)

Explain the process of renaming a worksheet in Ms Excel.

Date posted: April 9, 2018 . Answers (1)
What will be the result after pressing F6 in navigating around the worksheet? (Solved)

Explain what will happen after pressing F6 in navigating around the worksheet.

Date posted: April 9, 2018 . Answers (1)
What will be the result after clicking ALT+PAGE DOWN? (Solved)

Explain the end result after clicking ALT+PAGE DOWN.

Date posted: April 9, 2018 . Answers (1)
What will result after pressing CTRL+HOME? (Solved)

Explain what will happen after pressing CTRL+HOME.

Date posted: April 9, 2018 . Answers (1)
What will be the effect of pressing SHIFT+F6? (Solved)

Discuss the effect of pressing SHIFT+F6.

Date posted: April 9, 2018 . Answers (1)
What will be the effect of pressing SHIFT+F5? (Solved)

Explain the effect of pressing SHIFT+F5.

Date posted: April 9, 2018 . Answers (1)
What are the methods of starting Ms Excel application stored in a computer? (Methods may vary depending on Operating System or Ms Office version) (Solved)

Give two methods of starting Ms Excel application stored in a computer. (Methods may vary depending on Operating System or Ms Office version).

Date posted: April 9, 2018 . Answers (1)
In what areas are spreadsheets commonly used? (Solved)

Give areas where spreadsheets are commonly used.

Date posted: April 9, 2018 . Answers (1)
What is a 'Worksheet?' (Solved)

Define a 'Worksheet'.

Date posted: April 9, 2018 . Answers (1)
What is a 'Cell?' (Solved)

Define a 'Cell' in relation to spreadsheets.

Date posted: April 9, 2018 . Answers (1)
What is a 'Workbook' (Solved)

Define a 'Workbook'

Date posted: April 9, 2018 . Answers (1)
What is a Graph(Chart) in relation to spreadsheets? (Solved)

Define a Graph(Chart) in relation to spreadsheets.

Date posted: April 9, 2018 . Answers (1)
What is 'automatic recalculation' as used in a spreadsheet? (Solved)

Explain the meaning of 'automatic recalculation' as used in a spreadsheet.

Date posted: April 9, 2018 . Answers (1)