USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
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: -Excel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height. AutoFit Column Width-changes the column width to hold the largest value in the column.
Detailed explanation-3: -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-4: -Click the Home tab; Go to Font group; Then you will view the border button, as the figure 2 shows above.
Detailed explanation-5: -MIN: This function determines the lowest cell value included in the argument.