Class 10 – IT – Code 402 – Electronic Spreadsheet Assessment Questions with Solution

by

Question: What is a formula bar? How is it different from name box?

Formula bar is used to apply the formula on active cell. It is located to the right side of the Name box whereas the Name box is located left to the formula bar and it displays the name of active cell.

Question: How do you name a range of cells?

Question: Describe the use of Resolve Conflicts dialog box in Excel.

Question: How do you name a range in cells in Excel?

Question: Why are spreadsheets are merged? Also, explain the steps to merge multiple spreadsheets.

Session 1: Analysing Data in a Spreadsheet

Assessment – Fill in the blanks.

  1. A scenario is a Set of values that you enter in a worksheet to perform calculations.
  2. It is a good practice to use sorted data while applying the SubTotal command to it.
  3. The Data Table tool displays the result of applying formula to a list of alternate values for variables in a separate range of cells.
  4. Goal seek can process only one input value at a time.
  5. Solver deals with equations with multiple unknown variables.

Assessment Answer Questions

Question: List the different What-If Analysis tools used in Excel.

Following are the different What-If Analysis tools of Excel:

  • Scenario Manager
  • Data Table
  • Goal Seek
  • Solver

Question: Explain any two What-If Analysis tools of Excel.

Question: What is Data Consolidation?

Question: Why do you consolidate data?

Question: Explain the use of Scenario.

Question: What is Goal seek?

Question: What is solver? How is it different from Goal Seek in Excel?

Question: What is the basic difference between ‘Scenario Manager’ and ‘Data Table’ tools?

Session 2: Linking Data and Spreadsheets

Assessment – Fill in the blanks.

  1. Linking spreadsheet data enables you to keep the information updated without editing multiple locations every time the data changes.
  2. To insert a new worksheet, click on the Home tab and select the Insert option.
  3. You need to type Reference manually, if you are entering it using the keyboard.
  4. A Hyperlink is a coloured and underlined text or graphics.
  5. A Relative Hyperlink is a partial address.

Question: List any two benefits of linking spreadsheets.

  • It enables you to keep the information updated without editing multiple locations every time the data changes.
  • It Improves data integrity

Question: Why do you link the spreadsheet data?

Question: How do you get data from an MS Access table in Excel?

Question: How do you add or insert a new sheet in a Excel workbook?

To add a new sheet, click on the Insert Worksheet button on the sheet tab or press shortcut key: Shift + F11.

Question: Differentiate between absolute and relative hyperlinks.

Absolute HyperlinkRelative Hyperlink
An absolute hyperlink is a hyperlink that contains the full address of the destination file or webpage.A relative hyperlink is a hyperlink that contains a partial address, which is related to the address of the output file of the destination file or webpage.

Question: How can you import the data from external sources in Excel? Explain.

Question: Is it possible to retrieve the data in Excel from external sources? If yes, mention any two sources.

Yes, we can retrieve the data in Excel via a link from external sources, such as from MS Access, web, text, server and some other sources.

Question: Describe the use of hyperlink in Excel.

A hyperlink is a coloured and underlined text or graphics that you click to open a file, location in a file, or a web page. With the help of hyperlinks, the users can jump at a specific information. It is a quick way to view or access related information from different sources. In an Excel spreadsheet, you can create a hyperlink in any cell.

Question: What will be the correct reference if you are linking cells D4:D20 of sheet1 to get the sum of the selected range in a cell A1 of Sheet2?

=SUM(Sheet1!D4:D20)

Session 3: Sharing and Reviewing a Spreadsheet

Question: How can a group of people work on the same Excel spreadsheet simultaneously?

Question: Why are track changes needed?

Question: What are comments?

Question: Why do you compare and merge spreadsheets?

Question: Sharing a spreadsheet is useful. Why?

Sharing a spreadsheet is useful because many users can work simultaneously on it. It also saves the trouble of keeping a track of multiple versions of the same spreadsheet.

Session 3: Using Macro in a Spreadsheet

Assessment – Fill in the blanks.

  1. Macros automates the recorded actions and saves your time and efforts.
  2. You’re actually recording your mouse clicks and Keystrokes while creating a macro.
  3. A Function is a line of code that executes when you call it.
  4. Each function has a Name and may have Parameters.

Question: What is a macro?

Question: How can you record a macro?

Question: Which application software is used to edit the codes written in macro?

Question: How can you pass arguments to a macro?

Question: How do you turn on the macro recording in an Excel?

To turn on the macro recording in an Excel, click on View Tab > Macros > Record Macro.

Write the syntax to define a macro as a function.

Question: Write a VBA code to access the A4 cell of a worksheet directly using the cell object.

Function CellData()
MsgBox Cells(4, 1) 		=> Display the result of 4th row, 1st Column (i.e. A4) in Message Box
End Function

OR

Function CellData()
MsgBox Range(“A4”) 	=> Display the result of A4 in Message Box
End Function

Leave a Comment