FUNDAMENTAL QUIZ 7

What is the purpose of the 'GET & TRANSFORM DATA' function in Excel?

• To proofread the document

• To import or connect external data and modify it

• To draw and write directly on the worksheet

• To organize data in the workbook

What are queries and connections used for in Excel?

• Sorting and filtering data

• Creating formulas

• Importing data from different workbooks and building internal relationships

• Formatting data

What is the purpose of the 'SORT & FILTER' project in Excel?

• To organize data efficiently and navigate the workbook with ease

• To automate tasks

• To predict data trends

• To protect the document

What does the 'DATA TOOLS' project help with in Excel?

• Drawing and writing on the worksheet

• Organizing data

• Predicting data trends and grouping data

• Proofreading the document

What is the focus of the 'PROOFING' tab in Excel?

• Proofreading tasks like spelling and grammar checks

• Data analysis results

• Accessibility considerations

• Drawing and writing on the worksheet

What does the 'ACCESSIBILITY' tab emphasize in Excel?

• Accessibility considerations like alt text for images

• Data analysis

• Proofreading tasks

• Automating tasks

What does the 'INSIGHTS' tab in Excel present?

• Data analysis results and trends

• Proofreading tasks

• Drawing and writing on the worksheet

• Language-related settings

What is the purpose of the 'LANGUAGE' tab in Excel?

• Automating tasks

• Proofreading tasks

• Language-related settings and tools

• Data analysis

What does the 'COMMENTS' tab facilitate in Excel?

• Comment management

• Data analysis

• Proofreading tasks

• Drawing and writing on the worksheet

What does the 'PROTECT' tab deal with in Excel?

• Data analysis

• Document protection measures

• Automating tasks

• Proofreading tasks