MS Excel MCQs

Correct Answer: Ctrl+;

The correct answer is Ctrl+;, as asked in this question on MS Excel.

Correct Answer: Data > Filter

In Microsoft Excel, the Filter option is accessed via the Data tab on the ribbon, then clicking Filter. This allows users to sort and display specific rows based on defined criteria.

Correct Answer: Ctrl + ;

In Microsoft Excel, pressing 'Ctrl' and the semicolon ';' simultaneously inserts the current date into the active cell.

Correct Answer: F4

In Microsoft Excel, pressing F4 repeats the last command or action performed.

Correct Answer: Transpose

The Transpose function in Excel allows you to switch the orientation of data from rows to columns or vice versa.

Correct Answer: Logical test and return value

The IF function checks a condition and returns one value if the condition is TRUE and another if it is FALSE.

Correct Answer: Cell

A cell, formed by the intersection of a row and a column, is the fundamental unit of data entry in an Excel worksheet.

Correct Answer: F2

Pressing the F2 key allows a user to enter edit mode for the currently selected cell.

Correct Answer: Ctrl+Page Down

In Excel, Ctrl+Page Down moves to the next worksheet, while Ctrl+Page Up moves to the previous one.

Correct Answer: Insert

The Insert tab on the Excel ribbon contains the Table command used to create tables.

Correct Answer: Perform vertical lookup and return value

VLOOKUP stands for 'Vertical Lookup' and is used to search for data in a column and return a corresponding value from the same row.

Correct Answer: MAX()

The MAX() function returns the largest numeric value in a given set or range of cells.

Correct Answer: SUM()

The SUM() function is used to add all numbers in a selected range of cells.

Correct Answer: MOD()

The MOD() function returns the remainder after a number is divided by a divisor.

Correct Answer: .pdf

.pdf is a document format, not a native Excel workbook format used for storing worksheet data.

Correct Answer: =SUM(A1:A10)

Wait, the original text had a typo prefix. Assuming standard syntax: '=SUM(A1:A10)' is valid. Based on typical exam questions, a formula like '$.=SUM(sales)/(10-5)' is invalid due to characters like '$' being placed incorrectly at the start.

Correct Answer: Adds a range of cells based on a condition

The correct answer is Adds a range of cells based on a condition, as asked in this question on MS Excel.

Correct Answer: SUM

The correct answer is SUM, as asked in this question on MS Excel.

Correct Answer: Alt + Enter

In Excel, Alt + Enter is used to insert a line break inside a single cell.

Correct Answer: .xlsx

.xlsx is the default file format for workbooks in modern versions of Microsoft Excel.

Correct Answer: =NOW()

The =NOW() function in Excel returns the current date and time.

Correct Answer: =

In Microsoft Excel, every formula must begin with an equal sign (=).

Correct Answer: Formula Bar

The Formula Bar in Excel displays the contents of the active cell, including formulas and cell references.

Correct Answer: Numbers

In Excel, rows are identified by numbers along the left side, while columns are identified by letters.

Correct Answer: F1

The F1 function key is the standard shortcut in most Microsoft Office applications, including Excel, to open the Help menu.

Correct Answer: 1,048,576

Since Excel 2007, the maximum number of rows per worksheet has been 1,048,576.

Correct Answer: 100

Microsoft Excel allows for a default of 100 undo actions.

Correct Answer: Name Box

The Name Box, located to the left of the formula bar, displays the cell reference or name of the currently selected cell.

Correct Answer: Cell

A cell is the rectangular space created by the intersection of a row and a column in a spreadsheet program.

Correct Answer: B1:B2

A cell range is defined by two or more cells, represented by the starting cell and the ending cell separated by a colon.

Correct Answer: COUNT IF

The COUNTIF function is used to count cells in a range that meet a single specific criterion.

Correct Answer: Alt + =

Alt + = is the shortcut for the AutoSum feature in Excel, which automatically sums a column or row of data.

Correct Answer: Auto Fill

Auto Fill is an Excel feature that automatically fills data based on a pattern or series.

Correct Answer: Ascending Order

Sorting from A to Z arranges items in ascending order; sorting from Z to A is descending.

