Excel 2019 Certification

What is the function used to sum a range of cells in Excel?

• MERGE

• SUM

• ADD

• TOTAL

How can you create a pie chart in Excel?

• Click on the Home tab, select Pie Chart from the dropdown menu

• Use the Paint tool to draw a pie chart manually

• Select data, go to Insert tab, click on Pie Chart, choose style

• Copy and paste a pie chart image from the internet

What is the purpose of a PivotTable in Excel?

• The purpose of a PivotTable in Excel is to create animations

• The purpose of a PivotTable in Excel is to format text

• The purpose of a PivotTable in Excel is to play music

• The purpose of a PivotTable in Excel is to summarize and analyze data.

Explain the concept of conditional formatting in Excel.

• Conditional formatting in Excel is only available in the online version

• Conditional formatting in Excel enables users to format cells based on specified conditions, making it easier to identify trends, outliers, and important data points within a dataset.

• Conditional formatting in Excel is used for creating pivot tables

• Conditional formatting in Excel is used for spell-checking

What formula would you use to find the average of a range of cells in Excel?

• =SUM(range)

• =MIN(range)

• =AVERAGE(range)

• =MAX(range)

Describe the difference between a line chart and a bar chart in Excel.

• The difference between a line chart and a bar chart in Excel is that a line chart shows trends over time with connected data points, while a bar chart uses bars to represent data values for easy comparison.

• A line chart displays data horizontally, while a bar chart displays data vertically.

• A line chart is used for qualitative data, while a bar chart is used for quantitative data.

• A line chart uses bars to represent data values, while a bar chart shows trends over time with connected data points.

How can you apply conditional formatting to highlight cells that contain specific text?

• You can apply conditional formatting to highlight cells that contain specific text by selecting the range, going to Conditional Formatting > Highlight Cells Rules > Text that Contains, entering the text, choosing the format, and confirming.

• Highlighting cells with specific text can be done by merging cells

• Conditional formatting for specific text involves deleting the cells

• You can apply conditional formatting by changing the font color of the text

What function would you use to find the maximum value in a range of cells in Excel?

• MIN

• SUM

• AVERAGE

• MAX

What is the benefit of using VLOOKUP function in Excel?

• It helps in formatting cells in Excel.

• It helps in searching and retrieving specific data from tables in Excel.

• It assists in generating random numbers in Excel.

• It allows users to create pivot tables in Excel.

Explain the process of creating a clustered column chart in Excel.

• Select data -> Insert tab -> Column Chart -> Clustered Column

• Insert tab -> Clustered Column -> Select data -> Column Chart

• Highlight data -> Insert tab -> Column Chart -> Clustered Column

• Select data -> Format tab -> Column Chart -> Clustered Column