Loading...
Quarter 3 Long Quiz MICROSOFT EXCEL Part 2
Quiz by Lezly Ramiro
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Suppose you loan money to a bank amounting P100,000.00 and you have to pay this amount in 20 years with an interest rate of 3%. The monthly payment will be _______________.
The example, =IF(A1>100,”Greater than 100”, “Less than 100”). Which of the arguments is the logical test?
Formula always begins with this sign followed by a cell address, operators and numbers needed.
The “A” in A11 is called as the _____________.
A.
In adding the data entered in rows 2 to 11 in column A. The formula would be _______.
=NOW() displays ___________
___________ is one of the functions of MS Excel.
=IF(A1>70, “Passed”, IF(A1=75, “FAIR”, “Failed”)). If the value is 71, what will be displayed?
What is the cell address of the active cell?
How many columns are displayed on the illustration?
What is this icon?
Choose the letter with the correct format or command.
Choose the letter with the correct format or command.
Choose the letter with the correct format or command.
Choose the letter with the correct format or command.
The Date Function requires _______ integer arguments.
Which of the following is NOT an Excel Function?
It is very useful for testing a cell and making decisions based on cell content.
If you are applying a(an) absolute reference you include ________________.
What is the average of these entries: 78,89,90,80,83?