SPREADSHEET OUTPUTS

classic Classic list List threaded Threaded
56 messages Options
123
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

anna
Questions & answers :)
Recitation in finals ..
ANNA MARIE FABRICANTE BATCH-1

1. What is borders ?
- borders are lines that help to distinguish columns or rows and help separate group of related information in the worksheet.

2. It is provide visual interest and emphasis on the worksheet, what it is ?
- colors and patterns.

3. What is gridlines ?
- are normal boundaries of cells in a worksheet.

4. What is text boxes ?
- is a box with text that floats over a worksheet or a chart sheet.

5. What is wordart ?
- will allow you to create pre-selected graphic text with shadows, curves,vertical,diminishing and flows.


Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

sarhjanesalvador
In reply to this post by Datamex
Question and Answer:
1. It is the part of the excel function that gives the maximum value in a range of cell or values.
  = MAX

2. A part of excel function that calculate the sum of the values or range of cell.
  = SUM

3. What would you click if you save a file.
  = its either save, save as, save as web page

4. In the key board, what key will you press if you close the document.
  = Alt + F4

5. It is the part of excel screen elements that shows the start button and the open program as well as the open files.
  =TASK BAR
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

benjietesortero117
In reply to this post by benjietesortero117
QUESTION :

1.) WHAT IS A CHRAT?

2.) WHAT ARE THE DIFF TYPES OF CHART?

3.) WHAT IS THE USE OF CHART WIZARD?

4.) GIVE THE DISCRIPTION OF THE FF CHART?

5.) WHAT IS THE OBJECTIVE OF LESSON 5 "CREATING CHARTS AND LINKS"?


ANSWER :

1.)A CHART IS A GRAPHIC OR DIAGRAM THAT MAY DISPLAYS DATA OR THE RELATIONSHIP BETWEEN SETS OF DATA IN PICTURE FORM

2.) COLOMN CHART
     BAR CHART
     LINE CHART
     PIE CHART
     XY SCATTER CHART
     AREA CHART
     DOUGHNUT CHART
   

3.) IT HELPS YOU CREATE A CHART QUICKLY.IT CAN APPEARS AS AN OBJECT IN A WORKSHEET

4.) XY SCATTER CHART - THIS TYPE OF CHART USES TWO VALUES AXES GRIDLINES TO PLOT PAIRS OF DATA POINTS IN LINE

    STOCK CHART - THIS TYPE OF CHART REQUIRES FOUR SERIES OF VALUES IN THIS ORDER : OPNE-HIGH-LOW-CLOSE

    RADAR CHART -PLOTS DATA SERIES VALUES USING A SEPARATE VALUE AXIXFOR EACH CATEGORY

5.) IT HELPS YOU LEARN THE DIFF. TYPES OF CHART
     IT HELPS YOU LEARN HOW TO CREATE THE COLOMN CHART
   
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

danilo macapanas
In reply to this post by danilo macapanas
QUESTION :

1.) USING THE AUTOSUM FUNCTION

2.)TRUE OR FALSE?
    A. AUTOSUM CAN MAKE SUBTRACTION COMPUTATION

3.)  B. THE SIGN USED IN COMPUTATION ARE + FOR ADDITION AND - FOR SUBTRACTION / FOR MULTIPLCATION AND * FOR DIVISION

4.) THIS MODEL WAS WRITTEN BY PETER CHEN IN 1976

5.) WAS DEVELOP BY Dr. E.F.CODD OF IBM IN THE 1970's


ANSWER :

1.) FUNCTION IS A BUILT-IN FOMULA THAT IS A SHORT CUT FOR COMMONLY USED CALCULATION

2.) TRUE

3.) B.  TRUE

4.) ENTITY-RELATIONSHIP MODEL

5.) RATIONAL MODEL  
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

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

Re: SPREADSHEET OUTPUTS

rubyannobejas1997
In reply to this post by Datamex
RECITATION 1.What is Auto Sum? answer: Built in formula for total value in arrow column 2.Displays the previous actions made to a worksheet. answer:Undo 3.What is Print view? answer: View or looks over the pages to make adjustment before printing 4.It is a standard Tool bar commands that open an existing worksheet. answer:Open 5.Maximizes and minimizes the window display? answer:Resizing,Buttons
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

soul
In reply to this post by Datamex
 

LESSON 1
EXCEL



  Submitted by:
 Mirasol Astillero
 Ivy Abierta

                                                                                  Submitted to:
Mr. Aries Artates





What is Excel - Excel is a computerized worksheet
What worksheet –is an on-screen spreadsheet that contains  various cells in column and rows.
What is workbook - A file that contains one or more worksheet.


