
Quarter 3 Long Quiz MICROSOFT EXCEL
Quiz by Lezly Ramiro
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Which among the two equations was correctly computed?
Which of the following is arranged in subsequent order?
To enter a formula using the mouse pointer, the first step to be done is _____________.
A ________________ goes around the selected cell. Its cell reference will be entered into the active cell and in the formula bar.
It identifies a cell or range on a worksheet and tells MS Excel where to look for the values or data.
This stores the exact location of the cells to which the formula refers while taking careful note of where those cells are located.
To copy the formula automatically without typing is to use the _________.
This allows you to quickly total a range of cells together.
_____________ means that when a formula is copied, the cell reference remains constant.
Which of the following options is correct in solving for the total of a certain range of cells?
The symbol used for autosum is ______________.
These are built-in formulas that perform special calculations automatically.
Which of the following is NOT TRUE about functions?
If you were adding the cells B5,C5D5,E5 and F5 the formula would read as ___________
The sum function is frequently used, Excel provides the autosum button on the ___________ toolbar.
It gets the average of the values in range.
To use the average function, use the _____________ function, you must select the cell where you want the result to appear
A statistical function that indicates the lowest value in a range
A function that returns the number between the middle of a set of the given numbers.
The date function requires three arguments such as ___________________.
NOW command gives you the _________________.
It is the interest per period and payments per month
Suppose you save P200.00 a month for 3 years with an interest rate of 5%, you will have _____________ at the end of the period.
It is the payment made each period
It is the present or lump-sum amount that a series of future payment is worth right now.
The ____________ function allows you to compute the periodic payment amount for a loan on a car, house or any other item.
It is a powerful worksheet that enables you to add decision-making and logical preference.
The value or expression that can be evaluated to TRUE or FALSE.
The correct syntax for logical function is ________________.
___________________ generally, deal with the time value of interest rate and number of payment loans.