SPREADSHEET OUTPUTS

classic Classic list List threaded Threaded
33 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Trixie Celario
                                    Using MS Excel to Create Worksheets

Excel is a computerized worksheet.

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

  PARTS                          DESCRIPTION
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 Toolbar
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.
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Ballao_luckylee
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

hannah mae paglinawan
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Dixson,Sherrylou
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Michelle_Oliva
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Ella
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Brendalie Salinas
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

mirallesmayjoy
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Herbert Mangale
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Mark Vince Solijon
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

markjudePretencio
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Rosalia Valida
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Jade_Daniel Ranjo
In reply to this post by Trixie Celario
12