Excel quiz 4th week

The function for arithmetic mean in Excel is

• =Sum

• =Average

• =Median

• =Mode

Removing duplicates when cleaning dataset helps to retain data integrity

• True

• False

• Maybe

• None of the above

Which of the following show data as vertical bars

• Scatter plot

• Pie chart

• Vertical chart

• Column chart

The '=COUNT' function is used for

• Counting blanks in a range

• Counting cells with both texts and numbers

• Counting the cells which contain numbers only

• Counting cells with only text

The function that is used for joining two or more text strings is

• =CONCATENATE

• =JOIN

• =ADD

• =PLUS

The type of chart that shows trend over time is

• Pie chart

• Bar chart

• Line chart

• Histogram

The best chart for highlighting proportions and percentages is

• Scatter plot

• Map

• Pie chart

• Line chart

The graphical representation of different pieces of information or data, using visual elements such as charts, graphs, or maps is referred to as

• Data wrangling

• Data cleaning

• Data validation

• Data visualization

What is the purpose of data visualization in Excel?

• Data visualization provides a quick and effective way to communicate information in a universal manner using visual information.

• Data visualization provides a platform for data analyst to showcase their skills

• Data visualization provides information on the stakeholders of the business

• Data visualization allows data to be summarised in Pivot table

Which tab of the ribbon should you go to for removing gridlines on a worksheet?

• Formulas

• View

• Review

• Developer