Used in place of absolute cell reference, IFS, SUMIF, Named Cells, Conditional Formatting, Data can be filtered for specific criteria eg, sales in a particular region (drop-down), Named Cells, Pivot Table, Conditional Formatting, Filter, Asks questions, one by one, and gives instructions of what the software must do if the answer to the question is true, IFS, CountIF, CountBlank, Pivot Table, Counts how many cells meet a certain rule, CountIF, Filter, Named Cells, SUMIF, Counts how many cells are empty, SUMIF, Conditional Formatting, Filter, CountBlank, Adds together all the numbers relating to a value looked for, Named Cells, IFS, SUMIF, CountBlank, Automatically applies formats to cells that meet a certain rule eg bold all cells over £2,000, Conditional Formatting, Filter, SUMIF, CountIF, A tool that shows only the data that meets a criteria and hides the rest, CountIF, Named Cells, Filter, IFS
0%
Spreadsheet Features 2
Share
Share
by
Clerobinson1
Edit Content
Save
Like
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Quiz
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
Open results
Copy link
QR code
Delete
Continue editing:
?
