Spreadsheet Fundamentals - Part I

What is the intersection of a row and a column in an Excel worksheet called?

• Range
• Cell
• Ribbon
• Formula Bar

Answer explanation

The intersection of a row and a column is called a cell. It is the basic unit where data is entered in Excel.

Which of the following is a group of adjacent cells in an Excel worksheet?

• Cell
• Range
• Ribbon
• Workbook

Answer explanation

A range is a group of adjacent cells selected together in an Excel worksheet. It can be a block of cells or a single row or column.

What is the name of the area at the top of the Excel window that contains commands and tools?

• Status Bar
• Ribbon
• Formula Bar
• Worksheet

Answer explanation

The Ribbon is the toolbar at the top of the Excel window that contains various commands and tools organized into tabs.

In Excel, which part allows you to enter or edit data in the active cell?

• Status Bar
• Title Bar
• Formula Bar
• Ribbon

Answer explanation

The Formula Bar displays the content of the active cell and allows you to enter or edit data or formulas in that cell.

What is the default name given to a new worksheet in Excel?

• Sheet1
• Workbook1
• Page1
• Table1

Answer explanation

When you create a new worksheet in Excel, it is named "Sheet1" by default. Subsequent sheets are named "Sheet2," "Sheet3," etc.

How do you select an entire row in an Excel worksheet?

• Click on the row number
• Click on the column letter
• Press Ctrl + A
• Click on any cell in the row

Answer explanation

Clicking on the row number selects the entire row in the worksheet.

Which tab in the Ribbon contains options for formatting cells, such as font size and color?

• Insert
• Data
• Home
• View

Answer explanation

The Home tab in the Ribbon contains most of the basic formatting tools, such as font size, color, and alignment options.

What do you call the vertical sections of an Excel worksheet that are labeled with letters?

• Rows
• Columns
• Cells
• Ranges

Answer explanation

Columns in Excel are the vertical sections of a worksheet, and they are labeled with letters (A, B, C, etc.).

Which part of the Excel window displays the name of the current workbook?

• Status Bar
• Formula Bar
• Title Bar
• Ribbon

Answer explanation

The Title Bar at the top of the Excel window displays the name of the current workbook file.

What happens when you double-click the boundary between two column headers in Excel?

• The column is deleted
• The column width is auto-adjusted
• A new column is inserted
• The entire column is selected

Answer explanation

Double-clicking the boundary between two column headers will automatically adjust the width of the column to fit the contents of the cells in that column.