Advanced_Spreadsheet_Level2

What is the primary purpose of the Sort function in a spreadsheet?

• To remove duplicate entries

• To arrange data in ascending or descending order

• To delete unnecessary data

• To highlight important values

Which of the following options is NOT a valid sorting order in a spreadsheet?

• Alphabetical (A-Z)

• Reverse Numerical Order (Largest to Smallest)

• Random Order

• Custom Sorting

What does the Filter function in a spreadsheet help with?

• Merging multiple cells

• Hiding specific rows based on criteria

• Changing font styles

• Creating graphs

When filtering numerical data, which of the following conditions can be applied?

• Greater than a specific value

• Less than a specific value

• Equal to a specific value

• All of the above

If you want to sort bank customers by their account balance in descending order, which option should you select?

• Sort A-Z

• Sort Z-A

• Sort Smallest to Largest

• Sort Largest to Smallest

What does the PMT function in a spreadsheet calculate?

• The total loan amount

• The monthly payment required for a loan

• The total interest paid on a loan

• The future value of an investment

Given a loan amount of ₹50,000, a 5% annual interest rate, and a 5-year loan period, how many monthly payments will be made?

• 5

• 12

• 60

• 50

Which formula is correct for calculating the monthly payment using the PMT function?

• =PMT(5%, 5, -50000, 0, 0)

• =PMT(5%/12, 60, -50000, 0, 0)

• =PMT(5%, 60, 50000, 0, 0)

• =PMT(0.05, 5, -50000, 0, 0)

If the interest rate is 5% per year, what is the equivalent monthly interest rate?

• 5%

• 0.5%

• 0.4167%

• 1%

If a loan is repaid in monthly installments at the end of each month, which payment type should be used in the PMT function?

• 0

• 1

• -1

• None of the above