Question 1

Which of the following methods cannot be used to edit the content of cell?

Accepted Answer

Correct Answer: Pressing the Alt key

Explanation: There are three main ways to enter 'Edit Mode' in Excel: Double-clicking the cell, clicking inside the Formula Bar, or pressing the F2 key. Pressing the 'Alt' key simply activates the menu bar shortcuts (Key Tips) and does not allow you to edit the cell's content.

Question 2

Which of the following will not set text in selected cells to italics?

Accepted Answer

Correct Answer: Using the Tools - Wizard - Web Form menu item

Explanation: To make text Italic, you can use the keyboard shortcut 'Ctrl + I', use the Italic button on the toolbar, or go to Format > Cells > Font tab. The 'Tools - Wizard - Web Form' menu is used for creating web forms and has absolutely nothing to do with formatting text style like Italics.

Question 3

Which of the following methods cannot be used to enter data in a cell?

Accepted Answer

Correct Answer: Pressing the Esc key

Explanation: When you are typing data into a cell: Pressing Enter, Tab, or any Arrow key will 'commit' (save) the data and move the selection to the next cell. However, pressing the 'Esc' (Escape) key cancels the entry. It deletes what you were typing and reverts the cell to its previous state, so no data is entered.

Question 4

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

Accepted Answer

Correct Answer: Point to speech on the tools menu, and then click show text to speech toolbar.

Explanation: Excel has a 'Text to Speech' feature (Speak Cells) that reads aloud the content of cells. In older versions (like Excel 2002/2003), this was accessed via Tools > Speech > Show Text to Speech Toolbar. This is very useful for verifying data entry without looking back and forth at the screen.

Question 5

Which function calculates your monthly mortgage payment?

Accepted Answer

Correct Answer: PMT (payments)

Explanation: The PMT function calculates the payment for a loan based on constant payments and a constant interest rate. It is commonly used for mortgages and car loans. It requires the interest rate, the number of periods (NPER), and the present value (PV/Loan Amount) to give you the monthly installment.

Question 6

Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

Accepted Answer

Correct Answer: On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

Explanation: This is a classic feature from the time of the Euro currency transition. Excel provided a specific Add-In called 'Euro Currency Tools'. Activating this add-in gave users a toolbar and functions to accurately convert legacy European currencies (like German Marks or French Francs) into Euros based on fixed conversion rates.

Question 7

How should you print a selected area of a worksheet, if you'll want to print a different area next time?

Accepted Answer

Correct Answer: On the file menu, click print, and then click selection under print what

Explanation: If your printing need is temporary (just for this time), you should choose 'Print Selection' in the print dialog. If you use 'Set Print Area' (Option A), Excel saves that area as the default print zone for the future, which you would have to manually clear later. 'Print Selection' is best for one-time specific prints.

Question 8

A function inside another function is called a ______ function.

Accepted Answer

Correct Answer: Nested

Explanation: When you use a function as an argument within another function, it is called a 'Nested' function. For example, =IF(A1>50, 'Pass', IF(A1>40, 'Retest', 'Fail')). Here, the second IF is nested inside the first IF. Excel allows multiple levels of nesting to create complex logic.

Question 9

Which of the following is a correct order of precedence in a formula calculation?

Accepted Answer

Correct Answer: None of these

Explanation: Excel follows a standard mathematical order of operations (PEMDAS). The correct order is: Parentheses (), Reference operators, Negation (-), Percent (%), Exponentiation (^), Multiplication and Division (* /), and finally Addition and Subtraction (+ -). None of the provided options list the hierarchy correctly (e.g., Exponentiation comes before Multiplication).

Question 10

You can print only an embedded chart by

Accepted Answer

Correct Answer: Selecting the chart before you print

Explanation: If you have a chart embedded inside a worksheet along with data, but you only want to print the chart itself, simply click on the chart to select it first. When a chart is selected, Excel's print command automatically isolates the chart and prints it on a full page, ignoring the surrounding cells.

