ExamVeda
Login
Home

Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental

MS Excel MCQ Questions and Answers based on the computer basics. MS Excel are always important for the banking examinations. For IBPS PO, IBPS Clerk, SBI PO, SBI clerk and other banking exams. Page-10 section-1

Each section contains 100 MCQs on MS Excel .
91
What is represented by the small, black square in the lower-right corner of an active cell or range?
Discuss
Answer & Solution
Answer: Option B
Solution:
Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image. MS Excel mcq solution image
92
In Excel, a Data Series is defined as what?
Discuss
Answer & Solution
Answer: Option C
Solution:
In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.
93
In Excel, the Fill Color button on the Formatting toolbar is used for what?
Discuss
Answer & Solution
Answer: Option D
Solution:
Fill Color is used to add or change the background color or pattern of cells.
94
In help menu of Excel, which of the following tabs are found?
Discuss
Answer & Solution
Answer: Option D
Solution:
In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.
95
A ________ is a grid with labeled columns and rows.
Discuss
Answer & Solution
Answer: Option B
Solution:
A worksheet in Excel is made up of Rows and Columns grids. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
96
The active cell:
Discuss
Answer & Solution
Answer: Option D
Solution:
An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.
97
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Discuss
Answer & Solution
Answer: Option D
Solution:
Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts.
A list of Excel Financial Functions in Excel are:
⇒Investment value functions including
1. FV
2. FVSCHEDULE
3. NPV
4. PV
5. RECEIVED
6. XNPV
⇒Internal rate of return functions including
1. IRR
2. MIRR
3. XIRR
⇒Asset depreciation functions including
1. AMORDEGRC
2. AMORLINC
3. DB
4. DDB
5. SLN
6. SYD
7. VDB
⇒Payment functions including
1. CUMIPMT
2. CUMPRINC
3. IPMT
4. ISPMT
5. PMT
6. PPMT
⇒Dollar conversion including
1. DOLLARDE
2. DOLLARFR
⇒Yield functions including
1. YIELD
2. YIELDDISC
3. YIELDMAT
4. ODDFYIELD
5. ODDLYIELD
6. TBILLEO
7. TBILLYIELD
⇒Price functions including
1. PRICE
2. PRICEDISC
3. PRICEMAT
4. ODDFPRICE
5. ODDLPRICE
6. TBILLPRICE
98
B7:B9 indicates:
Discuss
Answer & Solution
Answer: Option B
Solution:
B7:B9 indicates a range of cell between Cells B7 through B9.
99
The Cancel and Enter buttons appear in the:
Discuss
Answer & Solution
Answer: Option B
Solution:
Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar. MS Excel mcq solution image
100
Which of the following methods cannot be used to enter data in a cell
Discuss
Answer & Solution
Answer: Option C
Solution:
Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it's original state.