EXCEL SCREEN ELEMENT

• Menu Bar- Display the file, Edit, View, Insert, format, Tools, Data, Windows, Help.

• Standard Toolbar- Displays the frequently used task such as New, Open, Save, Email, Print, Print Preview, Spelling Check, Research, Copy, Paste, Cut, Undo, AutoSum, Chart Wizard.

• Formatting Toolbar- Display the Font Name, Font Size, Font Type, Paragraph, Alignment, Percent, Comma, Decimal Places, Indention, Borders, Colours.

• 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. Each cell is identified by a cell reference which is its column and row location.

• Active Cell - A cell that is selected. The content of the active cell is displayed in the Name Box at the Formula Bar.

• Range - A group of selected cell.

• Workbook - A file that contains one or more worksheet, which you can use to, organized various kinds of related information.

• Sheet Tabs - each workbook has many worksheets with sheets tabs to name each worksheet.

• Drawing Tools - Displays the tools you will need to draw shapes, lines, arrows, insert WordArt, ClipArt, pictures, textbox.

• Task Bar - Shows the start button and the open program as well as the open files.

• Scroll Bar - These bars are used to easily go to the top or bottom, left or right of the worksheet.

• Resizing Buttons - Maximizes or minimizes the window display.




• Close Button - Closes the document or program.

DISPLAYING OR HIDING PICTURE TOOLBAR

On the Menu Bar, Click View, then click to display all the available toolbars. Select or Deselect to display or hide the toolbars you need do not need. The toolbars can also be dragged and placed on the four sides of the screen as your desire. It can also be customized to fully or partially display the buttons.

STANDARD TOOLBAR

• New - Create a new file.
• 0pen - Opens an existing worksheet.
• Save - Saves current file made.
• E-mail - 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 Preview - Views or looks over the pages to make adjustments before printing.
• Spelling - Check the spelling of words in the whole worksheets and gives you a list of suggested spellings.
• Research - Reference information online and on your computer without leaving your office program. It can easily insert definition and other research information into your document, as well as customize settings to suit your research needs.
• Cut - Removes data from and to another location inside the worksheet or to other files.
• Copy - copies data that needs to be placed to the other location inside the worksheet or to other files.
• Paste - Placed the data cut or copied to a specified location inside the worksheet or to the other files.
• Undo - Displays the previous actions made after using the Undo command.
• Redo - Returns to actions made after using the Undo command.
• AutoSum - Built-in formula for total values in a row or column.
• Chart Wizard – Insert a chart needed for the worksheet.

CREATING A NEW WORKSHEET

A new worksheet is launched every time you open the Microsoft excel. You can immediately start typing your data inside the cell. You can always create a new worksheet with the following steps:
1. On the Menu Bar, click File, then New.
2. You can also click the New button on the Standard Toolbar.



ENTERING AND CHANGING DATA IN A CELL

You may enter your data by selecting cell. You can select a cell by clicking your mouse pointer on the cell. Type your data on the selected cell and move to the next cell to type another data. You can move to another cell by pressing the arrow keys on your keyboard or by just clicking the mouse to any cell.

THERE ARE TWO WAYS TO CHANGE THE DATA:

1. Once you are in the cell you want to change, double click the cell and when the blinking cursor appears, press backspace or delete and type your new data and press the enter key.
2. Once you are in the cell you to change, click your mouse on the formula bar, press backspace or delete and type your new data and press the enter key.


RESIZING THE COLUMN OR ROW

 If the text you typing does not fit the cell, you resize the column by pointing your mouse on the line between the column names and move it to the right or left.

DELETING DATA IN A CELL

There are three ways to delete the data:
1. Once you care in a cell, press space bar and press enter.
2. Once you are in a cell, double click the cell and when the blinking cursor appears, press back space or delete and press enter key.
3. Once you are in the cell, click your mouse on the formula bar, press backspace or delete and press the enter key.

USING THE UNDO BUTTON

The Undo function allows you to reverse the command action. While the Redo function allows you to restore a previous action.













MOVING AROUND THE WORKSHEET

You can move around the worksheet by pressing the arrow keys on the keyboard. You can also move around the document using the special keys on the keyboard
• Page up
• Page down
• Home
• End
• Ctrl + Home
• Ctrl + End


RENAMING THE WORKSHEET SHEET TABS

1. Click the mouse pointer on the sheet tab sheet3.
2. Right click the mouse on the sheet tab.
3. On the pop-up menu, click Rename.
4. Type the new name in the sheet tab.
5. Click the pointer to any blank space in the worksheet to deselect.

