Quiz
Spreadsheet
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1The information represented in the rows in a worksheet is called ..............................
- Adata
- Brecord
2............................ is the process of representing a range of numbers with same number of decimal point in a worksheet.
- AUnconditional numeric data formatting
- BConditional numeric data formatting
3In a worksheet, the process of rearranging data in a particular order is called .................
- Aediting
- Bsorting
4When you click............................ formatting, the data will be processed based on a given condition.
- Aunconditional
- Bconditional
5Unauthorized handling of data can be ignored by protecting datasheet with a ...................................
- Apassword
- Bdata handling
6A record can be searched in a worksheet with the help of ................ feature
- Aform
- Bfile
7......................... allows adding pictures in the worksheet from available gallery.
- AInsert picture
- Bformat picture
8By using .............................. data, only a set of records are made visible based on a given condition.
- Asorting
- Bfiltering
9......................................feature is used to update the cell values as per the given formula, if any editing takes place, in a database worksheet.
- Awhat if analysis
- Bquick analysis
10In conditional formatting, a set of data values are categorized with various colour patterns by using ......................scale
- Ameter
- Bcolour
11Spreadsheet is composed of horizontal and vertical grid lines
- ATrue
- BFalse
12A spreadsheet can only contain numeric data.
- ATrue
- BFalse
13LOTUS 123 is a DOS-based spreadsheet
- ATrue
- BFalse
14A spreadsheet can perform a powerful operation called recalculation
- ATrue
- BFalse
15By default, MS Excel provides five worksheets in a workbook.
- ATrue
- BFalse
16After protecting a worksheet, you can easily edit the data.
- ATrue
- BFalse
17You can insert a chart but not clipart in a worksheet.
- ATrue
- BFalse
18You can sort records of a worksheet in random order
- ATrue
- BFalse
19You can select a range of data as per your choice in a spreadsheet.
- ATrue
- BFalse
20You can group the rows but not the column in a worksheet.
- ATrue
- BFalse
Information
- Description
- Quiz on Spreadsheet, created by Shyni Aneesh on 22/05/2020.
- Author
- Shyni Aneesh
- Language
- English
- Views
- 3
- Rating
- No ratings yet Rate this quiz