0
Is an Excel function category that returns information about the format location or contents of worksheet cells.?
Wiki User
∙ 7y ago
The Information category has some of those kinds of functions like CELL, ISTEXT, ISNUMBER and others. The Lookup and Reference category has some of those kinds of functions like ROW, COLUMN, ADDRESS and others.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
Which element do you click to insert a pmt function to a worksheet?
You can click on the Insert Function button and choose the Financial functions category to get the PMT function.
Which element do you click to insert a PMT function into a worksheet?
You can click on the Insert Function button and choose the Financial functions category to get the PMT function.
Which element do you click to add a SUMIF function to a worksheet?
It is in the Math and Trig category of functions. You can click on the function icon to start the process of getting to it.
In Excel you can create a worksheet that will be able to make decisions based on the information that appears in other cells. In what category of the Insert Function dialog box will you find functions?
The Logical category functions are the ones most appropriate, like the IF function, but some functions in other categories could be used too, like SUMIF in the Math & Trig category.
Presents information about the worksheet the function of the button the mouse pointing to or the Mode of Excel?
Status Bar
In Excel can you create a worksheet that will be able to make decisions based on the information that appears in other cells?
Yes you can do that. The main function to do that is the If function. See the link below for more information on it.
A student enters the following text in the function field of an Excel worksheet equals D6-D8 This means that?
The cell will display the text D6-D8. If you want to subtract the contents of cell D8 from cell D6, then you need to type =D6-D8. The = symbol tells Excel you want to perform a function on the contents of the cell, instead of just displaying text.
Can the insert function button feature be used to enter a function?
Yes it can. It enables you to enter a function into the worksheet.
What is an excel function used to enter the system date in a cell in a worksheet?
The NOW function
In excel, what is VLOOKUP?
It is an inbuilt function and it stands for vertical lookup.Suppose you have two worksheets with information on for the same person. On each worksheet you have an identifying reference number for each person. Now suppose you wanted to use some of the information stored on worksheet 1 in worksheet 2. You could use vlookup in sheet 2 to vertically search down all the rows on sheet 1 for the specific reference number and then bring back the information from one of the cells to the right of it.This can be very useful.Click on the help icon. Type in 'vlookup' and press return. Choose 'VLOOKUP function' for more information.
Should be inserted into a worksheet to explain the purpose of formulas?
function
What can be inserted into a worksheet to explain the purpose of formulas?
function
