More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
Computer Science Ics Part 1 Chapter 9 Online Test MCQs With Answers
Question # 1
Which of the following functions is used to get the current date?
Choose an answer
Exact ()
Today ()
Month ()
Year ()
Previous
Skip
Next
Question # 2
Which of the following is spread sheet software
Choose an answer
LOTOUS 123
MS Excel
Both a and b
Neither a nor b
Previous
Skip
Next
Question # 3
Which of the following is correct column address.
Choose an answer
AA
25
38
CS
Previous
Skip
Next
Question # 4
A work book is a collection of.
Choose an answer
Formula
Functions
Tables
Sheets
Previous
Skip
Next
Question # 5
The function in MS-Excel is used to get the smallest value is called.
Choose an answer
Max
Min
a and b both
Smallest
Previous
Skip
Next
Question # 6
Each cell in a spreadsheet has a unique;
Choose an answer
Row
Column
Address
Row and column
Previous
Skip
Next
Question # 7
Calling cells by just their address (such as "A1") is called.
Choose an answer
Relative referencing
Absolute referencing
Calling Method
None
Previous
Skip
Next
Question # 8
The cell range from A3 to G3 should be written as.
Choose an answer
A3-G3
A3 : G3
A3 : G3 '
A3 . G3
Previous
Skip
Next
Question # 9
The intersection of a row and column is called;
Choose an answer
Data
Field
Cell
Equation
Previous
Skip
Next
Question # 10
For the custom format ##.000, the number 242.59 will appear as;
Choose an answer
242.59000
24.2590
242.59
None
Previous
Skip
Next
Question # 11
The correct column address is;
Choose an answer
AB
15
3D
D3
Previous
Skip
Next
Question # 12
Which cell address will be include in the range C5 : E7
Choose an answer
C8
C6
E4
D9
Previous
Skip
Next
Question # 13
A formula in MS-Excel begins with symbol.
Choose an answer
+
-
=
/
Previous
Skip
Next
Question # 14
A worksheet contains________ rows.
Choose an answer
65536
256
173214
None
Previous
Skip
Next
Question # 15
Each cell in a spread sheet has a unique
Choose an answer
Row
Column
Address
Both a and b
Previous
Skip
Next
Question # 16
Which of the following is an absolute address;
Choose an answer
A1
A1$
A$1$
None
Previous
Skip
Next
Question # 17
Calling a cell n MS. Excel by just their addresses is called.
Choose an answer
Named range
Labeling
Relative refreshing
Absolute refreshing
Previous
Skip
Next
Question # 18
The actual working area is Microsoft Excel is.
Choose an answer
Workbook
Work sheet
Lotus -123
Database
Previous
Skip
Next
Question # 19
A word book is a group of.
Choose an answer
Table
Formulas
Sheets
Functions
Previous
Skip
Next
Back