Excel Formatting

 Please watch the videos and complete the homework assignment:

https://www.youtube.com/watch?v=5kdsgXw-vkQ&feature=youtu.be

https://www.youtube.com/watch?v=doWDxQz0cNM&feature=youtu.be

 

Please answer these questions

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? 

6.  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?  

8.  What can you do with VBA in Excel?

9.  What are the disadvantages of using VBA?

10.  Describe the items on the developer tab in Excel?