Good News: Now View/Read Notes & Lectures anytime, anywhere at your Mobile.

Download 8th Class Computer Science Notes (Unit-3) for Federal Board (FBISE) Islamabad

Download 8th Class Computer Science Notes (Unit-3) for Federal Board (FBISE) Islamabad

Very Easy, Updated & Comprehensive Notes for all types of students i.e. Average / Extra Ordinary

Note: 
  • Please subscribe our SMS Alerts Service, Email Updates and Like our Facebook Page from right sidebar to get latest updates regarding our notes & other material/posts.
  • You can also install our Mobile App to view/read our notes anytime, anywhere on mobile.
  • Please inform us regarding any correction/mistake (if found) by Contacting Us.
  • Please SHARE this page from below, if you like these Notes to support us.

Download 8th Class Computer Science Notes (Unit-3) for Federal Board (FBISE) Islamabad

SHORT QUESTIONS
Differentiate between workbook and worksheet.
  • Workbook is a file of MS Excel containing one or more worksheets.
  • Worksheet is a large sheet containing information arranged in a matrix of rows and columns.
Differentiate between cut and copy.
  • Copy commands makes duplicate of the data selected.
  • Cut commands moves the selected data from one location to other.
Differentiate between Column and Row.
  • Columns are groups of cells from top to bottom vertically.
  • Rows are groups of cells from left to right horizontally.
Differentiate between Formula and function.
  • A formula is a mathematical expression used to perform mathematical operation.
  • A function is a read to use formula, provided by default by Excel. The user can perform calculations without having to type long and complex calculations.
Differentiate between SUM and AVERAGE function.
  • The SUM function takes all of the values in the specified cells and adds their values.
  • The AVERAGE function finds the average of the specified data.
Define the followings.
Spreadsheet
Spreadsheet is a large sheet containing information arranged in a matrix of rows and columns.
Formula
A formula is a mathematical expression used to perform mathematical operation.
POWER function
The power or exponent function finds the exponent of the given number. i.e. if a number is multiplied certain number of times to itself.
Copy and Paste
Copy commands makes duplicate of the data selected and paste command paste the copied data to the desired location.
Auto filling data
The auto fill feature of Excel allows the user to enter the pre-defined values in a series in cells automatically.

What is the purpose of using spreadsheet software?
It allows user to organize large amount of data. Calculations are easier in it. If changes are made in data, the result is updated automatically. A spreadsheet is used for following purposes:
·        Analyzing data
·        Creating charts and reports
·        Using statistical formulas
·        Managing budgets
·        Creating employee schedules
·        Tracking revenues and payment
Define SQRT function.
The square root of any number can be found using SQRT function. Its syntax is:
=SQRT(number)
=SQRT(Cell1)
How will you insert a function?
     i.                Select a cell.
   ii.                Click the Insert Function button. The 'Insert Function' dialog box appears.
 iii.                Search for a function or select a function from a category.
  iv.                Click OK. The 'Function Arguments' dialog box appears.
   v.                Click in the Range box and select the range.
  vi.                Click in the Criteria box and write query.
vii.                Click OK.
Define a Column and a Row?
  • Columns are groups of cells from top to bottom vertically.
  • Rows are groups of cells from left to right horizontally.
What do you know about worksheet tabs?
·        Worksheet tab is used to switch among worksheets.
·        At the bottom of workbook, sheet tabs are located.
·        By default, you have three sheet tabs "Sheet1", "Sheet2", "Sheet3".
·        These can be renamed.
What is the purpose of Formula bar?
·        The user can enter formula/function in the formula bar for calculation.
·        When a user enters any data in the cell it is automatically displayed in the formula bar.
How would you insert a function?
     i.                Select a cell.
   ii.                Click the Insert Function button. The 'Insert Function' dialog box appears.
 iii.                Search for a function or select a function from a category.
  iv.                Click OK. The 'Function Arguments' dialog box appears.
   v.                Click in the Range box and select the range.
  vi.                Click in the Criteria box and write query.
vii.                Click OK.
LONG QUESTIONS

