MS Excel Questions and Answers

Q: What is the shortcut key for Hyperlink in MS Excel?

The shortcut for inserting a hyperlink in MS Excel is Ctrl + K.Ctrl + K opens the Insert Hyperlink dialog in Excel, Word and PowerPoint alike, so the same key works across MS Office.The others do different things in Excel. Ctrl + R is Fill Right, copying the leftmost cell of a selection into the cells to its right. Ctrl + O opens a workbook. Ctrl + T creates a table from the selected range.

Q: Which function in MS Excel is used to highlight unusual and interesting data by changing the appearance of the cell range based on a condition?

The function is conditional formatting.Conditional formatting changes the appearance of cells (fill colour, font, data bars, colour scales or icon sets) automatically when their values meet a rule, such as values above a threshold or duplicates. It is used to make unusual values and patterns stand out.Merge and Center joins cells into one, What-If Analysis tests how changing inputs affects results (Goal Seek, Scenario Manager, Data Tables), and Wrap Text fits long text on several lines within a cell. None of them depends on a condition.

Q: "What are the two commonly used types of cell references in Excel?

The two common types are Absolute and Relative references.A relative reference such as A1 changes when a formula is copied to another cell, adjusting to the new position. An absolute reference such as $A$1 is fixed with dollar signs and always points to the same cell. Excel also allows mixed references like $A1, which lock only the column or the row.Static and dynamic, fixed and flexible, and positive and negative are not the names Excel uses for cell references.

Q: Where is the Autofill handle located in an active cell?

The AutoFill handle is at the bottom right corner of the active cell.In spreadsheets such as Excel, the fill handle is the small square at the lower right corner of the selected cell or range. Dragging it copies the contents into neighbouring cells or continues a series such as dates, numbers or weekdays. Double-clicking it fills down to match the adjacent column.Nothing that triggers AutoFill appears at the top left, bottom left or top right corners.

Q: Assertion-(A) : Functions in Excel are special programs that accept data and return a value after processing the data.Reason-(R) : Functions are different from regular formulas because they use operators like +, −, *, or /.

The Assertion is true, but the Reason is false.The Assertion describes Excel functions correctly: a function such as SUM or AVERAGE is a predefined formula that takes arguments (data), processes them and returns a value.The Reason is wrong. Ordinary formulas are the ones built from operators like +, −, * and /, for example =A1+A2. Functions differ precisely because they are ready-made, named routines, =SUM(A1:A2), that do the work without the user writing out the operators. So the options calling the Reason true fail.

Q: What is the default referencing mode in a spreadsheet?

The default referencing mode is relative.A reference such as A1 in a spreadsheet formula is relative: when the formula is copied to another cell, the reference shifts by the same number of rows and columns. That is why a formula can be filled down a column and still point to the right row each time.An absolute reference ($A$1) stays fixed when copied, and a mixed reference ($A1 or A$1) fixes only the column or only the row. Both have to be typed deliberately with dollar signs. 'Manual' is not a referencing mode; it is a calculation setting.

Q: What is the intersection of a column and a row on a worksheet called ?

The intersection of a column and a row is a cell.A worksheet is a grid of columns, labelled with letters, and rows, labelled with numbers. Each box where one column meets one row is a cell, and it is where data or a formula is entered.The address (or cell reference), such as B4, is the name of the cell made from its column letter and row number, not the cell itself. A value is what a cell contains, and a column is a whole vertical line of cells.

Q: The _____ feature of MS Excel quickly completes a series of data.

The feature is Auto Fill.Excel's AutoFill extends a series automatically: type Monday, or 1 and 2, select the cells and drag, and Excel continues the pattern (Tuesday, Wednesday..., or 3, 4, 5...). It also copies formulas down a column.The fill handle is the small square at the corner of the selection that you drag to trigger AutoFill; it is the tool, not the feature. AutoComplete suggests an entry from text already typed in the same column, and sorting reorders data rather than completing a series.

Q: In Excel, which symbol is used to start a formula ?

