Spreadsheet Skills for Beginners

Which of the following is a basic spreadsheet function used to add a range of cells?

• AVERAGE

• SUM

• COUNT

• MAX

What is the first step in creating a table in a spreadsheet?

• Entering data into cells

• Applying a filter

• Inserting a chart

• Using conditional formatting

Which formula would you use to calculate the average of cells A1 through A10?

• =SUM(A1:A10)

• =AVERAGE(A1:A10)

• =COUNT(A1:A10)

• =MAX(A1:A10)

How can you sort data in a spreadsheet from highest to lowest?

• Use the 'Sort Ascending' option

• Use the 'Sort Descending' option

• Apply a filter

• Use conditional formatting

Which type of chart is best for showing trends over time?

• Pie Chart

• Bar Chart

• Line Chart

• Scatter Plot

What is the purpose of using the VLOOKUP function in a spreadsheet?

• To calculate the sum of a range

• To find a value in a table based on a lookup value

• To count the number of cells in a range

• To create a chart

Which of the following is a method to filter data in a spreadsheet?

• Use the 'Sort Ascending' option

• Apply a filter

• Insert a chart

• Use conditional formatting

What is the file extension for a standard Excel spreadsheet?

• .docx

• .xlsx

• .pptx

• .txt

Which function would you use to find the largest number in a range of cells?

• MIN

• MAX

• AVERAGE

• SUM

How can you export a spreadsheet to a PDF format?

• Use the 'Save As' option and select PDF

• Use the 'Print' option and select PDF

• Use the 'Export' option and select PDF

• All of the above