SPREASHEET DATA VALIDATION

What is an automatic computer check method to make sure data entered is sensible and reasonable known as?

• Double Entry

• Verification

• Validation

Which of the following statements is false?

• Validation can check that the data is sensible

• Validation can check that the data falls between certain allowable boundaries

• Validation can check that the data is correct

a collection of worksheets which are stored together in a single file and given a single name.

• Workbook

• Cells

• Row

• Column

a single sheet (page) of rows and columns in a workbook

• Cells

• Worksheets

• Row

• Column

intersection of a column and a row on a worksheet

• Column

• Row

• Cells

• Freeze Row/Column

a range of cells that go down (vertical) in a spreadsheet/worksheet

• Column

• Data Validation

• Row

• Sort

a range of cells that go across (horizontal) the spreadsheet/worksheet

• Row
• Filter Views
• Data Validation
• Filter

a method of limiting the entries and responses used in a spreadsheet

• Sort

• Row

• Data Validation

• Filter Views

puts date from a specific range, such as a column, in numerical or alphabetical order

• Filter

• Sort

• Column

• SUM function

temporarily hide data in a spreadsheet so you see only a selection of specific rows or values

• Data Validation

• Formulas

• SUM function

• Filter