excel vocab

Question 1

cell

Answer 1

A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.

Question 2

Active Cell

Answer 2

The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.

Question 3

cell reference

Answer 3

refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: Data from one cell on the worksheet.

Question 4

range

Answer 4

The range is the difference between the highest and the lowest of differences in a series of numbers. We will therefore need the series that we want to perform range function

Question 5

column heading

Answer 5

Click on the number “2” on the left side of the spreadsheet to select the second row, which is the now the first row under the headings. Click the “View” tab, and then click the “Freeze Panes” button in the Window area of the ribbon. Your column headers now stay visible as you scroll down the spreadsheet.

Question 6

Autofill

Answer 6

Autofill is a function in some computer applications or programs, typically those containing forms, which fills in a field automatically. Most of the time, such as in Internet Explorer and Google Toolbar, the entries depend on the form field’s name, so as to not enter street names in a last name field or vice versa

Question 7

Worksheet

Answer 7

Worksheet. An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook.

Question 8

workbook

Answer 8

a workbook holds worksheets

Question 9

how to freeze rows

Answer 9

1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3. …
2. Click the View tab on the Ribbon.
3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. …
4. The rows will be frozen in place, as indicated by the gray line.

Question 10

how to add a header

Answer 10

Add header or footer content to a preformatted page number design. On the Insert tab, in the Header & Footer group, click Page Number. Click Top of Page, Bottom of Page, or Page Margins, depending on where you want page numbers to appear in your document. Choose a page number design from the gallery of designs.