MS Excel

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

• ADD

• MERGE

• SUM

• TOTAL

How can you insert a new column in Excel?

• Drag and drop the column to a new location

• Press the 'Delete' key on the keyboard

• Right-click on the column letter and select 'Insert'

• Use the 'Copy' function and paste it as a new column

Explain the difference between absolute and relative cell references in Excel formulas.

• Absolute cell references are used for text, while relative cell references are used for numbers

• Absolute cell references do not change, while relative cell references adjust based on the formula cell's position.

• Absolute cell references adjust based on the formula cell's position

• Relative cell references do not change

What type of chart is best suited for showing trends over time?

• Bar chart

• Pie chart

• Scatter plot

• Line chart

How can you create a pie chart in Excel?

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

• Navigate to View tab, click on Insert, select Pie Chart

• Right-click on data, go to Format, click on Pie Chart

• Click on the Home tab, select data, choose Pie Chart

What is the purpose of the VLOOKUP function in Excel?

• To calculate the sum of a range of cells

• To change the font style of a cell

• To insert a new row in a worksheet

• To search for a value in a table and return a corresponding value from another column.

Explain the difference between a bar chart and a column chart.

• Bar chart is used for qualitative data, column chart is used for quantitative data.

• Bar chart has vertical bars, column chart has horizontal bars.

• Bar chart has horizontal bars, column chart has vertical bars.

• Bar chart is always stacked, column chart is never stacked.

How can you add error bars to a chart in Excel?

• Select chart -> Click Chart Elements -> Check Error Bars -> Customize options

• Right-click on chart -> Add Error Bars

• Use a separate error bar chart and overlay it on the main chart

• Go to Insert tab -> Error Bars

What function can be used to count the number of cells that contain numbers in a range?

• AVERAGE

• COUNT

• MAX

• SUM

What is the function of the IF statement in Excel?

• To insert images into cells

• To change the font style of text

• To calculate mathematical operations

• To perform a logical test and return different values based on the result.