Q1. What happens in an Excel spreadsheet if a cell contains numerical data but the column is too narrow to display the value? How can you correct this?
Q2. What is conditional formatting with Highlight Cells Rules? Give one example of how this feature can be useful in business.
Q3. What is the difference between a relative cell reference and an absolute cell reference? When would you make a reference absolute? Provide an example of when you would use an absolute cell reference.