Excel
1) It is a software tool that lets one enter,
calculate, manipulate set of numbers
a)Speed sheet
b)Spread Sheet
c)Slide Sheet
d)None of these
2) It is a grid of cells made up of
horizontal and Vertical numbers
a)Worksheet
b)Sheet
c)Speed sheet
d)Page
3) It is a group of work sheets
a)folder
b)Document
c)Work book
d)Books
4) Three types of data can be entered in a
worksheet, number/character, text and ______
a)Formulas
b)Function
c)Logic
d)None of these
5) Cells can be referenced in how many ways?
a)2
b)3
c)4
d)5
6)A range can be cleared through this command
a)Edit-Copy
b)Edit-Paste
c)Edit-Clear
d)Edit-Cut
7)General arrangement of data is known as:
a)Arrangement
b)Overwriting
c)Manipulating
d)Formatting
8) Formatting option available in which menu?
a)Format
b)Edit
c) Windows
d)File
9)The pictorial representation of worksheet
data
a)Graph
b)Chart
c)Both a and b
d)None
10)Chart in Excel are saved in how many ways?
a)1
b)2
c)3
d)4
11)To select the current row press
a)Shift + Enter
b)Shift + Spacebar
c)Ctrl + Spacebar
d)Ctrl + C
12)To select the current column press
a)Ctrl + Spacebar
b)Ctrl + B
c)Shift + Enter
d)Ctrl + Enter
12)To select the current column press
a)Ctrl + Spacebar
b)Ctrl + B
c)Shift + Enter
d)Ctrl + Enter
13)To select the entire worksheet
a)Ctrl + B
b)Ctrl + V
c)Ctrl + A
d)Ctrl + C
14)By default height of row is points
a)12.75
b)12.01
c)12.50
d)12.30
15)By default Column width is points
a)8.40
b)8.43
c)8.50
d)8.20
16)Ms- Excel contains how many rows?
a)65,500
b)65,530
c)65,400
d)65,536
17)Ms-Excel contains how many column?
a)256
b)250
c)240
d)245
18)To enter current date press
a)Ctrl + L
b)Ctrl + ;
c)Ctrl + V
d)Ctrl + P
19)The Extension of saved file in MS-Excel
a).XIS
b).XAS
c).XLS
d).XLL
20)All formula starts with which sign in
Ms-Excel?
a)+
b)-
c)@
d)=
21)For creating an absolute reference, which
sign is used?
a)$
b)@
c)#
d)!
22)How many data series is there in chart?
a)250
b)255
c)260
d)265
23)Which button is used to undo a cell entry?
a)Ctrl
b)Enter
c)Cancel
d)Esc
24)A cell entry can be edited in the cell or
in the
a)Menu bar
b)Edit menu
c) Function bar
d) Formula bar
25) Which one of the following chart shows
only one data series?
a)Pie
b)Line
c)Bar
d)Column
26)A chart placed in worksheet is called
a)Formatting chart
b)Embedded chart
c)Aligning chart
d)None of above
27)Which chart shows the relationship of
parts to a whole?
a)Pie
b)Line
c)Stacked bar
d)Embedded
28)Scatter chart is also known as
a)XX chart
b)YX chart
c)XY chart
d)YY chart
29)The address of cell at 20th column and
30th row
a)T30
b)T20
c)T10
d)T40
30)The cell having bold boundary is called
a)Relative
b)Active
c)Absolute
d)Mixed
31)Cell address A4 in a formula means
a)Mixed cell reference
b)Absolute reference
c)Relative cell reference
d)All of above
32)Cell address $A$4 in a formula means it is
a
a)Mixed cell reference
b)Absolute reference
c)Relative cell reference
d)All of above
33)Cell address $A4 in a formula means it is
a
a)Mixed cell reference
b)Absolute reference
c)Relative cell reference
d)All of above
34)Cell address A$4 in a formula means it is
a
a)Mixed cell reference
b)Absolute reference
c)Relative cell reference
d)All of above
35)How would you refer to the range starting
from 1st column, 1st row and spread till 5th column and 3rd row?
a)A1:E3
b)A2:F3
c)A1:F3
d)A1:F1
36)By which command we can link a table with
Excel worksheet
a)Get external data
b)Join
c)Attach
d)Merge
37)You can use a function to combine text
from two cells into one cell. But you can use operator to do this. Which is
operator is that?
a)& (ampersand)
b)= (equal sign)
c)Space
d)All of these
38)Two common wildcard characters that excel
recognizes are
a)* and ?
b)< and >
c)^ and /
d)+ and –
39)In Excel the intersection of row and
column is called
a)Square
b)Cell
c)Cube
d)Worksheet
40)The multiplication arithmetic operator is
represented by which of the following symbols?
a)^
b)*
c)X
d)None of the above
41)To add two cells (A1 and A2) together you
use the following formula
a)=A1+A2
b)=ADD(A1+A2)
c)=TOGETHER(A1:A2)
d)A1 PLUS A2
42)To make a number in cell c1 10% smaller
than the number in C3 you enter
a)=C3*1.10
b)+C3*110
c)=C3%10
d)=C3*.90
43) Anything that is typed in worksheet
appears
a)In the formula bar only
b)In the active cell only
c)In both active cell and formula
bar
d)None of these
44)Using the F11 shortcut key to create a
chart sheet, creates
a)A default chart
b)A 2-dimensional column chart
c)A 2-dimensional bar chart
d)A 3-dimensional bar chart
45)You can print :
a)A range of cells by range name
b)An entire worksheet
c)A single worksheet
d)All of these
46)You can create only a horizontal page
break by first selecting
a)A row below the row where you
want the page break to occur
b)A cell in row 1
c)A cell in column A
d)Both a and c
47)The advantage of using spread sheet is
a)Calculation can be done
automatically
b)Changing data automatically
update calculations
c)More flexibility
d)All of the these
48)Which of following is popular DOS based
spread sheet package?
a)Word
b)Smart Cell
c)Excel
d)Lotus 1-2-3
49)How is data organized in a spreadsheet?
a)Lines and spaces
b)Layers and planes
c)Height and width
d)Rows and column
50)Excel files have a default extension of
a).xls
b).xlw
c).wk1
d)123
No comments:
Post a Comment