- What is Spreadsheet application?
- What is the use of MS Excel in the business?
- What command will you use to change the page layout and the format of the sheets of a workbook?
- What is circular reference? And kindly give an example of circular reference.
- How could you identify if the sheet suffers from circular reference?
- How to locate the circular reference?
- How to identify if the result of a formula that you made is correct?
- How to display the content of a certain cell to another cell? What if it is from other sheet? For example content of a cell on sheet2 to sheet1.
- What are the Excel worksheet functions that you can use in MS Excel?
- Give at least 10 types of charts that are used in MS Excel.
- Give 4 types of charts that could be used to plot two dimensional tables see for example a chart use to plot a certain country against their population.
- How to insert/format charts?
- How to print a workbook?
Sunday, July 13, 2008
Preassessment Part 3 (Speadsheet Application)
Subscribe to:
Post Comments (Atom)
6 comments:
Preassessment Part 3 (Speadsheet Application)
1.) What is Spreadsheet application?
spreadsheet application is computer application that displays multiple cells that together make up a grid consisting of rows and columns.
2.) What is the use of MS Excel in the business?
MS excel is able to calculate large numbers automatically, it is use to create balance sheet, used to encode multiple data that arranged, and for analyzing and organizing business data
3.) What command will you use to change the page layout and the format of the sheets of a workbook?
Step 1 - Click file in the menu bar
- select page setup
- then, the dialog box will appear
- set the page, margin, or sheet that you want to change
- then click "OK".
4.) What is circular reference? And kindly give an example of circular reference.
Circular reference is a formula that refers back to its own cell whether directly or indirectly.
Ralph & Brent
Sir for all the answers,
Click this ==> My Blog
5.) How could you identify if the sheet suffers from circular reference?
You may notice an arrow, so by that, you may trace the precedence where is the original cell that contains error.
6.) How to locate the circular reference?
By looking at the status bar, you may see whether you worksheet has a problem or errors.
7.) How to identify if the result of a formula that you made is correct?
You may try numbers that you can solve by yourself and try it on the sheet if it will be the same, so by that you will know if your answer is correct.
8.) How to display the content of a certain cell to another cell? What if it is from other sheet? For example content of a cell on sheet2 to sheet1.
First thing you must do is to put an equal sign to your cell and click the cell that you want to appear.
9.) What are the Excel worksheet functions that you can use in MS Excel?
- sum
- average
- if
- count
- countif
- sumif and etc.
10.) Give at least 10 types of charts that are used in MS Excel.
- Column
- Bar
- Pie
- Line
- Doughnut
- Radar
- Surface
- Bubble
- Stock
- Cylinder
11.) Give 4 types of charts that could be used to plot two dimensional tables see for example a chart use to plot a certain country against their population.
- Column
- Bar
- Cone
- Line
12.) How to insert/format charts?
Step 1 - Click insert in the menu bar
- select chart
- the dialog box will appear
- set standard types or custom types
- then click OK.
13.) How to print a workbook?
Step 1 - Go to file on the menu bar
- select print then PRINT
or
- Ctrl + P (shortcut key)
Ralph & Brent
What is Spreadsheet application?
· Is a very powerful tool especially in any business, in excel you can manipulate and create formulas so no need for you to compute using your paper and pen.
What is the use of MS Excel in the business?
Excel you can manipulate and create formulas so no need for you to compute using your paper and pen. By this you can forecast the development of your company, you can keep track with so many things in relation to figures.
What command will you use to change the page layout and the format of the sheets of a workbook?
To change the page layout, you may go to page setup.
Click file.
Select page setup.
Change the setting from margins, orientation, and paper size.
What is circular reference? And kindly give an example of circular reference.
When a formula refers back to its own cell, either directly or indirectly, it is called a circular reference.
How could you identify if the sheet suffers from circular reference?
Just after you established your formula a dialog box will appear with a notice that there is a circular reference.
You can see if it does have a circular reference on the status bar.
How to locate the circular reference?
You will found out such instance on the status bar.
How to identify if the result of a formula that you made is correct?
You may try to test by using numbers that would be easy for you to calculate.
How to display the content of a certain cell to another cell? What if it is from other sheet? For example content of a cell on sheet2 to sheet1.
If that would be the instance you may directly copy its content from such sheet then directly paste it to any sheet you want it to appear.
What are the Excel worksheet functions that you can use in MS Excel?
· MAX
· MIN
· AVERAGE
· SUM
· COUNT
· COUNTA
· COUNTIF
· IF
Give at least 10 types of charts that are used in MS Excel.
1) Column
2) Bar
3) Line
4) Pie
5) XY(scatter)
6) Area
7) Doughnut
8) Radar
9) Surface
10) Bubble
Give 4 types of charts that could be used to plot two dimensional tables see for example a chart use to plot a certain country against their population.
Column, bar, line and pie.
How to insert/format charts?
Just click insert on the menu bar.
Select chart.
Choose the chart you want to insert on the dialog box.
How to print a workbook?
If you were already have your workbook. Go to file.
Select print.
If it contains more pages then just enter it all.
Part 3 (Spreadsheet Application)
1. Manipulate calculate a number in application.
2. It use for creating chart, inflows, calculating number.
3. page set up
4. Circular reference in the formula refers back its on cell either directly or indirectly. Ex. Adding two numbers then, accidentally you include the cell were you put.
5. If the answer results to zero then information box will appear.
6. In the tab bar.
7. By adding small number.
8. By using a equal sign.
9. *
10. Column,
• Bar
• Line
• Pie
• Xy Scatter
• Area
• Doughnut
• Radar
• Surface
• Buble
11. Bar,, column,, Line,, Pie
12. Click Insert in the menu bar, then chart, click the standard of the chart then Next then O.K.
13. Click file, then Print. Or Ctrl P.
PART 3(spreadsheet application)
1.What is Spreadsheet application? is where you can create data by using column and rows and also do calculation and make a chart
2.What is the use of MS Excel in the business?
You can do easily your job in a faster way and you can do calculation etc.
3.What command will you use to change the page layout and the format of the sheets of a workbook?
Click file in the menu bar, select page setup, page setup dialog box appear then set the page, margin, or sheet etc. you want to change then click OK.
4.What is circular reference? And kindly give an example of circular reference
Circular references are a common error in Excel that can cause problems with your formulas. This error occurs when a formula refers to it self to determine the answer.
5.How could you identify if the sheet suffers from circular reference?
trace precedence
6.How to locate the circular reference?
By looking at the status bar.
7.How to identify if the result of a formula that you made is correct? by using small numbers
8.How to display the content of a certain cell to another cell? What if it is from other sheet? For example content of a cell on sheet2 to sheet1.
First put your cursor on the cell you want to transfer then on the other sheet put the equal sign (=) then go back to the first sheet then press enter.
9.What are the Excel worksheet functions that you can use in MS Excel?
sum, average, if, hyperlink, count, max, sin, sumif, pmt, stdev
10.Give at least 10 types of charts that are used in MS Excel.
Column, Bar, Pie, Line, Doughnut, Radar, Surface, Bubble, Stock & Cylinder
11.Give 4 types of charts that could be used to plot two dimensional tables see for example a chart use to plot a certain country against their population.
Column, Bar, Cone, & Line
12.How to insert/format charts? Click insert in the menu bar, then select chart then the dialog box appear set standard types or custom types then click OK.
13.How to print a workbook? click file in the menu bar, select print then print
Post a Comment