Question # 1

Which of the following functions is used to get the current date?

Choose an answer

Exact ()

Today ()

Month ()

Year ()

Which of the following is spread sheet software

Choose an answer

LOTOUS 123

MS Excel

Both a and b

Neither a nor b

Which of the following is correct column address.

Choose an answer

AA

25

38

CS

A work book is a collection of.

Choose an answer

Formula

Functions

Tables

Sheets

The function in MS-Excel is used to get the smallest value is called.

Choose an answer

Max

Min

a and b both

Smallest

Each cell in a spreadsheet has a unique;

Choose an answer

Row

Column

Address

Row and column

Calling cells by just their address (such as "A1") is called.

Choose an answer

Relative referencing

Absolute referencing

Calling Method

None

The cell range from A3 to G3 should be written as.

Choose an answer

A3-G3

A3 : G3

A3 : G3 '

A3 . G3

The intersection of a row and column is called;

Choose an answer

Data

Field

Cell

Equation

For the custom format ##.000, the number 242.59 will appear as;

Choose an answer

242.59000

24.2590

242.59

None

The correct column address is;

Choose an answer

AB

15

3D

D3

Which cell address will be include in the range C5 : E7

Choose an answer

C8

C6

E4

D9

A formula in MS-Excel begins with symbol.

Choose an answer

+

-

=

/

A worksheet contains________ rows.

Choose an answer

65536

256

173214

None

Each cell in a spread sheet has a unique

Choose an answer

Row

Column

Address

Both a and b

Which of the following is an absolute address;

Choose an answer

A1

A1$

A$1$

None

Calling a cell n MS. Excel by just their addresses is called.

Choose an answer

Named range

Labeling

Relative refreshing

Absolute refreshing

The actual working area is Microsoft Excel is.

Choose an answer

Workbook

Work sheet

Lotus -123

Database

A word book is a group of.

Choose an answer

Table

Formulas

Sheets

Functions

More Classes

Other Links

Computer Science Ics Part 1 Chapter 9 Online Test MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer