Excel Overview and Basic Navigation

What does the AutoSum button on the ribbon do in Excel?

• It automatically inserts a sum formula into the selected cell

• It applies conditional formatting to the selected range

• It hides selected rows or columns

Answer explanation

The AutoSum button on the ribbon in Excel automatically inserts a sum formula into the selected cell, making it easier to calculate totals.

How do you enter a new line within a cell in Excel?

• By pressing Enter

• By pressing Ctrl + Enter

• By pressing Alt + Enter

Answer explanation

To enter a new line within a cell in Excel, you should press Alt + Enter. This shortcut allows you to add line breaks within a cell.

What are cells in Excel?

• The rows and columns in a worksheet

• The individual rectangular boxes where you enter and manipulate data

• The area where you write functions

Answer explanation

Cells in Excel refer to the individual rectangular boxes where you enter and manipulate data, making them the correct choice.

What is the function of the formula bar in Excel?

• It displays the result of calculations

• It shows the content of the selected cell and allows editing

• It contains preset formulas for common tasks

Answer explanation

The formula bar in Excel shows the content of the selected cell and allows editing, making it a crucial tool for inputting and modifying data in spreadsheets.

Which ribbon tab contains commands related to formatting in Excel?

• Home

• Insert

• View

Answer explanation

The 'Home' ribbon tab contains commands related to formatting in Excel, making it the correct choice.

What is the title bar in Excel?

• The area where you enter formulas

• The bar at the top of the Excel window displaying the workbook name

• The section where you format cells

Answer explanation

The title bar in Excel is the bar at the top of the Excel window displaying the workbook name.

Which keyboard shortcut allows you to navigate to the last cell in a worksheet with data?

• Ctrl + Home

• Ctrl + End

• Ctrl + Page Down

Answer explanation

Ctrl + End is the keyboard shortcut that allows you to navigate to the last cell in a worksheet with data.

What is the purpose of the 'Format Painter' tool in Excel?

• It allows you to copy and paste formatting from one cell to another

• It automatically formats numbers as currency

• It changes the font style of the entire worksheet

Answer explanation

The 'Format Painter' tool in Excel allows you to copy and paste formatting from one cell to another.

What does the scroll bar in Excel allow you to do?

• Move the worksheet horizontally

• Move the worksheet vertically

• Both A and B

Answer explanation

The scroll bar in Excel allows you to move the worksheet both horizontally and vertically, making it easier to navigate through large amounts of data.

How do you select multiple non-adjacent cells in Excel?

• By holding down the Ctrl key while clicking on each cell

• By holding down the Shift key while clicking on each cell

• By dragging the mouse over the cells

Answer explanation

To select multiple non-adjacent cells in Excel, you hold down the Ctrl key while clicking on each cell. This allows you to choose specific cells scattered throughout the spreadsheet.