Mastering Excel: Formatting and Functions

What is cell formatting in Excel?

• Data entry only.

• Changing the appearance of cells, like adding borders or background colours.

• The process of deleting cells.

• Only applies to charts.

How can you change the font color of a cell?

• Double-click the cell and type the color name.

• Use the keyboard shortcut Ctrl + C to copy the color.

• Select the cell, click the font color icon, and choose a color.

• Right-click the cell and select 'Change Color' from the menu.

What is conditional formatting and how is it used?

• A method to create new spreadsheets from scratch.

• Used to delete cells that do not meet certain criteria.

• A feature that only works in word processing software.

• Used to change the appearance of cells based on a test, such as highlighting cells that are over 5.

How do you apply a conditional formatting rule to highlight cells?

• Select cells, go to 'File' > 'Save As', choose format, click 'Save'.

• Select cells, go to 'View' > 'Zoom', adjust the zoom level, and click 'OK'.

• Right-click on cells, select 'Delete', then confirm the action.

• Select cells, go to 'Home' > 'Conditional Formatting' > 'New Rule', choose type, set format, click 'OK'.

What types of charts can you create in Excel?

• Network diagram

• Column, Bar, Line, Pie, Scatter, Area, Doughnut, Radar, Combo, Surface, Treemap, Histogram, Box and Whisker charts.

• Gantt chart

• Flowchart

How do you insert a chart in an Excel worksheet?

• Drag and drop a chart from the desktop

• Right-click and select 'Add Chart'

• Select data, go to 'Insert' tab, choose chart type.

• Use the 'File' menu to insert a chart

What is the purpose of the SUM function in Excel?

• To calculate the average of a range of numbers in Excel.

• To add a range of numbers in Excel.

• To find the maximum value in a range of numbers in Excel.

• To count the number of cells in a range that contain text in Excel.

How do you write a basic formula in Excel?

• Start with '->' followed by the formula in a cell.

• Enter the formula directly without any symbols.

• Use '!' to indicate the beginning of a formula.

• Type '=' followed by the formula in a cell, e.g. =A1+A2.

What is the formula to calculate the average of a range of cells?

• =MEDIAN(range)

• =SUM(range)

• =AVERAGE(range)

• =COUNT(range)

How do you display a number as a percentage in Excel?

• Select the cell, right-click, choose 'Format Cells', select 'Percentage', and click 'OK'.

• Right-click the cell, select 'Copy', and paste it as a picture.

• Select the cell, click 'Insert', and choose 'Chart'.

• Highlight the cell, go to 'Data', and click 'Sort'.