Spreadsheet Functions and Formatting Quiz y9

What is the function of a spreadsheet?

• Play music

• create an interesting presentation

• Write a letter

• Organize, analyze, and store data in a tabular format

How can you format cells to display currency in a spreadsheet?

• Choose the 'Currency' format from the 'Number' menu in the 'Format' options.

• Apply the 'Italic' format from the 'Alignment' options

• Select the 'Date' format from the 'Format' menu

• Use the 'Bold' option in the 'Font' menu

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

• =MEDIAN(range)

• =MAX(range)-MIN(range)

• =SUM(range)/COUNT(range)

• =AVERAGE(range)

What is the purpose of data analysis in spreadsheets?

• To make decisions based on random guesses

• To create chaos and confusion

• To organize, interpret, and visualize data to make informed decisions.

• To waste time and effort without any purpose

How can you create a pie chart in a spreadsheet?

• Using the 'Format' menu to create a pie chart

• Selecting the data and using the 'Insert' or 'Chart' menu to choose 'Pie Chart'

• Typing 'Pie Chart' in the search bar

• Right-clicking on the data and selecting 'Pie Chart'

What is the function of the SUM function in spreadsheets?

• To add up a range of numbers

• To subtract a range of numbers

• To multiply a range of numbers

• To find the average of a range of numbers

How can you apply conditional formatting to a range of cells in a spreadsheet?

• Select the range, go to 'Format' menu, choose 'Conditional formatting'

• Use the shortcut Ctrl + C to apply conditional formatting to the range

• Type 'Conditional formatting' in the search bar and click on the first result

• Right-click on the range and choose 'Conditional formatting'

What is the difference between a line chart and a bar chart in spreadsheets?

• The line chart represents data with a continuous line, while the bar chart represents data with separate bars.

• The line chart is used for qualitative data, while the bar chart is used for quantitative data.

• The line chart represents data with separate bars, while the bar chart represents data with a continuous line.

• The line chart and bar chart are the same and can be used interchangeably.

Which symbol would we use in the formula to work out the total price of an item?

• X

• +

• *

• ^

To work out the profit we would use which of the following formulas?

A1= Total Price of items sold (Revenue)

B1= Total cost to buy the items

• =A1-B1

• =B1-A1

• =Sum(A1+B1)

• =A1/B1