Type '==' followed by the formula in a cell and press Enter.

Type '=' followed by the formula in a cell and press Enter.

Click on the formula bar and select a cell to create a formula.

Use the 'Insert Function' option to create a formula without typing.

+

*

-

=

SUM

COUNT

AVERAGE

MAX

The COUNT function counts all cells in a range regardless of content.

The COUNT function counts numeric values in a range.

The COUNT function averages numeric values in a range.

The COUNT function sums all values in a range.

Type 'SheetName.CellReference' to access the cell.

Reference cells by using 'CellReference@SheetName' format.

Use 'CellReference:SheetName' format.

Use 'SheetName!CellReference' format.

Relative references are used for formulas, while absolute references are used for formatting.

Relative references are fixed and do not change, while absolute references adjust based on the position.

Relative references adjust based on the position, while absolute references do not change.

Both relative and absolute references change based on the position of the cell.

Choose your data, navigate to 'View' > 'Chart Wizard', and select a format.

Select your data, go to 'Insert' > 'Pie Chart', and choose a style.

Select your data, go to 'File' > 'New Chart', and choose a type.

Highlight your data, click on 'Data' > 'Chart Options', and pick a design.

Scatter plot

Pie chart

Bar chart

Line chart

Right-click the chart and select 'Delete' to remove it.

Use the 'Insert' tab to add a new chart type.

Change the color by adjusting the monitor settings.

Select the chart, go to 'Format' tab, and choose a color from 'Shape Fill' or 'Chart Styles'.

To create charts and graphs automatically.

The purpose of the IF function in Excel is to perform conditional logic.

To calculate the sum of a range of cells.

To format text in different colors.

Use the 'Data' tab to create a chart directly.

Select data, go to 'File' tab, and click 'New Chart'.

Right-click on the worksheet and choose 'Insert Chart'.

Select data, go to 'Insert' tab, click 'Bar Chart', and choose a type.

The VLOOKUP function formats cells in a spreadsheet.

The VLOOKUP function deletes rows from a table.

The VLOOKUP function looks up a value in a table and retrieves corresponding data from another column.

The VLOOKUP function calculates the sum of a range of cells.

Double-click the chart title to edit it directly.

Select the chart and press 'Delete' to remove the title.

Use the 'Insert' menu to add a new title to the chart.

Right-click the chart title and select 'Format Chart Title'.

To join text strings together.

To convert text strings to numbers.

To find the length of text strings.

To split text strings apart.

Select your data, go to 'Insert' > 'Scatter', and choose a scatter plot type.

Select your data, go to 'File' > 'New', and create a new workbook.

Highlight your data, then go to 'View' > 'Gridlines', and enable gridlines.

Click on 'Data' > 'Sort', and arrange your data in ascending order.

To count the number of cells in a range.

To find the largest value in a set of numbers or a range of cells.

To calculate the average of a set of numbers.

To find the smallest value in a set of numbers.

Select the chart, go to chart tools, and enable 'Data Labels'.

Click on the chart and choose 'Insert Data'

Right-click the chart and select 'Add Data'

Go to the chart menu and select 'Label Options'

A line chart uses horizontal bars to show categories, while a column chart shows trends over time with connected points.

A line chart shows trends over time with connected points, whereas a column chart compares different categories using vertical bars.

A line chart displays data in a pie format, whereas a column chart uses scatter points to show trends.

A line chart compares different categories using diagonal lines, while a column chart shows trends over time with horizontal bars.

=COUNTIF(range, criteria)

=SUMIF(range, criteria)

=AVERAGEIF(range, criteria, [average_range])

=AVERAGE(range)