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.
142
The Chart wizard term data categories refers to:
✅ 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'.
143
The chart wizard term data series refers to
✅ 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.
144
Which of the following is not an example of a value?
✅ 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.
145
A worksheet can have a maximum of ________ number of rows
✅ 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'.
146
How many characters can be typed in a single cell in Excel?
✅ 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.
147
A typical worksheet has ________ number of columns
✅ 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).
148
Which of the following formulas will Excel Not be able to calculate?
✅ 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.
149
Which of the following formulas is not entered correctly?
✅ 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.
150
Which symbol must all formula begin with?
✅ 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.
151
What symbol is used before a number to make it a label?
✅ 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'.
152
Which of the following is an absolute cell reference?
✅ 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.
153
The default header for a worksheet is
✅ 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.
154
You can use the format painter, multiple times before you turn it off by
✅ 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.
155
When you group worksheets
✅ 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.
156
Data marker on a chart are linked to data points in a worksheet therefore:
✅ 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.
157
Which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
✅ 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.
158
This type of software is similar to an accountant's worksheet
✅ 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.
159
You cannot link Excel worksheet data to a Word document
✅ 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.
160
You can zoom a worksheet
✅ 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.