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: -When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery. You cannot format an entire column at once. Best fit means that the width of the column will be increased or decreased by a percentage you specify.
Detailed explanation-2: -Answer: In Microsoft Excel, the MAX function. Explanation: Giving the cell ranges in MAX function as arguments will result in output of the highest number value in cells.
Detailed explanation-3: -The Sum button menu allows you to enter one of five often-used functions easily into a cell. Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data. The range automatically selected by Excel is always correct.
Detailed explanation-4: -The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
Detailed explanation-5: -Numbers can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 +-( ), / . $ % E e. 46. Numbers entered into a worksheet are right-aligned, which means Excel displays the cell entry to the far right in the cell.