Computer — All MCQs
4795 questions available
Q4401.In Microsoft Excel, cell references are classified into how many distinct structural types?
Correct Answer: C
Excel uses exactly 3 types of cell references: Relative (A1), Absolute ($A$1), and Mixed ($A1 or A$1).
Q4402.Which chart type is best suited to compare the distinct, side-by-side performance of two employees in the year 2021?
Correct Answer: A
A Column Chart uses vertical bars side-by-side, which is the standard format for comparing discrete categorical data points.
Q4403.What is the mathematical output evaluated by Excel for the formula: (7-3)*(4+3)/4?
Correct Answer: B
Using PEMDAS rules: (7-3) = 4, (4+3) = 7. Next, 4 * 7 = 28. Finally, 28 / 4 = 7.
Q4404.In Microsoft Word, what does pressing the keyboard shortcut 'Ctrl + Right Arrow' do?
Correct Answer: C
Ctrl + Right Arrow skips the cursor forward word-by-word, whereas Ctrl + Left Arrow moves it backward word-by-word.
Q4405.In Microsoft Word, what is the default number of text lines that a Drop Cap spans?
Correct Answer: B
By default, when you apply a Drop Cap in Microsoft Word, the enlarged initial letter spans exactly 3 lines of normal body text.
Q4406.What is the default page setup layout orientation of slides in Microsoft PowerPoint?
Correct Answer: C
By default, Microsoft PowerPoint slides open in Landscape (horizontal widescreen) orientation, optimized for monitors and projectors.
Q4407.In programming and computer science, what term refers to the formal grammatical rules that govern the structure of data or statements?
Correct Answer: B
Syntax refers to the formal rules governing the structure and formatting of code or data. Semantics deals with the actual meaning.
Q4408.Which type of chart in Microsoft Excel is specifically designed to show how different components proportionally add up to 100%?
Correct Answer: A
A Pie Chart represents values as sectors of a circle, which visually demonstrates parts-to-a-whole relationships totaling 100%.
Q4409.In Microsoft Excel, what term describes the process of transferring or pulling active data from one worksheet to another worksheet?
Correct Answer: B
Linking or Referencing (e.g., using formulas like =Sheet1!A1) allows data to be dynamically pulled and updated across worksheets.
Q4410.In design and drawing software, what term describes a background that appears as a grainy, non-smooth surface pattern?
Correct Answer: A
A Texture fill applies a pre-made image of a physical surface (like sand, wood, or paper) to create a grainy, non-smooth background.
Q4411.On legacy DOS systems, why does a disk become completely unreadable if a computer virus corrupts the File Allocation Table (FAT)?
Correct Answer: B
The FAT acts as an index of where files are physically stored. If corrupted, DOS cannot map or locate the sectors holding the file data.
Q4412.In Windows environments, what is the default keyboard shortcut used to REDO the last action in Microsoft Office?
Correct Answer: C
Ctrl + Y is the standard keyboard shortcut to Redo an action. Ctrl + Z is the shortcut to Undo an action.
Q4413.Which of the following versions of Microsoft Windows does NOT feature a traditional Start button on the taskbar?
Correct Answer: B
Microsoft removed the traditional desktop Start button in Windows 8, replacing it with a full-screen, tile-based Start Screen.
Q4414.Which built-in function in Microsoft Excel is used to count only the numeric values within a specified cell range?
Correct Answer: A
The COUNT function counts cells containing numbers. COUNTA is used to count all non-empty cells regardless of data type.
Q4415.Which class of hardware devices is designed to translate processed computer data into a user-readable display or format?
Correct Answer: D
Output devices (like monitors, speakers, and printers) receive processed digital signals from the computer and display them for users.
Q4416.The social networking platform Google+ (launched in 2011) was designed as a direct alternative to which site?
Correct Answer: B
Google+ was developed by Google as a competitor to Facebook, structured around social 'Circles' and communities.
Q4417.In Microsoft Word, what is the keyboard shortcut to directly change the font or open the Font properties dialog box?
Correct Answer: A
Ctrl + Shift + F is the standard keyboard shortcut used to open the Font settings dialog box to customize typefaces and styles.
Q4418.What is the primary function of the 'Ctrl + Enter' shortcut key in Microsoft Word?
Correct Answer: A
Ctrl + Enter inserts a manual page break, forcing the text cursor to immediately skip to the top of the next blank page.
Q4419.What is the function of the 'Shift + Insert' keyboard shortcut in Microsoft Office applications?
Correct Answer: B
Shift + Insert is a classic alternative shortcut used to paste text or objects from the clipboard, equivalent to Ctrl + V.
Q4420.In Microsoft Excel, what are the horizontal and vertical scroll bars primarily used for?
Correct Answer: C
Scroll bars allow users to slide the screen horizontally (to view hidden columns) or vertically (to view hidden rows).