MICROSOFT OFFICE EXCEL

EXCEL








Lab Report Lab Report 02 Excel
Question.


How to crate the table?
On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data.

On the Home tab, in the Styles group, click Format as Table, and then click the table style that you want.


Keyboard shortcut

You can also press CTRL+L or CTRL+T.
Icon image

If the selected range contains data that you want to display as table headers, select the My table has headers check box in the Format as Table dialog box.

Table headers display default names if you do not select the My table has headers check box. You can change the default names by selecting the default header that you want to replace, and then typing the text that you want




State 5 example for mathematics formula using Excel?


  • Subtraction - minus sign ( - ) 
  • Addition - plus sign ( + ) 
  • Division - forward slash ( / ) 
  • Multiplication - asterisk (* ) 
  • Exponentiation - caret (^ ) 


How to insert symbol RM in two decimal places


  1. Click the Decrease Decimal button . That removes one decimal value. Click the Decrease Decimal button again  
  2. Click cell F1 to see the result 
  3. In the Number section of the Ribbon, click the Currency Style button . The numbers in column G are now treated as money values and a $ sign has been appended to them 
  4. In the Number section of the Ribbon, click the Percent Style button . Now the numbers in column H are treated as percentage values 
  5. Our percentage numbers need a little more precision; therefore, we will display them with at least two decimal places. While cells H3:H10 are still selected, in the Number section of the Ribbon.
  6. Click the Increase Decimal button twice. Notice that the numbers have changed and are now more precise:
















No comments:

Post a Comment