IMTECH Computer Study Center, khabam Lamkhai.
Paper: Course Of Computer Concept (CCC)
Duration: 2 hours Full mark: 100
Pass mark: 40
Theory
Questions from 1 to 20 carry 2 marks each (40 mark)
1. The electronic component use in Third generation of computer is
A) Transistor B) Vaccum Tubes C) Microprocessor D) Integrated Circuits
2. Which of the following is not the characteristic of a computer?
A) Speed B) Accuracy C) Storage D) IQ
3. What is the function of Motherboard on the computer?
A) Scanner and other things are part of the motherboard.
B) A circuit board that connect all the external and internal hardware.
C) It is a type of file server.
D) Used for typing on screen.
4. The shortcut key used to insert hyperlink is
A) Ctrl + Y B) Ctrl + H C) Ctrl + X D) Ctrl + K
5. File extension of word document is
A) .xls B) .word C) .doc D) .jpeg
6. A character that is raised and smaller above the baseline is known as
A) Raised B) Superscript C) Outline D) Cap script
7. What is portrait and Landscape.
A) Page margin B) page Orientation C) page size D) page layout
8. Ctrl + Y is the short cut key for
A) Redo the last action B) paste the selected text C) cut the selected text
E) Undo the last action
9. The Save as…. dialog box can be used
A) For saving the file for the first time to save
B) File by some alternative name
C) To save file in a format other than word
D) All of the above
10. Which function in Excel checks whether a condition is true or not?
A) SUM B) COUNT C) IF D) AVERGE
11. In Excel, which of the following denote a range from B1 through E5
A) B1=E5 B) B1:E5 C) B1 to E5 D) $B1.$E5
12. What are the ways which you can Freeze the Rows/Columns in a Worksheet?
A) Freeze first row
B) Freeze first column
C) Freeze panes (based on the selected cells)
D) All of the above
13. What is the base value of hexadecimal number?
A) 8 B) 2 C) 9 D) 16
14. What is a transition in PowerPoint?
A) A way to print the slide B) A visual effect between slides C) A type of font style
D) A background color
15. Which of the following language does the computer understand?
A) Computer understand only C language
B) Computer understand only Assembly language
C) Computer understand only Binary language
D) Computer understand only Basic
16. How many bytes in (1Kb)?
A) 1000 bytes B) 10000 bytes C) 2000 bytes D) None
17. The part of CPU, which perform all mathematical operations?
A) CU B) ALU C) Register D) MU
18. Which of the following is an example of an output device?
A) Monitor B) keyboard C) Mouse D) scanner
19. What is the full form of MAN network?
A) Man Area Network
B) Metro Area Network
C) Wide Area Network
D) Metropolitan Area Network
20. Which of the following is represent the binary of Octal number 26?
A) 01101 B) 10110 C) 10010 D) 10100
Practical
Questions from 21 to 24 carry 20 marks each (60 marks)
21. Create a document using Ms Word with following question. (20 m)
Insert 6 paragraph with 3 sentence each font size 12
Write heading on top as “Microsoft” on capital and expanded the word by 150% & (7.0 pt) with center align,
font size 20 and Bold.
Put new bullet for all paragraph like (IT.1, IT.2,.…. to IT.6)
Put watermark “COMPUTER” with font face “Algerian” in color orange and size 115 without semitransparent.
Make portraits page with legal size. And insert page number, Date on top header.
Insert an image inside a small shape an also insert hyperlink with any document on it.
Design page borders in any style with color blue
Write an equation as given below
{cos x−42 +¿ log θ}
∞ 2 a 2
√−x +
π
∫a b
∑ x−2
−∞ a
Insert footer font size 14 using tabs function – stop position (8.5 cm & 16 cm) like given below
Test…………………………………………………. Imtech…………………………………………….2025
22. Create a report using ms excel. (20 m)
Emp id NAME Product SALES MANUFACTURE RESULT
DATE
EM001 Rahul A $2500 03-05-2020 ?
EM002 Arjun B $1000 15-08-2009 ?
? John A $3000 20-04-2015 ?
? Mike C $1500 18-10-2022 ?
? Rohn B $1200 12-02-2022 ?
? Vicky B $1800 26-05-2020 ?
? Nikhil C $800 30-06-2013 ?
Find the total sales of product B.
Sales greater than 1600 than expensive or greater than 1000 than medium otherwise let’s buy it.
Expired of all the product is 6 years after its manufacture date, find how many products are expired till today
display on separate cell.
With appropriate features and function display all the name of the employee on a single cell using Emp id.
Using pivot table find the average of the all the employee sales.
Create 3d-column chart compare with Name, product and sales.
Highlight the top sales with background color orange.
23. Create a presentation using MS Powerpoint on the following topic “Environment” or “computer”. Create not less than
7 slide with suitable transition and animation for all slide. (20 m)
