WorksheetsMastering Excel: Formatting and Functions
Total questions: 15
Worksheet time: 8mins
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'.
What steps do you take to format a cell as currency?
Select the cell, right-click, choose 'Format Cells', select 'Currency', and click 'OK'.
Select the cell, go to 'Home', and change the font color to green.
Right-click the cell, choose 'Copy', and paste it in a new cell.
Select the cell, click 'Delete', and then type the currency symbol.
How can you round a number to two decimal places in Excel?
Use the CEILING function: =CEILING(number, 0.01)
Use the TRUNC function: =TRUNC(number, 2)
Use the ROUND function: =ROUND(number, 2)
Format the cell as currency without using a formula
How do you create a pie chart in Excel?
Select your data, go to the 'File' tab, and click 'New Chart'.
Highlight your data, right-click, and choose 'Insert Chart'.
Select your data, go to the 'Insert' tab, click 'Pie Chart', and choose a style.
Go to the 'View' tab, click 'Chart Options', and select 'Pie' from the dropdown.
What is the shortcut to quickly sum a column of numbers in Excel?
Press Alt + =
Press Shift + +
Press Ctrl + S
Press Alt + F4
What is the difference between relative and absolute cell references?
Both relative and absolute references are the same and do not affect calculations.
Absolute references adjust based on the position; relative references do not change.
Relative references are always fixed; absolute references change based on position.
Relative references adjust based on the position; absolute references do not change.
