Representation Advanced Quiz 3

1. In R, what does the function bind_rows() do?

2. In spreadsheets, what does the XMATCH function allow you to do?

3. In R, what does the function across() in dplyr do?

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

5. In R, what does the function pivot_longer() combined with mutate() allow you to do?

6. In spreadsheets, what is the advantage of using structured references with Excel tables in combination with dynamic arrays?

7. In R, how does the function reframe() differ from summarise()?

8. In spreadsheets, what does the MAKEARRAY function do?

9. In R, what is the purpose of the function type_convert() in combination with mutate(across())?

10. In spreadsheets, what is the benefit of combining LET and LAMBDA functions?