COLORING THE WORKSHEET SHEET TABS

1. Right click the mouse on the sheet tab.
2. On the pop-up menu, click Tab color, when the Format Tab Color dialog box appears, select the color.
3. Click color.

SAVING THE WORKSHEET

Microsoft excel provides many ways to save a file. It is important to know how each functions individually.

• Save - This save function overwrites a previous saved file. This save command opens a Save As dialog box for the first time a worksheet is saved. You can enter a file name and location where the file will be saved.






• Save As - This save function opens the Save As dialog box which you can save an existing file either using the same name or different one, also  you can choose to save the file in the different file location, name or file type.
• Save As Web Page – When  you choose this save function, this opens a Save As dialog box,
Then activates the web pages as the Save As type, which would allow you to add a page title using the line of texts in the file.

CLOSING THE WORKSHEET

Closing a worksheet removes it from the screen. If the worksheet is not yet saved, MS Excel will ask if you want to save your modified worksheet, then MS Excel closes.

EXITING MS EXCEL

To exit MS Excel, on the Menu Bar, click File and click Exit or click the Close button on the upper right corner of the screen. The screen will return to the Windows desktop.

OPENING A PREVIOUSLY SAVED WORKSHEET

1. On the Menu Bar, click file and click Open.
2. Click the Look in drop-down arrow to display the list of available drives and locate the drive containing your file.
3. Choose the file name where your worksheet was saved, then click open.


GETTING HELP

Help is available in many ways in Microsoft excel. You can even get help through the internet or just right in your computer as you work.

Should you need Help, a Type Question for help bar is found at the right most and of the Menu Bar. You simply type in your question and you will find several possible and related topics to answer your question.











Question and answer

1. How to save file using keyboard?
• Press ctrl + s

2. In Excel how to show sub-menu?
• Right click on the sheet tab to show sub-menu.

3. How to open document using the keyboard?
• Press ctrl + o

4. How to modify font using keyboard?
• BOLD – press ctrl + B
• ITALIC – Press ctrl + I
• UNDERLINED – CTRL + U

5. How to open Microsoft Excel using keyboard?
• Press all window select Microsoft Excel.



MIRASOL ASTILLERO TI B1















sol1s.docx
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

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

Re: SPREADSHEET OUTPUTS

basilio concrenio44
In reply to this post by Datamex
question&answer.txtfinal recitation
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

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

Recitation in excel. Erlyn mae reas

erlynreas
In reply to this post by Datamex
1. What is word art?
=Word art means that will allow you to create  pre-selected graphic text with shadows, curves,vertical and deminishing.
2. How to close document using keyboard?
=Press Alt+F4
3. How to show Sub-menu?
=Click  the right  click on the sheet tab.
4. How to show other buttons of the toolbar?
=Click the down arrow beside the icon and select from the drop down list of the other available commands.
5. How to open the document using the keyboard?
=Press Ctrl+O
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

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

Re: SPREADSHEET OUTPUTS

Mark Dave Lopez
In reply to this post by Datamex
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

Mark Dave Lopez
In reply to this post by Datamex
1.What is Toolbar.?
2.Parts of excel functions.?
3.What is =IF.?
4.What is =AVERAGE.?
5.What is Spredsheets.?

Answer:
1.Toolbar a strip of icon on a computer.
2.SUm,Average,Minimum,Maximim,Count,if
3.Shows A series of Calculation using the same formula.
4.Calculate the arithmetic mean of a range of cells.
5.Spreadsheet acocounting program for a computer.
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

charlie villablanca
In reply to this post by Datamex
Question and Answer:
1. What is excel?
     Answer:computerize the worksheet
2. What are the four (4) ways to start excel?
     Answer: click start button
                 open program
                 click Microsoft
                 choose excel
3. What is formatting toolbar?
     Answer: it is the changing the appearance of data of the cell.
4. Give at least five (5) formatting toolbar commands.
     Answer: font style
                 font size
                 bold
                 italic
                 underline
5. What is chart?
     Answer: it is the selected picture form
Reply | Threaded
Open this post in threaded view
|

Re: SPREADSHEET OUTPUTS

antonio s. oliva
In reply to this post by Datamex
Question and Answers
By: Antonio Oliva

1. Is the computerize worksheet.
Ans. Excel
2. Built-in formula for total values in a row or column.
Ans. Auto-sum
3. Increases or decreases the size of the view.
Ans. Zoom
4. Correct the spelling of the words use in the worksheet.
Ans. Spelling check
5. Places color to the front.
Ans. Color font
123