Quiz Spreadsheet

What is the main function of a spreadsheet?

• Word processor

• Data and number processor

• Presentation maker

• Image processor

What is the standard file extension for Microsoft Excel spreadsheets?

• .doc

• .ppt

• .xls or .xlsx

• .txt

What formula is used to sum values in cells A1 to A10?

• =AVG(A1:A10)

• =COUNT(A1:A10)

• =SUM(A1:A10)

• =MAX(A1:A10)

What function is used to find the average value?

• SUM

• AVERAGE

• COUNT

• MAX

What is meant by 'cell' in a spreadsheet?

• Row

• Column

• Intersection of row and column

• Worksheet

How do you lock a cell so it doesn't change when the formula is copied?

• Using the percent sign (%)

• Using the dollar sign ($)

• Using the asterisk (*)

• Using the hash sign (#)

What function is used to find the highest value in a range?

• MIN

• AVERAGE

• MAX

• COUNT

What is the function of the 'Filter' feature in a spreadsheet?

• Sum data

• Sort data

• Filter data based on criteria

• Create charts

How do you create a chart from data in a spreadsheet?

• Using the SUM function

• Using the 'Insert Chart' feature

• Using the 'Filter' feature

• Using the AVERAGE function

What is meant by 'formula' in a spreadsheet?

• Plain text

• Command to perform calculations

• Cell name

• Display format