vocab

Question 1

cell reference

Answer 1

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

Question 2

range

Answer 2

is the difference between the highest and the lowest of differences in a series of numbers

Question 3

column heading

Answer 3

colored row of letters used to identify each column within the sheet, or workbook

Question 4

cell

Answer 4

The data is usually text, a numeric value, or a formula. The entire spreadsheet is composed of rows and columns of cells.

Question 5

active cell

Answer 5

is the selected cell in which data is entered when you begin typing.

Question 6

Autofill

Answer 6

To change how you want to fill the selection

Question 7

Workbook

Answer 7

A cell can also reference another cell in the same worksheet, the same workbook or a different workbook.

Question 8

Worksheet

Answer 8

worksheet is 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

You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. … width of its column cannot display all the characters that its format requires. … This display difference can have a significant effect when the data is numeric.

Question 10

How to freeze rows

Answer 10

Select the row below the row(s) you want to freeze.Click the View tab on the Ribbon.Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. …
The rows will be frozen in place, as indicated by the gray line.

Question 11

How to add a header

Answer 11

Click the worksheet to which you want to add a predefined header or footer.
On the Insert tab, in the Text group, click Header & Footer. …
Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.

Question 12

Datatype

Answer 12

a programming language is a set of data with values having predefined characteristics.

Question 13

Database

Answer 13

is a collection of information that is organized so that it can easily be accessed, managed, and updated.

Question 14

Datasheet

Answer 14

or spec sheet is a document that summarizes the performance and other technical characteristics of a product, machine, component.

Question 15

Entry

Answer 15

Access Control Entry ACE Definition - Access control entries (ACE) are entries in an access control list containing information describing the access.

Question 16

Field

Answer 16

its a column table.

Question 17

Field Name

Answer 17

An assigned name for a field name, address, city, state, that will be the same in every record.

Question 18

Field Properties

Answer 18

These properties define the field’s characteristics and behavior. The most important property for a field is its data type. A field’s data type determines what kind of data it can store.

Question 19

Primary Key

Answer 19

is a special relational database table column (or combination of columns) designated to uniquely identify all table records. its main features are: It must contain a unique value for each row of data. It cannot contain null values.

Question 20

Record

Answer 20

In a database, a record (sometimes called a row ) is a group of field s within a table that are relevant to a specific entity.

Question 21

Relational Database

Answer 21

a database structured to recognize relations among stored items of information.

Question 22

Query

Answer 22

Are the primary mechanism for retrieving information from a database.

Question 23

Report

Answer 23

used to print and share data in access.