Worksheet is on-screen spreadsheet that contains various cells in columns and rows.
Workbook contains one or more worksheet which is automatically named as Sheet 1, Sheet 2 Sheet 3, and so on.
Excel Screen Elements
Menu Bar ---> Displays the File, Edit, View, insert, format, Tools, Data, Windows, and Help.
Standard Toolbar ---> Display the frequently used task such as New; Open, Save, Email, Print, Print View, Spelling Check, Research, Copy, Undo, Auto sum, Chart Wizard.
Formatting Toolbar ---> Displays the Font Name, Font Size, font Type, Paragraph Alignment, Percent, Comma, Decimal Places, Indention, Borders, and Colors.
Formula Bar ----> Displays the Name Box and cell reference for the active cell.
Cell ---> A cell is the rectangular area where a column and a row intersect.
Active Cell ---> A cell that is selected. The content of the active cell is its column and row.
Range ---> A group of selected cells.
Sheet Tabs ---> Each Workbook Has many worksheets with sheet tabs to name each worksheet.
Drawing Toolbar ---> Displays the tools you will needed to draw shapes, lines, and arrow, insert Word art, Clip art, pictures, and Text box.
Task Bar ---> Shows the Start Button and open program as well as the open files.
Scroll Bar ----> These bars are used to easily go to the top or button, left or right of the worksheet.
Resizing Buttons ---> Maximizes or minimizes the window display.
Close Button ----> Closes the document or program window.
STANDARD TOOLBARS COMMANDS
New -----------> Creates a new worksheet
Open ----------> Open a new existing worksheet
Save ----------> Saves the current file
Email----------> Allows you to send a file to reviewers online so that you do not have to rely upon a hard copy.
Print----------> Prints your worksheet directly to the installed printer.
Print Review---> Views or looks over the pages to make adjustment before printing.
Spelling ------> Check the spelling of words in the whole worksheet and gives you the list of suggestions spellings.
Research ------> Reference information online and on your computer without leaving your Office programs. It can easily insert information into your document, as well as customize setting to suit your research need.
Cut -----------> Removes data from and to another location inside the worksheet to other files.
Copy ----------> Copies data that needs to be placed to another location inside the worksheet to other files.
Paste ---------> Places the data cut or copied to a specified location inside the worksheet to other files.
Undo ----------> Displays the previous actions made to a worksheet.
Redo ----------> Returns the actions made after using UNDO command.
AutoSUM--------> Built-in formula for total values in a row or column.
Chart Wizard --> Inserts a chart needed for the worksheet.
Creating a New Worksheet
A new worksheet is launched every time you open MC Excel.
Resizing the Column or Row
If the text you are typing does not fit in the cell, you may resize the column by pointing your mouse on the line between the column names and move it to the right or left. To resize the row, point your mouse on the line between the row names and move it to up or down.