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