Font size
WorksheetsSPREASHEET DATA VALIDATION
Total questions: 22
Worksheet time: 14mins
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 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
expressions which return values
Rows
Filter Views
Formulas
Columns
pre-set formulas used to make calculations in Google Sheets
Formulas
Functions
Column
Average
adds a range of values in spreadsheet cells
Column
Sort
Charts
SUM function
changes the background color of cells that contain specific information
Sort
Formulas
Average
Conditional Formatting
Match the following:
Words entered into a spreadsheet
Labels
Numbers, dates, or times entered into a spreadsheet
Values
A group of spreadsheet cells
Range
Vertical lines of data labeled by a letter
Columns
Horizontal lines of data labeled by a number
Rows
