Question 1

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

Accepted Answer

Correct Answer: Pivot Table List

Explanation: This question refers to an older feature of Microsoft Office (Office Web Components). A 'Pivot Table List' was a specific component that allowed users to publish interactive Pivot Tables to web pages, enabling browser-based users to sort, filter, and analyze data without needing Excel installed.

Question 2

Excel is a:

Accepted Answer

Correct Answer: A spreadsheet

Explanation: Microsoft Excel is primarily defined as a 'Spreadsheet' program. It is designed for storing, organizing, and analyzing data in a tabular format (rows and columns). While it has some graphic capabilities (charts) and text features, its core identity and function is that of an electronic spreadsheet.

Question 3

What term describes a background that appears as a grainy, non-smooth surface?

Accepted Answer

Correct Answer: pattern

Explanation: In older Excel formatting (Format Cells > Patterns tab), a 'Pattern' referred to a two-color design composed of dots or crosshatches. A high-density dot pattern often looks 'grainy' or non-smooth, unlike a 'Solid' fill which is one smooth color or a 'Gradient' which blends colors smoothly.

Question 4

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

Accepted Answer

Correct Answer: Goal Seek

Explanation: Goal Seek is a 'What-If Analysis' tool. It is used for 'back-solving'. For example, if you know you want the total answer to be 100, but you don't know what input number will get you there, you use Goal Seek. It keeps changing the input cell until the formula returns exactly the result you want.

Question 5

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Accepted Answer

Correct Answer: Right click on the spreadsheet tab and select DELETE

Explanation: The fastest way to remove a worksheet is to right-click its tab (located at the bottom of the Excel window, e.g., 'Sheet1') and choose 'Delete' from the context menu. You can also go to Home > Cells > Delete > Delete Sheet, but right-clicking the tab is the most direct sequence.

Question 6

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ....

Accepted Answer

Correct Answer: B1:G10

Explanation: In Excel, a range is defined by the starting cell and the ending cell, separated by a colon (:). 'B1' is the top-left corner, and 'G10' is the bottom-right corner. Therefore, B1:G10 represents the entire rectangular block of cells between these two points. Other separators like hyphen (-) or semicolon (;) are not used for standard ranges.

Question 7

You can edit existing Excel data by pressing the

Accepted Answer

Correct Answer: F2 key

Explanation: The F2 key is the standard shortcut to switch a cell from 'Ready' mode to 'Edit' mode. Instead of double-clicking a cell or clicking in the Formula Bar, you can simply select the cell and press F2. This places the cursor at the end of the existing content, allowing you to modify it quickly.

Question 8

'Qtr 1, Qtr 2, Qtr 3' is an example of a

Accepted Answer

Correct Answer: Series

Explanation: In Excel, a 'Series' refers to a sequence of data that follows a predictable pattern. 'Qtr 1, Qtr 2, Qtr 3...' is a built-in custom list series. Excel recognizes this pattern, allowing you to use the AutoFill handle to extend it (e.g., automatically adding Qtr 4) without typing it manually.

Question 9

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

Accepted Answer

Correct Answer: Formula

Explanation: A Formula is the fundamental expression in Excel used for calculations. It always starts with an equals sign (=) and can contain cell references, constants, operators (like +, -, *), and functions. It tells Excel exactly how to process the values in specific cells to produce a result.

Question 10

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?

Accepted Answer

Correct Answer: Refresh Data

Explanation: Pivot Tables are not dynamic by default; they capture a snapshot of your data cache. If you change the original numbers in your source sheet, the Pivot Table won't show the new results until you click the 'Refresh Data' button (or press Alt+F5). This forces Excel to re-read the source data and update the report.

Question 11

You can use the formula palette to

Accepted Answer

Correct Answer: create and edit formulas containing functions

Explanation: The 'Formula Palette' (now known as the 'Insert Function' dialog box) helps users build complex formulas. When you click the 'fx' button, it assists you in selecting a function (like SUM, AVERAGE, IF) and inputting the correct arguments without needing to memorize the syntax manually.

Question 12

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

