This section contains carefully selected MCQs and Previous Year Questions with explanations to help students understand concepts and prepare effectively for examinations, interviews, and competitive tests.
Q: 1What is/are the uses of “Macro Feature” in MS-Excel?
1. It is used to send messages.
2. It saves a lot of time.
3. It designs the work sheet.
4. It maintains the uniformity of formatting changes in a sheet.
Choose the most appropriate answer from the options given below:
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.
Q: 2Which key open a Goto window in Microsoft Excel?
Option D
In Microsoft Excel, the Go To window is used to quickly move to a specific cell, range, or location in a worksheet. The shortcut key used to open the Go To dialog box is Ctrl+G.
Q: 3In MS Excel 2019, which of the following operator has the highest precedence?
Option D
The Percent (%) operator actually has a higher precedence than ^ (Exponentiation) and operates immediately after evaluating the number it follows.
Q: 4Which of the following is NOT a function of MS Excel?
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.
| FUNCTION | PURPOSE | EXAMPLE | RESULT |
|---|---|---|---|
| SUM() | Adds numbers in a range. | =SUM(2, 4, 8) | 14 |
| AVERAGE() | Finds the average (mean) of numbers. | =AVERAGE(10, 20, 30) | 20 |
| COUNT() | Counts numeric values in a range. | =COUNT(54, "suraku", 74) | 2 |
| COUNTA() | Counts all non-empty cells including numbers and text. | =COUNTA(54, "suraku", 74) | 3 |
| MIN() | Finds the smallest value. | =MIN(10, 22, 18) | 10 |
| MAX() | Finds the largest value. | =MAX(10, 12, 8) | 12 |
| PRODUCT() | Multiplies numbers. | =PRODUCT(2, 3, 5) | 30 |
| SQRT() | Returns the square root. | =SQRT(25) | 5 |
| POWER() | Raises a number to a power. | =POWER(2, 3) | 8 |
| MOD() | Returns the remainder after division. | =MOD(10, 3) | 1 |
Q: 5The default font for MS Excel 2019 datasheet is?
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.
Q: 6A valid formula is Excel begins with –
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:
Q: 7Which is not a commonly used type of cell data in Spreadsheet?
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.
| Data Type | Description |
|---|---|
| Numeric Value | Numbers used for calculations. |
| Text / Label | Words or text used for names, headings, or categories. |
| Date and Time | Stores calendar dates and times in proper format. |
| Formula | Equations that calculate values based on cell references. |
| Boolean / Logical | Represents logical values (TRUE or FALSE), used in conditions and logical formulas. |
Q: 8What will be the output of the following in MS-Excel?
=LCM(5,7,35)
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.
Q: 9In Excel 2016, if you want to insert 3 columns between Column G and H you would-
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.
Q: 10Consider the Excel formula for the Excel Sheet –
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 60 | A1 | 75 | A1 | =if(A1=C1,”T”,”F”) |
| 2 | 70 | A2 | 70 | A2 | =if(A2=C2,”T”,”F”) |
| 3 | 90 | A3 | 90 | A3 | =if(B3=D3,”T”,”F”) |
What will be the output in column no.5?
Option C
Q: 11Which of the following in spreadsheet is a method of arranging the data in ascending or descending order?
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.
Q: 12“Pivot Table” is a feature of which of the following software?
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.
| Feature | Purpose |
|---|---|
| Pivot Table | Summarize and analyze large sets of data quickly. |
| VLOOKUP / HLOOKUP | Search and retrieve data vertically or horizontally. |
| Conditional Formatting | Highlight cells automatically based on rules or conditions. |
| Goal Seek (What-If Analysis) | Find input value required to achieve a desired result. |
| Macros | Automate repetitive tasks using VBA. |
| Data Validation | Restrict or control data entry in cells. |
| Filter / Advanced Filter | Display only rows that meet criteria. |
| Freeze Panes | Keep rows/columns visible while scrolling. |
| Text to Columns | Split one column’s data into multiple columns. |
| PMT Function | Calculate loan repayments / EMI. |
Q: 13Microsoft Excel’s formula begins with ____________.
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:
Q: 14Which of the following is the most appropriate for the name of Excel Sheet?
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:
Q: 15Representation of data in a graphical manner is an important feature of Excel. Identify it. Also give the name of the component depicted below:
Option D
Thank you so much for taking the time to read my Computer Science MCQs section carefully. Your support and interest mean a lot, and I truly appreciate you being part of this journey. Stay connected for more insights and updates! If you'd like to explore more tutorials and insights, check out my YouTube channel.
Don’t forget to subscribe and stay connected for future updates.
| Student Name | |
|---|---|
| College |
| What's Say |
|---|