DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A column border is an unused column with a significantly reduced width.
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Explanation:
Detailed explanation-1: -A column border is an unused column with a significantly reduced width. You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year. You can add only a maximum of five conditional formats to a range.
Detailed explanation-2: -When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
Detailed explanation-3: -Click the Home tab; Go to Font group; Then you will view the border button, as the figure 2 shows above.
Detailed explanation-4: -MIN: This function determines the lowest cell value included in the argument.
There is 1 question to complete.