Spreadsheet Skills

Noah is working on his spreadsheet for a school project. Which function should he use to calculate the average of a range of cells?

• SUM

• AVERAGE

• MEDIAN

• COUNT

Ella is creating a budget spreadsheet. What is the purpose of data validation in her spreadsheet?

• To format cells based on conditions

• To restrict the type of data that can be entered in a cell

• To create charts and graphs

• To sort and filter data

James is working on a spreadsheet. Which of the following is an example of conditional formatting?

• Changing the font size

• Applying a colour scale to cells based on their values

• Inserting a new row

• Merging cells

Harry is tracking his monthly expenses over the year. What type of chart would be most suitable for showing the trend of his expenses over time?

• Pie Chart

• Bar Chart

• Line Chart

• Scatter Plot

Poppy is working on a spreadsheet and needs to add up the number of cells that contain numbers in a range. Which function should she use?

• SUM

• COUNT

• ADD UP

• AVERAGE

Aarav is creating a spreadsheet to track project deadlines. How can he ensure that a cell only accepts dates within a specific range?

• Use a formula

• Apply conditional formatting

• Use data validation

• Sort the data

Harry is organizing a list of his favorite books in a spreadsheet. What does Sorting do in a spreadsheet?

• Changes the order of the selected values so they are organised largest to smallest or in alphabetical order

• Looks up a value in a horizontal row

• Counts the number of cells in a range

• Sums the values in a range

During a class project, Sebastian and Emily were asked to create different types of charts using spreadsheet software. Which of the following is NOT a type of chart available in most spreadsheet software?

• Histogram

• Pie Chart

• Bubble Chart

• Flow Chart

Chloe is working on a spreadsheet to track her monthly expenses. What function should she use to perform a logical test and return one value for TRUE and another for FALSE?

• To perform a logical test and return one value for TRUE and another for FALSE

• To sum a range of cells

• To find the maximum value in a range

• To count the number of blank cells

Scarlett wants to highlight cells in her spreadsheet that contain values greater than 100. How can she do this?

• Use a filter

• Apply conditional formatting

• Sort the data

• Use the SUM function