Basic and Advance 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 Basic and Advance Questions and Answers flashcards as text
Which feature in Excel allows you to group and summarize data with collapsible outline levels?
Answer: Group and Outline
The Group and Outline feature lets you group rows or columns together, creating collapsible sections that make it easier to navigate and summarize large datasets.
What is the purpose of the Name Manager in Excel?
Answer: To create, edit, and manage named ranges and defined names
The Name Manager (Ctrl+F3) provides a central location to create, edit, delete, and manage all named ranges and defined names in a workbook.
Which Excel function returns the current date and time and updates automatically when the worksheet recalculates?
Answer: NOW()
NOW() returns the current date and time as a serial number, updating each time the worksheet recalculates. TODAY() returns only the date without the time component.
What is the difference between Cut and Copy when moving cells in Excel?
Answer: Cut removes the original data after pasting; Copy leaves the original intact
Cut (Ctrl+X) moves data by removing it from the source location after pasting. Copy (Ctrl+C) duplicates data, leaving the original cells unchanged.
Which view in Excel is best suited for setting page breaks and print areas before printing?
Answer: Page Break Preview
Page Break Preview shows exactly where pages will break when printed and allows you to drag page break lines to customize the print layout.
What does the Freeze Panes feature do in Excel?
Answer: Keeps specific rows and columns visible while scrolling through the rest of the worksheet
Freeze Panes locks certain rows and/or columns in place so they remain visible as you scroll through large datasets, commonly used to keep headers in view.