1. Data Analysis is
A. The process of evaluating data using analytical and logical reasoning to examine each component of the data provided.
B. the presentation of data in a pictorial or graphical format.
C. online data mining and data visualization solution.
D. visual reporting, tree maps, correlation analysis, decision trees, association rules, self organizing maps.
E. open-source and free visualization and exploration software for all kinds of graph and networks.
2. Data Mining is
A. A Sifting through very large amounts of data for useful information.
B. the presentation of data in a pictorial or graphical format.
C. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
D. visual reporting, tree maps, correlation analysis, decision trees, association rules, self organizing maps.
E. open-source and free visualization and exploration software for all kinds of graph and networks.
3. Data Visualization is
A. The presentation of data in a pictorial or graphical format.
B. The process of evaluating data using analytical and logical reasoning to examine each component of the data provided.
C. An online data mining solution.
D. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
E. a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data.
4. A Spreadsheet refers to
A. a file made of rows and columns that helps sort data, arrange data easily, and calculate numerical data.
B. The presentation of data in a pictorial or graphical format.
C. The process of evaluating data using analytical and logical reasoning to examine each component of the data provided.
D. An online data mining solution.
E. a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.
5. Examples of spreadsheet programs:
A. Google Sheets, LibreOffice, Lotus 1-2-3, Microsoft Excel
B. Microsoft Access, Microsoft Word, Microsoft Excel
C. Google Sheets, Microsoft Access, Microsoft Word
D. Google Sheets, Microsoft Power Point, OpenOffice -> Calc
E. OpenOffice -> Calc, Microsoft Power Point, Microsoft Word
6. A worksheet is
A. a collection of cells
B. a chart
C. a row
D. a column
E. a graph
7. A cell is
A. The point where a column and a row intersect
B. a chart
C. a row
D. a column
E. a graph
8. The Active Cell is
A. the cell which you have currently selected.
B. a chart
C. a row
D. a column
E. a graph
9. The Active Cell
A. has a darker outline around it
B. is painted gray
C. is shaded black
D. is colored yellow
E. has a green outline around it
10. Each cell has a unique address. This address is known as
A. the Cell Reference
B. The numbers
C. The letters
D. The Cell position
E. The Cell location
|
|
|
11. The Cell with a darker outline around
A. The Active Cell
B. The Dynamic Cell
C. The Inactive Cell
D. The Moving Cell
E. The Energetic Cell
12. The cell reference comes from
A. the Column Letter followed by the Row Number.
B. the Row Number followed by the Column Letter.
C. the Column Number followed by the Row Letter.
D. the Row Letter followed by the Column Number.
E. the Column Letter followed by the Row Letter.
13. An example of a cell reference:
A. H800
B. 8H
C. 800B
D. AC
E. 234N
14. Decide which sentence is true.
A. Spreadsheet programs can generate a variety of charts and graphs.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
15. Decide which sentence is true.
A. You can change the width of columns.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
16. Decide which sentence is true.
A. Spreadsheet can be used as databases.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
17. Decide which sentence is true.
A. In a spreadsheet you can enter text.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
18. Decide which sentence is true.
A. You can change the height of rows.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the width of columns.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
19. Decide which sentence is true.
A. You can change the width of columns.
B. You cannot change the height of rows.
C. In a spreadsheet you can only enter numbers and formulae.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
20. Decide which sentence is true.
A. You can change the width of columns.
B. You cannot change the height of rows.
C. In a spreadsheet you can only enter functions that add, subtract, multiply or divide.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
21. Decide which sentence is true.
A. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
B. You cannot change the width of columns.
C. You cannot change the height of rows.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
22. Decide which sentence is true.
A. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
B. You cannot change the name of sheets.
C. You cannot change the height of rows.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
23. Decide which sentence is true.
A. Spreadsheet can be used as databases.
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the number of sheets.
|
|
|
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
24. Decide which sentence is true.
A. A formula always starts with an = sign
B. In a spreadsheet you can only enter numbers and formulae.
C. You cannot change the number of sheets.
D. Spreadsheets cannot be used as databases.
E. Spreadsheet programs cannot generate charts.
25. Decide which sentence is false.
A. In a spreadsheet you can only enter numbers and formulae.
B. A formula always starts with an = sign
C. You can change the number of sheets.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
26. Decide which sentence is false.
A. Spreadsheet programs cannot generate charts.
B. Spreadsheet programs can generate a variety of charts and graphs.
C. In a spreadsheet you can enter numbers and formulae.
D. You can change the width of columns.
E. Spreadsheets can be used as databases.
27. Decide which sentence is false.
A. In a spreadsheet you can only enter numbers and formulae.
B. You can change the width of columns.
C. You can change the height of rows.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
28. Decide which sentence is false.
A. You cannot change the width of columns.
B. Spreadsheet can be used as databases.
C. In a spreadsheet you can enter numbers and formulae.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs cannot generate charts.
29. Decide which sentence is false.
A. Spreadsheets can be used as databases.
B. In a spreadsheet you can enter text.
C. In a spreadsheet you can enter numbers and formulae.
D. You can change the width of columns.
E. Spreadsheet programs can generate graphs.
30. Decide which sentence is false.
A. Spreadsheet programs cannot generate charts.
B. You can change the height of rows.
C. In a spreadsheet you can enter numbers and formulae.
D. You can change the width of columns.
E. Spreadsheets can be used as databases.
31. Decide which sentence is false.
A. You cannot change the height of rows.
B. You can change the width of columns.
C. In a spreadsheet you can enter numbers and formulae.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
32. Decide which sentence is false.
A. In a spreadsheet you can only enter functions that add, subtract, multiply or divide.
B. You can change the width of columns.
C. You can change the height of rows.
D. Spreadsheets can be used as databases.
E. Spreadsheet programs can generate charts.
33. Decide which sentence is false.
A. You cannot change the number alignment.
B. Spreadsheet programs can generate a variety of charts and graphs.
C. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
D. You can change the width of columns.
E. Spreadsheets can be used as databases.
34. Decide which sentence is false.
A. You cannot choose a font in a spreadsheet.
B. In a spreadsheet you can enter operations that add, subtract, multiply or divide.
C. You can change the name of sheets.
D. Spreadsheets can be used as databases.
E. Spreadsheets programs can generate charts.
35. Decide which sentence is false.
A. The formula is always visible in the cell.
B. In a spreadsheet you can enter numbers and formulae.
C. You can change the number of sheets.
D. The formula can be seen in the formula bar.
E. Spreadsheet programs can generate charts.
