Excel Basics
Working with Data
Formulas & Ranges
Formatting Tools
Application & Analysis
100

What is the name of the Microsoft application used to work with spreadsheets?

Microsoft Excel

100

What are the horizontal divisions in a worksheet called?

Rows

100

What is an equation used to calculate values in Excel called?

Formula

100

What feature adjusts text position within a cell (left, center, right)?

Alignment

100

Why might a company use several worksheets in one workbook?

To separate data by department or category.

200

What is a digital table of rows and columns used to organize and analyze data?

Spreadsheet

200

What are the vertical divisions in a worksheet called?

Columns

200

What do you call a group of selected cells, such as A1:A5?

Range

200

What feature combines cells and centers the text across them?

Merge and Center

200

Why is using cell references in formulas helpful?

It allows formulas to update automatically if values change.

300

What is the file that contains one or more worksheets called?

Workbook

300

What is the intersection of a row and column called?

Cell

300

What is a selected range where the cells are not next to each other called?

Nonadjacent Range

300

What tool changes the appearance (font, size, color) of a cell quickly?

Cell Style

300

What’s one advantage of using a spreadsheet over paper tables?

Easier calculations, updates, and data organization.

400

What is a single page or tab within an Excel file called?

Worksheet

400

What is a cell’s address, like A1 or B2, called?

Cell Reference

400

What is a selected range where all the cells touch each other?

Adjacent Range

400

What option lets you display data as currency, date, or percent?

Number Format

400

How can using styles improve your spreadsheet?

It creates consistency and makes data easier to read.

500

What term describes the currently open sheet you are working on in Excel?

Active Worksheet

500

Where can you type or view a formula or value besides the cell itself?

Formula Bar

500

What do you call the identification of a range using cell references?

Range Reference

500

What feature adds lines around cells to visually separate data?

Border

500

Why would you use "Merge and Center" in a title row?

To center a heading across multiple columns for clarity.