Spreadsheet Software - Short Questions and Answers. Find the most important and conceptual short questions with answers of Computer Science, ICS Part-1 Chapter No.9: Spreadsheet Software. The following questions are especially for the examinations; and job interview questions on Microsoft Excel & Google Sheets:

Spreadsheet Software is application software used for entering, calculating, manipulating, and analyzing sets of numbers. The specialty of this software is working with numbers. It can hold a large amount of data arranged in rows and columns. It can manipulate numbers and present information in numerous ways.

Q.2: Write some examples of spreadsheet software?

The following are the examples of spreadsheet programs:

• Microsoft Excel
• Lotus 123
• iWork Numbers
• LibreOffice
• OpenOffice
• VisiCalc

Q.3: Define Grids of Columns & Rows feature?

A spreadsheet consists of a Grid of Columns and Rows. The columns are labeled with letters (A, B, C, and so on). The rows are labeled with numbers (1,2,3 and so on).

Q.4: What is a Cell?

The intersection of a row and a column form a Cell. Each cell has a reference number that is formed by combining the column number and row number e.g. A1, C5, and E10, etc. A cell contains labels or values.

Q.5: What is a Formula?

A Formula is a mathematical expression that shows the relationship of two or more cells in the worksheet. The formula is not shown in the cell in which it is entered. Instead, its value is displayed in the cell in which it is written. It must begin with an equal sign “=”.

Examples of formulas are:

=(C1*100)/B1

=(A1*A5)+(A2/A3)

Q.6: What is a Function?

A Function is a built-in tool that is used to perform an operation and return a value. It can be used with both numbers and text. It is used in formulas. It gets one or more input values and gives a single value as output.

Examples of functions are:

=Sum(C1:C10)

=SQRT(16)

• It provides easy methods for analyzing data and presenting high-quality graphics output
• Easy to make changes in the input data
• The effect of any change in the input data is immediately shown in the output

Q.8: Differentiate between Worksheet and Workbook?

A worksheet is an area where data is entered. A worksheet consists of 256 columns and 65,536 rows. The collection of related worksheets forms a Workbook. Spreadsheet software allows you to save the whole workbook, containing several worksheets, as a file. A new workbook contains three worksheets by default.

Q.9: What are 3D-Worksheets?

New spreadsheets are rated as 3D-Worksheets, which are like a pad of worksheets. It is due to this feature that the data in one worksheet can be used for calculations performed in another worksheet of the same or a different workbook.

Q.10: What is Cell Reference?

Every cell in a spreadsheet has a reference. It is called Cell Address. It is calculated by combining the column letter and row number of a cell. For example, the address of cell at the intersection of column A and row 5 will be “A5”.

Q.11: Differentiate between Active Cell and Passive Cell?

The currently selected cell is called the Active Cell. The active cell is indicated by a dark border around the cell. The dark border is also called a cursor. The cell that is not currently selected is in passive state. It is known as Passive Cell.

Q.12: What is Cell Range?

If your formula involves contiguous cells, you can refer to all the cells as a range. The range is specified as follows:

For example, the cells A1, A2, A3, A4, A5 can be referred to as A1:A5.

Q.13: What is Named Ranges?

Range Names are names that you define to represent a cell or cell range on a worksheet. These range names can further be used in formulas instead of cell addresses or ranges. They also make it easier to use, maintain, and understand the formulas in the worksheet. Select Insert|Name|Define from the menu bar to define a name for a cell or range of cells.

Q.14: What is Relative Cell Reference?

The address of the cell in a formula that is relative to the location of the formula is called Relative Cell Reference. The cell address in relative reference changes when a formula is copied from one cell to another.

Q.15: What is Absolute Cell Reference?

The reference to a cell in a formula that does not change when the formula is copied to any other cell in the worksheet is called Absolute Cell Reference. To enter absolute reference, $(dollar sign) is used before and after column letter, e.g.$A\$5 is absolute cell reference.

Q.16: What is meant by Linking Worksheets?

While applying the formula in a worksheet, you may want to use the value from a cell in another worksheet within the same workbook by using the following format:

Q.17: Differentiate between Count() function and Today() function?

Count() function returns the number of entries in a number field that is in a range or array of numbers. Today() function returns the current date of your system.

Q.18: Differentiate between Merge & Center command and Text Wrap?

The Merge & Center command is used to merge a number of selected cells into one cell. In Text Wrapping, the text automatically shifts to a new line when it exceeds the width of the column. If text is not wrapped, it is written in one long line.

Q.19: Define Function Wizard?

To view all functions available in MS Excel and to apply any of them, the function wizard can be used. To activate the function wizard select Inset|Function from the menu bar.

Q.20: What does Cell Formatting mean?

The appearance of contents of a cell is known as its format. It consists of font, font size, font color, alignment, etc. The manner in which data is displayed in a cell is known as Cell Format. It is applied from the Format Cells dialog box. MS Excel provides 12 pre-defined formats.

Q.21: What is Chart and Chart Wizard?

Chart allows presenting data entered into the worksheet in a visual format using a variety of graph types. Chart Wizard brings you through the process of creating a chart by displaying a series of dialog boxes.

Q.22: Define the following Format Codes?

• #
• 0
• ?
• .

 # Displays only significant digits and does not display insignificant zeros. 0 Displays insignificant zeros if a number has fewer digits than there are zeros in the format. ? Adds spaces for insignificant zeros on either side of the decimal point so that decimal points align when formatted with a fixed-width font, such as Courier New. . Specifies how many digits appear to the right of a decimal point.

Q.23: How would you apply the column’s title on every page in printing?