Spreadsheet Application Quiz

What is the primary function of spreadsheet applications?

• To browse the internet

• To create presentations

• To process numerical data

• To edit images

Which of the following is NOT a type of data that can be processed in a spreadsheet?

• Text data

• Numeric data

• Image data

• Date and time data

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

• To create charts

• To search for a value in a table

• To format cells

• To sum a range of numbers

What is the purpose of the VLOOKUP function in Excel?

• To find values in a vertical table

• To format cells

• To calculate the average of a range

• To create a pie chart

Which function is used to calculate the total payment for a loan in Excel?

• COUNT

• PMT

• AVERAGE

• SUM