1) Which of these is NOT a data collection method? a) questionnaire b) Tally c) interview d) text message 2) Which software do we use in school to analyse data? a) Excel b) PowerPoint c) Word d) Internet Explorer 3) In Excel what does the SUM function do? a) Adds the cells up in a row or column b) Finds the average of a row or column c) Finds the highest number in a row or column d) Finds the lowest number in a row or column 4) In Excel what does the AVERAGE function do? a) Adds the cells up in a row or column b) Finds the average of a row or column c) Finds the highest number in a row or column d) Finds the lowest number in a row or column 5) In Excel what does the MAX function do? a) Adds the cells up in a row or column b) Finds the average of a row or column c) Finds the highest number in a row or column d) Finds the lowest number in a row or column 6) In Excel what does the MIN function do? a) Adds the cells up in a row or column b) Finds the average of a row or column c) Finds the highest number in a row or column d) Finds the lowest number in a row or column 7) In Excel, what does the COUNT function do? a) it counts how many cells contain a number b) counts how many blank cells there are c) counts only the cells with specific data in them d) counts how many cells contain data 8) In Excel, what does the COUNTA function do? a) it counts how many cells contain a number b) counts how many blank cells there are c) counts only the cells with specific data in them d) counts how many cells contain data 9) In Excel, what does the COUNTBLANK function do? a) it counts how many cells contain a number b) counts how many blank cells there are c) counts only the cells with specific data in them d) counts how many cells contain data 10) In Excel, what does the COUNTIF function do? a) it counts how many cells contain a number b) counts how many blank cells there are c) counts only the cells with specific data in them d) counts how many cells contain data 11) What do we use to present data that has been analysed? a) Tables and Charts b) Tables and chairs 12) Why do we use FORMATTING in Excel? a) To improve the look of our data b) To make the data easier to read c) To extract the important parts of the data d) All of these 13) Why do we use dashboards to present our findings a) Because it shows we can use Excel b) It is a visual display that organizes and summarizes key information

1. Data analysis

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม