computer Applications Quiz

1. What function is used to find the average of a range of values?

• SUM

• MEDIAN

• AVERAGE

• COUNT

2 The formula =A1+B1 is an example of which operator?

• Multiplication

• Addition

• Division

• Logical

3 What does the PMT function calculate?

• Loan interest

• Monthly Payment

• Future Value

• Profit

4. What is the shortcut for Flash Fill in Excel?

• Ctrl + F

• Ctrl + E

• Ctrl + D

• Ctrl + C

5. Which formula is used to lookup data vertically in a table?

• HLOOKUP

• VLOOKUP

• MATCH

• INDEX

6. What does the IFERROR function do?

• Shows Error

• Ignores Error

• Returns a value if there’s an error

• Displays Error Message

7. What type of chart is best for showing trends over time?

• Pie Chart

• Column Chart

• Line Chart

• Bar Chart

8. Which function returns the remainder after division?

• MOD

• ROUND

• ABS

• POWER

9. What is the purpose of Mail Merge?

• Printing Documents

• Creating Spreadsheets

• Merging Text with Data

• Encrypting Files

10. What type of file is commonly used as the Data Source?

• PDF

• Excel

• Image

• Video