VIEW AND EDITING IN MS EXCEL

This is where we encode our data. 

• TABLE

• CHART

• CELL

• DOCUMENT

These are a set of cells forming a certain parameters or range. 

• Groups of Cells 

   

• Cellulites 

• Cell Range

• Chart

The following are NOT the correct formatting of a cell range EXCEPT: 

• A1-C2 

• A1/C2 

• A1;C2 

• A1:C2

These commands lets you create clear and defined boundaries for the different section of your worksheet. 

• Cell wall

• Firewall 

• Cell Borders and Fill Color 

• Fence

This cell alignment command allows to you center TEXT of your MS Excel Worksheet 

• Right Align 

• Middle Align 

• Top Align 

• Bottom Align

This cell alignment command allows you to center CONTENT of your MS Excel Worksheet 

• Center Align 

• Top Align 

   

• Right Align 

• Bottom Align

This merging command allows you to MERGE cell contents in the SAME ROW into a new larger cell. 

• Merge and Center 

• Merge Across 

   

• Unmerge Cells 

• Merge Cells

This feature of MS Excel allows you to automatically adjust your cell's width and height by double clicking onto the cell's column. 

• Formatting 

• Formulas

   

• AutoSum

• AutoFit

This feature of MS Excel allows you to create a series of data just by entering a data onto a cell and dragging this down would duplicate the selected cell content. 

• Fill Handle bar

• Cell range 

• AutoSum

• AutoFit

It is a shortcut key to edit the cell content 

• F1

• F2

• F3

• F4