DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When the data on a cell turns into a sequence of symbols ##### what does it tell us?
|
|
Column width is not enough to display
|
|
|
The function name in the formula is wrong
|
|
|
Reference address is not real
|
|
|
An error occurred while referencing data
|
Explanation:
Detailed explanation-1: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
Detailed explanation-2: -When using Microsoft Excel, I usually solve ##### errors by double-clicking the offending column headers. This can become a bit tedious, however, when there are multiple columns displaying the errors at the same time.
Detailed explanation-3: -The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In the following example, we created an array that’s 4 rows tall by 5 columns wide with =SEQUENCE(4, 5).
There is 1 question to complete.