USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In a process called ____, Excel continually reviews the workbook for error in formulas.
|
|
background formula checking
|
|
|
workbook formula checking
|
|
|
foreground formula checking
|
|
|
background function checking
|
Explanation:
Detailed explanation-1: -If a cell contains a formula that breaks a rule that Excel uses to check for problems, a triangle appears in the top-left corner of the cell. You can prevent these indicators from displaying. On the Excel menu, click Preferences., and then clear the Enable background error checking check box.
Detailed explanation-2: -Auditing. The process of examining a worksheet for errors in formulas. Create from Selection. A command by which you can name a cell range based on existing row or column titles.
Detailed explanation-3: -You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
There is 1 question to complete.