Correct Answer: 1,048,576

Modern versions of Microsoft Excel support 1,048,576 rows per worksheet.

Correct Answer: =

In Excel, every formula must begin with the equals sign (=) to tell the application to perform a calculation.

Correct Answer: Name Box

The Name Box, located to the left of the formula bar, displays the cell reference (address) of the currently selected cell.

Correct Answer: Moving cell content away from the cell border

Indentation in Excel increases the space between the cell border and the text content within the cell.

Correct Answer: =AVERAGE(B3:E5)

The AVERAGE function in Excel calculates the arithmetic mean of the specified cell range.

Correct Answer: Book1

By default, Microsoft Excel names new workbooks as 'Book1' until they are saved with a specific name.

Correct Answer: =

In Microsoft Excel, every formula must begin with an equals sign (=).

Correct Answer: Formula Bar

The Formula Bar in Excel shows the value or formula contained in the currently selected cell.

Correct Answer: Copy formatting one cell to other

Format Painter allows you to apply the same formatting from one object or cell to another.

Correct Answer: Formula

Formulas are expressions that perform calculations on data in a worksheet.

Correct Answer: Insert chart

The 'Insert' tab in Excel provides the options to create various types of charts from selected data.

Correct Answer: Retrieve data vertically from table

VLOOKUP stands for 'Vertical Lookup' and is used to search for data in the first column of a table.

Correct Answer: .xlsx

The default file format for Excel 2007 and later is .xlsx.

Correct Answer: Font

The Font option allows for customization of text style, size, and formatting within Excel cells.

Correct Answer: To lock specific rows or columns

Freeze Panes keeps specific rows or columns visible while scrolling through the rest of the worksheet.

Correct Answer: Print area

The 'Print Area' feature enables users to define specific sections of a sheet to be printed.

Correct Answer: To combine two or more cells in one cell

CONCATENATE joins text from two or more cells into one single cell.

Correct Answer: F11

Pressing the F11 key in Excel instantly creates a default column chart based on the currently selected data range on a new chart sheet.

Correct Answer: =

All formulas and functions in Microsoft Excel must begin with an equal sign (=).

Correct Answer: To add up a range of cells

The SUM function mathematically adds all numbers within a selected range of cells.

Correct Answer: Now

The NOW() function in Excel returns the current date and time formatted as a date and time.

Correct Answer: Pivot table

Pivot tables are powerful tools in Excel used specifically to calculate, summarize, and analyze large datasets.

Correct Answer: Worksheets and Charts

In Microsoft Excel, a single workbook contains multiple sheets, which can be either data worksheets or chart sheets.

Correct Answer: Title bar

The Title bar is located at the top of the application window in Microsoft Excel.

Correct Answer: Pressing the Alt key

The Alt key alone does not initiate editing; F2, double-clicking, and the formula bar are standard methods.

Correct Answer: Capitalize the first letter in a text string

The PROPER function in Excel capitalizes the first letter of each word in a text string.

Correct Answer: xlsx

The default file extension for modern Microsoft Excel workbooks is .xlsx.

Correct Answer: F11

Pressing F11 in Excel creates a new chart sheet based on the selected data range.

Correct Answer: All of these

Various formula structures, including nested functions and complex combinations, are used for advanced calculations in spreadsheet software.

Correct Answer: Automatically adds a range of cell values

The AutoSum feature in Excel automatically creates a SUM formula for a selected range of cells.

Correct Answer: Use no border

To remove borders previously applied to a cell or range in Excel, you select the area and choose the 'No Border' option from the Borders menu.

Correct Answer: Shift

Holding down the Shift key while dragging a column boundary in Excel allows you to insert the column into a new location without overwriting existing data.

Correct Answer: Data

The 'Remove Duplicates' feature is located under the 'Data' tab in the MS Excel ribbon.

Correct Answer: View >Window>Split

To divide the worksheet window into separate panes in Excel, you navigate to the View tab and select Split.

Correct Answer: Intersection of rows and columns

In spreadsheet programs like Excel, a cell is formed by the spatial intersection of a horizontal row and a vertical column.

Correct Answer: =

In MS Excel, every formula or function must begin with an equals sign '=' so the application knows to calculate the entry.

