51.
…… is not MS Excel function.
52.
Which of the following is not available in MS Excel?
Statistical Function
Pivot Table
What if analysis
Mail Merge Facility
Answer: Option
Discuss about this problem:
Discuss in Forum
53.
In MS Excel 2003, a worksheet can have a maximum …… number of rows.
54.
A$1 is an example of ……
Relative Reference
Absolute Reference
Mixed Reference
None of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
55.
Which is an example of a function?
=ADD(A1:A10)
=A1 + A
=SUM(A1:A10)
=A1 + A10
Answer: Option
Discuss about this problem:
Discuss in Forum
56.
Multiple calculation can be made in a single formula using……
Standard Formulas
Array Formula
Complex Formula
Smart Formula
Answer: Option
Discuss about this problem:
Discuss in Forum
57.
In MS Excel 2003, comments can be added to cell using ……
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Answer: Option
Discuss about this problem:
Discuss in Forum
58.
Workbook is a collection of……
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
62.
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Answer: Option
Discuss about this problem:
Discuss in Forum
63.
Paste Special command pastes selectively……
Formats
Validations
Formulas
All of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
65.
In a excel worksheet, you can select……
The Entire Worksheet
Rows
Columns
All of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
66.
Which of the following is not a logical operator?
67.
What type of chart is useful for comparing parts of a whole?
Pie Chart
Column Chart
Line Chart
Dot Graph
Answer: Option
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
69.
Which of the following is a popular DOS based spreadsheet package?
70.
When a number does not fit into MS Excel column, it looks like ……
71.
Which chart can be created in MS Excel?
72.
The first cell in excel worksheet is ……
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum