MCQ Questions and Answers Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 MCQ Questions and Answers flashcards as text
Which tab on the Excel ribbon contains the Sort and Filter commands?
Answer: Data
The Data tab contains Sort and Filter commands along with other data management tools like Data Validation, Text to Columns, and Remove Duplicates.
What file extension does a macro-enabled Excel workbook use?
Answer: .xlsm
The .xlsm extension indicates a macro-enabled workbook that can contain VBA macros, while .xlsx files cannot store macros.
How many worksheets does a new Excel workbook contain by default in Excel 2016 and later?
Answer: 1
Starting with Excel 2013, new workbooks default to 1 worksheet. Earlier versions defaulted to 3 worksheets.
Which of the following is NOT a valid Excel chart type?
Answer: Matrix Chart
Matrix Chart is not a built-in Excel chart type. Waterfall, Treemap, and Sunburst charts were all added in Excel 2016.
What does pressing F2 do when a cell is selected in Excel?
Answer: Enters edit mode for the active cell
F2 puts the active cell into edit mode, placing the cursor in the cell so you can modify its contents without overwriting them.
Which feature allows you to restrict what values users can enter into specific cells?
Answer: Data Validation
Data Validation lets you create rules that restrict input to whole numbers within a range, dates, list selections, text length limits, or custom formulas.