Assignment Help- Describe how freeze panes works in Excel? What tab contains freeze panes? 7. Describe what split in the windows area of the view tab does in Excel?
1. What function in Excel takes the absolute value of a number?
2. Describe how you set the print area in Excel?
3. Describe the steps for using Text to Columns to split the following data into individual cells. Note, the commas separate fields.Dallas, Texas, USA
4. Describe how conditional formatting works in Excel. Please list the step. Give an example of when one would use this functionality?
5. Describe how protect workbook and protect worksheet work. Please list the step. Give an example of when one would use this functionality?