Information Technology
Class-9
Part-B
Unit-4 Electronic Spreadsheet,
Chapter-2 Microsoft Excel
A. Multiple Choice Questions:
1. By default a workbook contains:
a 1 worksheet b. 2 worksheet c. 3 worksheet d. 4 worksheet
Answer: 3 worksheet
2. A worksheet contains:
a. 65256 rows and 26 columns b. 65256 rows and 256 columns c. 65536 rows and 256 columns d. 65556 rows and 256 columns
Answer: 65,536 rows and 256 columns
3. Cell address $A$4 in a formula say=$A$4*20% is an example of which of the referencing?
a. Absolute b. Relative c. Mixed d. All of the above
Answer: Mixed
4. If cells, A1:A3 contain 205,25,80 then=MAX(A1:A3,82) returns:
a. 18 b. 80 c. 82 d. 20
Answer: 82
5. The area of a chart in which the actual data is plotted is called:
a. Plot area b. data area c. chart area d. sheet area
Answer: Plot area
6. Relation between prices of an entity in percentage can be best represented in:
a. bar chart b. line chart c. pie chart d. none of the above
Answer: Pie Chart
B. State T for true or F for false:
1. The intersections of rows and columns form cells.
Answer: T
2. A workbook cannot have more than 3 sheets.
Answer: F
3. A pie chart has 2 axes.
Answer: F
4. When you clear the contents of a cell, all the contents and formats of that cell are deleted.
Answer: F
5. The AVERAGE() function works as a combination of SUM() and COUNT() functions.
Answer: F
6. Cancel button on the formula bar can be used to undo a cell entry after it has been completed.
Answer: F
7. Text entries are aligned whereas numeric entries are right aligned.
Answer: T
C. Short Answer Type Questions:
1. What is a workbook and worksheet?
Answer: A workbook is a file in which you store your data. A workbook file is always saved with .XLS extension.
A workbook is a multi-page Excel document. Each page in the workbook is called a worksheet. A worksheet consists of cells that are organized into columns and rows.
Worksheet: Each page in a workbook is called a worksheet, consisting of cells that is organized into columns and rows. By default a new workbook has three sheets. You can add or remove sheets from a workbook as and when required.
2. What do you mean by a cell and cell pointer?
Answer: Cell: A cell is the smallest unit of a worksheet. Intersections of rows and columns form cells. You can enter a number, text, or formula in a cell. A worksheet contains 65536 rows, and 256 columns.
Cell Pointer: A frame around an active cell is called cell pointer. It is used to make a cell active. When you enter data, it is always placed in the active cell.
3. What do you mean by a range of cells?
Answer: Cell Range: A cell range is a group of one or more cells. A cell range is specified by giving the address of the first cell in the range, followed by a colon(:) and the last cell in the range.
4. What is AutoFill feature of spreadsheet? What is Fill handle?
Answer: AutoFill feature is spreadsheet programs like Microsoft Excel and Google Sheets automatically fills cells with data based on a pattern or other cells. This feature can save time and reduce errors when entering repetitive data.
Fill handle is a tool in Microsoft excel that lets users copy data or formulas across rows or down columns quickly. It's a small black dot in the bottom right corner of a cell that contains a formula or data.
5. What are the different ways to edit cell contents?
Answer: To edit cell content in Microsoft excel, you can use the keyboard, the mouse, or the formula bar.
Keyboard:
* F2: Press this key to activate edit mode
* Backspace: Use this key to delete characters.
* Delete: Use this key to delete characters or to delete a range of cells.
* Insert: Press this key to turn on overtype mode, which replaces existing characters with new ones.
* Alt+Enter: Press this key to start a new line of text in a cell.
Mouse: * Click in the cell you want to edit.
* Use the mouse pointer to position the insertion point.
* Double-click in the cell to activate your cursor.
6. What is the default alignment for textual and numeric data in a cell? How can it be changed?
Answer: In Microsoft Excel, the default alignment for text is left and the default alignment for numbers is right. This alignment makes data easier to read, compare, and scan.
Explanation:
Text: By default, text is left aligned in a cell. This is the standard alignment for most data types.
Numbers: By default, numbers are right aligned in a cell.
Users can change the alignment of cells in Excel as needed. For example, to change the alignment to left, users can press Alt+H and then A+L. To change the alignment to center, users can press Alt+H and then A+C.
7. Why is formatting of spreadsheet required?
Answer: Formatting spreadsheets is important because it can:
* Improve readability: Formatting can make data more visible and easier to read, especially in large worksheets.
* Add visual appeal: Formatting can make spreadsheet look more polished and organized.
* Help find meaning: Formatting can help you find meaning in the spreadsheet without having to go through each cell.
* Draw attention to important cells: Cells with good formatting can automatically draw your attention to important cells.
* Avoid improper reports: Using the wrong number formats can lead to improper reports.
8. What do you mean by cell referencing? What are the different type of cell referencing?
Answer: Cell referencing in a spreadsheet program like Microsoft Excel is a way to specify a cell or range of cells in a formula. There are several types of cell references, including relative, absolute, mixed, structured, and 3D.
* Relative cell references
* Absolute cell references
* Mixed cell references
* Structured cell references
* 3D cell references
9. What are functions?
Answer: Functions in a spreadsheet are predefined formulas that perform calculations using specific values, called arguments. Functions can be used to perform simple or complex calculations.
Spreadsheet functions:
* Sum
* MIN
* MAX
* AVERAGE
* COUNT
* PRODUCT
* VLOOKUP
10. What is a chart? Name a few chart types available in spreadsheet.
Answer: A chart is a visual representation of data in a spreadsheet. Charts can help make large amounts of data easier to understand.
Types of chart:
* Column chart
* Line chart
* Area chart
* Bar chart
* Pie chart
* Combo chart
* Doughnut chart
11. What are basic characteristics of formulas in spreadsheet?
Answer: Formulas in a spreadsheet are expressions that start with an equal sign and are used to calculate, manipulate, and automate data.
Basic characteristics:
* Equal sign
* Operands
* Calculation operators
* Functions
D. Long Answer Type Questions:
1. What is an electronic spreadsheet?
Answer: An electronic spreadsheet is a computer program that organizes data in rows and columns for storage, analysis, and manipulation.
How it works:
* Data is stored in cells, which are the intersections of rows and columns.
* Data can be numbers, text labels, or formulas that combine data from other cells.
* Formulas can be used to automatically calculate values.
* Results can be displayed graphically in charts and graphs.
2. What are the different kinds of charts available in excel?
Answer: Excel has many types of charts, including line, bar, column, area, pie, and scatter charts.
* Line chart:
Shows how data change over time
Connects data points with lines.
Useful for tracking trends like revenue, expenses, and profit margins
Can compare multiple data sets on a single chart
* Bar chart:
Compares items in a specific period
Can include cones, cylinders, and pyramids
A simple way to compare numeric values
* Column chart:
Use vertical bars to compare data points
Can be used to show data that's arranged in columns or rows on a worksheet
* Area chart:
A type of line chart with filled in area
Compares two or more data sets over time
* Scatter chart:
A type of chart available in excel.
3. What do you mean by cell referencing?
Answer: Cell referencing is a method of identifying and accessing cells in a spreadsheet by their coordinates or address.
Cell referencing in a spreadsheet program like Microsoft Excel is a way to specify a cell or range of cells in a formula. There are several types of cell references, including relative, absolute, mixed, structured, and 3D.
* Relative cell references
* Absolute cell references
* Mixed cell references
* Structured cell references
* 3D cell references
Some other links: