WorksheetsRS_COM_7
Total questions: 30
Worksheet time: 15mins
Name
Class
Date
1.
Short cut key used for converting the selected text in to right align?
a)
ctrl+R
b)
ctrl+L
c)
ctrl+U
d)
ctrl+J
2.
Short cut key used for converting the selected text in to left align?
a)
ctrl+R
b)
ctrl+L
c)
ctrl+U
d)
ctrl+J
3.
Short cut key used to justify the selected text?
a)
ctrl+R
b)
ctrl+L
c)
ctrl+U
d)
ctrl+J
4.
Give the short cut key to get the help from Windows?
a)
F1
b)
F2
c)
F3
d)
F6
5.
Which short cut key is used for spelling and grammar check?
a)
F1
b)
F2
c)
F3
d)
F7
6.
Which short cut key is used for searching for a word?
a)
ctrl+C
b)
ctrl+F
c)
ctrl+U
d)
ctrl+Z
7.
Which short cut key is used for saving a file?
a)
ctrl+C
b)
ctrl+F
c)
ctrl+S
d)
ctrl+Z
8.
Which short cut key is used for opening a new document?
a)
ctrl+N
b)
ctrl+F
c)
ctrl+S
d)
ctrl+Z
9.
Which short cut key is used for opening an existing file?
a)
ctrl+N
b)
ctrl+O
c)
ctrl+S
d)
ctrl+Z
10.
Which short cut key is used for printing a file?
a)
ctrl+N
b)
ctrl+O
c)
ctrl+P
d)
ctrl+Z
11.
Which key sequence is to be selected for viewing the text in full screen mode?
a)
file-> full screen
b)
view->full screen
c)
edit->full screen
d)
none of these
12.
Which short cut key is used for replacing part of document?
a)
ctrl+R
b)
ctrl+O
c)
ctrl+P
d)
ctrl+Z
13.
The extension for an excel file is
a)
doc
b)
dot
c)
xls
d)
ppt
14.
The excel book is divided in to
a)
document
b)
slides
c)
work sheets
d)
none of these
15.
Microsoft Excel is a ..........program
a)
spread sheet
b)
accounting
c)
word processing
d)
presentation
16.
Each work sheet in excel consists of
a)
slides
b)
documents
c)
rows and columns
d)
none of these
17.
In excel rows and columns determines
a)
space
b)
documents
c)
cells
d)
none of these
18.
Number of rows in excel is
a)
256
b)
65536
c)
100
d)
528
19.
Number of columns in excel is
a)
256
b)
65536
c)
100
d)
528
20.
The cell corresponding to column A and row 20 is
a)
A20
b)
20A
c)
AB
d)
B19
21.
Which key moves the cursor up one page?
a)
page up
b)
page down
c)
end
d)
home
22.
Which key moves the cursor down one page?
a)
page up
b)
page down
c)
end
d)
home
23.
The key which can be used for coming back to first cell,A1
a)
page up
b)
page down
c)
ctrl + end
d)
ctrl + home
24.
For adding the contents of two cells A1 and A2 and to get the result at C1, what should be typed in C1?
a)
A1+A2
b)
=A1+A2
c)
@A1+A2
d)
A1:A2
25.
For adding the contents of two cells A1 and A2 and to get the result at C1, what should be typed in C1?
a)
sum(A1,A2)
b)
sum(A1:A2)
c)
=sum(A1:A2)
d)
A1,A2
26.
For adding the contents of five continuous cells B1 to B5 and to get the results At C1, what should be typed in C1?
a)
=sum(B1,B5)
b)
=sum(B1+B5)
c)
=sum(B1:B2)
d)
None
27.
The list of functions is available in which menu
a)
File
b)
Edit
c)
View
d)
Insert
28.
Which function is used for finding the average of 5 numbers
a)
sum
b)
average
c)
clean
d)
None
29.
Name the function which returns the largest value from a set of values
a)
average
b)
sum
c)
product
d)
Max
30.
When a new Excel file is opened how many sheets does it contain by default?
a)
4
b)
3
c)
2
d)
1
100 %
