Excel Mastery

TOTAL

ADD

SUM

MERGE

Use the AVERAGE function in Excel.

Manually calculate the sum and divide by the number of cells.

Apply the MAX function in Excel.

Use the SUM function in Excel.

Relative cell references do not adjust based on their new position

Absolute cell references change their location when copied or moved

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

Absolute cell references do not change their location when copied or moved, while relative cell references adjust based on their new position.

To calculate the sum of a range of cells

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

To change the font style of a cell

To insert a new row in a worksheet

Manually input data into cells

Use the Paintbrush tool

Select data range, go to Insert tab, click on PivotTable, choose data range, place pivot table, drag and drop fields

Click on Format tab

Line chart

Bar chart

Scatter plot

Pie chart

Data validation in Excel is only important for aesthetic purposes.

Data validation in Excel has no impact on data accuracy.

Data validation in Excel slows down data processing.

Data validation in Excel is crucial for maintaining data accuracy, consistency, and integrity by enforcing specific criteria for the data entered into cells.

Change the font color of the cells

Use conditional formatting in Excel

Use Excel formulas to manually highlight cells

Apply borders to the cells

To insert images into cells

To calculate complex mathematical formulas

To change the font style of text

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

Click on the Format tab

Select the Line Chart option

Select data, go to Insert tab, click on Bar Chart, choose desired style

Use the Paint Bucket tool