Computer (ICT) (ECO227)
DIPET 1 in Economics - ECNT
Semester: Resit
Level: 300
Year: 2016
THE UNIVERSITY OF BAMENDA
HIGHER TECHNICAL TEACHER TRAINING COLLEGE BAMBILI
DEPARTMENT OF ECONOMIC SCIENCE — LEVEL 200
RE-SIT EXAMINATION 2015/2016
Course Code & Title: ICT 208 - COMPUTER
Instructor: Akouyu S. N.
Instruction: Answer ALL Questions Duration: 1H30M
SECTION A: MCQ - Copy the letter and the answer corresponding to the correct answer in your answer booklet
1)
The insertion point in a table can be moved by using
a) Shift + Tab' key c) All of the above
b) Tab key
.d)
Arrow keys
2) Which of the following command lets you set the vertical alignment?
a) Page Setup command' from Format menu Page Setup command from File menu
b) Font command from Format menu . d) Paragraph command from Format menu
. 3) ,Minimum zoom percentage supported by MS Word is
a) 10% b) 25% c) 4% d) 15%
4) .1n word-processing the task of changing the appearance of a document is
a) Editing b) Proofing Formatting
,
d) Inserting
5) Which of the following is not a type
of tab
stop?
a) Bar b) Point c) Left d) Decimal
6) Which page orientation you will select if you wish to print in wide format?
a ) V e r t i c a l Landscape c) Horizontal d) Portrait
. 7) What is the default alignment for values and dates in a cell?
a) Left b) Centre c) Right d) Justify
8) The word wrap features
a) allows you to type over text
b)
appears
at the bottom-of the document
c)/ automatically move text to the next line when necessary
d) is the short horizontal line indicating the end of document
.5) -Which input device is not suitable; to work with MS
Word?
a)
,
Light Pen b) Joystick . c) Mouse d) Keyboard
.10) Which of the following option is not in Insert menu?
a) Header and Footer- -0 Footnote
• b) Bookmark • d) Hyperlink
11) The red wave underline in MS Word document indicates
Spelling errors b) Grammar errors c) None
-
of these d) Address block
12) You can use different page format within the same document by separating the differently formatted
area with a
a) Format break b) Document break c) Line break
.
d): Section break
13) To keep specific rows and columns from scrolling off the screen you first must position the cell
pointer
a) to the right of the column you want to remain on the screen
b) on the
row
you want to remain on the screen
e) below the row you want to remain on the screen
d) both below and right of the row and column you want to remain on the screen
14) Which of the following component displays the contents of active cell?
a)
/
Formula bar b) Menu bar • c) Status bar d) Name box
15) If you wanted to sort an employee file so that they would be listed alphabetically by last name and
first name within individual zip codes (smallest to largest), ,which of the following would be the
correct order of the sort.?
a) last name (ascending), then first name(ascending), then last name (ascending)
b) zip codes (descending), then last name(ascending), then first name(ascending) -
c) last name (descending), then first name (descending), then last name (descending)
d) zip codes (ascending), then last name (ascending), then first name (ascending)
16) A quick way to return to a specific area of a worksheet is to
-
type in the ______
a) None of these b) Formula bar c) Zoom box d) Name box
www.schoolfaqs.net
17 ) Which keyboard-shortcut o pen s the go
to di alog box?
'a) F5 b) Ctrl + B c) F2 d) Ctrl + Shift + B
18) Which of the following contains buttons that can change the
appearance of text?
A Title bar b) Status bar c) Menu bar d) Formatting bar
19) What determines the amount of vertical space between lines of text?
a) Margin b) Paragraph c) Line spacing d) All of the above
20) Which of the following is a menu that shows a list of commands relevant to a particular item, evoked
with the right-click of a mouse button?
a) Formatting toolbar c) Shortcut toolbar
b) Standard toolbar , d) Shortcut menu
21) What function would display the highest sales amount in a column?
a) Count b) Maximum c) Sum d) Average
22) Which of the following items
can be formatted using a software package?
a) Single letter b) Word c) Series of words d) All of the above
23) What type of operation is performed in the formula =A4*B4? ,
a) Subtraction : b) Division c) Multiplication d) Addition
24) What is referenced or explained at the end of a page in a document?
a)Footnote b) Footers .
b) Endnotes d) None of the
.
above
25) Which of the following displays the current document name?
a) Title bar b) Status bar c) Menu bar d) Formatting bar
26) Data can be arranged in ascending or descending order by using
a) Sort command from Table menu c) None of these
b) . Sort command from Tools menu .
d)
Sort command from Data menu
27) How many sheets are there in Excel Workbook by default?
a) 4 b) 5 c) 2 d) 3
28) How would the Cell reference $F$3 be described?
a) Relative cell reference c) a &
-
b
b)
Absolute cell reference d) None of the above
.
29) To .select multiple non-ad3acent cells in a worksheet you will click them holding
a) ALT key . b) Ctrl+Shift key c) Shift Key d) CTRL key
30) The shortcut-key to repeat, a task is
a) Ctrl+Z =:0 Ctrl+Y c) Ctrl+R d) None
SECTION B: Answer the Following Questions
1) Explain the similarities and differences between a named Database Management Program and a
named Desktop Publishing Progr
.
am (8 pts)
2) When you copy a formula, Excel changes the cell address to match where the copied formula is
located. Give an example of when this is helpful. Think and explain another situation when you might
not want Excel to do this. (7 pts)
3) Explain the difference between a function and a formula giving an example of each. (3 pts)
4) If you delete a row or column, it is deleted across the entire worksheet. What problems could result
from this? (2 pts)
5) How many scroll bars are normally on the PowerPoint screen? Name them. (3 pts)
6) You can copy a formula with.the Copy and Paste buttons or with the Fill Handle. Which do you prefer
and why? (2 pts)
7) Identify two ways of opening a document in a named Presentation Program. (4 pts)
'8) Name the three sections available for a Footer on a work sheet. (3 pts)
9) List two different ways you can change the case of text in a Word processor. (2 pts)
10)Describe how to rename a worksheet tab. (2 pts) -
11)How can you AutoFit a column to the longest text in it? (2 pts)
12) Explain what-happens when you copy text in any named application unt
•
il you want to paste it. (2 pts)
&dad azzir
•
www.schoolfaqs.net
