Computer applications 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

A byte contains how many bits?

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

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

__ 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

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

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

Conveys meaning and is useful to one or more people.

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

A(n) __ device is any hardware component that allows you to enter data and instructions into a computer.

1. output
2. input
3. communications
4. terminal

Some people refer to the series of input, process, output and storage activities as the __ processing cycle.

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

A computer contains many electric,electronic and mechanical components known as

1. software
2. output
3. input devices
4. hardware

The __ unit is a case that contains electronic components of the computer that are used to process data.

1. control
2. arithmetic
3. system
4. base