USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which error is obtained when a formatted number does not fit within a cell?
|
|
#####
|
|
|
#DIV/0
|
|
|
#DIV@
|
|
|
#VALUE!
|
Explanation:
Detailed explanation-1: -Explanation: #### = If a formatted number does not fit within a cell it shows #####. Also, if an unformatted number does not fit, it will display the number in scientific format. also, it shows when MS Excel cannot able to recognize the formula entered.
Detailed explanation-2: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents.
Detailed explanation-3: -The General format is the default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way that you type them.
There is 1 question to complete.