Question 1

A worksheet range is a

Accepted Answer

Correct Answer: A group of cells

Explanation: A 'Range' in Excel simply refers to a selection of two or more cells. These cells can be adjacent (touching each other, like A1:B10) or non-adjacent. A range is identified by the cell reference of the upper-left cell and the lower-right cell, separated by a colon.

Question 2

The Chart wizard term data categories refers to:

Accepted Answer

Correct Answer: A horizontal axis

Explanation: In Excel charting terminology, 'Categories' typically act as the labels for the data points. These are usually plotted along the horizontal (X) axis. For example, in a sales chart, the months (Jan, Feb, Mar) are the 'Categories', while the sales numbers are the 'Series'.

Question 3

The chart wizard term data series refers to

Accepted Answer

Correct Answer: A collection of chart data markers

Explanation: A 'Data Series' is a row or column of numbers that are plotted in a chart. Visually, it is represented by a collection of data markers (like bars, lines, or pie slices) that originated from the same data source column or row. Each series is usually given a unique color or pattern.

Question 4

Which of the following is not an example of a value?

Accepted Answer

Correct Answer: Serial Number 50771

Explanation: In Excel, 'Values' refer to data that can be used in calculations, such as Numbers (350), Dates (May 10, 2001), and Percentages (57%). 'Serial Number 50771' contains both text ('Serial Number') and numbers, making it a Text String (Label), not a numeric Value.

Question 5

A worksheet can have a maximum of ________ number of rows

Accepted Answer

Correct Answer: 65,535

Explanation: In Excel 2003 and earlier versions, the maximum number of rows in a single worksheet was 65,536. This was a hard limit imposed by the software's architecture at the time. In newer versions (Excel 2007 onwards), the row limit has been increased to 1,048,576 rows to handle 'Big Data'.

Question 6

How many characters can be typed in a single cell in Excel?

Accepted Answer

Correct Answer: 32,000

Explanation: In older Excel versions, the maximum number of characters that a cell could hold was approximately 32,000 (specifically 32,767). While only the first 1,024 characters might display in the cell directly, the cell content itself could store up to this limit. Option C is the closest correct approximation.

Question 7

A typical worksheet has ________ number of columns

Accepted Answer

Correct Answer: 256

Explanation: This question refers to older versions of Excel (like Excel 2003), where the maximum number of columns was limited to 256 (labeled from A to IV). In modern versions (Excel 2007 and later), this limit has been significantly increased to 16,384 columns (labeled up to XFD).

Question 8

Which of the following formulas will Excel Not be able to calculate?

Accepted Answer

Correct Answer: =SUM(A1:A5)/(10-10)

Explanation: Excel cannot calculate Option C because the denominator (10-10) equals zero. Division by zero is mathematically impossible, and Excel will return a '#DIV/0!' error. All other formulas are syntactically and mathematically valid.

Question 9

Which of the following formulas is not entered correctly?

Accepted Answer

Correct Answer: 10+50

Explanation: Option D (10+50) is missing the equals sign (=) at the beginning. Therefore, Excel will simply display '10+50' as text inside the cell and will NOT perform the addition. All other options start with =, so they are valid formulas.

Question 10

Which symbol must all formula begin with?

Accepted Answer

Correct Answer: =

Explanation: The equals sign (=) is the universal trigger for formulas in Excel. It tells the program that the content following it should be calculated mathematically. Without the =, Excel treats the entry as simple text or a number.

Question 11

What symbol is used before a number to make it a label?

Accepted Answer

Correct Answer: '(apostrophe)

Explanation: If you want Excel to treat a number as text (a label) so it doesn't get used in calculations or lose leading zeros (like 007), you type a single apostrophe (') before the number. For example, typing '123 makes Excel store it as the text string '123'.

Question 12

Which of the following is an absolute cell reference?

Accepted Answer

Correct Answer: $A$1

Explanation: An absolute cell reference is denoted by the dollar sign ($) before both the column letter and row number (e.g., $A$1). This locks the reference so that if you copy the formula to another cell, it still points to exactly cell A1, unlike a relative reference (A1) which would shift.

Question 13

The default header for a worksheet is

Accepted Answer

Correct Answer: None

Explanation: By default, a new Excel worksheet has no header or footer. It is empty ('None'). Users must manually go to Page Setup or Insert > Header & Footer to add elements like page numbers, dates, or file names.

Question 14

You can use the format painter, multiple times before you turn it off by

Accepted Answer

Correct Answer: Double clicking the format painter button

Explanation: A single click on the Format Painter allows you to copy formatting once. However, if you 'Double-Click' the Format Painter button, it locks the tool in the 'On' position, allowing you to click and paint formatting onto multiple different cells until you press Esc.

Question 15

When you group worksheets

Accepted Answer

Correct Answer: B and C

Explanation: Grouping worksheets (selecting multiple tabs) allows you to perform bulk actions. You can print all of them at once (B) and type data/formulas into one sheet to have it appear in ALL grouped sheets simultaneously (C). You cannot enter 'variable' (different) data while grouped.

Question 16

Data marker on a chart are linked to data points in a worksheet therefore:

Accepted Answer

Correct Answer: You can change the position of a data marker and automatically change the data point value in the worksheet

Explanation: This describes a specific feature (mostly in older Excel versions) where the link between a chart and data was two-way. Not only did changing data update the chart, but clicking and dragging a chart bar (marker) could actually reverse-calculate and update the number in the cell.

Question 17

Which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

Accepted Answer

Correct Answer: Networkdays

Explanation: The NETWORKDAYS function specifically calculates the number of whole working days between a 'Start_date' and an 'End_date', automatically excluding weekends and optionally excluding holidays. The WORKDAY function is different; it returns a future date based on a number of days added.

Question 18

This type of software is similar to an accountant's worksheet

Accepted Answer

Correct Answer: Spreadsheets

Explanation: Spreadsheet software (like Excel) was digitally modeled after the physical paper worksheets used by accountants (ledgers). The row-and-column grid format was specifically designed to replicate and automate the financial calculations accountants used to do by hand.

Question 19

You cannot link Excel worksheet data to a Word document

Accepted Answer

Correct Answer: With the copy and paste buttons on the standard toolbar

Explanation: Standard 'Copy and Paste' (using the toolbar buttons) creates a static duplicate of the data in Word. It does NOT create a live link. To create a link (where Word updates when Excel changes), you must use 'Paste Special > Paste Link' or Insert Object methods.

Question 20

You can zoom a worksheet

Accepted Answer

Correct Answer: All of the above

Explanation: Zooming can be done in various contexts. In 'Print Preview', clicking the page zooms in/out. You can also use the Zoom toolbar button there. In normal view, you can use View > Zoom or the slider in the bottom status bar to adjust the magnification level.

MS Excel MCQs