No, not with a formula. What you can do is use the Filter facility to hide records, which are always in rows. Using an Advanced Filter, you can extract data from an overall set.
You would not use an If statement to do it in a normal formula that is directly in a cell. You would do it through Conditional Formatting. Go to Conditional Formatting and you can enter an if formula instead of a cell value for determining the condition, and then set the formatting you want.
When using excel, always start your formulas with an "=" (equal) sign.
No. The condition of a cell can be either true or false.
It is a formula that the user creates themselves, instead of using the built-in functions.
You can click on it in the Formula Bar near the top of screen, or you can press the F2 key.
It is a function
It is when you are using an OR condition, which in Excel can be implemented through an OR function, or in an Advanced Filter by listing the criteria on different rows.
It is used to copy the formula down or across.
Not entirely, but you can use a mouse to select ranges you include in a formula.