ERTC LTD EXAMINATION PLATFORM(DATA PROCESSING)
1. The CPU stores data in the ................?
Control Unit Motherboard Arithmetic & Logic Unit Memory
2. What is Microsoft Excel .........................?
3.What is the name of the area hilighted in green, in the diagram below(choose 2)
Excel Ribbon tabs Excel workbook tabs Excel Worksheet menu tab Excel quick access toolbar Excel ribbon (multiple choice question as part of excel assessment test)
4.To change the background of the colour of selected range A1:E1 user needs to select the range,navigate to home tab and select the colour in fill colour option in font group?
True False
Question 5
5.(1)Type out the above data (2)Sort the names in ascending order (3)Filter for male staff (4)Filter for female staff (5)Apply borders to the work area
Table Data
| S/N | NAME | AGE | SEX | M.STATUS | QUALIFICATION | YEAR EMPLOYED | 1 | Olapade John | 22 | F | SINGLE | B.SC | 1992 |
|---|---|---|---|---|---|---|
| 2 | Olaolu Dare | 24 | M | Married | HND | 1980 | 3 | Titilayo Ojo | 25 | M | Single | HND | 1975 |
| 4 | Maria | 23 | F | Married | B.SC | 1968 |
| 5 | Lara | 24 | M | SINGLE | B.SC | 1996 |
| 6 | Kadijah | 22 | F | Married | HND | 1988 |
| 7 | Kayode | 24 | M | Single | HND | 1986 |
| 8 | Tosin | 21 | F | Single | B.SC | 1985 |
| 9 | Tolulope | 20 | F | Married | OND | 1984 |
| 10 | Imisi | 23 | M | Married | HND | 1991 |
6. Using the document below,type the data and password the document!
COURSE NOTE
CSC 411 An overview of object Oriented Programming In procedural programming, program is divided into small parts called functions. In object oriented programming, program is divided into small parts called objects. Procedural programming follows top down approach. Object oriented programming follows bottom up approach Differences - In procedural programming, program is divided into small parts called functions. - Procedural programming follows top down approach - It relies on procedures or routines - Object-oriented programming (OOP) is about encapsulating data and behavior into objects. - Object oriented programming follows bottom up approach -. In object oriented programming, program is divided into small parts called objects Procedural programming (PP), also known as inline programming takes a top-down approach. It is about writing a list of instructions to tell the computer what to do step by step. It relies on procedures or routines. Object-oriented programming (OOP) is about encapsulating data and behavior into objects. Characteristics of procedure-oriented programming language: • It emphasis on algorithm (doing this). • Large programs are divided into smaller programs known as functions. • Function can communicate by global variable. • Data move freely from one function to another function.Hence, list out the step for passwording a document.
7.The following are examples of spreadsheet except?
Lotus 123
Quattra
Microsoft Excel
Corel Draw
8.Itemize four(4) types of operators used to perform Excel operations.
-----------
-------------
-------------
----------
9.One of the following is a formula used in calculating arithmetic sum in EXCEL
=SUM(A1:E1)
A1:E1
=10%*A1
=Average(A1:E1)
10.An ICON in computer refers to a pictorial diagram, which represents a given application in the system while a folder serves as storage shelve in the computer
True
False
ERTC LTD EXAMINATION PLATFORM(HTML)
1. 1. Set the size of the image to 250 pixels wide and 400 pixels tall.
250 by 400
250 by 150
Arithmetic & Logic Unit
Memory by harddisk
2. Add a "tooltip" to the paragraph below with the text "About W3Schools".
W3Schools is a web developer's site.
3.Make the element below into a link that goes to "https://www.w3schools.com". this is a link