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.
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 |
|---|