Microsoft Excel Section 1 Page 6


126.
The formula to get updatable current data in excel is ……
date()
today()
now()
ctrl + ;
Answer: Option

127.
What is the extension of MS Excel file?
.html
.xls(x)
.pmt
.xml
Answer: Option

128.
Which of the following formula is true in MS Excel?
A1 + B1
=A1+B1
A1+Ba=
A1+C1=
Answer: Option

129.
Intersectional part of rows and columns are known as ……
Column Chart
Table
Row Chart
Cell
Answer: Option

130.
Which function is used to add a series of numbers?
Formula button
Autosum button
Total button
Quick total button
Answer: Option

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

132.
Getting data from a cell located in a different sheet is called ……
Accessing
Referencing
Updating
Functioning
Answer: Option

133.
By formatting a cell in currency, we can specify ……
decimal place
currency symbol
both of above
none of above
Answer: Option

134.
=SUM(B1:B8) is an example of a ……
Function
Formula
Cell Address
Value
Answer: Option

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

136.
In MS Excel 2007, …… numbers of sheet are created by default.
3
5
1
4
Answer: Option

137.
What is the shortcut key to bring format cell dialog box?
Ctrl + F
Ctrl + E
Ctrl + 1
Ctrl + D
Answer: Option

138.
Which one is the last column header in MS Excel 2007?
XFD
XFX
XFL
SFT
Answer: Option

139.
Multiple calculations can be made in a single formula using……
Standard Formula
Complex Formula
Smart Formula
Array Formula
Answer: Option

140.
A circular reference is ……
A formula that depends on itself
A geometric tool
Is always correct
Shows the sum of references
Answer: Option

141.
In MS Excel 2003, a typical worksheet has …… number of columns.
128
256
512
1024
Answer: Option

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

143.
A function inside another function in MS Excel is called …..
sum function
text function
round function
nested function
Answer: Option

144.
In MS Excel workbook is a collection of ……
Cell
Worksheet
Project
Workspace
Answer: Option

145.
To remove the contents of the selected cell, you must choose……
Edit & Delete
Edit & Clear Contents
Edit & Clear All
Data & Delete
Answer: Option

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

147.
Which of the following formula is wrongly typed?
10+50
"=10+50"
"=A1*B1"
"=A1+10"
Answer: Option

148.
Which function is used to calculate depreciation, rate of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
Answer: Option

149.
Conditional count can be performed using……
=countiff()
=countif()
=ifcount()
=iffcount()
Answer: Option

150.
Which of the following formula will not be able to calculate in MS Excel?
"=SUM(Purchase)-A1"
"=SUM(A1:A10)*.6"
"=SUM(A1:A10)/(10-5)"
"=SUM(A1:A10)-5"
Answer: Option

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

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