Fundamentals of Computer Science 2 Questions

Fundamentals of Computer Science 2 (CSCC2202)

Higher Institute of Commerce and Management (HICM)

Semester: Second Semester

Level: 200

Year: 2017

Answers (200 )

FUNDAMEANTALS OF COMPUTER SCIENCE II

REVISION QUESTIONS 2016/2017

1. . One primary use for a spreadsheet is to -------------- a real world situation. (a) model (b) broaden

2. The advantages of using a spreadsheet is (a) calculation can be automatically. (b) changing data

automatically updates calculations (c) more flexibility (d) all of the above

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

computer search in the media center (b) maintain an inventory (d) type a biography

4. What does the Ctrl + I shortcut key accomplish in Ms- word? (a) It converts selected text into the

next larger size of the same front (b) It adds a line break to a document (c) It makes the selected

text bold (d) It applies Italic formatting to the selected text.

5. 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 Page (c) To make large document more readable

(d) To allow page headers and footers to appear on document when it is printed

6. In Microsoft word shortcut key CTRL+R is used for (a) Open the Print dialog box (b) Update

the current web page (c) Close the current window (d) None of these

7. Maximize, minimize and close button are called: (a) Run button (b) Home button (d) Start button

8. Shortcut for Save As command is (a) F10 (b) F4 (c) F7 (d) f12

9. Which enables us to send the same letters to different persons? (a) Macros (b) templates (c) Mail

merge (d) none

10. “Ctrl + R Arrow” is used to (a) Moves the cursor one word right (b) Moves the cursor end of the

line (c) Moves the cursor end of the other document (d) Move cursor one paragraph down.

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

page (c) On every page (d) none of the above

12. 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 documents determines by printer (c)Page orientation

of a document cannot be changed.

13. Where can you change the vertical alignment? (a) Formatting toolbar (b)paragraph dialog box (c)

Page setup dialog box (d) standard toolbar

14. Which of the following is a front style? (a) Bold (b) Italic (c) Regular (d) superscript

15. How can you apply the same formatting you did to another text (a) Copy the text and paste in

new location. Then type the new again. (b) Copy the text and click on special paste tool on the

new place (c) Select the text and then click on Format painter and select the next text (d) All of

the above

16. A feature of MS Word that saves the document automatically after certain intervals is available

on (a) save tab on option dialog box (b) Save as a dialog box (c) Both of the above

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

18. To auto-fit the wide of the column (a) Double click on the right border column (b) Double click

the right border (b) Double click the left border column (c) Double click the column header (d)

All the above.

19. The default header for a worksheet is (a) User name (b) Date and time (c) Sheet tab name (d)

None

20. Which of the following methods will enter data inside a cell? (a) Pressing the Esc key (b)

pressing an arrow key (c) Pressing the tab key (d) pressing the enter button to the formula bar

www.schoolfaqs.net

21. The cell reference for the cell range of G2 to M12 is ----------- (a) G2.M12 (b)G2;M12 (c)

G2:M12 (d) G2-M12.

22. You can automatically adjust the size of the text in cell if they do not fit in width by (a) Double

clicking on right border of column header (b) From format choose columns and then auto-fit

selection (c) From formatting choose columns and then auto fit selection (c) From format cells

dialog box mark (d) All the above

23. What is entered by the function =today() (a) The data value for the day according to system clock

(b) The time value according to a system clock (c) Today’s data according to system (d) all the

above.

24. By default excel provides 3 work sheets. You need just two how will you delete the third one (a)

Right click on sheet Tab of third sheet and choose Delete from the context menu (b) click on

sheet 3 and from Edit menu choose Delete (c) Both of the above (d)none of the above

25. Which of the following statements is not true? (a) You can type directly into a power point slide

but typing into text box is more convenient. (b) From the insert menu choose picture and then

from the file to insert your image into the slides. (c) You can display a power point presentation

in Normal, slide sorter or slide show view. (d) You can show or hide task pane from view>>

Toolbars

26. Which of the following sections does not exist in a slide layout? (a) Titles (b) Lists (c) charts (d)

