It refers to a cell reference or formula which always refer to a specific cell(s) and does not change even if it is copied elsewhere in the worksheet or workbook. For example $A$4.
maurice.mutuku answered the question on April 9, 2018 at 12:57
-
What is the difference between external and remote cell references?
(Solved)
Distinguish between external and remote cell references.
Date posted:
April 9, 2018
.
Answers (1)
-
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)