126.
The formula to get updatable current data in excel is ……
127.
What is the extension of MS Excel file?
128.
Which of the following formula is true in MS Excel?
129.
Intersectional part of rows and columns are known as ……
130.
Which function is used to add a series of numbers?
Formula button
Autosum button
Total button
Quick total button
Answer: Option
Discuss about this problem:
Discuss in Forum
131.
To edit the content of a cell in MS Excel, we press ……
F2
Double click on the cell
Click on the formula bar
All of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
132.
Getting data from a cell located in a different sheet is called ……
Accessing
Referencing
Updating
Functioning
Answer: Option
Discuss about this problem:
Discuss in Forum
133.
By formatting a cell in currency, we can specify ……
decimal place
currency symbol
both of above
none of above
Answer: Option
Discuss about this problem:
Discuss in Forum
134.
=SUM(B1:B8) is an example of a ……
135.
Each excel file in called a workbook because ……
It can contain text and data.
It can be modified.
It can contain many sheets including worksheets and chart sheets.
You have to work hard to create it.
Answer: Option
Discuss about this problem:
Discuss in Forum
136.
In MS Excel 2007, …… numbers of sheet are created by default.
137.
What is the shortcut key to bring format cell dialog box?
138.
Which one is the last column header in MS Excel 2007?
139.
Multiple calculations can be made in a single formula using……
Standard Formula
Complex Formula
Smart Formula
Array Formula
Answer: Option
Discuss about this problem:
Discuss in Forum
140.
A circular reference is ……
A formula that depends on itself
A geometric tool
Is always correct
Shows the sum of references
Answer: Option
Discuss about this problem:
Discuss in Forum
141.
In MS Excel 2003, a typical worksheet has …… number of columns.
142.
Which of the following is not the correct way to edit cell content?
Alt Key
F2 Key
Click the formula bar
Double click the cell
Answer: Option
Discuss about this problem:
Discuss in Forum
143.
A function inside another function in MS Excel is called …..
sum function
text function
round function
nested function
Answer: Option
Discuss about this problem:
Discuss in Forum
144.
In MS Excel workbook is a collection of ……
145.
To remove the contents of the selected cell, you must choose……
Edit & Delete
Edit & Clear Contents
Edit & Clear All
Data & Delete
Answer: Option
Discuss about this problem:
Discuss in Forum
146.
Which of the below is false statement?
We can copy data from excel
We can import data in excel
We can export data from excel
None of the above
Answer: Option
Discuss about this problem:
Discuss in Forum
147.
Which of the following formula is wrongly typed?
148.
Which function is used to calculate depreciation, rate of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
Answer: Option
Discuss about this problem:
Discuss in Forum
149.
Conditional count can be performed using……
=countiff()
=countif()
=ifcount()
=iffcount()
Answer: Option
Discuss about this problem:
Discuss in Forum