1 Spreadsheet Fundamentals and Data Organization Free Online FlashCards

What does the cell address B3 identify?

A cell address uses its column letter followed by its row number; B3 is in column B, row 3.

What does the range A1:C4 include?

A range is a group of cells. A1:C4 includes every cell from A1 through C4.

How should records and variables be arranged in a dataset?

Each row should represent one record, and each column should represent one characteristic, or variable.

What makes a useful dataset header?

Use short, meaningful, unique column names and avoid empty headers.

What keeps a dataset as a clean rectangular block?

Keep records in one continuous rectangular block without blank rows or columns, merged cells, or totals mixed into the records.

What happens to a relative reference when its formula is copied?

A relative reference, such as A2, changes when a formula containing it is copied to another location.

What happens to an absolute reference when its formula is copied?

An absolute reference, such as $A$2, stays fixed when copied.

What does a mixed cell reference fix?

A mixed reference fixes either the column or the row: $A2 fixes the column, while A$2 fixes the row.

How does a cell’s value differ from its format?

A value is the information stored in a cell; its format controls how that information appears.

Why might an identifier be stored as text?

Treat identifiers such as ZIP codes or product codes as text when needed, especially if leading zeros matter.

Why should a column use consistent data types?

Use consistent types within each column; mixing entries such as 12, twelve, and N/A in a numeric field can cause problems.

What date convention is recommended for clarity?

Use a consistent, unambiguous date convention, such as YYYY-MM-DD.