Excel Vocab

Question 1

What is a Cell?

Answer 1

Rectangular shaped box in a worksheet.

Question 2

What is an Active Cell?

Answer 2

An Active Cell is a Cell that is currently selected and ready to add information to.

Question 3

What is a Cell Reference?

Answer 3

A cell reference is the location of a cell or group of cells in a worksheet.

Question 4

What is range?

Answer 4

Range is a collection of two or more cells.

Question 5

What is the column heading?

Answer 5

The column heading is the identification used to find a column.

Question 6

What is Autofill?

Answer 6

When you start typing a word, the field will be filled in automatically.

Question 7

What is a Workbook?

Answer 7

A workbook is a compilation of worksheets in Excel.

Question 8

A worksheet is…

Answer 8

.. A single spreadsheet that contains cells organized by rows and columns.

Question 9

What happens when you enter more numeric characters than can fit in a cell?

Answer 9

a series of number signs is displayed in the cell

Question 10

how to Freeze rows:

Answer 10

1. Select the row you want to freeze.
2. Click on the ‘view’ tab.
3. Click on the ‘Freeze panes’ in the ‘window’ section.
4. Select the ‘freeze top row’

Question 11

How do you add a header?

Answer 11

1. Go to the insert tab.
2. Click on the ‘header & Footer’ button in the ‘text’ selection.
3. Add header name and change view at the bottom of the document, next to the zoom slider.