Explore topic-wise InterviewSolutions in .

Correct answer is (a) autofill

(a) Comparative operator

Cell pointer is a rectangle box which can be moved around the worksheet. The cell in which the cell pointer is currently located is known as “Active cell”. When you type any content, it will appear in the active cell.

Correct answer is (a) range

In Calc, “&” is a text operator which is used to combine two or more texts as a single text. Joining two different texts is also known as “Text Concatenation”. An expression using the text operator has the following syntax:

Reference operators are used to refer cell ranges. A continuous group of cells is called as “Range”. There are three types of reference operators that are used to refer cells in Calc. 

They are –

1. Range Reference Operator

2. Range Concatenation

3. Intersection Operator

Correct answer is (c) ~

Colon (:) is the range reference operator. It is used to group a range of cells. An expression using a range operator has the following syntax: reference left : reference right.

Where reference left is the starting cell address of a linear group of cells or upper left comer address of a rectangular group of cells. Reference right may be a last cell address of a linear group or lower right comer address of a rectangular group of cells.

Correct answer is (c) :

Correct answer is (a) View

(i) Text Operator:

In Calc, “&” is a text operator which is used to combine two or more texts as a single text. Joining two different texts is also known as “Text Concatenation”. An expression using the text operator has the following syntax:

(ii) Rows and Columns of spreadsheet:

the formula bar contains the worksheet of work area which consist of grid cells The worksheet has number of rows and columns, where each column is labelled as A, B, C, D … AA, AB, AC … and the rows are numbered from 1,2,3 … OpenOffice Calc version 4.1.5 contains 1024 columns and 10,48,576 rows. Column heading starts from A and end with AMJ. In the case of Microsoft Excel 2016, there are 16,384 columns (A to XF(d) and 10,48,576 rows available.

Copy – paste:

1. Select the cell or group of cell you want to copy, then using Ctrl + C (or) Edit → copy (or) copy icon.

2. Select the cells in which you want to paste, using Ctrl + V (or) Edit → paste (or) paste – icon.

Cut- paste:

1. Select the cell or group of cell you want to cut, then using Ctrl + X (or) Edit → cut (or) cut-icon.

2. Move the cell pointer to the cell in which you want to paste, using Ctrl + V (or) Edit → paste (or) paste-icon.

OpenOffice.org (OOo), commonly known as OpenOffice, is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, database and more. It is available in many languages and works on all common computers. It stores all your data in an International open standard format and can also read and write files from other common office software package.

(a) Spreadsheet

Correct answer is (b) Excel

Correct answer is (b) LibreCalc

Correct answer is (c) VisiCalc

1. Arithmetic Operators

2. Relational Operators

3. Reference Operators

4. Text Operators.

Correct answer is (b) 2

Correct answer is (c) 11

Correct answer is (c) table

Correct answer is (c) Expression

Correct answer is (c) cell pointer

Correct answer is (d) 4

Correct answer is (b) False

Correct answer is (b) Home cell

Formula bar:

This is a very important element in a spreadsheet. It contains Name box, Function Wizard, Sum button, Function button and Input line.

Name box:

It display the current cell address

Function Wizard:

It is used to insert function

Sum button:

It is used to quickly insert sum function

Input Line:

This is used to show the contents of the current cell. It always shows actually what you typed in a cell. It is also used to edit the contents.

 To construct a formula, you should follow the steps below:

1. Cell pointer should be in the cell in which you want to display the result.

2. Formula should begin with an = sign.

3. In a formula, use only cell reference (cell addresses) instead of the actual values within the cells.

4. While constructing a formula, BODMAS rule should be kept in mind. 

In Calc, you can enter formulas in two methods, either directly into the cell or at the input line. Formula in Calc may start with equal (=) or plus (+) or minus (-) sign followed by a combination of values, operators and cell references. But, as a general , practice, all formulas should start with an equal sign. If any formula starts with a + or -, the values will be considered as positive or negative respectively.

Correct answer is (b) 25

Correct answer is (b) Tab

Changing the column width in Calc in different ways available.

(i) Using mouse to change the column width. Keep the mouse button pressed and drag left or right in order to change the width of the column.

(ii) Using the dialog to change the column width. Click to choose Format → Column → Width, then enter the column width in the dialog box, which appears on the screen, then click OK button. Now that you want coloumn width increased.

SUM is the most frequently used function to add a set of values.

The syntax of the SUM ( ) is 

= SUM (range 1; range 2; range 3 ……….. range n) If you want to know the sum of the values on A1, A2, A3, A4, A4 in A5, Place your cell pointer in A5 and directly type the formulae as follows. = SUM (A1 : A4)

1. Backspace key is used to delete the character left of the insertion pointer of the cell.

2. Delete key is used to delete the character right of the insertion pointer of the cell.

3. This can be done while typing or after typing in the cell.

To find the average, using anyone of the following ways.

Typing in the formula bar

1. = (A1+A2+A3)/3 (or)

2. = AVERAGE (A1; A3)

Yes, you can edit the contents of a cell in several distinct ways. Use this method convenient for you,

1. Double-click the cell you would like to edit. The cursor is placed where you double clicked.

2. Press the F2 key, the cursor is placed at the end of the text.

3. Click anywhere in the formula bar. The formula bar changes to have an entered and check mark.

Correct answer is (a) Sheet count

Formatting Data in a cell gives additional effect to the text. Additional effect includes changing the font style, font size, automatic wrapping, bold, underline, italic etc. The data in Calc can be formatted in several ways. Using formatting icons can be used.

Correct answer is (b) Sorting

Filter is a way of limiting the information that appears on screen. Filters are a feature for displaying and browsing a selected list or subset of data from a worksheet. The visible records satisfy the condition that the user sets. Those that do not satisfy the condition are only hidden, but not removed. OpenOffice Calc allows three types of filters. They are AutoFilter, Standard Filter and Advanced Filter.

Sorting is the process of arranging data in ascending or descending order. There are two types of sorting in OpenOffice Calc. 

They are,

1. Simple Sorting

2. Multi Sorting

3. Sort by selection.

Correct answer is (c) 3

(a) conditional formatting

Correct answer is (b) Filters

Data are in different types. Data are made up of alphabets, numbers, Date and time is another data type even though it has numbers and symbols. In general, 

data types are classified as:

Alphabetic data type – consists of alphabets only.

Numeric data type – consists only numbers (whole number or fractional numbers)

Alphanumeric data types – consists of a combination of alphabets and numerals

Date data type – consists only dates

Time data type – consists only time

Correct answer is (a) left

Correct answer is (d) 5

The outline of the window is very similar to other application windows of OpenOffice. The main area of the Calc window is called as “Work area” or “Worksheet”.

A worksheet is a grid of cells with a programmable calculator attached to each cell.

A new spreadsheet can be created from various methods. From windows, select Start → All Programs → OpenOffice → OpenOffice Calc. Double click on “OpenOffice” icon the desktop.