A formula in Excel starts with the = symbol.Typing = at the start of a cell tells Excel that what follows is a formula to calculate, such as =A1+B1 or =SUM(A1:A10), rather than text or a number to store as typed.$ is used inside a formula to make a cell reference absolute ($A$1), not to start one. # appears in error values such as #DIV/0!, and @ has a special use in newer Excel for implicit intersection; neither begins a formula.

Q: In Excel, what is the intersection of a row and column called ?

The intersection of a row and a column is a cell.A worksheet is a grid of columns (lettered A, B, C ...) and rows (numbered 1, 2, 3 ...). Where a column and a row meet is a cell, named by its column letter and row number, such as B3. Each cell holds one value or formula.A range is a group of cells (A1:C5), a data table is a structured block of data or a what-if analysis tool, and 'worksheet element' is too vague to name anything.

What is the shortcut key for Hyperlink in MS Excel?

A.Ctrl + R
B.Ctrl + O
C.Ctrl + T
D.Ctrl + K

Exam Year(s)

MP Lab Technician - 2015,

Answer: D

The shortcut for inserting a hyperlink in MS Excel is Ctrl + K.

Ctrl + K opens the Insert Hyperlink dialog in Excel, Word and PowerPoint alike, so the same key works across MS Office.

The others do different things in Excel. Ctrl + R is Fill Right, copying the leftmost cell of a selection into the cells to its right. Ctrl + O opens a workbook. Ctrl + T creates a table from the selected range.

Discuss in Forum

Which function in MS Excel is used to highlight unusual and interesting data by changing the appearance of the cell range based on a condition?

A.Merge and center
B.What-if analysis
C.Conditional formatting
D.Wrap text

Exam Year(s)

RSMSSB Livestock Assistant - 2025, RSMSSB - 2025,

Answer: C

The function is conditional formatting.

Conditional formatting changes the appearance of cells (fill colour, font, data bars, colour scales or icon sets) automatically when their values meet a rule, such as values above a threshold or duplicates. It is used to make unusual values and patterns stand out.

Merge and Center joins cells into one, What-If Analysis tests how changing inputs affects results (Goal Seek, Scenario Manager, Data Tables), and Wrap Text fits long text on several lines within a cell. None of them depends on a condition.

Discuss in Forum

"What are the two commonly used types of cell references in Excel?

A.Static and Dynamic
B.Absolute and Relative
C.Fixed and Flexible
D.Positive and Negative

Exam Year(s)

RSMSSB - 2025, Rajasthan Nursing Tutor - 2025,

Answer: B

The two common types are Absolute and Relative references.

A relative reference such as A1 changes when a formula is copied to another cell, adjusting to the new position. An absolute reference such as $A$1 is fixed with dollar signs and always points to the same cell. Excel also allows mixed references like $A1, which lock only the column or the row.

Static and dynamic, fixed and flexible, and positive and negative are not the names Excel uses for cell references.

Discuss in Forum

Where is the Autofill handle located in an active cell?

A.Top left corner
B.Bottom left corner
C.Top right corner
D.Bottom right corner

Exam Year(s)

RSMSSB - 2025, NHM Rajasthan Pharmacist - 2025, Rajasthan NHM Pharma Assistant - 2025,

Answer: D

The AutoFill handle is at the bottom right corner of the active cell.

In spreadsheets such as Excel, the fill handle is the small square at the lower right corner of the selected cell or range. Dragging it copies the contents into neighbouring cells or continues a series such as dates, numbers or weekdays. Double-clicking it fills down to match the adjacent column.

Nothing that triggers AutoFill appears at the top left, bottom left or top right corners.

Discuss in Forum

Assertion-(A) : Functions in Excel are special programs that accept data and return a value after processing the data.

Reason-(R) : Functions are different from regular formulas because they use operators like +, −, *, or /.

A.Both (A) and (R) are true, and (R) is the correct explanation of (A).
B.Both (A) and (R) are true, but (R) is not correct explanation of (A).
C.(A) is true, but (R) is false.
D.(A) is false, but (R) is true.

Exam Year(s)

RSMSSB - 2025, Rajasthan ANM - 2025,

Answer: C

The Assertion is true, but the Reason is false.

The Assertion describes Excel functions correctly: a function such as SUM or AVERAGE is a predefined formula that takes arguments (data), processes them and returns a value.

The Reason is wrong. Ordinary formulas are the ones built from operators like +, −, * and /, for example =A1+A2. Functions differ precisely because they are ready-made, named routines, =SUM(A1:A2), that do the work without the user writing out the operators. So the options calling the Reason true fail.

Discuss in Forum

What is the default referencing mode in a spreadsheet?

A.Absolute
B.Relative
C.Mixed
D.Manual

Exam Year(s)

RSMSSB - 2025, RSMSSB Lab Technician - 2025,

Answer: B

The default referencing mode is relative.

A reference such as A1 in a spreadsheet formula is relative: when the formula is copied to another cell, the reference shifts by the same number of rows and columns. That is why a formula can be filled down a column and still point to the right row each time.

An absolute reference ($A$1) stays fixed when copied, and a mixed reference ($A1 or A$1) fixes only the column or only the row. Both have to be typed deliberately with dollar signs. 'Manual' is not a referencing mode; it is a calculation setting.

Discuss in Forum

What is the intersection of a column and a row on a worksheet called ?

A.Column
B.Value
C.Address
D.Cell

Exam Year(s)

Tripura Public Service Commission - 2022,

Answer: D

The intersection of a column and a row is a cell.

A worksheet is a grid of columns, labelled with letters, and rows, labelled with numbers. Each box where one column meets one row is a cell, and it is where data or a formula is entered.

The address (or cell reference), such as B4, is the name of the cell made from its column letter and row number, not the cell itself. A value is what a cell contains, and a column is a whole vertical line of cells.

Discuss in Forum

The _____ feature of MS Excel quickly completes a series of data.

A.Auto Complete
B.Auto Fill
C.Fill Handle
D.Sorting

Exam Year(s)

Tripura Public Service Commission - 2022,

Answer: B

The feature is Auto Fill.

Excel's AutoFill extends a series automatically: type Monday, or 1 and 2, select the cells and drag, and Excel continues the pattern (Tuesday, Wednesday..., or 3, 4, 5...). It also copies formulas down a column.

The fill handle is the small square at the corner of the selection that you drag to trigger AutoFill; it is the tool, not the feature. AutoComplete suggests an entry from text already typed in the same column, and sorting reorders data rather than completing a series.

Discuss in Forum

In Excel, which symbol is used to start a formula ?

A.# symbol at the beginning
B.= symbol before the formula
C.$ symbol before values
D.@ symbol for referencing

Exam Year(s)

Tripura Public Service Commission - 2026,

Answer: B

A formula in Excel starts with the = symbol.

Typing = at the start of a cell tells Excel that what follows is a formula to calculate, such as =A1+B1 or =SUM(A1:A10), rather than text or a number to store as typed.

$ is used inside a formula to make a cell reference absolute ($A$1), not to start one. # appears in error values such as #DIV/0!, and @ has a special use in newer Excel for implicit intersection; neither begins a formula.

Discuss in Forum

10.

In Excel, what is the intersection of a row and column called ?

A.Data table structure
B.Worksheet element
C.Cell in spreadsheet
D.Range of values

Exam Year(s)

Tripura Public Service Commission - 2026,

Answer: C

The intersection of a row and a column is a cell.

A worksheet is a grid of columns (lettered A, B, C ...) and rows (numbered 1, 2, 3 ...). Where a column and a row meet is a cell, named by its column letter and row number, such as B3. Each cell holds one value or formula.

A range is a group of cells (A1:C5), a data table is a structured block of data or a what-if analysis tool, and 'worksheet element' is too vague to name anything.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: MS Excel Questions and Answers || MS Excel MCQ Questions and Answers || MS Excel GK Questions and Answers || MS Excel GK MCQ Questions || MS Excel Multiple Choice Questions and Answers || MS Excel GK || GK on MS Excel || Computer Awareness Questions and Answers || Computer Awareness MCQ Questions and Answers || Computer Awareness GK Questions and Answers || GK on Computer Awareness

MS Excel Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications