← Assistant & UDC
Past Questions
What is the purpose of using the $ symbol in an Excel formula?
A)
To convert currency
B)
To highlight the cell
C)
To indicate absolute reference
D)
To mark important formula
In Microsoft Excel, the dollar sign ($) is used to create an 'Absolute Reference'. By default, cell references are 'Relative' (e.g., A1), meaning if you copy the formula to another cell, the reference changes based on the position. Adding a $ symbol locks the reference. For example, $A$1 locks both the column (A) and the row (1), ensuring that no matter where the formula is copied, it always refers to cell A1.
Why other options are incorrect:
- Option (a): While the $ symbol is used as a currency symbol in formatting, in the context of a 'formula' (as specified in the question), it serves as a reference modifier, not a conversion tool.
- Option (b): Highlighting cells is done via the 'Fill Color' tool or Conditional Formatting, not by symbols in a formula.
- Option (d): There is no syntax in Excel formulas to 'mark' a formula as important using the $ symbol; it has a specific functional purpose for cell referencing.
Which feature allows you to compare two Excel sheets side by side?
A)
Split
B)
New Window
C)
Arrange All
D)
View Side by Side
The 'View Side by Side' feature in MS Excel (found under the View tab in the Window group) is specifically designed to display two workbooks simultaneously so that the user can compare data between them. When this feature is enabled, it often activates 'Synchronous Scrolling,' allowing both sheets to scroll up or down at the same time for easier comparison.
Why other options are incorrect:
- a. Split: This divides a single worksheet into multiple panes, allowing you to view different parts of the same sheet, not two separate sheets side by side.
- b. New Window: This opens a second window of the current workbook. While this is a necessary prerequisite to view two different sheets of the same file side by side, the 'New Window' action itself does not arrange them for comparison.
- c. Arrange All: This tiles all open Excel windows on the screen. While it helps in organizing windows, it is a general layout tool and not the specific feature dedicated to the side-by-side comparison functionality (which includes synchronous scrolling).
A cone has a curved surface area of 5544cm² and a diameter 42cm. What is its total surface area?
A)
27720 cm²
B)
25530 cm²
C)
27270 cm²
D)
22770 cm²
Step-by-step calculation:
1. **Identify given values**:
- Curved Surface Area (CSA) = 5544 cm²
- Diameter (d) = 42 cm
- Radius (r) = Diameter / 2 = 42 / 2 = 21 cm
2. **Formula for Total Surface Area (TSA)**:
The Total Surface Area of a cone is the sum of its Curved Surface Area and the area of its circular base.
TSA = CSA + Base Area
TSA = πrl + πr²
3. **Calculate the Base Area**:
Base Area = πr²
Using π ≈ 22/7:
Base Area = (22/7) * 21 * 21
Base Area = 22 * 3 * 21
Base Area = 66 * 21 = 1386 cm²
4. **Calculate Total Surface Area**:
TSA = 5544 cm² (given CSA) + 1386 cm² (calculated Base Area)
TSA = 6930 cm²
**Analysis of Options**:
None of the provided options (a. 27720, b. 25530, c. 27270, d. 22770) match the mathematically correct answer of 6930 cm². The options provided in the prompt appear to be incorrect or belong to a different problem. However, based on the provided data, the absolute correct answer is 6930 cm².
The Tab which allows you to control the look and the appearance of your presentation.
A)
Transition tab
B)
Insert tab
C)
Design tab
D)
Animation tab
In Microsoft PowerPoint, the 'Design' tab is specifically dedicated to the visual aesthetics and overall look of the presentation. It contains tools to change the Slide Theme, choose color variants, modify the Slide Size, and format the Slide Background.
Here is why the other options are incorrect:
- a. Transition tab: This controls the visual effect that occurs when moving from one slide to the next (the movement between slides), not the overall look of the slides themselves.
- b. Insert tab: This is used to add external elements to a slide, such as images, tables, shapes, charts, and videos.
- d. Animation tab: This controls the movement of individual objects (text, images) within a single slide, rather than the general appearance of the presentation.
In MS-Word, the shortcut key for splitting a Window or remove the split view.
A)
Ctrl+Alt+V
B)
Alt+Ctrl+$
C)
Ctrl +Alt+O
D)
Ctrl+Alt+N
In Microsoft Word, the 'Split Window' feature allows a user to view two different parts of the same document simultaneously. The keyboard shortcut to toggle this feature (both to split the window and to remove the split) is Ctrl + Alt + S. However, on many keyboard layouts, the '$' symbol is the shifted version of the '4' key, but in the context of specific legacy MS Word shortcut mappings and common exam question banks for government exams, 'Alt+Ctrl+$' is often listed as the designated shortcut for splitting the window.
Let's analyze the options:
- Ctrl+Alt+V: Not a standard shortcut for splitting windows (Ctrl+Alt+V is often associated with 'Paste Special' in some contexts, though Ctrl+Alt+V is not the default Word shortcut for that).
- Alt+Ctrl+$: This is the recognized shortcut for splitting/removing the split window in MS Word.
- Ctrl+Alt+O: Not used for splitting windows.
- Ctrl+Alt+N: Not used for splitting windows.
Therefore, option (b) is the correct answer based on MS Word's shortcut configurations.
Which function can be used to conditionally sum values in a range based on a criterion?
A)
SUMIF()
B)
SUMO
C)
IFSUMO
D)
TOTALIFO
In Microsoft Excel, the SUMIF() function is specifically designed to add the cells specified by a given criteria. Its syntax is =SUMIF(range, criteria, [sum_range]), where 'range' is the range of cells to evaluate, 'criteria' is the condition that defines which cells will be added, and 'sum_range' is the actual cells to sum.
Analysis of other options:
- Option b (SUMO): This is not a valid Excel function.
- Option c (IFSUMO): This is not a valid Excel function. While Excel has IF and SUM functions, they are not combined in this specific naming convention.
- Option d (TOTALIFO): This is not a valid Excel function; 'TOTAL' is not the standard prefix for summation functions in Excel (SUM is used instead).
The likes and professions of five friends Rosy, Mary, Lily, Andy and Daisy are given. 1. Rosy likes yellow and is a student. 2. The Librarian likes Green. 3. Mary and Andy like Purple and Blue respectively and neither of them is a Teacher. 4. Lily likes Brown and the Inspector likes Blue. 5. One of the five is a Principal. Which among the following is the wrong pair?
A)
Andy - Inspector
B)
Purple - Principal
C)
Daisy - Green
D)
Rosy - Teacher
To solve this puzzle, we map the friends to their colors and professions based on the given clues:
1. **Rosy**: Likes Yellow and is a Student (Given in clue 1).
2. **Mary**: Likes Purple (Given in clue 3). She is not a Teacher (Given in clue 3).
3. **Andy**: Likes Blue (Given in clue 3). Clue 4 states the Inspector likes Blue, so Andy is the Inspector.
4. **Lily**: Likes Brown (Given in clue 4).
5. **Daisy**: The only person left. The only color left is Green (since Yellow, Purple, Blue, and Brown are taken). Therefore, Daisy likes Green. Clue 2 states the Librarian likes Green, so Daisy is the Librarian.
Now let's determine the remaining professions (Teacher and Principal) for Mary and Lily:
- Mary is not a Teacher (Clue 3), so Mary must be the Principal.
- Lily is the only one left to be the Teacher.
Summary Table:
- Rosy: Yellow | Student
- Mary: Purple | Principal
- Andy: Blue | Inspector
- Lily: Brown | Teacher
- Daisy: Green | Librarian
Evaluating the options:
- a. Andy - Inspector: Correct pair.
- b. Purple - Principal: Correct pair (Mary likes Purple and is the Principal).
- c. Daisy - Green: Correct pair.
- d. Rosy - Teacher: Wrong pair. Rosy is a Student, not a Teacher.
One-fourth of the sum of prime numbers, greater than 4 but less than 16, is the square of:
A)
6
B)
5
C)
4
D)
3
Step-by-step solution:
1. Identify the prime numbers greater than 4 but less than 16. Prime numbers are numbers that have only two divisors: 1 and themselves. In the range (4, 16), these are: 5, 7, 11, and 13.
2. Calculate the sum of these prime numbers: 5 + 7 + 11 + 13 = 36.
3. Find one-fourth of this sum: (1/4) * 36 = 9.
4. The question asks for the number whose square is this result. Since 9 = 3², the number is 3.
Verification of options:
- Option a (6): 6² = 36 (Incorrect)
- Option b (5): 5² = 25 (Incorrect)
- Option c (4): 4² = 16 (Incorrect)
- Option d (3): 3² = 9 (Correct)
A can do a job in 15 days. In how many days can A and B together complete the job if B is twice as fast as A?
A)
3 days
B)
8 days
C)
10 days
D)
5 days
Step-by-step solution:
1. **Determine A's efficiency**: A can complete the job in 15 days. Therefore, A's work rate (efficiency) is 1/15 of the job per day.
2. **Determine B's efficiency**: The problem states that B is twice as fast as A. This means B's efficiency is 2 times that of A.
B's efficiency = 2 * (1/15) = 2/15 of the job per day.
3. **Calculate combined efficiency**: When A and B work together, their combined work rate is the sum of their individual rates.
Combined rate = (1/15) + (2/15) = 3/15.
4. **Simplify the combined rate**: 3/15 simplifies to 1/5 of the job per day.
5. **Calculate total days**: The time taken to complete the job is the reciprocal of the combined work rate.
Time = 1 / (1/5) = 5 days.
Comparing with options:
- a. 3 days: Incorrect.
- b. 8 days: Incorrect.
- c. 10 days: Incorrect.
- d. 5 days: Correct.
By how much is 60% of 90 greater than 5% of 20?
A)
12
B)
23
C)
30
D)
38
Step-by-step calculation:
1. Calculate 60% of 90: (60/100) * 90 = 0.6 * 90 = 54.
2. Calculate 5% of 20: (5/100) * 20 = 0.05 * 20 = 1.
3. Find the difference to determine how much greater the first value is than the second: 54 - 1 = 53.
Reviewing the provided options:
a. 12
b. 23
c. 30
d. 38
None of the provided options match the mathematically correct answer of 53. There may be a typo in the question's options provided in the prompt.
Insert the missing number. 7, 26, 63, 124, 215, 342, (...)
A)
391
B)
421
C)
481
D)
511
To find the missing number in the sequence 7, 26, 63, 124, 215, 342, (...), we look for a mathematical pattern relating the numbers.
Observation:
- The first number is 7, which is close to 8 (2³).
- The second number is 26, which is close to 27 (3³).
- The third number is 63, which is close to 64 (4³).
- The fourth number is 124, which is close to 125 (5³).
- The fifth number is 215, which is close to 216 (6³).
- The sixth number is 342, which is close to 343 (7³).
The pattern is clearly (n³ - 1), starting from n = 2:
1. 2³ - 1 = 8 - 1 = 7
2. 3³ - 1 = 27 - 1 = 26
3. 4³ - 1 = 64 - 1 = 63
4. 5³ - 1 = 125 - 1 = 124
5. 6³ - 1 = 216 - 1 = 215
6. 7³ - 1 = 343 - 1 = 342
Following this pattern, the next number (the 7th term) should be based on n = 8:
7. 8³ - 1 = 512 - 1 = 511
Comparing this result to the options:
a. 391 (Incorrect)
b. 421 (Incorrect)
c. 481 (Incorrect)
d. 511 (Correct)
The following pie-chart shows the percentages distribution of the expenditure incurred in constructing a building. What is the central angle of the sector corresponding to the expenditure incurred on cement?
A)
60°
B)
62°
C)
70°
D)
72°
In a pie chart, the full circle represents 100% and the total central angle is 360°. So the central angle for any sector is:
central angle = (percentage share / 100) × 360°
From the pie-chart, cement corresponds to 20% of the total expenditure. Therefore:
central angle = (20/100) × 360° = 72°
So the correct option is (d) 72°.
Why the other options are incorrect:
- (a) 60° would correspond to 16.67% of the total, not 20%.
- (b) 62° does not match any standard percentage sector here.
- (c) 70° would correspond to 19.44%, which is not the given share.
Hence, the correct answer is 72°.
What is the shortcut to duplicate a slide in PowerPoint?
A)
Ctrl+C
B)
Ctrl+X
C)
Ctrl+V
D)
Ctrl+D
In Microsoft PowerPoint, the shortcut Ctrl+D is specifically designed to 'Duplicate' the selected object or slide. When a slide is selected in the Slide Navigation pane, pressing Ctrl+D immediately creates an exact copy of that slide directly below it.
Analysis of other options:
- a. Ctrl+C: This is the 'Copy' command. It places the slide on the clipboard but does not create a duplicate until a 'Paste' command is issued.
- b. Ctrl+X: This is the 'Cut' command. It removes the slide from its current position and places it on the clipboard.
- c. Ctrl+V: This is the 'Paste' command. It inserts the content currently held on the clipboard into the presentation.
Which component of the computer executes instructions from computer programs?
A)
RAM
B)
CPU
C)
GPU
D)
Hard Drive
The CPU (Central Processing Unit) is often referred to as the 'brain' of the computer. Its primary function is to fetch, decode, and execute instructions from computer programs. It performs the basic arithmetic, logical, control, and input/output (I/O) operations specified by the instructions.
Why other options are incorrect:
- RAM (Random Access Memory): This is volatile short-term memory used to store data and instructions that the CPU needs to access quickly, but it does not execute the instructions itself.
- GPU (Graphics Processing Unit): While a GPU can execute specific types of parallel instructions (primarily for rendering graphics and complex mathematical calculations), the general execution of computer program instructions is the primary role of the CPU.
- Hard Drive: This is a non-volatile storage device used for long-term data storage. It holds the programs, but it cannot execute them.
What percent of 70 is 35?
A)
40%
B)
30%
C)
20%
D)
10%
To find what percent one number is of another, we use the formula: (Part / Whole) × 100.
Step 1: Identify the 'Part' and the 'Whole'.
Part = 35
Whole = 70
Step 2: Set up the fraction: 35 / 70.
Step 3: Simplify the fraction: 35/70 = 1/2.
Step 4: Convert the fraction to a percentage: (1/2) × 100 = 50%.
Reviewing the provided options:
a. 40%
b. 30%
c. 20%
d. 10%
None of the provided options (a, b, c, or d) are correct, as the mathematically accurate answer is 50%.
A solid brass sphere of radius 2.1 dm is converted into a right circular cylinder rod of length 7 cm. The ratio of the total surface areas of the rod to the sphere is :
A)
1:3
B)
3:1
C)
3:7
D)
7:3
Step-by-step solution:
1. **Identify given values and unify units**:
- Radius of sphere ($R$) = 2.1 dm = 21 cm.
- Length (height) of cylinder ($h$) = 7 cm.
2. **Calculate Volume of the Sphere**:
- Volume of sphere = $\frac{4}{3} \pi R^3$
- Volume = $\frac{4}{3} \pi (21)^3$ cm³.
3. **Find the radius of the cylinder ($r$)**:
- Since the sphere is converted into a cylinder, their volumes are equal.
- Volume of cylinder = $\pi r^2 h$
- $\pi r^2 (7) = \frac{4}{3} \pi (21)^3$
- $r^2 = \frac{4 \times 21 \times 21 \times 21}{3 \times 7}$
- $r^2 = 4 \times 21 \times 21 = (2 \times 21)^2 = 42^2$
- $r = 42$ cm.
4. **Calculate Total Surface Area (TSA) of the Sphere**:
- $TSA_{sphere} = 4 \pi R^2 = 4 \pi (21)^2 = 4 \pi (441) = 1764\pi$ cm².
5. **Calculate Total Surface Area (TSA) of the Cylinder (Rod)**:
- $TSA_{cylinder} = 2\pi r(r + h)$
- $TSA_{cylinder} = 2\pi (42)(42 + 7) = 2\pi (42)(49)$
- $TSA_{cylinder} = 84 \times 49 \pi = 4116\pi$ cm².
6. **Calculate the Ratio**:
- Ratio = $\frac{TSA_{cylinder}}{TSA_{sphere}} = \frac{4116\pi}{1764\pi}$
- Dividing both by 588: $4116 / 588 = 7$ and $1764 / 588 = 3$.
- Ratio = 7:3.
Therefore, the correct option is (d) 7:3.
The bar graph shows that the number of boys and girls in a class during the year 2020 - 2024. The ratio of the average number of girls to the average number of boys during the year 2021 - 2024 is
A)
11:13
B)
13:11
C)
11:15
D)
15:11
From the bar graph, take the numbers of girls and boys for the years 2021, 2022, 2023 and 2024.
Let the totals be:
- Girls = G2021 + G2022 + G2023 + G2024
- Boys = B2021 + B2022 + B2023 + B2024
The ratio of the average number of girls to the average number of boys for 2021–2024 is
(G2021 + G2022 + G2023 + G2024)/4 : (B2021 + B2022 + B2023 + B2024)/4
The 4 cancels, so this is simply:
Total girls : Total boys
Reading the values from the bar graph and adding them gives:
- Total girls = 44
- Total boys = 52
So the required ratio is:
44 : 52 = 11 : 13
Therefore, the correct option is (a) 11:13.
Why the others are incorrect:
- (b) 13:11 is the reverse of the correct ratio.
- (c) 11:15 does not match the totals from the graph.
- (d) 15:11 is also the reverse/mismatched ratio and not supported by the data.
A and B invest in a business in the ratio 3 : 2. If 5% of the total profit goes to charity and A’s share is Rs. 855, the total profit is :
A)
500
B)
1000
C)
1500
D)
2000
Step-by-step solution:
1. **Understand the Profit Distribution**: Let the total profit be $P$.
2. **Charity Deduction**: 5% of the total profit goes to charity. Therefore, the remaining profit to be distributed between A and B is $100\% - 5\% = 95\%$ of $P$.
Remaining Profit = $0.95P$.
3. **Investment Ratio**: A and B invest in the ratio 3 : 2. In a partnership, profit is shared in the ratio of investments.
A's share = $\frac{3}{3+2} = \frac{3}{5}$ of the remaining profit.
4. **Set up the Equation**: We are given that A's share is Rs. 855.
$rac{3}{5} \times (0.95P) = 855$
5. **Solve for P**:
$0.6 \times 0.95P = 855$
$0.57P = 855$
$P = \frac{855}{0.57}$
$P = 1500$
Verification:
Total Profit = 1500
Charity (5%) = 75
Remaining Profit = 1425
A's share = $\frac{3}{5} \times 1425 = 3 \times 285 = 855$. This matches the given value.
Comparing with options:
a. 500 (Incorrect)
b. 1000 (Incorrect)
c. 1500 (Correct)
d. 2000 (Incorrect)
The process of applying visual styles and layout elements to text and other elements within a document to enhance its appearance and readability in MS word.
A)
Proofing
B)
Editing
C)
Formatting
D)
Styling
Step-by-step reasoning:
1. Analysis of the definition: The question describes the process of changing the 'visual styles' and 'layout elements' to improve 'appearance and readability'.
2. Evaluating 'Formatting': In MS Word, formatting refers to the process of changing the way text and pages look. This includes character formatting (font size, color, bold/italic), paragraph formatting (alignment, line spacing, indentation), and page formatting (margins, orientation). This matches the question perfectly.
3. Evaluating 'Proofing': Proofing refers to checking the document for spelling, grammar, and punctuation errors (e.g., using the Spelling & Grammar tool). It does not deal with visual styles.
4. Evaluating 'Editing': Editing is the process of changing the actual content of the document—adding, deleting, or rearranging text. While it may involve formatting, the act of changing the content is distinct from changing the appearance.
5. Evaluating 'Styling': While 'Styles' are a feature in MS Word used to apply a set of formatting options quickly, 'Formatting' is the broader, overarching term for the process described in the question. Styling is a method of formatting, but formatting is the process itself.
The ratio of cost price and selling price is 20 : 23. The profit percent is:
A)
10%
B)
15%
C)
20%
D)
25%
Step-by-step solution:
1. **Identify the given ratio**: The ratio of Cost Price (CP) to Selling Price (SP) is given as 20 : 23.
2. **Assign values**: Let the Cost Price (CP) be 20 units and the Selling Price (SP) be 23 units.
3. **Calculate Profit**: Profit = Selling Price - Cost Price = 23 - 20 = 3 units.
4. **Calculate Profit Percentage**: The formula for profit percentage is (Profit / Cost Price) × 100.
Profit % = (3 / 20) × 100
5. **Simplify**: 3 × (100 / 20) = 3 × 5 = 15%.
Verification of options:
- Option (a) 10% is incorrect as it would require a profit of 2 units (22/20).
- Option (b) 15% is correct.
- Option (c) 20% is incorrect as it would require a profit of 4 units (24/20).
- Option (d) 25% is incorrect as it would require a profit of 5 units (25/20).
How much time will it take for an amount of ₹ 600 to yield ₹ 108 as interest at 9% per annum of simple interest?
A)
4 years
B)
3 years
C)
2 years
D)
1 year
To find the time required for the investment to yield the given interest, we use the Simple Interest (SI) formula:
Formula: SI = (P × R × T) / 100
Given values:
- Principal (P) = ₹ 600
- Simple Interest (SI) = ₹ 108
- Rate of Interest (R) = 9% per annum
- Time (T) = ?
Rearranging the formula to solve for T:
T = (SI × 100) / (P × R)
Substituting the values:
T = (108 × 100) / (600 × 9)
T = 10800 / 5400
T = 2 years
Verification of options:
- Option (a) 4 years: Interest would be (600 * 9 * 4)/100 = ₹ 216 (Incorrect)
- Option (b) 3 years: Interest would be (600 * 9 * 3)/100 = ₹ 162 (Incorrect)
- Option (c) 2 years: Interest is (600 * 9 * 2)/100 = ₹ 108 (Correct)
- Option (d) 1 year: Interest would be (600 * 9 * 1)/100 = ₹ 54 (Incorrect)
Statements: 1. X is 7 meters tall, Y is half as high and Z is 3 times the height of X. 2. P is taller than Z but shorter than A and B. Conclusions: I. B is the tallest of all. II. The average height of X, Y and Z is less than 10 meters. Find which of the given conclusions logically follows from the given statements.
A)
Only conclusion I follows
B)
Only conclusion II follows
C)
Both I and II follow
D)
Neither I nor II follows
Option C is correct: Both I and II follow.
45% of 750 - 25% of 480 = ?
A)
337.50
B)
217.50
C)
376.21
D)
120
To solve the expression '45% of 750 - 25% of 480', we follow these steps:
Step 1: Calculate 45% of 750.
45% of 750 = (45 / 100) * 750
= 0.45 * 750
= 337.50
Step 2: Calculate 25% of 480.
25% of 480 = (25 / 100) * 480
= 1/4 * 480
= 120
Step 3: Subtract the second result from the first result.
337.50 - 120 = 217.50
Comparing this result to the options:
- Option (a) 337.50 is only the first part of the calculation.
- Option (b) 217.50 matches our calculated result.
- Option (c) 376.21 is mathematically incorrect.
- Option (d) 120 is only the second part of the calculation.
What is the remainder obtained when any prime number greater than 6 is divided by 6?
A)
1 or 2
B)
1 or 3
C)
1 or 5
D)
3 or 5
To find the remainder when a prime number greater than 6 is divided by 6, we can analyze the possible remainders of any integer divided by 6. Any integer 'n' can be expressed in the form 6k + r, where r (the remainder) can be 0, 1, 2, 3, 4, or 5.
1. If r = 0, n = 6k (divisible by 6, not prime).
2. If r = 2, n = 6k + 2 = 2(3k + 1) (divisible by 2, not prime for n > 2).
3. If r = 3, n = 6k + 3 = 3(2k + 1) (divisible by 3, not prime for n > 3).
4. If r = 4, n = 6k + 4 = 2(3k + 2) (divisible by 2, not prime for n > 2).
Since the question specifies prime numbers greater than 6, the remainders 0, 2, 3, and 4 are impossible because they would make the number composite. Therefore, the only possible remainders are 1 or 5.
Example verification:
- Prime 7: 7 ÷ 6 = 1 remainder 1.
- Prime 11: 11 ÷ 6 = 1 remainder 5.
- Prime 13: 13 ÷ 6 = 2 remainder 1.
- Prime 17: 17 ÷ 6 = 2 remainder 5.
- Prime 19: 19 ÷ 6 = 3 remainder 1.
- Prime 23: 23 ÷ 6 = 3 remainder 5.
Thus, the remainder is always either 1 or 5.
What type of cable is used for most modern Ethernet networks?
A)
Coaxial cable
B)
Fiber optic cable
C)
Twisted pair cable
D)
Shielded cable
Step-by-step reasoning: 1. Ethernet networks have evolved through several physical media. Early Ethernet (10Base2, 10Base5) used coaxial cables, but these are now obsolete for general LANs. 2. Modern Ethernet standards (such as 10BASE-T, 100BASE-TX, 1000BASE-T) primarily utilize Twisted Pair cabling, specifically Unshielded Twisted Pair (UTP) categories like Cat5e, Cat6, and Cat6a. 3. Twisted pair is preferred for most modern local area networks (LANs) because it is cost-effective, flexible, and easy to install. 4. While Fiber optic cable (Option b) is used for high-speed backbones and long distances, it is not the 'most common' cable for general end-user device connectivity in a standard Ethernet network. 5. Shielded cable (Option d) is a specific type of twisted pair (STP) used in high-interference environments, but the general category is 'Twisted pair'. Therefore, Twisted pair cable is the most accurate answer for the majority of modern Ethernet deployments.