Computer (ICT) Questions

Computer (ICT) (ECO227)

DIPET 1 in Economics - ECNT

Semester: Second Semester

Level: 300

Year: 2016

Answers (200 )

School: HTTTC Department: Economic Science Instructor: Akouyu S. N.

Course Code: ICT 208 Course Title: Computer (ICT) Option Level: 200

DATE: __________Hall_______ Exam Session: Second Semester 2015/2016 – July 2016 Time: 2 Hours

Instructions: Answer ALL questions chronologically, skipping a line or two after each question.

MCQ – Each question below gives a multiple choice of answers. Select the best (most appropriate one)

option/answer and fill in your answer booklet E.g. if the answer to question “1” is “c”, you write as follows:

(1) e – Word processor

1) A program which helps to create written documents and lets you go back and make corrections as necessary

(a) Desktop publisher (b) Processing Word (c) Tool bar (d) Spreadsheet (e)Word processor I

2) The extension of a MS Access Database is: (a) .mdb (b) .mac (c) .mad. (d).md (e) rndb.ac

3) Why are headers and footers used in document? (a) To enhance the overall appearance of the document (b) To

mark the starting and ending of a. page (c) To make large document more readable (d) To alloW page headers and

footers to appear on document when it is printed

4) What is the minimum number of rows and columns that a word table can have? (a) Zero (b) 2 rows and 1

column (c) 2 rows and 2 column (d) 1 row and 1 column (e) None of the above

5) A____ is a collection of predefined design elements and color schemes. (a) feature (b) hyperlink (c) palette (d)

theme (e) template

6) In Microsoft Word shortcut key CTRL+ R is used for (a) Open the Print dialog box (b) Reset task (c)

Close the current window (d) Restore the current page (e) None of these

7) The cell reference for cell range of G2 to M12 is_____(a) G2 to M12 (b) G2;M12 (c) G2:MI2 (d) G2-MI2

(e) G2 M12

8) Maximize, Minimize and Close button are called: (a) Run button (b) Control button (c) Home button (d) Start

button (e) Active buttons

9) The ability to combine name and addresses with a standard document is called ____ (a) document formatting

(b) database management (c) mail merge (d) form letters (e) merge letters

10) A word processor would most likely be used to do (a) keep an account of money spent (b) do a computer

search in media center (c) maintain an inventory (d) type a biography

11) What is gutter margin? (a) Margin that is added to the left margin when printing (b) Margin that is added

to right margin when printing - . (c) Margin that is added to the binding side of page when (d) Margin that is

added to the outside of the page when printing

REPUBLIC OF CAMEROON

Peace – Work - Fatherland

THE UNIVERSITY OF BAMENDA

P.O BOX 39, Bambili

www.schoolfaqs.net

12) By default, on which page will the header or the footer is printed? (a) on first page (b) on alternate page,

13) Which function will you use to enter current time

a worksheet cell? (a) = today () (b) = now() (c) =

time() (d) = current time () (e) = time now()

14) Which of the following is true regarding page Orientation of a Document? (a) Page Orientation can be

change at any time (b) Page Orientation of document determines by printer (c) Page Orientation must be set

before start typing (d) Page Orientation of a document Cannot be changed.- I

15) Which operation will you perform if you need to move a block of text? (a) Copy and Paste (b) Cut and. Paste

cut

16) The ______ , or typeface, defines the appearance and shape of letters, numbers, and special characters. (a) font

(b) font size (c) point (d) paragraph formatting (e) letter shapes •

17) Which of the following is not a font style? (a) Bold (b) Italics (c) Regular (d) Superscript (e) Bold Italic

18) From where can you access the Save command? (a) Home tab (b) Insert tab (c) Review tab .0.)None of

above (e) Access Tab

19) Row can you apply exactly the same formatting you did to another text? (a) Copy the text and paste in new

location. Then type the new text again..(}) Copy the text and click on Paste Special tool on new place (0) Select

the text then click on Format Painter and select the new text (d) All of above

20) When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply: (a) Use =if ()

function to format. the required numbers red (b) Apply Conditional Formatting command on Format menu (c)

