• 6 hours
  • Easy

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 9/1/22

Manipulate Data in Excel

Evaluated skills

  • Manipulate data in Excel

Description

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

Sales workbook
Sales workbook
  • 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

Ever considered an OpenClassrooms diploma?
  • Up to 100% of your training program funded
  • Flexible start date
  • Career-focused projects
  • Individual mentoring
Find the training program and funding option that suits you best