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-8 section-1

Each section contains 100 MCQs on MS Excel .
71
How do you display current date only in MS Excel?
Discuss
Answer & Solution
Answer: Option B
Solution:
DATE - returns the serial date value for a date
TODAY - returns today's date
NOW - returns the current date and time
TIME - assemble a proper time.
72
How do you wrap the text in a cell?
Discuss
Answer & Solution
Answer: Option D
Solution:
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.
73
What does COUNTA () function do?
Discuss
Answer & Solution
Answer: Option D
Solution:
COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.
74
What is the short cut key to highlight the entire column?
Discuss
Answer & Solution
Answer: Option D
Solution:
Ctrl + Space Bar is the short cut key to highlight the entire column.
75
In the formula, which symbol specifies the fixed columns or rows?
Discuss
Answer & Solution
Answer: Option A
Solution:
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
76
Excel displays the current cell address in the ________
Discuss
Answer & Solution
Answer: Option C
Solution:
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a named range.
77
What is the correct way to refer the cell A10 on sheet3 from sheet1?
Discuss
Answer & Solution
Answer: Option A
Solution:
First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.
It would be look like =Sheet3!A10
78
Which language is used to create macros in Excel?
Discuss
Answer & Solution
Answer: Option A
Solution:
VBA (Visual Basic for Applications) is the programming language of Excel with VBA we can automate tasks in Excel by writing so called macros.
79
Which of the following is not a term of MS-Excel?
Discuss
Answer & Solution
Answer: Option D
Solution:
A worksheet in Excel is made up of Rows and Columns. 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.
80
How many worksheets can a workbook have?
Discuss
Answer & Solution
Answer: Option D
Solution:
Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.