Select the cells that contain number between 0 and 100 then click Red color on Text Color tool (d) Use

=DisplayRed () (e) All of above

21) Which of the following commands should you always use before submitting a document to others? (a) find

command (b)- Replace command-(.c) Spelling and Grammar (d) Thesaurus,(e) Edit submit

22) What primary clement is used to protect a workbook at the file level? (a) Password (b) Permissions (c)

Custom Lists (d) Protect Worksheet and Contents of Locked Cells (e) Workbook protector

23) If you want to communicate a message or persuade other people, you would typically use this type of

software. (a) worksheet (b) database (c) document (d) presentation (e) communication

24) A feature of MS Word that saves the document automatically after certain interval is available on (a) Save tab

on Options dialog box (b) Save As dialog box (c) Both of above (d) None of above

25) Which of the following is not a type of page margin? (a) Left (b) Right(c) Center (d) Top (e) bottom

26) To autofit the width of column: (a) Double click the right border of column (b) Double click the left border of

column (c) Double click the column header (d) All of above (e) None of the above

www.schoolfaqs.net

27) Which of the following statement is false? (a) You can set different header and footer for even and odd pages

(b) You can set different page number formats for different sections (c) You can set different header and footer for

first page of a section (d) You can set different header and footer for last page of a section (e) None of the above

28) Changing the appearance of a document is called: (a) Proofing (b) Editing

Arranging

29) A function inside another function is called_____(a) Nested function (b) Round function (c) Sum 'function

(d) Text function (e) Inner function

