FUNDAMENTALS OF COMPUTER

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.
A
True
B
False
C
Either A or B
D
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.