MS Excel
430 questions available
FILTER BY SUBTOPIC
Q381.Which specific area in an Excel window allows users to directly enter values, text, and formulas into cells?
Correct Answer: C
The Formula Bar is the input area located above the main worksheet grid, allowing users to enter and edit text, values, or cell formulas.
Q382.How can you select and activate a specific cell in an Excel worksheet?
Correct Answer: D
A cell is activated by clicking it directly, navigating to it using the arrow keys, or pressing the Tab key to move sequentially.
Q383.In Microsoft Excel, what is the horizontal spacing of a column called?
Correct Answer: C
In Excel, column spacing is adjusted and defined as 'Column Width', which can be resized to accommodate the length of cell values.
Q384.In MS Excel, a group of adjacent cells on which operations can be performed is called a _____?
Correct Answer: A
A cell Range is a group of two or more adjacent cells in Excel. It is referenced by separating the top-left and bottom-right cells with a colon (e.g., A1:C5).
Q385.In Microsoft Excel, what is the name of the tiny solid square in the lower-right corner of a selected active cell?
Correct Answer: A
The Fill Handle is the small solid square in the bottom-right corner of an active cell. It is used to quickly copy cell data or auto-fill ranges.
Q386.Which chart type in MS Excel represents only a single value for each variable, showing proportions of a whole?
Correct Answer: A
A Pie Chart represents a single data series where each category is shown as a slice of a circle, adding up to 100%.
Q387.Which of the following terms is NOT associated with Microsoft Excel?
Correct Answer: A
Columns and Workbooks are core structural elements of MS Excel. A browser is an external web navigation application.
Q388.What is the maximum number of rows supported in a single worksheet of MS Excel 2007 and later?
Correct Answer: B
Excel 2007 and newer versions support up to 1,048,576 rows and 16,384 columns per worksheet.
Q389.What does the topmost title bar of a Microsoft Excel window display?
Correct Answer: B
The Title Bar displays the name of the active Workbook file (e.g., Book1) alongside the application name 'Excel'.
Q390.How can you quickly duplicate or fill values across an adjacent cell range in Microsoft Excel 2016?
Correct Answer: B
Values can be duplicated down a range by clicking and dragging the tiny square Fill Handle in the bottom-right corner of the active cell selection.
Q391.Where does Microsoft Excel display the cell address of the currently active cell?
Correct Answer: A
The Name Box, located to the left of the Formula Bar, displays the cell address of the currently selected active cell (e.g., A1).
Q392.In MS Excel 2016, which menu sequence is used to split the active worksheet window into two panes?
Correct Answer: B
To split a window in Excel 2016, navigate to the View tab on the ribbon, click the Window group, and click the Split button.
Q393.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).
Q394.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.
Q395.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%.
Q396.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.
Q397.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.
Q398.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).
Q399.What is the common behavior of the 'F4' key in Microsoft Office applications like Word and Excel?
Correct Answer: A
F4 acts as the 'repeat' key, replicating the immediate previous action (like font formatting, row insertion) instantly.
Q400.Which of the following represents the latest standalone/perpetual edition of Microsoft Excel?
Correct Answer: A
Microsoft released Office 2024 (including Excel 2024) as the latest standalone/perpetual software package, whereas Microsoft 365 is a subscription-based service.