- What is the primary function of the Ribbon in Excel?
- A) To display data in a chart format
- B) To organize and access various tools and commands
- C) To create formulas for calculations
- D) To save and manage files
Answer: B) To organize and access various tools and commands
- Which tab on the Ribbon would you use to insert a table into an Excel worksheet?
- A) Home
- B) Insert
- C) Formulas
- D) Data
Answer: B) Insert
- Where is the Formula Bar located in the Excel interface?
- A) At the top of the worksheet, below the Ribbon
- B) At the bottom of the worksheet
- C) On the right side of the worksheet
- D) On the left side of the worksheet
Answer: A) At the top of the worksheet, below the Ribbon
- Which feature allows you to view multiple worksheets in a single Excel window?
- A) Split View
- B) Freeze Panes
- C) Arrange All
- D) Zoom
Answer: C) Arrange All
- What does the Status Bar in Excel display?
- A) The current cell’s formula
- B) Information about the worksheet and current cell
- C) The name of the worksheet
- D) The history of recent actions
Answer: B) Information about the worksheet and current cell
- Which area in Excel is used to enter and edit data in a cell?
- A) The Formula Bar
- B) The Ribbon
- C) The Status Bar
- D) The Name Box
Answer: A) The Formula Bar
- To change the font style of text in a cell, which tab on the Ribbon would you use?
- A) Home
- B) Review
- C) Page Layout
- D) View
Answer: A) Home
- What is the purpose of the Name Box in Excel?
- A) To display the name of the workbook
- B) To enter and view the address of the currently selected cell
- C) To show the name of the worksheet
- D) To access saved names of ranges
Answer: B) To enter and view the address of the currently selected cell
- Which tab on the Ribbon provides access to features like Sorting and Filtering?
- A) Home
- B) Data
- C) Review
- D) View
Answer: B) Data
- What does the “Quick Access Toolbar” allow you to do?
- A) Access frequently used commands quickly
- B) Customize the appearance of the workbook
- C) Create and manage macros
- D) Switch between open workbooks
Answer: A) Access frequently used commands quickly
