Past Papers 11th Class Computer Science Ch 9

Past Papers 11th Class Computer Science Ch 9 Questions

  

•  Write the formula for calculating the average of cells B₂ and B₃.
• Define functions in excel.
• What is meant by Spread Sheet?
• Explain the work sheet.
• List two benefits of Spread Sheet?
• Distinguish between Formulas and Functions.
• Differentiate between worksheet and workbook.
• Write a function that total cells A1 through A5.\
• Describe absolute referencing.
• Write down a formula to add five cells in a row in MS-Excel.
• What is column?
• Define cell range.
• Define formula in excel.
• What do you know about chart in MS-Excel?
• Define cell.
• Differentiate between relative and absolute referencing.
• What is cell and cell address?
• What is the use of formula in MS-Excel?
• What is meant by cell reference?
• What is active cell?
• Explain relative addresses with example in MS-Excel.
• Write any two difference between active cell and passive cell in MS-Excel.
• State two feature of Spreadsheet Software.
• Write two basic features of MS-Excel.
• What is merge and center option in Excel.
• List two function of MS-Excel.
• How formula is used in MS-Excel.
• Name two type of chart used in MS-Excel.
• Can you enter data in passive cell?
• Explain # symbol in custom format?
• List any four built in function of spread sheet.
• Write a formula to calculate the percentage having total and obtained marks in cell A2 and B6 respectively?
• What is use of values and labels in worksheets?
• What is named range or state the advantages of named ranges?
• Write a formula to calculate the average of cell A2 to E2?
• What is most powerful feature of worksheet and why?