0
How do you use the worksheet function to fill the selected cell with Y if cell B4 is greater than cell B3 and N if cell B4 is less than cell B3?
Note that your question does not specify what happens if B4 is equal to B3, so the following assumes it is left blank:
=IF(B4>B3,"Y",IF(B4<B3,"N",""))
If Y is for greater or equal to:
=IF(B4>=B3,"Y","N")
If it is N for equal to and Y is only for greater than:
=IF(B4>B3,"Y","N")
What else can I help you with?
What function do you use to fill a selected cell with y if cell L8 is greater than 10 and n if cell L8 is less than or equal to 10?
You use the "IF" function.
What is an excel function used to enter the system date in a cell in a worksheet?
The NOW function
What is the first to do when entering data in a cell worksheet?
Once the cell is selected, then you can just start typing. See the related question below.
When you first select a range of cell or an object before starting the spell checker Excel checks the selected?
worksheet
What cell does formulas and functions in Excel make use of?
Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.
What do you insert when you want to insert notes into a worksheet?
You can type notes directly onto the worksheet, you could type them into a text box on the worksheet, or you can add comments, which are attached to a cell. Pressing Shift - F2 will enter a comment into the selected cell. A small red triangle in the top right corner will indicate that a cell has a comment and it can be seen by putting the cursor over the cell.
In Excel is cell A1 designated the active cell?
If you select one cell, it will be active. However, if you select multiple cells at once, only one can be the active cell. That is usually the cell you select first.
How do you use worksheet function to fill the selected cell with the largest value?
Each program has its own formula, one should look for the tutorial on the program one is using in order to know the correct way for each separate program.
What is printing from cell A1 to the last occupied cell in the worksheet?
Click on the extreme upper, left hand cell, the whole sheet is selected. That way U also select, whichever cells that are filled.
What function retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell?
NOW function
How can you tell which cell in a worksheet is the active cell?
The cell borders are highlighted, or if a range of cells are selected, the active cell will be a different colour than the others, usually being white. The name of the active cell will always appear in the name box.
Is it true If each cell in a selected range is next to a row of numbers Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked?
false
