FUNDAMENTALS OF COMPUTER

Previous
Next

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 errors in formulas as you create or manipulate it.
A
background formula checking
B
workbook formula checking
C
foreground formula checking
D
background function checking
Explanation: 

Detailed explanation-1: -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-2: -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.

Detailed explanation-3: -When Excel finds an error in a formula, it displays a small green error triangle in the top-left corner of the cell. [Find & Select button, Home tab, Editing group] to highlight cells with formula errors, blank cells, and cells with precedents and dependents.

Detailed explanation-4: -What is the #REF error in Excel? The #REF! error in Excel appears if you’re running a formula that is referring to a cell that doesn’t exist. If you delete a cell, column, or row in your spreadsheet, and build a formula including a cell name that has been deleted, Excel will return the #REF!

There is 1 question to complete.
Previous
Next