MS Excel — Set 2
Computers · MS Excel · Questions 11–20 of 80
What is the shortcut key to insert a new worksheet in the current workbook?
Correct Answer: A. Shift + F11
Shift + F11 adds a new blank sheet to the left of the currently active sheet. This allows for quick expansion of the workbook without using the mouse. New sheets are named 'SheetX' by default.
Which error message appears in Excel if a column is not wide enough to display the number?
Correct Answer: D. #######
A series of hash symbols indicates that the cell contains a numeric value that exceeds current width. To fix this, users must expand the column width manually or use AutoFit. This prevents numeric data from being shown incorrectly.
Which Excel tool is used to summarize and analyze large amounts of data efficiently?
Correct Answer: A. Pivot Table
Pivot Tables allow users to reorganize and summarize selected columns and rows of data to see different perspectives. It is considered one of Excel's most powerful data analysis features. It can perform calculations like sum, average, or count automatically.
What is the shortcut key to edit the content of a selected cell?
Correct Answer: D. F2
Pressing F2 places the cursor at the end of the data within the active cell. This is a faster alternative to double-clicking with a mouse. It allows for direct modification of text or formulas.
Which function is used to find the highest value in a range of cells?
Correct Answer: A. MAX
The MAX function scans the selected range and returns the largest numeric value found. It ignores empty cells and text within the selection. It is a standard function for basic data comparison.
Which feature in Excel allows you to keep certain rows or columns visible while scrolling?
Correct Answer: D. Freeze Panes
Freeze Panes is useful for keeping headers visible while navigating through long lists of data. It can lock the top row, the first column, or a specific selection. This option is found under the 'View' tab on the Ribbon.
What happens if you press Ctrl + ; (Semicolon) in an Excel cell?
Correct Answer: A. Inserts Current Date
The Ctrl + ; shortcut is used to quickly stamp the current system date into a cell. To insert the current time, the shortcut used is Ctrl + Shift + :. This is a static entry that does not update automatically.
Which chart type in Excel is best for showing the relationship of parts to a whole?
Correct Answer: D. Pie Chart
Pie charts represent data as slices of a circle, where each slice shows a percentage of the total. They are best suited for simple datasets with a few categories. Complex data is usually better represented by bar or column charts.
Which function is used to vertically look up a value in the first column of a table?
Correct Answer: A. VLOOKUP
VLOOKUP stands for Vertical Lookup and searches for data in rows. It requires a lookup value, a table range, and a column index number. It is widely used to link different datasets based on a common identifier.
What does the 'Fill Handle' (the small square at the bottom-right of a cell) do?
Correct Answer: D. Copies or extends a series
The Fill Handle allows users to quickly copy a cell's content to adjacent cells. It can also recognize patterns, such as dates or numbers, to extend a series automatically. This significantly speeds up repetitive data entry tasks.