Which of the following tasks can data analysts do using both spreadsheets and SQL? Select all that apply. 1 point Perform arithmetic Join data Use formulas Process huge amounts of data efficiently

To answer the question, we need to identify the tasks that data analysts can do using both spreadsheets and SQL. Let's go through each option one by one:

1. Perform arithmetic: Data analysts can perform arithmetic operations using both spreadsheets and SQL. In spreadsheets, they can use formulas and functions to perform calculations on numerical data. In SQL, they can use mathematical operators and functions to perform arithmetic operations on data stored in databases.

2. Join data: Data analysts can join data using both spreadsheets and SQL. In spreadsheets, they can use functions like VLOOKUP or INDEX-MATCH to combine data from different sheets or tables. In SQL, they can use JOIN statements to combine data from multiple tables based on common columns.

3. Use formulas: Data analysts can use formulas in spreadsheets to perform calculations and manipulate data. However, in SQL, they use queries and functions instead of formulas to retrieve and manipulate data from databases. So, using formulas is not applicable in SQL.

4. Process huge amounts of data efficiently: Both spreadsheets and SQL can handle large amounts of data efficiently. However, SQL is specifically designed for working with databases and can handle massive datasets more efficiently than spreadsheets.

Based on the above analysis, the tasks that data analysts can do using both spreadsheets and SQL are:

• Perform arithmetic
• Join data
• Process huge amounts of data efficiently

Therefore, the correct options are 1, 2, and 4.