Test
Spreadsheet
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (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
- AVerdadero
- BFalso
12A spreadsheet can only contain numeric data.
- AVerdadero
- BFalso
13LOTUS 123 is a DOS-based spreadsheet
- AVerdadero
- BFalso
14A spreadsheet can perform a powerful operation called recalculation
- AVerdadero
- BFalso
15By default, MS Excel provides five worksheets in a workbook.
- AVerdadero
- BFalso
16After protecting a worksheet, you can easily edit the data.
- AVerdadero
- BFalso
17You can insert a chart but not clipart in a worksheet.
- AVerdadero
- BFalso
18You can sort records of a worksheet in random order
- AVerdadero
- BFalso
19You can select a range of data as per your choice in a spreadsheet.
- AVerdadero
- BFalso
20You can group the rows but not the column in a worksheet.
- AVerdadero
- BFalso
Información
- Descripción
- Test sobre Spreadsheet, creado por Shyni Aneesh el 22/05/2020.
- Autor
- Shyni Aneesh
- Idioma
- English
- Visitas
- 3
- Valoración
- Aún sin valoraciones Valora este test