MS Excel
430 questions available
FILTER BY SUBTOPIC
Q401.In Microsoft Excel, what key can be pressed to quickly remove/clear an embedded formula from selected cells?
Correct Answer: A
Pressing the DELETE key clears formulas, values, or text from selected cells without removing the cell borders or styles.
Q402.In spreadsheet programs like Microsoft Excel, you can use the drag-and-drop method to perform which operations?
Correct Answer: D
Dragging a selected cell or range moves its contents. Holding down the Ctrl key while dragging duplicates (copies) the contents to the target cell.
Q403.In Microsoft Excel, what function key is pressed to immediately edit the contents of the currently selected cell?
Correct Answer: C
Pressing F2 enters Edit mode for the active cell, placing the blinking text cursor at the end of the cell's current contents.
Q404.What is the name of the spreadsheet component or workspace used to input the values for generating a chart?
Correct Answer: C
The Datasheet is the tabular grid workspace where raw data values are entered to construct and modify charts in legacy MS Office tools.
Q405.What is the primary purpose of the VLOOKUP function in Microsoft Excel?
Correct Answer: C
VLOOKUP (Vertical Lookup) searches for a specified key in the first column of a range and returns a corresponding value from a target column in the same row.
Q406.In Microsoft Excel, what does the Chart Wizard term 'data categories' refer to?
Correct Answer: C
In standard Excel charts, 'data categories' represent the labels plotted along the horizontal X-axis (category axis).
Q407.What is the default file format extension used to save Microsoft Excel spreadsheets in Excel 2007 and later?
Correct Answer: A
Starting with Excel 2007, Microsoft introduced the open XML standard file format extension '.xlsx' as the default.
Q408.In Microsoft Excel, what does formatting text using the 'PROPER()' function do?
Correct Answer: B
The PROPER() function capitalizes the first character of each word in a text string and converts all other letters to lowercase.
Q409.When you open a spreadsheet in Microsoft Excel, what is the topmost bar of the application window called?
Correct Answer: A
When a new workbook is opened in Microsoft Excel, the Title Bar appears at the very top of the screen and displays the name of the open workbook.
Q410.In spreadsheet applications like Microsoft Excel, the individual rows of a table correspond to _____?
Correct Answer: B
In database and spreadsheet tables, each horizontal row represents a complete record (a collection of related fields).
Q411.A cell entry such as 'July 16, 2016' is recognized and treated as which of the following by Microsoft Excel?
Correct Answer: B
Excel treats valid dates (such as 'July 16, 2016') as numerical values, storing them internally as serial numbers for date calculations.
Q412.Which of the following software programs is classified as application software?
Correct Answer: C
MS Excel is an end-user application designed for spreadsheet calculations, whereas Windows, Linux, and DOS are system operating systems.
Q413.What is the default name assigned to the very first worksheet when you create a new workbook in MS Excel?
Correct Answer: B
Excel automatically creates the first worksheet with the default, sequential sheet name 'Sheet1'.
Q414.In Microsoft Excel charts, the vertical axis is referred to as the ______?
Correct Answer: C
Conventionally, Excel charts place category labels on the horizontal X-axis and numerical data ranges on the vertical Y-axis.
Q415.Which MS Excel utility or feature allows you to quickly fill adjacent columns or rows with a series of sequential data?
Correct Answer: C
The Auto Fill feature (drag-and-drop using the fill handle) automatically populates cells with sequential series, dates, or copied formulas.
Q416.Which file format utility is commonly used to compress and combine multiple files together for easier emailing and sharing?
Correct Answer: D
The ZIP format compresses files to reduce storage size and combines multiple individual files into a single archive for convenient sharing.
Q417.In Microsoft Excel, which function is used to calculate the product of a range of numbers?
Correct Answer: D
The =PRODUCT() function multiplies all numbers provided in its cell range or arguments and returns their mathematical product.
Q418.In spreadsheet applications like Excel, what is another commonly accepted name for a 'cell address'?
Correct Answer: B
A cell reference identifies a cell's coordinates (column letter and row number, such as B5) in a worksheet.
Q419.In Microsoft Excel, what does the term 'filter' refer to?
Correct Answer: C
Filtering temporarily hides rows that do not meet set conditions, allowing users to isolate and analyze specific data subsets.
Q420.What are the individual, rectangular boxes arranged in rows and columns in an Excel sheet called?
Correct Answer: C
The basic units where data is entered at the intersection of rows and columns are called cells.