English 40 Practice Speed Passage
Typing English 40 (GCC, GCC-TBC) speed passage practice file. (10 passage)English 40 Speed (GCC-TBC)
July 2023 Exam - Selected Question
MS Excel (25-Question)
1.
Aver() function
in MS Excel 2010 will find average of the numbers from given cells ?
A.
TRUE
B.
FALSE
B
2.
Which function
will add two numbers in cells A1 and A2 in MS Excel 2010?
A.
=A1 and A2
B.
=A1 add A2
C.
=sum(A1,A2)
D.
=add(A1,A2)
C
3.
In MS-Excel, sort
command has ________ types.
A.
3
B.
2
C.
5
D.
7
A
4.
We cannot use
____ in Formula while Typing Formula in cell
A.
Special Characters
B.
Characters
C.
Spaces
D.
Numbers
C
5.
Z-A sequence
indicates _______ sorting of the text
A.
Descending
B. Ascending
C. Vertical
D. Numeric
A
6. In MS-Excel Arranging
data in specific order is called as ________
A. Data Manipulation
B. Data Abstraction
C. Data Certification
D. Data Sorting
D
7. Which cell will become
active if we press ctrl + home key in MS Excel 2010?
A. a1
B. b1
C. c1
D. d1
A
8. ............ is Date and
Time Function
A. =HOUR()
B. =AND()
C. =IF()
D. =FIND()
A
9. Sort and Filter Commands
in Home Tab are also available in _____Tab
A. View
B. Data
C. Page Layout
D. Insert
B
10.
The formula bar in MS Excel 2010 shows contents of cell and formula entered
in cell.
A. TRUE
B. FALSE
A
11.
In MS Excel How
to insert Hyperlink
A.
Ctrl+L
B.
Ctrl+k
C.
Ctrl+R
D.
Ctrl+1
B
12.
"Pie"
is types of .....................
A.
Page
B.
Page Layout
C.
Picture
D.
Chart
D
13.
__________Function
converts the number into nearest integer.
A.
Round()
B.
Min()
C.
if()
D.
int()
D
14.
= SUM(E8:E11)
this function rearrange the values in cells range between E8 to E11.
A.
TRUE
B.
FALSE
B
15.
In Excel Vlookup
is used to search data by reference vertically
A. TRUE
B. FALSE
A
16.
Which is called
to square formed by the intersection of rows and columns in MS Excel 2010?
A.
cell
B.
column
C.
borders
D.
rows
A
17.
We can set
password for protecting worksheet/workbook.
A.
TRUE
B.
FALSE
A
18.
File in excel
2010 has __________ extension.
A.
.doc
B.
.xls
C.
.xlsx
D.
.xlx
C
19.
In Worksheet 'C'
column and Row 7th that particular Cell will be recognized as ____________
A.
C7
B.
7c
C.
c*7
D.
c+7
A
20.
Which function
can be used to calculate average in MS Excel 2010?
A. avg()
B. aver()
C. percent()
D. average()
D
21.
In MS Excel 2010
which group contains the sort & filter, find and select options?
A.
Alignment group
B.
font group
C.
cells group
D.
editing group
D
22.
The checkboxes
for which protection is to be given are set to be ________
A.
OFF
B.
ON
C.
Group
D.
ungrouped
B
23.
Row are label as _____________
A.
1,2,3,4,...........
B.
I,II,III,............
C.
A,B,C,D,..........
D.
a,b,c,d,.........
A
24.
Using =
Min(B2:b10) Formula, we get the smallest number in Cell B2 to B 10.
A.
TRUE
B.
FALSE
A
25.
With ______Option
Current System Date get inserted in cell
A.
Date()
B.
Set Date()
C.
Current Date ()
D. Today()
D