Accepted Answer

Correct Answer: F11

Explanation: F11 is the dedicated shortcut key in Excel to instantly create a default chart. When you select a range of data and press F11, Excel creates a new chart sheet (usually named Chart1) using that data. This is much faster than going through the Insert tab menus.

Question 13

The autofill feature

Accepted Answer

Correct Answer: Extends a sequential series of data

Explanation: AutoFill is a powerful Excel feature that allows you to drag the fill handle to automatically copy data or extend a series (like Days: Mon, Tue, Wed... or Numbers: 1, 2, 3...). It does not automatically sum numbers (that's AutoSum) nor does it apply borders.

Question 14

If you press ____ the cell accepts your typing as its contents.

Accepted Answer

Correct Answer: Enter

Explanation: Pressing the 'Enter' key is the standard way to finish typing in a cell and accept the data (usually moving the selection down to the next cell). While 'Tab' also accepts data (moving right), 'Enter' is the primary key for data entry confirmation in Excel.

Question 15

To copy cell contents using drag and drop, press the

Accepted Answer

Correct Answer: None of these

Explanation: By default, dragging the fill handle or cell border 'Moves' the data. To 'Copy' data using drag and drop, you must hold down the 'Ctrl' key while dragging. Since the 'Ctrl' key is not listed in options A, B, or C, the correct answer is 'None of these'.

Question 16

Which of the following is not a worksheet design criterion?

Accepted Answer

Correct Answer: Description

Explanation: Good spreadsheet design relies on principles like Efficiency (calculations work fast), Auditability (formulas can be checked and traced), and Clarity (data is easy to read). 'Description' is not considered a standard formal design criterion, although documenting your work is good practice.

Question 17

You can open the Highlight Changes dialog box by choosing Track Changes from the ____ Menu.

Accepted Answer

Correct Answer: Tools

Explanation: The 'Track Changes' feature allows users to keep a record of edits made to a workbook. In older menu-based Excel versions, this was accessed via Tools > Track Changes > Highlight Changes. In newer versions, this is often a hidden legacy feature or found under the Review tab if enabled.

Question 18

To protect a worksheet, you can choose Protection and the Protect Sheet from the ____ menu.

Accepted Answer

Correct Answer: Tools

Explanation: In classic Excel interfaces (pre-2007), security features were found under the 'Tools' menu. The path was Tools > Protection > Protect Sheet. In modern Excel versions, you will find these options under the 'Review' tab in the 'Protect' group (Protect Sheet / Protect Workbook).

Question 19

You can quickly change the appearance of your work by choosing Auto Format from the ____ Menu.

Accepted Answer

Correct Answer: Format

Explanation: This question refers to older versions of Excel (like Excel 2003). In those versions, the 'AutoFormat' command was located under the 'Format' menu. In modern Excel (2007 onwards), this specific menu structure doesn't exist, and similar features are found under 'Format as Table' on the Home tab.

Question 20

Which of the following is not an option in the spelling dialog box?

Accepted Answer

Correct Answer: Edit

Explanation: The Spelling dialog box in Excel (and Word) contains buttons like 'Ignore Once', 'Ignore All', 'Change', 'Change All', 'Add to Dictionary', and 'AutoCorrect'. There is no button labeled simply as 'Edit'. If you want to edit the cell content directly, you have to close the dialog box and edit the cell.

MS Excel MCQs

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

Excel is a:

What term describes a background that appears as a grainy, non-smooth surface?

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ....

You can edit existing Excel data by pressing the

'Qtr 1, Qtr 2, Qtr 3' is an example of a

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?

You can use the formula palette to

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

The autofill feature

If you press ____ the cell accepts your typing as its contents.

To copy cell contents using drag and drop, press the

Which of the following is not a worksheet design criterion?

You can open the Highlight Changes dialog box by choosing Track Changes from the ____ Menu.

To protect a worksheet, you can choose Protection and the Protect Sheet from the ____ menu.

You can quickly change the appearance of your work by choosing Auto Format from the ____ Menu.

Which of the following is not an option in the spelling dialog box?