FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -You cannot format an entire column at once. Hiding cells is a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see.

Detailed explanation-2: -Instead of Format Painter, use the following trick to copy formatting to an entire column or row: Select the cell that contains the format you want to copy. Press [Ctrl]+C to copy the cell’s content and formats. Press [Ctrl]+Spacebar to select the entire column.

Detailed explanation-3: -Check the rule you created. Double-check the rule in the Conditional Formatting Rules Manager. Sometimes, for no reason at all, Microsoft Excel distorts the rule you have just created. So, if the rule is not working, go to Conditional Formatting > Manage Rules and check both the formula and the range it applies to.

Detailed explanation-4: -A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. You can nest IF functions as deep as you want, but after you get yet beyond a nest of three IF functions, the logic becomes difficult to follow.

Detailed explanation-5: -One reason why you may not be able to format cells is because the cells are locked. To check if the cells are locked, go to the Review tab and click on Protect Sheet. If there is a checkmark next to Locked, then the cells are locked and you will not be able to format them.