Microsoft Excel Section 1 Page 3


51.
…… is not MS Excel function.
MAX
MIN
AVG
MOD
Answer: Option

52.
Which of the following is not available in MS Excel?
Statistical Function
Pivot Table
What if analysis
Mail Merge Facility
Answer: Option

53.
In MS Excel 2003, a worksheet can have a maximum …… number of rows.
256
1024
32000
65536
Answer: Option

54.
A$1 is an example of ……
Relative Reference
Absolute Reference
Mixed Reference
None of the above
Answer: Option

55.
Which is an example of a function?
=ADD(A1:A10)
=A1 + A
=SUM(A1:A10)
=A1 + A10
Answer: Option

56.
Multiple calculation can be made in a single formula using……
Standard Formulas
Array Formula
Complex Formula
Smart Formula
Answer: Option

57.
In MS Excel 2003, comments can be added to cell using ……
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Answer: Option

58.
Workbook is a collection of……
Cells
Worksheet
Workspace
Project
Answer: Option

59.
Filter option is used to……
Arrange data in alphabetical order.
Arrange data in numeric order
Arrange data in chronological order
Extract the records that meet given criteria
Answer: Option

60.
There are the 3 types of data found in spreadsheet, they are……
Data, Word, Number
Equations, Data, Number
Word, Number, Labels
Number, Formula, Labels
Answer: Option

61.
Which of the following is correct to add the numbers A2 and B10?
=SUM(A2,B10)
=SUM(A2:B10)
=SUM(A2 and B10)
=SUM(A2 to B10)
Answer: Option

62.
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Answer: Option

63.
Paste Special command pastes selectively……
Formats
Validations
Formulas
All of the above
Answer: Option

64.
…… deletes a worksheet from excel workbook.
Select the sheet, choose Edit & Delete
Select the sheet, choose Format and Hide
Both of above
None of the above
Answer: Option

65.
In a excel worksheet, you can select……
The Entire Worksheet
Rows
Columns
All of the above
Answer: Option

66.
Which of the following is not a logical operator?
>
<
=
+
Answer: Option

67.
What type of chart is useful for comparing parts of a whole?
Pie Chart
Column Chart
Line Chart
Dot Graph
Answer: Option

68.
Which option can be chosen to convert a column of data into row?
Cut & Paste
Edit>Paste Special>Transpose
Both of above
None of the above
Answer: Option

69.
Which of the following is a popular DOS based spreadsheet package?
Lotus 1-2-3
Word
Smart Cell
Excel
Answer: Option

70.
When a number does not fit into MS Excel column, it looks like ……
###
div/0
#div@
None of the above
Answer: Option

71.
Which chart can be created in MS Excel?
Area
Line
Pie
All of the above
Answer: Option

72.
The first cell in excel worksheet is ……
AA
A1
Aa
A0
Answer: Option

73.
In MS Excel 2007 comments can be added to cell using……
Insert Tab > New Comment
Review Tab > New Comment
Data Tab > New Comment
Formula Tab > New Comment
Answer: Option

74.
To add two cell (C1 and C2) together you use the following formula……
=C1+C2
=ADD(C1+C2)
=TOGETHER(C1:C2)
=C1 plus C2
Answer: Option

75.
Which of the following contains the name of each record on the chart?
Cell
Title
Axis
Legend
Answer: Option

#buttons=(Ok, Go it!) #days=(20)

Our website uses cookies to enhance your experience. Check Now
Ok, Go it!