11th Computer Science Book Ch-9 (Spreadsheet Software)

Here is the list of important short questions for 11 class students computer book chapter 9 (Spreadsheet Software)

11th Computer Science Book Ch-9 (Spreadsheet Software)

Here is the list of important short questions for 11 class students computer book chapter 9 (Spreadsheet Software). These Questions are collected from all past Papers of Lahore Board, Federal Board, Rawalpindi Board, Dera Ghazi Khan Board, Multan Board, Gujranwala Board, Bahawalpur Board, Faisalabad Board, and Sargodha Board.

IMPORTANT (MCQ’s 1*1=1 + Short Question  2*2 = 4) = 5 MARKS

SHORT QUESTIONS:

  1. Define Spreadsheet.          BISE(Bwp 2018 , 2016 , 2014 , 2013 , 2010 , Dgk 2015 , Fsd 2011 , Grw 2013 , 2012 , Mlt 2012 , Rwp 2013 , 2012 , 2010 , Shw 2013 , Srg 2012)
  2. List the benefits/ uses of spreadsheet .BISE(Bwp 2016 , Fsd 2013 , 2010 , Grw 2018 , 2014 , Lhr 2016 , 2010 , Mlt 2018 , 2017 , 2013 , Shw 2016 , Srg 2013 , Rwp 2017)
  3. What are the main uses of Ms-Excel?                              BISE(Dgk 2012)
  4. Write basic features / functions of Ms Excel.                  BISE(Bwp 2012 , Dgk 2017 , 2014 , Fsd 2014 , Grw 2011 , Lhr 2013 , Mlt 2011 , Srg 2016)
  5. What is column in Ms-Excel?                               BISE(Srg 2015)
  6. How are Rows and Columns identified in the Spreadsheet?/Differentiate Row & column in Excel.            BISE(Ajk 2017 , Mlt 2010 , Grw 2018)
  7. Define workbook.                          BISE(Dgk 2014 , Fsd 2012)
  8. Define worksheet.                         BISE(Dgk 2015 , Grw 2017 , 2014 , Mlt 2014 , 2012 , 2011 , Srg 2014 , Shw 2017)
  9. What are functions?          BISE(Ajk 2016)
  10. What is the difference worksheet & workbook?              BISE(Dgk 2013 , Grw 2012 , Mlt 2016 , Rwp 2016 , Srg 2011 , 2018 , Shw 2018)
  11. What is 3D-sheet??                                                           BISE(Mlt 2011 , Bwp 2018)
  12. What is meant by cell in Ms-Excel ?/ define Cell.            BISE(Ajk 2016 , Grw 2016 , Srg 2016)
  13. What is Cell & Cell address?                                 BISE(Bwp 2012 , Dgk 2013 , Lhr 2013 , Rwp 2014 , Srg 2010 , Fsd 2018 , Shw 2018)
  14. Differentiate between Active cell& Passive cell.  BISE(Bwp 2011 , Dgk 2015 , Fsd 2016 , 2014 , Lhr 2011 , Rwp 2011 , Shw 2017)
  15. Define active cell.                                     BISE(Bwp 2016 , 2014 , 2013 , Lhr 2010 , Rwp 2013 , Mlt 2018)
  16. List different types of data  in Excel                                 BISE(Dgk 2011 , Grw 2010)
  17. What is the procedure to enter data in a cell?                BISE(Grw 2010 , Ajk 2018)
  18. Can you enter data in passive cell?                                  BISE(Grw 2017)
  19. Define formula in Excel.                                       BISE(Bwp 2017 , 2011 , Shw 2014 , Srg 2012 , Mlt 2017 , Lhr 2018)
  20. Distinguish b/w Label & Formula.                        BISE(Bwp 2016)
  21. Explain the difference b/w Labels & Values in Excel?                   BISE(Srg 2017)
  22. What is meant by cell reference?                        BISE(Rwp 2016)
  23. Describe Absolute referencing.                                        BISE(Fsd 2011 , Rwp 2011 , Shw 2013)
  24. What do you mean by Relative Cell reference?               BISE(Bwp 2015)
  25. Explain relative address with example in MS-excel.        BISE(Fsd 2016)
  26. Differentiate b/w Absolute & relative cell addressing.    BISE(Fsd 2017 , 2010 , Lhr 2017 , 2012 , Rwp 2010 , Srg 2017)
  27. What is cell range?                                                           BISE(Shw 2014)
  28. What do you understand by the term “Named Ranges” BISE(Dgk 2016 , 2015 ,  Mlt 2011)
  29. What is name box?                                                           BISE(Bwp 2013)
  30. How formula is written or used in MS-Excel? /What is formula? Give example             BISE(Ajk 2017 , Bwp 2010 , Grw 2015 , Srg 2018)
  31. Define function in Spreadsheet.Write any four built in function of spreadsheet.           BISE(Grw 2016 , Lhr 2012 , Mlt 2014 , 2012 , 2011 , Dgk 2018 , Ajk 2018)
  32. Differentiate b/w formula & function.                 BISE(Bwp 2015 , Dgk 2012 , 2011 , Fsd 2018 , 2013 , 2012 , Grw 2013 , Lhr 2017 , 2014 , 2010 , Mlt 2013 , Rwp 2018 , 2017 , 2014 , Srg 2011)
  33. Define Sum & Average function.                                                              BISE(Lhr 2015)
  34. Write down a formula to add five cells in a Row in Ms-Excel.                 BISE(Mlt 2014)
  35. Write a function that totals cell A1 through A5 / totals cell B3 to B10.   BISE(Bwp 2013 , Lhr 2016 , Srg 2016 , 2014 , 2010)
  36. Write the formula for calculating the average of cell B2 and B3 / average of cell B1 and B2.    BISE(Srg 2013 , Mlt 2012)
  37. Write the formula calculating average of three numbers.                                   BISE(Dgk 2016)
  38. What is merge & center option in Ms- excel? How you can merge two cell.      BISE(Grw 2011 , Rwp 2012 , Lhr 2015 , Mlt 2016 , Dgk 2017)
  39. What is do you Chart in Ms-excel?                       BISE(Mlt 2014)
  40. Explain # symbol in custom format.                                 BISE(Fsd 2017)
  41. Name two types of chart used in MS-Excel                     BISE(Bwp 2017 , Lhr 2018)
  42. Define Gridline in Ms Excel.                                              BISE(Rwp 2018)