Manipulate Data in Excel

Description

All questions in this quiz will be based on the sales workbook below:

Question 1
You want to calculate the “Total” in the workbook. How do you write the function in cell E9?
- =SUM(E2:E8)
- =SUM(E2+E8)
- =SUM(E2 to E8)
Question 2
For cells F2 to F8, you want to display a bonus of $500 if the sales figure is greater than $10,000, and a bonus of $100 if it’s lower. How would you do this?
- Manually input the bonuses in the relevant cells.
- Insert an IF function in cells F2 to F8 and complete the arguments.
- Input 500 in F2 and copy/paste this value into the relevant cells. Then input 100 into cell F6, then copy/paste this value into the relevant cells.
Question 3
In F2, what result will be displayed if you entered the following formula: =IF(E2<10000,100,500)?
- TRUE
- FALSE
- 500
- 100