(i) Entering text when the formula requires a number or a logical value, such as TRUE or FALSE.
(ii) Microsoft Excel cannot translate the text into the correct data type. For example, if cell A5 contains a number and cell A6 contains the text "Not available", the formula=A5+A6 will return the error #VALUE!.
(iii) Entering or editing an array formula, and then pressing ENTER.
(iv) Entering a cell reference, a formula, or a function as an array constant.
(v) Supplying a range of operator or a function that requires a single value, not a range.
maurice.mutuku answered the question on April 10, 2018 at 06:03
- How can you clear as well as edit a cell's content in Excel?(Solved)
Explain how you can clear as well as edit a cell's content in Excel.
Date posted: April 10, 2018. Answers (1)
- What activities would you undertake while editing a worksheet or a worksheet item?(Solved)
Discuss activities you may undertake while editing a worksheet or a worksheet item.
Date posted: April 10, 2018. Answers (1)
- What does editing a worksheet mean?(Solved)
Explain the meaning of editing a worksheet.
Date posted: April 10, 2018. Answers (1)
- List 10 commands that can be used to edit a text(Solved)
List 10 commands that can be used to edit a text
Date posted: April 10, 2018. Answers (1)
- What is 'Relative cell reference?'(Solved)
Explain the meaning of 'Relative cell reference'
Date posted: April 9, 2018. Answers (1)
- What is 'Absolute cell reference?'(Solved)
Define 'Absolute cell reference'
Date posted: April 9, 2018. Answers (1)
- 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)
- Hassan saved his spreadsheet having in mind to restrict access to his sensitive file.
What are the main password security options he may have used during...(Solved)
Hassan saved his spreadsheet having in mind to restrict access to his sensitive file.
Give the main password security options he may have used during saving to lock the file.
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)