FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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.
A
The Range Finder
B
The formula checker
C
A data table
D
An amortization schedule
Explanation: 

Detailed explanation-1: -Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.

Detailed explanation-2: -The spell checker also only checks one spreadsheet at a time. To spell check the whole workbook, right-click one of your spreadsheets, and select Select All Sheets. Once that’s done, all of your spreadsheets will be selected, and spell check will look for errors in the whole workbook.

Detailed explanation-3: -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.
Previous
Next