WorksheetsMS Excel
Total questions: 15
Worksheet time: 8mins
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.
How can you change the chart type in Excel?
Open a new Excel file to change chart type
Right-click on the chart and select 'Change Type'
Press Ctrl + C to change chart type
Select chart -> Go to 'Design' tab -> Click 'Change Chart Type' -> Choose desired chart type
What is the purpose of the CONCATENATE function in Excel?
To create pivot tables
To combine multiple strings or cell values into one single string.
To calculate mathematical operations
To format cells based on specific conditions
Explain the difference between a line chart and a scatter plot.
A line chart connects data points with a line, while a scatter plot shows individual data points without connecting them.
A line chart displays data in 3D, while a scatter plot is limited to 2D.
A line chart is used for qualitative data, while a scatter plot is used for quantitative data.
A scatter plot connects data points with a line, while a line chart shows individual data points without connecting them.
How can you create a pivot table in Excel?
Right-click on data range, select Create PivotTable, choose data range, drag and drop fields
Go to Data tab, click on PivotTable, select data range, drag and drop fields
Use the Formula tab, click on PivotTable, choose data range, drag and drop fields
Select data range, go to Insert tab, click on PivotTable, choose data range, place pivot table, drag and drop fields
What is the function of the AVERAGE function in Excel?
Sorts a range of numbers in ascending order
Finds the maximum value in a range
Multiplies a range of numbers
Calculates the arithmetic mean of a range of numbers.
