Business Analytics One 0.0 / 5 ? Business StudiesBusiness Analytics OneUniversityAQA Created by: I.J.MISTRY1Created on: 02-04-22 14:53 200 is invested in a shares ISA. The annual dividend from this investment is 7. What is the percentage yield on this investment? 3.5% 1 of 19 400 is invested in shares ISA. The annual dividend from this investment is 18. What is the percentage yield on this investment? 4.5% 2 of 19 Good use of information technology can help an organisation to become more competitive True 3 of 19 As you move from one cell to another the contents of the Name Box will Change for each different Cell you click on 4 of 19 Which of the following is the correct hierarchy from the lowest level to the highest level? data, information, knowledge 5 of 19 Which of the following is a source for internal data? Transaction Processing Systems 6 of 19 An organisation’s business processes can create a competitive advantage. True 7 of 19 In Excel a ready-made formula is called a Function. The Auto sum (sigma) can be used to insert a function. True 8 of 19 An Excel formula will only work with numbers False 9 of 19 An Excel formula can only have one answer. False 10 of 19 Which formula would result in the highest number from the Cells E4 to E12 appearing? MAX (E4:E12) 11 of 19 Which formula would result in the average for the numbers in Cells D4 to D9 appearing in your spreadsheet? AVERAGE (D4:D9) 12 of 19 Managing pay and payroll is an example of a Human Resources Business Process 13 of 19 If you create a new Excel file and put the cursor on Cell A1 the Name box will show: A1 14 of 19 Managing account collections is an example of a Finance Business Process 15 of 19 …. Is (are) data that have been organised to have meaning and value to a recipient. Complete this sentence which one of the following words: Information 16 of 19 Information is data that have been assembled and organised to be useful. True 17 of 19 In a data warehouse, existing data are constantly purged as new data come in. False 18 of 19 Looking at the Excel sample below taken from Exercise 12, an If Statement is the best way to calculate the Discount Price in column H. True 19 of 19
Comments
No comments have yet been made