MS Excel — Set 5
Computers · MS Excel · Questions 41–50 of 80
Which chart type is most suitable for showing trends over a period of time?
Correct Answer: A. Line Chart
Line charts connect individual data points with a line to show progression or changes. They are ideal for time-series data like monthly sales or temperature fluctuations. They make it easy to identify upward or downward trends.
What is the shortcut key to bold text in an Excel cell?
Correct Answer: D. Ctrl + B
Ctrl + B toggles the bold formatting for the selected cells. Ctrl + I is used for italics, and Ctrl + U for underlining. These basic formatting shortcuts help in making certain data stand out.
Which Excel function counts the number of cells that are not empty in a range?
Correct Answer: D. COUNTA
COUNTA counts cells containing any type of information, including numbers, text, and error values. Only truly empty cells are ignored by this function. It is very useful for determining the size of a dataset.
Which symbol is used for multiplication in Excel formulas?
Correct Answer: D. *
The asterisk (*) is the standard mathematical operator for multiplication in Excel. The forward slash (/) is used for division. Using 'X' will result in a formula error as it is treated as a character.
What does the 'AutoFilter' feature do in Excel?
Correct Answer: A. Hides rows that don't meet criteria
AutoFilter allows users to selectively view data based on specific values in a column. It doesn't delete any data; it simply hides rows that aren't relevant to the selection. Filtered data can be easily restored by clearing the filter.
Which function allows you to count cells based on a specific condition (e.g., values greater than 50)?
Correct Answer: C. COUNTIF
COUNTIF requires two arguments: the range of cells and the criteria to be met. For example, =COUNTIF(A1:A10, ">50") will count how many cells meet that rule. It is a fundamental tool for data reporting.
What is the shortcut key to insert the current date in an Excel cell?
Correct Answer: D. Ctrl + ;
Pressing Ctrl + ; (semicolon) instantly types the current system date into the selected cell. This is a static value that won't change when you reopen the file. It is commonly used for date-stamping records.
Which tool is used to copy only the formatting from one cell to another?
Correct Answer: A. Format Painter
Format Painter allows you to pick up the style (color, font, borders) of a cell and apply it to others. You can double-click it to apply the same format to multiple non-adjacent cells. This ensures a consistent look throughout the sheet.
What is the purpose of the 'Goal Seek' tool in Excel?
Correct Answer: B. Finding input needed for a target result
Goal Seek is a 'What-If Analysis' tool that works backward from a known result to find a missing input. For example, it can calculate what interest rate is needed for a specific loan payment. It is found under the Data tab.
What is the shortcut key to switch between open Excel workbooks?
Correct Answer: B. Ctrl + Tab
Ctrl + Tab cycles through all Excel workbooks currently open in the same instance of the program. Alt + Tab is a general Windows shortcut to switch between different applications. This helps in multi-tasking across several reports.