30) Which tab is not available on left panel when you open a presentation? (a) Outline (b) Slides`(c) Notes (d) All

of above are available

31) Which of the following statements is not true? (a) You can type text directly into a PowerPoint slide but

typing in text box is more - convenient. (b) From Insert menu choose picture and then From File to insert your

images into slides. (c) You can display a PowerPoint presentation in Normal, Slide Sorter or Slide Show view. (d)

You can show or hide task pane from View >> Toolbars

32) What lets you to create new presentation by selecting ready-made font color and graphics effects?

(a) Presentation Template (b) Master Slide (c) Design Template (d) Animation Scheme (e) All of above

33) What feature will you use to apply motion effects in between a slide exists and another enters?

(a) Slide transition (b) Slide Design (c) Animation Objects (d) Animation Scheme

34) In a PowerPoint presentation: (a) Sound clips can be inserted but not movie clips (b) Movie clips can be inserted but

not sound clips (c) Both cannot be inserted (d) Both can be inserted (e) Only one of them

35) If you have a PowerPoint show you created and want to send using, email to another teacher you can add the show to

your email message as a (an) (a) Inclusion (b) Attachment (c) Reply (d) Forward

36) Which of the following is not a valid data type in Excel? (a) Number (b) Character (c) Label (d) Date/Time

37) Which area in an Excel window allows entering values and formulas? (a) Title Bar (b) Menu Bar (c) Formula Bar (d)

Standard Tool Bar (e) Name. Box Bar

38) To select an entire column in MS-EXCEL, press? (a) CTRL + C (b) CTRL + Arrow key (c) CTRL + S (d) None of

the above

39) How do you wrap the text in a cell? (a) Format, cells, font (b) Format, cells, protection (c) format, cells, number

(d) Format, cells, alignment

40) What does COUNTA () function do? (a) counts cells having alphabets (b) counts empty cells (c) counts cells

having number (d) counts non-empty cells (e) it counteracts cells

41) Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? (a) Logical-

(b) Math & Trig6nometry (c) Statistical (d) Financial

www.schoolfaqs.net

42) A function inside another function is called _____(a) nested function (b) round function (c) sum function (d) text

function (e) inside or merge function

43) Which of the following shortcuts can be used to insert a new line in the same cell? (a) Enter (b) Alt + Enter (c) Ctrl

+ Enter (d) Shift + Enter

44) Worksheet can be renamed by (a) Adding ? symbol at the end of filename while saving workbook

(b) Click on Worksheet tab by Holding CTRL Key and type new name (c) double click on the worksheet tab and type new name (d)

Worksheet cannot renamed (e) All of the above

45) Which one is the last column header in Excel 2007? (a)XFD (b) XFX (c) XFL (d) FXD (e) XDF

46). Cut Copy and Paste is in _____ Group in the Home tab. (a) Font (b) Page Setup (c) Clipboard (d) Editing (e)

Formatting

47) A character that is raised and smaller above the baseline is known as (a) Outlined (b) Raised character (c) Superscript (d)

Subscript (e) upper script

48) A feature of MS Word that saves the document automatically after certain interval is available on (a) Save tab on

Options dialog box (b) Save As dialog box (c) Both of above (d) None of above (e) Document auto saver

49) Excel uniquely identifies cells within a Worksheet with a _____ (a) Cell names (b) Column numbers and row letters

50) Except for the______function, a formula with a logical function showing the word "TRUE" or "FALSE" as a result.

(a) IF (b) AND (c) OR d) NOT (e) All of the above

51) Material consisting of text and numbers is best presented as (a) A table slide (b) A bullet slide (e) A title slide

(d) All of the above

52) To give a PowerPoint presentation to a large audience you: (a) Set up your computer in a large auditorium, and

click large, auditorium, OK (b) Click the slide you wish the audience to see in normal view, then click the next

slide, and.so on (c) Choose either view, slide show or slide show, view show (d) Slick slide show, OK

53) Which of the following is not one of PowerPoint's views? (a) Slide show view (b) Slide view (c)

Presentation view (d) Outline view

54) What is the term used when a clip art image changes the direction of faces? (a) Group (b) Flip (c) Rotate (d)

All of the above (e) directional alteration

55) The slide thus used to introduce a

topic and set the tone for the presentation is called the (a) table.slic16 (b)

graph slide (c) bullet slide (d) title slide (e) Intro slide

56) Which of the following should be used when you want to add a slide to an existing presentation? (a) File, add a

new slide (b) Insert, new slide (c) File, open (d) File, new

www.schoolfaqs.net

57) To make a number in cell CI 10% smaller than the number in C3 you enter (a) =C3*1.10 (b) + C3*110

58) You can print (a) A range of cells by mange name (b) An entire worksheet (c) A single worksheet

(d) All of the above

59) The advantage of using a spreadsheet is: (a) calculations can be done automatically (b) changing data

automatically updates calculations (c) more flexibility (d)-

'all of the above

60) To select a column the easiest

method is to………… (a) Double click any cell in the column (b) Drag

from the top cell in the column to the last cell in the columns(c) click the column heading (d) click the column

label

61) If you press……., the cell accepts your typing as its contents.,(a) Enter (b) Ctrl+Enter (c) Tab (d) Insert

(e) content key

62) You can copy cell formats • from one cell to another by using the (a) Backspace key (b) Default

font (c) Format painter (d) Formatting toolbar (e) format copy

63) A……is a group of cells that form a rectangle on the screen. (a) Calculation (b) Formula (c) Range (d) Range

address (e) triangular cells

64) What is an expression that tells how the numbers in a determined set of cells are to be calculated? (a)

Formula (b) Field (c) Data (d) Query (e) equation

65) Each excel file is called a workbook because (a) It can contain text and data (b) It can be modified (c) It can

contain many sheets including worksheets and chart sheets (d) You have to work hard to create it

66) You cart use the format painter multiple times before you turn it off by (a) You can use the format painter button

only one time when you click it (b) Double clicking the format painter button (c) Pressing the Ctri key and clicking the

format painter button (d) Pressing Alt key and clicking the format painter button

67) MS-EXCEL can be used to automate (a) financial statements, business forecasting (b) transaction registers,

inventory control (c) accounts receivable, accounts payable (d) any of the above .

68) What key can you press to get help in Word 2010? (a) <Esc> (b) <Ctrl> + <1-1>.(c) <F1> (d) <F11> (d)

69) Word underlines spelling errors_ in green, and grammar errors in red. (True or False?)

70) How would you insert a 0 symbol in a document? Click the Insert tab on the Ribbon and click the

Symbol button in the Symbols group. (b) Press <Ctrl> + <C> (c) Click the Copyright button on the Quick Access

www.schoolfaqs.net