Explore topic-wise InterviewSolutions in .

Correct answer is (b) :

1. # DIV/0! → When a number is divided by zero 

2. VALUE! → When a wrong argument is given in a fromula

Correct answer is  (c) G2: M12

A work book is a collection of a number of Work Sheets

Rows in spread sheet are horizontal vectors while columns are vertical vectors

Correct answer is (c) Work book

1. Workbook: A le in spread sheet is known as a workbook. A work book is a collection of a number of work sheets. 

2. Work sheets: The work area which consists of rows and columns in a spreadsheet is called a worksheet. By default three work sheetsheet 1, sheet -2, sheet -3 are available in work book.

One or more cells selected is called a range

Libre Office calc has three type of cell entries, they are Value, Label  and  Formula

IF function is Logical function

Correct answer is (c) Three

Range is a group of adjacent cells that forms a rectangular area.

The dark box which distinguishes the active cell is called Cell Pointer

Correct answer is (a) 1

1. 1880 

2. 1900

• TEXT 
• CONCATENATE

(d) Multiplication

Correct answer is (c) SUM

Correct answer is (b) Left

= IF(C3 < 15000, 500, 800)

Correct answer is (a) Redo

Basic Pay → B2 

DA → C2 

Gross salary → D2 

C2 = B2 * 76% 

D2 = B2 + C2

Correct answer is (b) Undo

Spreadsheet navigation: We can move around a worksheet through four arrow keys 

1. Left-arrow key 

2. Right arrow key 

3. Up arrow key 

4. Down arrow key 

The mouse can also be used for navigation in a spreadsheet except for data entry. Some common operations/navigations are listed below:

The name of the worksheet will be shown in the Sheet Tab at the bottom left of the windows.

2. Up arrow key 

3. Left arrow key 

4. Right arrow key

• A1 → Total Mark 
• B1 → Mark in Accountancy
• C1 → Mark in Business Studies 
• D1 → Index Mark 
• A2 → Enter the Marks 
• B2 → Enter the Marks 
• C2 → Enter the Marks 
• D2 → =A2 + B2 + (C2 * 25%)

1. COUNT 

2. COUNTA 

3. COUNTBLANK 

4. COUNTIF

1. J9 

2. B4: H12 

3. D5: J15

1. Rename a worksheet: 

Step – 1 Select the work sheet in the Sheet Tab which we want to Rename. 

Step – 2 Right click and select Rename sheet from the drop up menu 

Step – 3 Type new name in the Name eld and press OK button 

2. Delete a worksheet: 

Step – 1 Select the worksheet in the Sheet Tab which we want to delete 

Step – 2 Right click and select Delete sheet from the drop up menu 

Step – 3 Click on Yes to the conformation question.

3. Copy a worksheet: 

Step – 1 Click on blank rectangle Top left corner of the worksheet (Range Adress A1: AM J1048576) 

Step – 2 Move the curser inside the worksheet and Right click the mouse. 

Step – 3 Click on Copy from the dropdown menu. 

Step – 4 Open the worksheet where we want to copy the sheet 

Step – 5 Right click on cell A1. Click on Paste.

1. L8. 

2. F10: L16

Step 1: Go to the File menu File menu 

Step 2: Click on Save Save 

OR

Step 1: & Step 2 – Press Ctrl + S Ctrl + S 

Step 3: Type the le in the name eld instead of default name Untitled 1 Name eld 

Step 4: Choose the place where we want to save the new le. 

Step 5: Click on Save

1. It is both free software and open source software. 

2. It can be used to calculate, analyse and manage data. 

3. Libre Office Calc is available for a variety of platforms including Linux, OSX, Microsoft windows and Free BSD

Procedure: 

Step 1 – Open a blank new worksheet in LibreOffice Calc.

Step 2 – Enter the data in the following cells.

Step 3 – Enter the formula in B9 = ACCRINT (B2, B3, B4, B5, B6, B7, B8) 

Output:

A  cell is identified by a combination of a column header (letter) and a row header (number)

Application → Office → LibreOffice Calc

 The cell A5 indicate Column Column A and Row Row 5

Autosum (Σ) Function is commonly used to get the addition of various numbers other contents of various cells.

LibreOffice Calc, MS Office Excel, Open Office Spreadsheet.

1. Relative Cell references: 

By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location. 

2. Absolute Cell reference: 

The absolute cell reference consists of the column letter and row number surrounded by dollar ($) signs. Eg $A$5. An absolute cell reference is used when we want a cell reference to stay fixed on a specific cell.

Preparation of reports using Pivot Tables: 

A Pivot Table is a way to present information in a report format. A Pivot Table report provides enhanced layout, attractive and formatted report with improved readability. There are two types of data table. 

1. One-Variable Data Table (One – Variable ) 

2. Two-Variable Data Table (Two-Variable) 

• The one variable Data Table allows us to identify a single decision variable in our model and see how changing the values for that variable affects the values calculated by one or more formulas in our model.
• The two variable Data table allows us to specify two decision variables and a variety of inputs and only a single formula.

Correct answer is (a) =

Relative Cell references: By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reect the new location

• A spreadsheet is a configuration of rows and columns. 
• A spreadsheet is also known as worksheet

1. Cell: The intersection of a row and a column is called a cell. A cell is identified by a combination of an alpha – numeric character 

eg: A1, B6, C10, etc. This alpha numeric

character is called cell address. Hence each cell has a unique address. 

2. Ranges: Range is a group of adjacent cells that forms a rectangular area. A range is specified by giving the address for first cell in range and the last cell in the rage, 

eg: range starting from A10 to A20 is written as A10: A20 where colon (:) is the range operator. 

3. Work sheets: The work area which consists of rows and columns in a spreadsheet is called worksheet. By default three worksheets sheet 1, sheet -2, sheet -3 are available in work book. 

4. Workbook: A le in spread sheet is known as a workbook. A work book is a collection of a number of work sheets.

The cell co-ordinate in the formula are known as cell references

1. Labels:

Descriptive information for rows or columns in the form of a text or a special character is called Label. 

Eg: Name, Roll No, Address.

2. Formula: The formula means a mathematical calculation on a set of cells. The formula must start with an = (equal to) sign. When a cell contains a formula, it often contains reference to other cells. 

Eg:= Basic pay + DA + HRA

(c) Text or Label