Programming Examples

In a spreadsheet, create a table with the following data for monthly sales


In a spreadsheet, create a table with the following data for monthly sales (in Rs.):

MonthSales (in Rs.)
January6000
February4500
March7000
April3200
May5200

Use conditional formatting to:

  1. Color cells green if sales are greater than 5000.
  2. Color cells yellow if sales are between 3000 and 5000.
  3. Color cells red if sales are below 3000.
Output/ Explanation:

Latest Current Affairs 2025 Online Exam Quiz for One day Exam Online Typing Test CCC Online Test Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Online MBA 2 years Online MCA Online BCA Best Website and Software Company in Allahabad