USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
5
|
|
|
20
|
|
|
50
|
|
|
As many as you want
|
|
|
Sheet
|
Detailed explanation-1: -Although it is limited to only one or two variables (one for the row input cell and one for the column input cell), a Data Table can include as many different variable values as you want. A scenario can have a maximum of 32 different values, but you can create as many scenarios as you want.
Detailed explanation-2: -You can add only a maximum of five conditional formats to a range. The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed. A name cannot be assigned to two or more nonadjacent ranges.
Detailed explanation-3: -Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? The formula =B6+B7+B8+B9+B10.