Excel Certification Challenge

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

• SUM

• ADD

• TOTAL

• MERGE

How can you create a pie chart in Excel?

• Manually input each data point and draw the chart with a pencil

• Click on the Line Chart option

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

• Use the Paint tool to draw a pie chart

What is the purpose of conditional formatting in Excel?

• To change the font style

• To insert new rows and columns

• To calculate formulas automatically

• The purpose of conditional formatting in Excel is to visually highlight important data based on specified conditions.

Which function is used to find the highest value in a range of cells?

• MIN

• MAX

• AVERAGE

• SUM

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

• The main difference is in how the data is visually represented: lines for line charts and bars for bar charts.

• The background color of the chart

• The font size of the labels

• The color scheme used

How can you apply a custom formula to a cell in Excel?

• Whisper the formula to your computer's microphone

• Write the formula on a piece of paper and scan it into Excel

• Click on the cell, then shake your device to apply the formula

• Select the cell, type the formula in the formula bar, and press Enter.

What is the significance of using absolute references in Excel formulas?
Example: $H$4

• Absolute references are only used for text formatting

• Absolute references slow down Excel performance

• Absolute references make formulas more complex

• Absolute references prevent cell references from changing when the formula is copied.

Explain the steps to create a line chart in Excel.

• Use the Filter function

• Select the Scatter plot type

• Select data -> Insert tab -> Line in Charts group -> Choose line chart type

• Click on the File tab

How would you use the SUM function in Excel?

• When you want to calculate the average of a range of cells

• When you need to add up a range of numbers in a worksheet

• When you need to search for a value in a table and return a corresponding value from another column.

• When you want to change the font color of a cell

How can you apply a custom number format to cells in Excel?

• Manually format each cell individually

• Use a predefined number format from the dropdown menu

• Write a VBA script to apply the custom format

• Select the range of cells, go to Format Cells > Number tab > Custom category, enter the custom format code, then click OK