Practice Problems on Ms Excel : Average Sum Forumlae and Condtional Formating


You are being provided with an excel files “Task 01.xlsx”. This file must be downloaded and SAVED on your machine from the lms. Your task is to fill YELLOW color cells in the “Task 01.xlsx” file with meaningful formulas so that the appropriate value is displayed in the cell.


TASK 02 [15 Marks]
You are being provided with an excel files “Task 02.xlsx”. This file must be downloaded and SAVED on your machine from the lms. Your task is to fill YELLOW color cells in the “Task 02.xlsx” file with meaningful formulas so that the appropriate value is displayed in the cell.

TASK 03 [35 Marks]
You are being provided with a excel files “Task 03.xlsx”. This file must be downloaded and SAVED on your machine from the lms. Your task is to fill YELLOW color cells in the “Task 03.xlsx” file with meaningful formulas so that the appropriate value is displayed in the cell.

 

TASK 04 [35 Marks]
You are being provided with an excel files “Task 04.xlsx”. This file must be downloaded and SAVED on your machine from the lms. Your Task in this File are:
1. Condintional Formatting of Percent Columns Cells same as given bellow: [5 Marks]
2. Fill the Pass/Fail Column Cell using Excel Function then Format it using conditional Formatting same as given bellow: [10 Marks]
NOTE: Passing Percent is greater than equal to 70 %
3. Fill the Grade Column Cell with Excel Function. [10 Marks]





4.Insert a Bar Chart and Pie Chart same as given bellow: [10 Marks]
 Output Screen of Task 4

 

************** Best of Luck **************







BioJava?

BioJava is highly complicated simulation software dedicated to providing Java tools for processing biological data. It is an open source project including objects for manipulating sequences, file parsers, dynamic programming, and simple statistical routines. It is meant for simplifying operations and functionalities performed by bio-informatics students, teachers, researchers and professionals.


You Will Learn How To
  • Became a good and professional programmer.
  • Implement the biological computation problems.
  • Professional Programming in JAVA language.
  • Use an Opensourse code and library (Biojava).
  • Develop a Bioinformatics Tool.

Prerequisites:

  • Basics of C++ programming language
Subscribe to: Posts (Atom)