chart terms cell, row, column

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

cell

A cell is the intersection of a row and a column. A cell can contain a label, a numeric value, or a formula.

formula

A formula is an expression entered in a cell that performs numeric calculation, logical comparison, or text string manipulation.

function

A function is a preset formula. Functions consist of the function name and its arguments. The function name tells Excel what calculation you want it to perform

label

A label is any cell entry other than a numeric value or a formula. A text entry in a cell is called a label. A range of values will often have a label to identify it

range

A range is a block of cells that can be selected, manipulated, named, or formatted as a group.

relative cell reference

A relative address is a standard cell reference that appears like this: A1,E15,M42. A relative address changes if you copy a formula that contains it to a new location on the worksheet. Think of it like saying "in two weeks" - the date will always be different (or relative) depending on the current date.

workbook

A workbook is the Excel file that stores your information. Each workbook may contain numerous worksheets.

worksheet

A worksheet is an electronic spreadsheet that lets you enter, analyze, and calculate data. Within a workbook, worksheets can share information, and calculations pertaining to several worksheets can be performed at one time. The default number of worksheets in a new workbook is three

absolute cell reference

An absolute address in a formula refers to a specific cell location or range. It always points to the location of a specific cell, even if you copy it. Absolute addresses are created by adding a $ sign in front of each character in the cell address. For example, $C$8 always refers to cell C8.

column

Columns are the vertical divisions of a worksheet that are identified by letters

legend

Legends provide a key to the data illustrated in a chart

row

Rows are the horizontal divisions of a worksheet that are identified by numbers.

value

When a cell contains a formula, the resulting number shown on the screen is called a value.


Ensembles d'études connexes

APUSH Chapter 24, APUSH Chapter 25

View Set

exam 3 chp 41,45,46,47 practice questions

View Set

IELTS - Task 2 - Working from home, advantages and disadvantages Types of introduction/body 1 advantages

View Set

AP Chemistry Equilibrium Test Potential Questions

View Set

Principles of Nutrition Chapter 5

View Set

Leadership Mid Term, Leadership Week 6 and 7, Leadership Week 5

View Set

Chapter 16 Genetic Regulation in Bacteria

View Set