Cluster 3 Assessment

What are some advanced features in Microsoft Word that can improve document formatting?

• Shapes, Animations, Transitions

• Font styles, Page numbers, Spell check

• Page layout, Page borders, Page breaks

• Styles, templates, themes, columns, tables, text boxes

How can you create a database in Microsoft Access from scratch?

• Open Excel and import data

• Ask a friend to create it for you

• Use Google Docs instead

• Open Access, select 'Blank Database', choose a location and name, then click 'Create'.

List some common Excel functions used for data analysis.

• AVERAGEIF

• SUMIFS

• VLOOKUP, SUMIF, COUNTIF, AVERAGE, MAX, MIN, CONCATENATE

• IFERROR

Explain the concept of clustering in data analysis.

• Clustering involves partitioning data points into clusters where points in the same cluster are more similar to each other than to points in other clusters.

• Clustering involves merging data points into a single group.

• Clustering is a technique to analyze data by visualizing it in graphs.

• Clustering is a method to sort data alphabetically.

What are the benefits of using macros in Excel?

• Macros in Excel have no impact on efficiency

• Macros in Excel are prone to causing errors

• Macros in Excel provide automation for repetitive tasks, saving time, reducing errors, and increasing efficiency.

• Macros in Excel can only be used for complex tasks

Describe the process of creating a pivot table in Excel.

• Select data range -> Data tab -> PivotTable -> Choose data range -> Place pivot table -> Drag fields to rows/columns -> Drag numerical data to values -> Customize with filters, slicers, formatting

• Select data range -> Insert tab -> PivotTable -> Choose data range -> Place pivot table -> Drag fields to rows/columns -> Drag numerical data to values -> Customize with filters, slicers, formatting

• Copy data -> Insert tab -> PivotTable -> Choose data range -> Place pivot table -> Drag fields to rows/columns -> Drag numerical data to values -> Customize with filters, slicers, formatting

• Highlight data -> Insert tab -> PivotTable -> Choose data range -> Place pivot table -> Drag fields to rows/columns -> Drag numerical data to values -> Customize with filters, slicers, formatting

How can you import data from external sources into Microsoft Access?

• Access does not support importing data from external sources.

• Use the 'External Data' tab on the ribbon in Microsoft Access.

• Use the 'Design' tab on the ribbon in Microsoft Access.

• Manually type the data into Microsoft Access.

What are some key differences between Microsoft Word and Microsoft Excel?

• Microsoft Word is for creating presentations, while Microsoft Excel is for web browsing.

• Microsoft Word is used for data analysis, while Microsoft Excel is used for graphic design.

• Microsoft Word is primarily for coding, while Microsoft Excel is for video editing.

• Microsoft Word is for word processing and creating documents, while Microsoft Excel is for data organization, manipulation, and analysis.

Discuss the importance of data validation in Excel.

• Data validation in Excel is important for maintaining data integrity, reducing errors, and ensuring accurate analysis.

• Data validation in Excel is only important for formatting purposes.

• Data validation in Excel is time-consuming and unnecessary.

• Data validation in Excel can lead to more errors and confusion.

What are some advanced techniques for data visualization in Excel?

• Pivot charts, interactive dashboards with slicers, sparklines, advanced chart types, VBA programming

• Data tables, WordArt, ClipArt