27. Which of the following is not a valid data type in excel (a) Number (b) Character (c) Label (d)

Date/time.

28. How many worksheets can a workbook have (a) 3 (b)8 (c) 255 (d)None of the above

29. What happens when the dollar signs ($) are entered in a cell address? (a) $B$2:$B$10 (b) An

absolute cell address is created. (b) Cell address will change when copied to another cell (c) The

sheet tab is changed (d) The status bar does not display the cell address.

30. Which of the following is correct9? (a) =AVERAGE(4, 5, 6, 7) (b) =A VERAGE(A1, BI, CI) (c)

AVERAGE(A1:A9’ B1 B9){^’AII of the above

31. What is the quickest way to select entire worksheet? (a) Choose-Edit- Select ail from the Menu

(by - Click on the first column, press Ctrl, and then click on the last column (c) Click on the first

column, press Shih, and then click on the last column (d)Click on the rectangle box on the upper

left comer

32. Which of the following is correct syntax in Excel (a) =IF(LogicalTest, TestResult, FalseTest)

(b)=IF(LogicalTest,(TrueResult, FalseResult) (c) =IF( LogicalTest, TrueResult, FalseResult) (d)

= IF(LogicalTest, TrueResult ), IF(LogicalTest, FalseResult)

33. What are some ways to erase typing in Microsoft Word? (a) Backspace (b) Delete (c) Insert (d)

All of the Above

34. Materials consisting of text and numbers is best presented as (a) table slide (b) A bullet slide (c)

A title slide (d) All of the above

35. Except for the ------- function, a formula with a logical function shows the word “TRUE’’ or

“FALSE” (a) IF(b) AND) (c)0R (d) NOT

36. The selected design template can be applied (a) To current slide only (b) To all the slides (c)To

the new presentation you create (d) All of above

37. What is the Quick Access Toolbar? (a) There are no toolbars in Word 2010. (b) What appears

when select presentation you create(c) A customizable toolbar of common commands that

appears above or below the Ribbon. (d) An extension of the Windows taskbar.

www.schoolfaqs.net

38. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events

that will do this? (a) Go to File-Save As - Save As Type - Excel worksheetM Right click on the.

spreadsheet tab and select DELETE (c) Right click on the spreadsheet and select Insert - Entire

Column (d) None of above

39. 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

40. Which of the following is NOT a new features in Word 2010? (a) Backstage view (b) Improved

picture editing (c) The Ribbon (d) Pate with Live Preview

41. What is the Quick Access Toolbar?(a)There are no toolbars in word 2010 (b) What appears when

you select text (c) A customizable toolbar of common commands that appears above or below

the select text. (d) An extension of the Windows taskbar.

42. What is the name of the bar bottom of desktop? (a) Taskbar (b) icons (c) Wallpaper

43. Where can you find basic file management commands and program options? (a) Status bar (b)

Title bar (c) Close button (d) File tab

44. In Microsoft Word shortcuts DELETE is for (a) Undo something (b) Delete something (c) Paste

something (d) None of these

45. What does control +B shortcut accomplish in Ms Word (a) It converts text into the next larger

size of the same font (b) It adds a line break to the document (c) It makes the selected text bold

(d) It applies Italic formatting the selected text.

46. In Microsoft word shortcut key CTRL+W is used for (a) Open the Print dialog box (b) update the

current Web page (c)Close the current window (d) None of the above

47. In Microsoft word shortcut SHIFT+DELETE is used for (a) Delete the selected item

permanently placing the item in the recycle Bin (b) Copy the selected item (c) Rename the

selected item (d) Create a shortcut to the document.

48. In Microsoft Word shortcut key CTRL+F is used for (a) Open the Organize Favorite dialog box

(b)Open the Search bar (c) Start the find utility (d) Open the History bar

49. Red wavy lines under text indicate: (a) None of these (b) Character Mistakes (c)Spelling Mistakes

(d) Grammatical Mistakes

Portrait and landscape are : (a) Page Orientation (b) Page size (c) Page layout(d) All the above

www.schoolfaqs.net