NEW
Font size
WorksheetsVIEW AND EDITING IN MS EXCEL
Total questions: 10
Worksheet time: 5mins
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
