Describe how you can freeze column headings The steps are o Lunch excel and

Describe how you can freeze column headings the steps

This preview shows page 3 - 4 out of 4 pages.

12. Describe how you can freeze column headings 13. Write the formula you would use to perform the following tasks a. Adding cell E3, E4, + E9 => =SUM(E3,E4,E9) b. Change The Cell Format Firstly you need to go to Format Cell and you choose what do you want to change, there are 6 different type (Number, Alignment, Font, Border, Fill, Protection )Example : I want to change the color of the Sub Total, you can go to Fill and choose the background color and choose color what do you want. 14. What the following arithmetic operators mean in excel a. ( ) Brackets b. ^ Exponentiation c. + Addition d. – Subtraction negation
Image of page 3
e. * Multipication f. / Dividion operator 15. What order does Excel calculate formula? 16. How does formatting effect the readability of spreadsheets (explain your answer) Spreadsheets help in numeric document. It makes easier for the reader to analyse the data and understand that. And also, using the cells (s the main part of spreadsheet) and the formula plus the layout (for design) help you in develop your work and other people easier to get to know about what you have done.
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Three '16
  • Business, Chart types, different chart types, different chart features

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes