Computer applications UE Past Papers Questions.

Carefully study an excel sheet below, which describes the performance of 5 students who sat for 5 tests.

Answer the questions below:

1. The address of an active cell is displayed in ___
2. The contents of the active cell is displayed in __
3. How many worksheets are there by default in the excel workbook?
4. Write the formula to calculate the sum of Test 5 in cell G6
5. Write the formula to calculate the total score of Jaffary`s test
6. Write the formula to count the total number of students who sat for test 1 in J2
7. In cell D8, write the formula to compute an average of Johnson`s test results
8. In cell H2, write the formula to compute average of Test 1 results
9. In cell H8, write the formula to compute the overall average performance of all students for all tests
10. In B10, write a general formula to add 10 bonus points to every student who`s average is greater than or equal to 70 otherwise add 5 points.
11. In cell J4, write the formula to count the number of tests that all students sat for .
12. In cell F9, write the formula to give remarks to Julius`s performance under the following conditions: Exellent -when the total score is greater than 350 otherwise Satisfactory.
13. Write the general formula to assign grades to students average under the following criteria: A:70-100, B:60-69, C:50-59,D:40-49, otherwise F
14. Write a formula to find the maximum average score for each student average score in cell I8

Answer / Solution

A byte contains how many bits?

1. 4
2. 8
3. 6
4. 2

Answer / Solution

This invention helped make computers much smaller and faster. What is it called?

1. vacuum tube
2. central processing unit
3. random access memory
4. integrated circuit

Answer / Solution

__ is an electronic device, operating under the control of instructions stored in its own memory, that can accept data, process the data according to specified rules, produce results, and store the results for future use.

1. input device
2. output device
3. computer
4. both A abd B

Answer / Solution

__ is a collection of unprocessed items, which can include text, numbers, images, audio and video.

1. data
2. information
3. output
4. input

Answer / Solution