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
Each cell can contain a
Choose an answer
Label
Value
Formula
All
Previous
Skip
Next
Question # 2
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 # 3
The number of argument in SQRT( ) function is MS-Excel
Choose an answer
One
Two
Equal or range
Equal to column
Previous
Skip
Next
Question # 4
How many arguments does the sun function required
Choose an answer
1
2
3
4
Previous
Skip
Next
Question # 5
Which of the following is an absolute address;
Choose an answer
A1
A1$
A$1$
None
Previous
Skip
Next
Question # 6
Formula can be applied on:
Choose an answer
Values
Labels
Unmerged Cells
None
Previous
Skip
Next
Question # 7
Which of the following is a spreadsheet?
Choose an answer
MS-Word
Ms-Excel
Ms-Powerpoint
Both a & b
Previous
Skip
Next
Question # 8
The intersection of a row and column is called;
Choose an answer
Data
Field
Cell
Equation
Previous
Skip
Next
Question # 9
Which is a correct cell address of worksheet?
Choose an answer
AA
25
3B
C5
Previous
Skip
Next
Question # 10
Which cell address will be include in the range C5 : E7
Choose an answer
C8
C6
E4
D9
Previous
Skip
Next
Question # 11
Which of the following is an absolute address.
Choose an answer
$AI
AI
A$I
$ASI
Previous
Skip
Next
Question # 12
Which of the following is correct column address.
Choose an answer
AA
25
38
CS
Previous
Skip
Next
Question # 13
By default how many worksheets are present in MS-Excel workbook?
Choose an answer
3
4
5
None
Previous
Skip
Next
Question # 14
The actual working area in Excel is;
Choose an answer
Workbook
Worksheet
Spreadsheet
Notesheet
Previous
Skip
Next
Question # 15
The actual working area is Microsoft Excel is.
Choose an answer
Workbook
Work sheet
Lotus -123
Database
Previous
Skip
Next
Question # 16
A signal worksheet contains ________ columns
Choose an answer
65536
256
2365
None
Previous
Skip
Next
Question # 17
Spread sheet is a grid of
Choose an answer
Row
Column
Row and column
None
Previous
Skip
Next
Question # 18
A worksheet contains________ rows.
Choose an answer
65536
256
173214
None
Previous
Skip
Next
Question # 19
Which of the following is a correct column address
Choose an answer
AA
25
3B
C5
Previous
Skip
Next
Back