Objective questions with answers on Microsoft Excel
If you are looking for multiple choice questions with answers on MS-Excel, you are at the right place. We have compiled all possible question answers for MS-Excel to help you in preparing for competitive exams, interview or online aptitude tests. These MCQs will also make you an expert in Microsoft Excel. The objective question answers will be added to the post – MCQs on Microsoft Excel for Interview and Online Aptitude Test, keep visiting for future updates. Learn MS-Excel and secure a desired job.
1. How do you display current date only in MS Excel?
A. Date ()
B. Today ()
C. Now ()
D. Time ()
Answer
Answer: Option B
Explanation : 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.
2. How do you wrap the text in a cell?
A. Format cells font
B. Format cells protection
C. Format cells number
D. Format cells alignment
Answer
Answer: Option D
Explanation : 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.
3. What does COUNTA () function do?
A. Counts cells having alphabets
B. Counts empty cells
C. Counts cells having number
D. Counts non-empty cells
Answer
Answer: Option D
Explanation : COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.
4. What is the short cut key to highlight the entire column?
A. Ctrl + C
B. Ctrl + Enter
C. Ctrl + Page Up
D. Ctrl + Space Bar
Answer
Answer: Option D
Explanation : Ctrl + Space Bar is the short cut key to highlight the entire column.
5. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. ;
Answer
Answer: Option A
Explanation : 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.
6. You can convert existing excel worksheet data an charts to an HTML document by using
A. FTP wizard
B. Internet assistant wizard
C. Intranet wizard
D. Import wizard
Answer
Answer: Option B
Explanation : The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data to HTML format. It is designed for the 1997 and earlier versions of Excel.
7. A circular reference is
A. Geometric modeling tool
B. A cell that points to a drawing object
C. A formula that either directly or indirectly depends on itself
D. Always erroneous
Answer
Answer: Option C
Explanation : A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.
8. Which of following is Not one of Excel’s what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
Answer
Answer: Option D
Explanation : Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.