USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
|
|
The Range Finder
|
|
|
The formula checker
|
|
|
A data table
|
|
|
An amortization schedule
|
Explanation:
Detailed explanation-1: -When you run the spell checker in a workbook, Excel automatically checks the spelling in all worksheets at once. You can use the DELETE key to cleat cell contents. When you enter a value in a worksheet cell, it automatically left-aligned. You can edit the cell contents in the Formula bar or in the cell itself.
Detailed explanation-2: -external reference. What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
There is 1 question to complete.