Correct Answer: 3

Excel utilizes exactly three types of cell references: Relative (A1), Absolute ($A$1), and Mixed (A$1 or $A1).

Correct Answer: Cell

A cell is the fundamental unit of a spreadsheet, identified by a column letter and row number intersection, like C4.

Correct Answer: Both A & B

In Excel's conditional formatting, formats can be applied based either on the static value inside a cell or through a dynamic formula evaluation.

Correct Answer: 7

Applying BODMAS: (7-3) = 4, (4+3) = 7. Formula is 4 * 7 / 4. 28 / 4 = 7.

Correct Answer: A1:A10

In MS Excel, a colon (:) is used as the range operator to refer to a continuous block of cells, such as A1:A10.

Correct Answer: Data validation

Drop-down lists in Excel are created using the 'Data Validation' feature located under the Data tab.

Correct Answer: It finds the position of a value in a range or array.

The MATCH function returns the relative numerical position of an item in an array that matches a specified value.

Correct Answer: Highlights values or cells based on a condition or criteria

Conditional formatting automatically applies distinct visual formatting (like colors) to cells that meet certain preset conditions.

Correct Answer: Pie Chart

A pie chart displays data in a circular graph, with slices representing relative sizes of a whole.

Correct Answer: AutoSum

AutoSum provides a fast, one-click way to automatically inject the =SUM() formula around contiguous data blocks.

Correct Answer: Select data that needs to be analyzed

Before inserting a Pivot Table in Excel, you must first highlight or select the contiguous range of tabular data you intend to analyze.

Correct Answer: Format menu

The Format menu (often found under Format Cells > Number > Custom) allows users to set custom date patterns like YYYY/MM/DD.

Correct Answer: Pencil work

Spreadsheet software features active cells, menus, and workbooks, whereas 'pencil work' is a physical, non-digital task.

Correct Answer: $A$1

In Excel, an absolute cell reference uses dollar signs ($) to lock the column and row coordinates so they do not change when copied.

Correct Answer: The data in the cell is changed or deleted

Smart tags respond to specific data types; altering or deleting the core data in the cell removes the contextual trigger for the tag.

Correct Answer: Document

In MS Excel, files are called Workbooks consisting of Worksheets/Cells, whereas 'Document' is the nomenclature for MS Word.

Correct Answer: organize data

MS Excel is a powerful spreadsheet application used for data organization, calculation, and analysis.

Correct Answer: Automatically adds range of cell values

AutoSum is an Excel function that rapidly inserts a formula to compute the total sum of adjacent cells.

Correct Answer: =

All formulas in Microsoft Excel must start with the equals (=) sign to inform the software that the content is a calculation.

Correct Answer: Insert

To create a chart in Excel, the user navigates to the 'Insert' tab and selects the desired chart type from the Charts group.

Correct Answer: Double clicking on column right border on column header

In Excel, double-clicking the right border of a column header automatically adjusts the column width to fit the content.

Correct Answer: All of these

The 'Paste Special' command allows users to selectively paste specific attributes like formulas, formatting, or validation rules.

Correct Answer: Now

The =NOW() function in Excel returns the current date and time and updates whenever the worksheet is recalculated.

Correct Answer: Can place a chart on a new chart sheet or on any sheet in the workbook

Excel provides the flexibility to embed a chart within an existing worksheet or display it on a separate dedicated chart sheet.

Correct Answer: $

The dollar sign ($) is used to create an absolute cell reference, preventing the reference from changing when copied.

Correct Answer: Standard

The Open icon is typically located on the 'Standard' toolbar to quickly access and open saved workbooks.

Correct Answer: A, B, C

Excel columns are identified by letters (A, B, C...) while rows are identified by numbers.

Correct Answer: $A$1

In Excel, the dollar sign ($) is used to denote an absolute cell reference, keeping the row and column fixed.

Correct Answer: Ctrl+'

Ctrl+' (or Ctrl+Shift+Double Quote) is the shortcut in Excel to copy the formula or value from the cell directly above.

Correct Answer: xls

.xls is the legacy extension for Excel, while .xlsx is the current standard; among the provided choices, .xls identifies Excel.