.xlsx

.xls

.txt

.csv

COUNT

MAX

AVERAGE

SUM

1, 2, 3, ....

A, B, C, ....

A1, B1, C1, ....

I, II, III, ....

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

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

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

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

The purpose of conditional formatting in Excel is to visually enhance data by applying formatting based on specific conditions.

To create charts automatically based on data trends.

To protect data from being edited by users.

To sort data in ascending or descending order.

Select the data range, go to the 'Home' tab, click 'Format', then choose 'Align' options.

Select the data range, go to the 'Data' tab, click 'Sort', choose the column and order, then click 'OK'.

Highlight the data, then press 'Ctrl + Z' to undo any changes.

Right-click the data range and select 'Delete' to remove duplicates.

MAXIF

AVERAGEIF

SUMIF

COUNTIF

Pie chart

Scatter plot

Bar chart

Line chart

Select the cells, go to Data > Sort > Ascending > Apply changes.

Right-click the cells, choose Format Cells > Number > Set decimal places.

Select the cells, go to Home > Font > Change color to red.

Select the cells, go to Conditional Formatting > New Rule > Format cells that contain > Greater than > Enter value > Choose format > OK.

Data validation allows users to change cell colors based on values.

Data validation is a feature in Excel that restricts the type of data or values that can be entered in a cell.

Data validation is used to automatically generate formulas in Excel.

Data validation is a method for creating charts in Excel.

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

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

Highlight your data, then right-click and select 'Create Graph' from the menu.

Choose 'Data' > 'Chart Wizard' and follow the prompts.

Relative references are used for formatting; absolute references are for calculations.

Relative references are fixed and do not change; absolute references adjust based on position.

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

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

Copy and paste a list into the cell to create a dropdown.

Insert a table to generate a dropdown list.

Use Data Validation to create a dropdown list in a cell.

Use conditional formatting to create a dropdown list.

Select the cell, go to 'Home' > 'Format' > 'Freeze Panes' option.

Select the cell, go to 'File' > 'Save As' > 'Freeze Panes'.

Right-click the cell and choose 'Freeze Panes' from the context menu.

Select the cell, go to 'View' > 'Freeze Panes' > 'Freeze Panes'.

Ctrl + 1

Ctrl + Shift + C

Shift + 1

Alt + F1

Use the 'Remove Duplicates' feature in the 'Data' tab.

Manually delete each duplicate entry.

Use the 'Sort' feature in the 'Data' tab.

Copy the data to a new sheet and remove duplicates there.

Ctrl + S

Ctrl + P

Ctrl + C

Ctrl + V

By typing @

By typing #

By typing +

By typing =

MIN()

AVERAGE()

MAX()

LARGE()