1. __________can be added to pivot tables that acts like a filter.
a. slicer
B. value
c. sort
d. query
2. ___________function calculates the payment on the principal, during a specific period of a loan or investment that is paid in constant periodic payments ,with constant interest rate.
a. ppmt()
B. ipmt()
c. pmt()
d. pv()
3. What will be out put of =Floor(1,567,0.01)
a. 2
B. 1.57
c. 1.56
d. 1
4. In a students’ database table, _____________ field can be the primary key
a. name
B. phone number
c. roll number
d. address
5. At ________________tier ,the database resides along with query processing langauges