Question Bank for 7th Class Computers Science Microsoft Excel Introduction to MS-Excel 2010

1)

A row and column arrangement of data and the formulas to manipulate it is called a _____.

A)

Spreadsheet

B)

Tablesheet

C)

Gridsheet

D)

Rolesheet

View Solution

2)

Observe the given image and answer the questions that follow.

Cell marked as A is called _________ cell.

A)

Active

B)

Passive

C)

Marquee

D)

Formula

View Solution

3)

Observe the given image and answer the questions that follow.


Match the following.
Column - I	Column - II
(a)	(i) Sheet tab scroll buttons
(b)	(ii) Name Box
(c)	(iii) Insert Worksheet
(d)	(iv) Expand Formula Bar

A)

(a) - (ii), (b) - (iii), (c) - (iv), (d) - (i)

B)

(a) - (iii), (b) - (ii), (c) - (iv), (d) - (i)

C)

(a) - (iv), (b) - (i), (c) - (ii), (d) - (iii)

D)

(a) - (iii), (b) - (iv), (c) - (i), (d) - (ii)

View Solution

4)

The arrows indicated by 'A' in the given image are called __________.

A)

Filter switches

B)

Data switches

C)

Form switches

D)

None of these

View Solution

5)

Which of the following options when clicked after selecting cell A1 in Fig.1 will display the data as shown in Fig. 2?

A)

B)

C)

D)

View Solution

6)

To format only those cells that rank in the top 10 items in a selected data range, use ______ option.

A)

B)

C)

D)

View Solution

7)

What should be typed in a cell to select all cells in row 5?

A)

= A11(5)

B)

= cell(5)

C)

=5

D)

=5:5

View Solution

8)

Which of the following icons is used to format a cell using pre-defined styles?

A)

B)

C)

D)

View Solution

9)

To select the entire row containing the current cell, press __________.

A)

+

B)

C)

+

D)

+

View Solution

10)

Which of the following is a valid cell range?

A)

A1 ; C4

B)

A1-C4

C)

A1:C4

D)

C4;A1

View Solution

11)

You can enable filtering of the selected cells by _______.

A)

Home tab \[\to \] Filter group \[\to \] Click on 'Filter'

B)

Home tab \[\to \]Editing group \[\to \] Click 'Sort & Filter' \[\to \]Filter

C)

Press

+

D)

Both [B] and [C]

View Solution

12)

Which of the following options when clicked will convert the data as shown in Image-1 into the data, as shown in Image-2?

A)

B)

C)

D)

View Solution

13)

Match the different Merge options given in Column-I with their corresponding names given in Column-II.

Column -I	Column - II
(a)	(i) Merge & Center
(b)	(ii) Unmerge Cells
(c)	(iii) Merge Cells
(d)	(iv) Merge Across

A)

(a) - (i), (b) - (ii), (c) - (iii), (d) - (iv)

B)

(a) - (ii), (b) - (iii), (c) - (iv), (d) - (i)

C)

(a) - (iv), (b) - (i), (c) - (ii), (d) - (iii)

D)

(a) - (iii), (b) - (iv), (c) - (i), (d) - (ii)

View Solution

14)

Identify the function of the given icon.

A)

It is used for adding up and down arrows.

B)

It is used to rotate text diagonally or vertically.

C)

It is used for wrapping text by displaying it on multiple lines.

D)

It is used for adding text effects to a cell.

View Solution

15)

Ankur has entered the value 1 into cell A1 and 3 into cell A2. Now, he selected both the cells and dragged down the fill handle. What would be the result of this action?

A)

It will create a linear series of even numbers.

B)

It will create a number series of odd numbers.

C)

It will copy the values of selected cells into next cells.

D)

It is not possible to drag the fill handle downward.

View Solution

16)

Which of the following keyboard shortcuts when pressed, will select the cell one column to the left of active cell?

A)

B)

+

C)

+

D)

Both [A] and [B]

View Solution

17)

___________ number format multiplies the cell value by 100 and displays the result with a percent symbol.

A)

Currency

B)

Fraction

C)

Special

D)

Percentage

View Solution

18)

If you want to display the leading zero in a numeric entry, like 01234567, how should it be entered in the cell?

A)

+01234567

B)

'01234567

C)

''01234567

D)

(01234567)

View Solution

19)

While entering data in a worksheet, Riya pressed

+

in a cell, what value will be printed in that cell?

A)

Current Time

B)

Square root of current value in cell

C)

Current Date

D)

Square of current value in cell

View Solution

20)

You have pasted some text in a cell. To again paste the same text in some other cell you can press the _________ key.

A)

B)

C)

D)

View Solution

21)

Match the MS-Excel shortcut sequences given in Column-I with their description in Column-II.

Column - I	Column - II
(a) +	(i) Applies or removes bold formatting
(b) +	(ii) Applies or removes underlining
(c) +	(iii) Displays the Format Cells dialog box
(d) +	(iv) Applies or removes italic formatting

A)

(a) - (ii), (b) - (i), (c) - (iv), (d) - (iii)

B)

(a) - (ii), (b) - (iii), (c) - (i), (d) - (iv)

C)

(a) - (ii), (b) - (iv), (c) - (i), (d) - (iii)

D)

(a) - (iii), (b) - (i), (c) - (iv), (d) - (ii)

View Solution

22)

Consider the given expression entered in a cell.

= 476 + 28 * (100-(10)^2)

What would be displayed in the cell when you type the given expression and then press the Enter key?

A)

#DIV/0!

B)

476

C)

#NAME?

D)

0

View Solution

23)

Which of the following is the CORRECT description of AutoComplete feature?

A)

It will force MS-Excel to display value in multiple lines within the cell.

B)

It automatically fills the entry based on other entries that you have already made in a column, when you type the first few letters of the similar text.

C)

It inserts a series of values or text items in a range of cells.

D)

None of these

View Solution

24)

Which of the following statements hold(s) true about the given command button with respect to Header & Footer tools?