Representation Advanced Quiz 1

1. In R, what does the function pivot_wider() from tidyr do?

2. In spreadsheets, what is the difference between an array formula and a standard formula?

3. In R, what is the purpose of the function unnest() in tidyr?

4. In spreadsheets, what is the purpose of the INDIRECT function?

5. In R, what does the function map() from purrr do?

6. In spreadsheets, what does the LET function allow you to do?

7. In R, what does the function nest() in tidyr do?

8. In spreadsheets, how does the XLOOKUP function improve upon VLOOKUP?

9. In R, what is the purpose of the function recode_factor()?

10. In spreadsheets, what is the purpose of dynamic arrays?