Data Analytics & Engineering

1. Question 1 of 12

   Question 1 of 12

   In Excel, which formula calculates the average of cells B2 to B10?

   One answer

   =SUM(B2:B10)=COUNT(B2:B10)=AVERAGE(B2:B10)=MAX(B2:B10)
2. Question 2 of 12

   Question 2 of 12

   You have a long sales table. Which tool gives the total sales per region most quickly?

   One answer

   A pie chartA pivot tableConditional formattingAlphabetical sorting
3. Question 3 of 12

   Question 3 of 12

   In a well-structured data table, each row usually represents:

   One answer

   A record (a customer, a sale…)A variableA fileA calculation
4. Question 4 of 12

   Question 4 of 12

   Which of these are data types?

   Several answers possible

   TextCell colourNumberDate
5. Question 5 of 12

   Question 5 of 12

   A CSV file is:

   One answer

   An Excel file containing macrosAn imageA text file whose values are separated by a delimiter (comma, semicolon)A database program
6. Question 6 of 12

   Question 6 of 12

   What is the median of the series 2, 3, 3, 4, 18?

   One answer

   46318
7. Question 7 of 12

   Question 7 of 12

   For the same series, the mean (6) is higher than the median. Why?

   One answer

   The median is always smaller than the meanThe value 18, far from the others, pulls the mean upThere must be a calculation errorThe series has an odd number of values
8. Question 8 of 12

   Question 8 of 12

   Revenue goes from 200 to 250. What is the percentage increase?

   One answer

   50%20%25%2.5%
9. Question 9 of 12

   Question 9 of 12

   A relational database organises data into:

   One answer

   Independent, unrelated documentsTables linked to each other by keysFile foldersProtected spreadsheets
10. Question 10 of 12

    Question 10 of 12

    SQL is mainly used to:

    One answer

    Create presentationsProgram web animationsDraw network diagramsQuery and change the data in a database
11. Question 11 of 12

    Question 11 of 12

    In Python, what does print(len([4, 8, 15])) display?

    One answer

    27315An error.
12. Question 12 of 12

    Question 12 of 12

    Pandas is a Python library used to work with data tables.

    One answer

    TrueFalse

This test is a guide: it helps you choose your course and does not decide whether you can enrol.