BTEC DIT Component 2B

Which one of these features is used to return values from a table

• VLookup

• Count If

• SUMIF

• Max

A __________ is used to present data in an easy to understand way?

Select all of the formatting tools

• Colours

• Border

• Formulas

• Alignment

Which tool is used to ensure data entered is reasonable and sensible?

• Validation

• Verification

• Freeze panes

• Comments

Which of these functions would be used to find the largest number in a range of cells?

• Max

• Min

• Average

• Count

The ____________ function is used to find the smallest number in a range of cells

Which of these functions is used to add up the numbers if they meet a criteria

• SumIf

• CountIf

• VLookup

• Average

Which of these functions is used to count the numbers if they meet a criteria

• SumIf

• CountIf

• VLookup

• Average

Which tool is used to change the colour of cells and text based on the contents

• VLookup

• CountIF

• Conditional Formatting

• Validation

Which of these elements need to be Included when displaying a graph?

• Formulas

• Functions

• Chart title

• Axis labels