Write the steps to create a spreadsheet in MS Excel.
·                    To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen.
·                    To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet.
What are the components of an Excel Window explain in detail.
i)      Office Button              ii)     Quick Access Toolbar           iii)    Ribbon Tabs
iv)     Title Bar                    v)     Address Bar                        vi)     Active Cell
vii)    Rows                         viii)   Columns                    ix)     View Buttons
x)     Sheet Tabs                 xi)     Status Bar                  xii)    Scroll Bar
xiii)   Zoom Slider
How many types of toolbars are there in MS Excel?
  • Title Bar
  • Standard Toolbar
  • Formatting Toolbar
  • Quick Access Toolbar
Write the purpose of the following function SUM, AVERAGE, MIN and MAX.
  • The SUM function returns the value after adding the selected numbers or values in range of cells
  • The AVERAGE function returns the mean or average of the selected numbers or values of range of cells.
  • The MIN function returns the smallest (min) value in the selected range of cells.
  • The MAX function returns the largest (max) value in the selected range of cells.
How would you apply borders? Write steps
  • Borders are the marked boundaries around the cells.
  • The cells or range of cells can be formatted and given borders by border button in home tab.
How would you save a spreadsheet in Excel? Write steps.
     i.                Click on the Office Button.
   ii.                Select Save As Excel Workbook from it.
 iii.                When Excel workbook is clicked, the Save as dialog box appears
  iv.                From Save In select the location and type the name for worksheet in File name and click on save button and the file will be saved.
Write steps to insert new Row and Column in a spreadsheet.
  • Click on the cell where you want to insert row or column.
  • Right click and click the INSERT option.
  • Insert Dialogue box appears
  • Click on Entire Row or Entire Column to insert a new row or column.
Define Charts. How to create a Pie Chart write steps.
Charts are pictorial representation of data. They are easy to read and understand. A document becomes more impressive and useful if charts are added to it. Following are the steps to create pie chart:
     i.                Type the data, for which pie chart is to be drawn.
   ii.                Select the data for which pie chart is to be drawn.
 iii.                Click on insert tab.
  iv.                From Charts Command group click on Pie Chart.
   v.                Select the chart type from the given.
  vi.                Pie Chart is inserted.

COMMENTS

Name

10th Class Notes,88,10th Class Old Papers,2,1st Year Notes,11,5th Class Notes,6,6th Class Notes,61,6th Class Old Papers,2,7th Class Notes,55,7th Class Old Papers,2,8th Class Notes,66,8th Class Old Papers,2,9th Class Notes,88,9th Class Old Papers,2,Articles,1,Download Free E-Books on IT,1,Guess Papers,11,Home Tutors,4,Home Tutors in Islamabad & Rawalpindi,15,Home Tutors in Jhang,1,Home Tutors in Karachi,2,Home Tutors in Lahore,4,Home Tutors in Multan,1,Home Tutors in Rahim Yar Khan,1,Home Tutors in Wah Cantt & Taxila,3,Important Questions,11,Information Technology,1,Miscellaneous,10,News & Events,4,Notes & Handouts,377,Old Papers,11,Solved AIOU Assignments,1,Video Lectures,1,
ltr
item
Download Class Notes: Download 8th Class Computer Science Notes (Unit-3) for Federal Board (FBISE) Islamabad
Download 8th Class Computer Science Notes (Unit-3) for Federal Board (FBISE) Islamabad
Download 8th Class Computer Science Notes (Unit-3) for Federal Board (FBISE) Islamabad
https://3.bp.blogspot.com/-1Z7GyLLUcOs/WKmqF0lrB5I/AAAAAAAADfs/VD7VeORGmYErts0aoRYgWOlYtlDKJJQRQCLcB/s1600/8th_class_computer_science_notes_fbise_islamabad_model_schools_colleges_federal_directorate_of_education_by_shahzad_iftikhar.jpg
https://3.bp.blogspot.com/-1Z7GyLLUcOs/WKmqF0lrB5I/AAAAAAAADfs/VD7VeORGmYErts0aoRYgWOlYtlDKJJQRQCLcB/s72-c/8th_class_computer_science_notes_fbise_islamabad_model_schools_colleges_federal_directorate_of_education_by_shahzad_iftikhar.jpg
Download Class Notes
http://www.downloadclassnotes.com/2016/10/unit-3-download-8th-class-viii-english-notes-for-islamabad-model-schools-colleges.html
http://www.downloadclassnotes.com/
http://www.downloadclassnotes.com/
http://www.downloadclassnotes.com/2016/10/unit-3-download-8th-class-viii-english-notes-for-islamabad-model-schools-colleges.html
true
6576910405746451012
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy