CS Free MCQ Bank

[ Option D ]

Macro is a feature in MS Excel that records a sequence of actions so that they can be automatically (saves time) repeated later. It is mainly used to automate repetitive tasks and maintain consistency (uniformity) in formatting or calculations.

[ Option D ]

The Percent (%) operator actually has a higher precedence than ^ (Exponentiation) and operates immediately after evaluating the number it follows.

[ Option D ]

MS Excel supports many built-in functions for calculations and data analysis. Functions like count(), min(), and max() are all valid and are used to count items, find the minimum value, and find the maximum value in data, respectively.

Common Excel Mathematical Functions:

[ Option C ]

The Calibri with a font size of 11 points has been the default font in Microsoft Office (Word, Excel, PowerPoint) since Office 2007, replacing Times New Roman.

[ Option B ]

In Microsoft Excel, a formula is an expression used to perform calculations or other actions on data in worksheet cells. Every valid Excel formula begins with an Equal Sign (=), which signals to Excel that the cell contains a formula, not just plain text, or numbers.

Remember:

• Equal Sign (=) : Used for starting a formula in Excel.
• Dollar Sign ($) : Used for absolute cell references in formulas.
• Hash Sign (#) : Used to indicate error messages or overflow in cells.
• At Sign (@) : Used for dynamic arrays or structured references.

[ Option C ]

User Authentication is not a type of data input in spreadsheets. Authentication relates to verifying user identity and is handled by security systems, not by spreadsheet data entry.

[ Option D ]

In MS Excel, the LCM function is used to calculate the Least Common Multiple of one or more numbers. The LCM is the smallest number that is divisible by all the given numbers with remainder 0. For example, the formula =LCM(5, 7, 35) calculates the LCM of 5, 7, and 35.

[ Option B ]

In Excel 2016, when you want to insert multiple columns, it is important to understand that Excel always inserts new columns to the left of the selected column(s). 

To insert 3 columns between Column G and H, we need to select Column H first. By right-clicking and choosing Insert, a new column will appear to the left of H. Repeating this process three times will insert three new columns exactly between G and H.

[ Option C ]

• In row 1, A1 is 60 and C1 is 75, so 60 ≠ 75 : Output is F.
• In row 2, A2 is 70 and C2 is 70, so 70 = 70 : Output is T.
• In row 3, B3 is 90 and D3 is 90, so 90 = 90 : Output is T.
   

[ Option B ]

Sorting in a spreadsheet like MS Excel, refers to arranging data in a specific order, either ascending (smallest to largest or A to Z) or descending (largest to smallest or Z to A). This helps organize data logically for easier analysis and viewing.

[ Option A ]

A Pivot Table is a powerful feature in Microsoft Excel used to summarize, analyze, explore, and present large sets of data quickly. Pivot Tables let users drag and drop fields to quickly change reports and analyze data trends interactively.

IMPORTANT EXCEL FEATURES:

[ Option B ]

In Microsoft Excel, a formula is an expression used to perform calculations or other actions on data in worksheet cells. Every valid Excel formula begins with an Equal Sign (=), which signals to Excel that the cell contains a formula, not just plain text, or numbers.

Remember:

• Equal Sign (=) : Used for starting a formula in Excel.
• Dollar Sign ($) : Used for absolute cell references in formulas.
• Hash Sign (#) : Used to indicate error messages or overflow in cells.
• At Sign (@) : Used for dynamic arrays or structured references.

[ Option B ]

In Microsoft Excel, a Workbook (Excel file) contains one or more Worksheets (commonly called "sheets"). Each sheet has a name, shown on the sheet tab at the bottom (like Sheet1, Sheet2, etc.). Users can rename sheets to give them meaningful names (like RSSB_Questions, RPSC_Questions, etc.).

When naming an Excel worksheet (sheet), the name must have at least 1 character (it cannot be left blank) and name cannot exceed 31 characters. The name cannot contain certain characters like:

• : (Colon)
• (Backslash)
• / (Forward Slash)
• ? (Question Mark)
• * (Asterisk)
• [ (Left Square Brackets)
• ] (Right Square Brackets)
• Cannot begin or end with a single quote ( ' ).

[ Option D ]

[ Option D ]

In Microsoft Excel, the shortcut key to hide the selected column is Ctrl + 0. This shortcut quickly hides the entire column containing the selected cell(s).

[ Option B ]

The function RIGHT(text, num_chars), returns the last num_chars characters from a given text string.
Syntax:
RIGHT(text, num_chars)

• The text is the string from which you want to extract characters.
• The num_chars is number of characters to extract from the right end of the string.

The string "india" has 5 characters. The function =RIGHT("india", 2) returns last 2 characters, which are "i" and "a", i.e, "ia".

[ Option A ]

[ Option B ]

In older versions of Microsoft Excel (Excel 2003), the maximum number of rows per worksheet was 65,536 (2¹⁶). The number of columns in those versions was 256. This limit was increased in later versions (starting from Excel 2007) to 10,48,576 rows and columns to 16,384.

[ Option C ]

Conditional Formatting in MS Excel is the feature that highlights unusual and interesting data by automatically changing the appearance of cells or a cell range based on specified conditions. Users can set rules based on numbers, text, or formulas. For example, highlighting cells greater than a certain value, duplicate entries, or specific dates.

COMMONLY USED CONDITIONAL FORMATTING OPTIONS:

• Merge and Center : Combines multiple cells into one and centers text.
• What-If Analysis : Used for forecasting and scenario analysis.
• Wrap Text : Displays text on multiple lines within a single cell.

[ Option C ]

In Microsoft Excel, navigating between different sheets (worksheets) within a workbook can be quickly done using keyboard shortcuts.

[ Option D ]

The PMT (Payment) function in Excel calculates periodic loan payments considering a fixed interest rate, loan term, and principal.

Syntax: =PMT(rate, nper, pv) 
Where:
Rate = Interest rate per period.
Nper = Total number of payment periods.
Pv = Present value or loan amount.

MS Excel : Financial Functions:

[ Option D ]

In a spreadsheet application like MS Excel or Google Sheets, the Wrap Text option is used to display the entire text within a single cell by breaking the text into multiple lines automatically based on the cell width.

• Without wrapping, long text will overflow into adjacent empty cells or get cut off.
• Enabling Wrap Text adjusts the row height so all the text remains visible inside the cell, improving readability.

[ Option D ]

Must Know :

F6 / Shift+F6 : This switches between panes like worksheet, ribbon, task pane, status bar, not between workbooks.

Ctrl + Page Up : This switches to the previous worksheet within the same workbook, not another workbook.

Ctrl + Shift + F6 : This switches to the previous workbook window when multiple are open.

Ctrl + F6 : This switches to the next workbook window.

Must Know :

F6 / Shift+F6 : This switches between panes like worksheet, ribbon, task pane, status bar, not between workbooks.

Ctrl + Page Up : This switches to the previous worksheet within the same workbook, not another workbook.

Ctrl + Shift + F6 : This switches to the previous workbook window when multiple are open.

Ctrl + F6 : This switches to the next workbook window.

[ Option D ]

Must Know :

F6 / Shift+F6 : This switches between panes like worksheet, ribbon, task pane, status bar, not between workbooks.

Ctrl + Page Up : This switches to the previous worksheet within the same workbook, not another workbook.

Ctrl + Shift + F6 : This switches to the previous workbook window when multiple are open.

Ctrl + F6 : This switches to the next workbook window.

[ Option D ]

In an active cell of a spreadsheet, the autofill handle is a Small Square located at the Bottom Right Corner. It is used to quickly copy cell contents or continue a series (like numbers, dates, or formulas) by dragging in adjacent cells.

[ Option B ]

In spreadsheets like Microsoft Excel, pressing the F2 key allows you to edit the contents of the selected cell directly. When you press F2, the cursor is placed at the end of the cell's data, enabling you to modify or add to the existing content without overwriting it immediately.

[ Option B ]

When working with formulas in Excel, Cell References are used to refer to the data in other cells. How these references behave when copying formulas to other cells depends on the type of referencing:

1. Relative Referencing: Changes the cell reference based on the relative position of the formula when copied. For example, copying a formula referencing A1 one row down will change the reference to A2.
2. Absolute Referencing: The cell reference remains constant, no matter where the formula is copied. It is denoted by adding a dollar sign ($) before the column letter and row number.
3. Mixed Referencing: Either the row or the column is fixed, not both.

[ Option A ]

In MS Excel, several tools are used for What-If Analysis, which helps in forecasting and decision-making. Tools like Scenario Manager, Goal Seek, and Data Table allow users to analyze different input values and see their impact on results. On the other hand, Portrait refers to the page orientation in the Page Layout settings and has nothing to do with data analysis or forecasting.

[ Option A ]

In MS Excel, the Name Box shows the address of the currently selected or active cell. The Name Box is a small rectangular box located at the top left corner of the Excel window, just to the left of the Formula Bar.

[ Option A ]

Remember, the Cut command (Ctrl + X) is used to move content from one cell to another. When you cut a cell, the content is temporarily removed from the original cell and can be pasted into a new cell, preserving both the data and its formatting.

On the other hand, the Delete Key is used to permanently remove the content from a cell. Once deleted, the content cannot be pasted elsewhere. When Delete key is pressed, it deletes content but formatting remains unless “Clear All” is used.

[ Option C ]

• The Today() function in Excel returns the current system date, updating automatically whenever the worksheet recalculates or is opened.
• The Now() function returns the current system date along with the current time, also updating automatically.
• So, =Today(), returns the current system date only while =Now(), returns the current system date along with current time. Therefore, both functions provide the current date.

[ Option D ]

Must Know :

[ Option B ]

In MS Excel, data management is one of the most important features. When we want to arrange values in a specific order, we use the Sort feature. The Sort feature in MS Excel helps arrange the contents of cells in either increasing / ascending or decreasing / descending order.

[ Option B ]