NEW
Font size
WorksheetsExcel - Pop Quiz - W2
Total questions: 10
Worksheet time: 5mins
The image shows various filter options that can be performed on a set of information. With which filters we can do it.
Color filters
Text filters
Numerical filters
Search Filters
To arrange data in ascending order of age we will
Filter it
Sort it
Apply Conditional Formatting
Rearrange data manually
This icon represents
Auto sum
Sort and Filter
Spreadsheet is mainly used for _________________.
Written Text
Add Images
Calculations
Presentation
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
A feature that allows you to change the font style in a spreadsheet.
A technique used to protect cells from accidental editing.
A tool that automatically calculates formulas in a spreadsheet.
A feature that applies formatting to cells based on specific conditions or rules.
1
2
3
4
1
2
3
4
Color Scales
Icon Sets
Data Bars
Top/Bottom Rules