Question 11

Gridlines

Accepted Answer

Correct Answer: a, b and c

Explanation: Excel gives you full control over Gridlines (the faint lines that separate cells). You can configure them independently for viewing and printing. For example, you can keep them visible on your screen while working (View tab) but turn them off for the printed paper (Page Layout tab), or vice versa. Therefore, all options describe valid settings.

Question 12

What does the VLOOKUP function do?

Accepted Answer

Correct Answer: Finds related records

Explanation: VLOOKUP stands for 'Vertical Lookup'. It searches for a specific value in the first column of a table array and returns a value in the same row from a specified column. It is primarily used to find related records, such as looking up a Student ID to find their Name or Marks.

Question 13

How are data organized in a spreadsheet?

Accepted Answer

Correct Answer: Rows and columns

Explanation: The fundamental structure of any spreadsheet (including Excel) is a grid system. Data is organized into horizontal 'Rows' (identified by numbers 1, 2, 3...) and vertical 'Columns' (identified by letters A, B, C...). The intersection of a row and a column creates a 'Cell', which holds the data.

Question 14

Which types of charts can excel produce?

Accepted Answer

Correct Answer: Bar charts, line graphs and pie charts

Explanation: Excel is a powerful visualization tool capable of producing a wide variety of charts. While options A, B, and D restrict the list to just one or two types, option C is the most inclusive correct answer. Excel supports Column, Bar, Line, Pie, Area, Scatter, and many other chart types.

Question 15

Each excel file is called a workbook because

Accepted Answer

Correct Answer: It can contain many sheets including worksheets and chart sheets

Explanation: An Excel file is technically referred to as a 'Workbook'. The analogy is that just as a physical book contains many pages, an Excel Workbook can contain multiple 'sheets'. These sheets can be standard Worksheets (grids for data) or Chart Sheets (dedicated full-page charts), keeping related work together in one file.

Question 16

You can open the consolidate dialog box by choosing Consolidate from the ______ menu.

Accepted Answer

Correct Answer: Data

Explanation: The 'Consolidate' feature combines values from multiple ranges into one new range. This command is categorized as a data management tool. Therefore, in both old and new versions of Excel, you will find the 'Consolidate' button under the 'Data' menu (or Data tab on the Ribbon).

Question 17

Macros are 'run' or executed from the ______ menu.

Accepted Answer

Correct Answer: Tools

Explanation: In older versions of Excel (like Excel 2003), the option to record, run, or edit Macros was located under the 'Tools' menu (Tools > Macro > Macros). In modern versions of Excel (2007 and later), this functionality has been moved to the 'View' tab (Macros button) and the dedicated 'Developer' tab.

Question 18

Except for the ______ function, a formula with a logical function shows the word 'TRUE' or 'FALSE' as a result

Accepted Answer

Correct Answer: IF

Explanation: Standard logical functions like AND, OR, and NOT purely evaluate conditions and return a boolean result: either TRUE or FALSE. The IF function is unique because it allows you to specify exactly what to display (e.g., 'Pass', 'Fail', numbers, or other text) instead of just the standard Boolean True/False.

Question 19

When you insert an Excel file into a Word document, the data are

Accepted Answer

Correct Answer: Linked

Explanation: When you insert an Excel file into Word (using Insert Object), you often have the choice to 'Link' to the file. If the data is 'Linked', any changes made to the original Excel file will automatically update in the Word document. If it were merely 'Embedded', the Word doc would store a static copy that doesn't update with the original file.

Question 20

What function displays row data in a column or column data in a row?

Accepted Answer

Correct Answer: Transpose

Explanation: The TRANSPOSE function is used to rotate the orientation of a data range or array. It converts a vertical range of cells (column) to a horizontal range (row), or vice versa. For example, if you copy a column of names and use 'Paste Special > Transpose', they will be pasted across a row.

MS Excel MCQs