MS Excel — Set 3
Computers · MS Excel · Questions 21–30 of 80
Which of the following is an absolute cell reference in Excel?
Correct Answer: D. $A$1
The dollar signs ($) before both the column letter and row number lock the reference. This means the reference will not change when the formula is copied to another cell. This is essential for referencing constants like tax rates.
Which function allows you to perform a logical test and return one value if True and another if False?
Correct Answer: C. IF
The IF function is the most basic logical function used for decision-making in Excel. It evaluates a condition and provides results based on that outcome. Multiple IF functions can be nested for more complex logic.
What is the shortcut key to apply the 'AutoSum' function to a range of cells?
Correct Answer: A. Alt + =
The Alt + = shortcut quickly generates a SUM formula for the adjacent range of numbers. Excel automatically guesses the range based on nearby data. This is the fastest way to total a column or row of figures.
Which Excel feature helps you to restrict the type of data or values that users enter into a cell?
Correct Answer: A. Data Validation
Data Validation can be used to create drop-down lists or set limits on numeric entries. It ensures data integrity by preventing incorrect inputs. Users can also set custom error messages to guide data entry.
What is a group of worksheets saved together in one file called?
Correct Answer: C. Workbook
A workbook is the entire Excel file that can contain one or many individual sheets. This structure allows for organizing related data across different tabs. When you save an Excel file, you are saving the entire workbook.
Which tab on the Excel Ribbon contains tools like 'Sort' and 'Filter'?
Correct Answer: C. Data
The Data tab is dedicated to managing, organizing, and analyzing external and internal data. While basic sort/filter tools also appear on the Home tab, the full suite is in the Data tab. It also includes tools for data cleaning and forecasting.
In Excel, what does the '#######' error usually indicate?
Correct Answer: C. Cell width insufficient
This occurs when numeric values or dates are too long to fit in the current column width. It is a visual indicator rather than a calculation error. Expanding the column will reveal the hidden value immediately.
Which function is used to join several text strings into one string?
Correct Answer: D. CONCATENATE
CONCATENATE (or the newer CONCAT) combines text from different cells into a single cell. An ampersand (&) can also be used as a shortcut for this operation. This is useful for combining first and last names from separate columns.
What is the shortcut key to select the entire column in an Excel sheet?
Correct Answer: A. Ctrl + Space
Ctrl + Space selects all cells in the column containing the active cell. To select an entire row, the shortcut is Shift + Space. These shortcuts are very helpful for formatting entire sections of a spreadsheet.
Which tool in Excel is used to automate repetitive tasks by recording a series of actions?
Correct Answer: C. Macro
Macros are recorded sequences of instructions that can be triggered with a button or shortcut. They are written in the VBA (Visual Basic for Applications) programming language. They help in reducing errors and saving time in routine reporting.