33919355
Description
Flashcards by William Smart, updated more than 1 year ago
|
Created by William Smart
over 2 years ago
|
|
| Question | Answer |
| Q1 There are two types of software you can use to analyse data: 1.) Spreadsheets 2.) Databases | Q2 What is a Spreadsheet used for: 1.) Store text and numerical data 2.) Process and manipulate numerical data 3.) Produce graphs 4.) Set data types, including text, numeric, decimal, currency and percent |
| Q3 Spreadsheets contain different: 1.(Worksheets) Which is then which then form a Workbook | Q4 What is a Spreadsheet used for: 1.) Create formula and use built-in functions 2.) Carry out modelling using What-If Analysis |
| Q5 What tasks are Spreadsheets really good at: 1.) Calculating invoices 2.) Finding out the effect of price changes on sales of goods 3.) Importing data collected from, for example, a sensor or survey | Q6 What tasks are Spreadsheets really good at: 1.) Producing a graph to show how many people used a shop. 2.) Showing a business’s accounts over a year with months in a different worksheet 3.)Importing data collected from, for example, a sensor or survey |
| Q6 A _____ is made up of one or more tables which contain data? 1.) Database | Q7 The table will also have ______? 1.) Fields |
| Q8 Databases are much better than spreadsheets at? 1.) Storing and processing large amounts of data | Q9 You can also use a database to create? 1.) personalised letters 2.) emails and business cards 3.) Data storage 4.) All of above Answer is (4) |
| Q10 What are the Advantages of Spreadsheets? 1.) Formulas can be used to calculate and recalculate totals 2.) What-If Analysis can be carried out using different values 3.) Data modelling can be carried out | Q11 What are the Advantages of Spreadsheets? 1.) Worksheets can be used to separate different sets of data in a Workbook 2.) Data can easily be presented in tables with columns and rows |
| Q12 What are the Disadvantages of Spreadsheets? 1.) If a model is created, the results might not be realistic 2.) Spreadsheets can take a long time to create | Q13 What is the Disadvantages of Spreadsheets? 1.) Errors in formulas can be difficult to spot and correct 2.) If you don't spot any errors in formulas, the results will be incorrect 3.) Text data cannot be manipulated easily |
| In terms of the software needed to present the information. What are the five main tools that you can choose between? 1.) Word Processors 2.) Spreadsheets 3.) Databases | In terms of the software needed to present the information. What are the five main tools that you can choose between? 1.) Desk Top Publishing 2.) Presentation Software |
| What are environmental vulnerabilities? The tendency of the environment to respond either positively or negatively to changes in human and climatic conditions. Or something close to this. | vulnerabilities of physical hazard Wooden homes are less likely to collapse in an earthquake, but are more vulnerable to fire. theft. |
Want to create your own Flashcards for free with GoConqr? Learn more.