Font size
WorksheetsG8 Unit 6
Total questions: 21
Worksheet time: 13mins
A field that stores data that is unique
Key field
Data Field
Conditional formatting
It is a format, such as cell color, which is based on a logical test.
format only colors
Absolute cell reference
The value of the cell will stay in different row of the table.
The value of the cell will stay the same in every row of the table.
Cell reference
Means they take values from other cells in the Microsoft word
Means they take values from other cells in the spreadsheet
They are the columns of the table.
field
Record
Each (a) stores all the data about one thing
A positive number means there is a (a)
They are the rows of the table
field
Record
Write three advantages of organizing data as a table in a spreadsheet.
Sort and search the data
Use formatting to pick out important facts.
Use formulas to calculate new information
allow sorting only
In Excel, rows are labeled by letters
True
False
When inserting a formula, always start with (+)
True
False
The function is a cell content that starts with an equal sign and contains constants, cell references, and operations
True
False
The key field stores data that is unique
True
False
The Auto-sum button will add up a group of numbers
True
False
We use the spreadsheet to organize data and make a data table
True
False
The rows of a table are called records
True
False
Conditional formatting is a format that is based on a logical test, such as cell color
True
False
In Excel, columns are labeled by numbers
True
False
Each (a) stores all the data about one thing
A negative number means there is a
(a)
Choose the correct rule that will be selected in conditional formatting for the following table
less than 50
less than 70
less than 100
