DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If sales are larger than $5, 000 the salesperson receives a bonus of 10 percent of total sales; otherwise the salesperson receives a 2 percent bonus of sales. Which of the following formulas reflect this logical statement?
|
|
=IF(sales<5000, sales*2%, sales*10%)
|
|
|
=IF(sales<5000, sales*10%, sales*2%)
|
|
|
=IF(sales>5000, sales*2%, sales*10%)
|
|
|
=IF(sales>5000, sales*10%, sales*2%)
|
Explanation:
Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-2: -Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want.
Detailed explanation-3: -Answer: Option a-Currency is the number format used to apply to the cell showing the total sales for the month. Explanation: Numbers must be formatted as currency in order to be displayed as monetary values.
There is 1 question to complete.