Computer application question, Quizzes of Computer Applications

This documents contains random question and answer on computer application software excel, Microsoft etc..

Typology: Quizzes

2019/2020

Available from 11/30/2021

taiwo-idowu
taiwo-idowu 🇳🇬

2 documents

1 / 16

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
KEY QUESTIONS AND ANSWERS ON CSC 201
COMPILED BY: HIGHDEEULOGY AND MUSBIK
1. What is metropolitan area network (MAN)
a) interconnectivity of computers that are within a limited area e.g a building.
B) interconnectivity of computers within a city.
c) interconnectivity of computers and networks all over the world.
d) interconnectivity of computers and networks within a country.
2. What is HTTP
A) Hypertext Transfer Protocol.
b) Hypertext Trojan Program.
c) High-level Technical Total Package.
d) Hypertext Transaction Protocol.
3. What is an output device?
A) The unit that sends result of processing to user.
b) The unit that controls system operations.
c) The unit that is used to enter data into a computer system
d) none of (a) to (c).
4) What is a program?
a) The physical components of a computer system
B) A set of instruction that makes computer to perform a task or group of
tasks.
c) The printout from a printer attached to a computer system.
d) It is a micro computer system.
5. What is an input device?
a) the unit that sends results of processing to users.
b) the unit that controls system operations.
C) the unit that is used to enter data into a computer system.
d) the unit that stores information.
6. what is local area network?
A) interconnectivity of computers that are within a limited area e.g an office.
b) interconnectivity of computers within a city.
c) interconnectivity of computers within a country.
d) none of (a) to (c)
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff

Partial preview of the text

Download Computer application question and more Quizzes Computer Applications in PDF only on Docsity!

KEY QUESTIONS AND ANSWERS ON CSC 201

COMPILED BY: HIGHDEEULOGY AND MUSBIK

  1. What is metropolitan area network (MAN) a) interconnectivity of computers that are within a limited area e.g a building. B) interconnectivity of computers within a city. c) interconnectivity of computers and networks all over the world. d) interconnectivity of computers and networks within a country.
  2. What is HTTP A) Hypertext Transfer Protocol. b) Hypertext Trojan Program. c) High-level Technical Total Package. d) Hypertext Transaction Protocol.
  3. What is an output device? A) The unit that sends result of processing to user. b) The unit that controls system operations. c) The unit that is used to enter data into a computer system d) none of (a) to (c).
  1. What is a program? a) The physical components of a computer system B) A set of instruction that makes computer to perform a task or group of tasks. c) The printout from a printer attached to a computer system. d) It is a micro computer system.
  1. What is an input device? a) the unit that sends results of processing to users. b) the unit that controls system operations. C) the unit that is used to enter data into a computer system. d) the unit that stores information.
  2. what is local area network? A) interconnectivity of computers that are within a limited area e.g an office. b) interconnectivity of computers within a city. c) interconnectivity of computers within a country. d) none of (a) to (c)
  1. The secondary storage a) Stores data temporarily while there is electricity supply to the system. b) Handle the arithmetic operation on system. C) Stores information (both data and instructions) on permanent basis. d) Handle the control operation of a system.
  2. Which of the following is true? a) internet and worldwide web are the same. B) internet and worldwide web are different c) internet is a part of worldwide web. d) the worldwide web is part of internet.
  3. what is a protocol? (a) a program that find the folder that accommodate file B) rules and formats to be used for a type of service c) a computer machine that send documents from one server to another d) an anti-virus programs
  4. What is the full meaning of HTML a) Hypertext Modular Logic B) Hypertext Markup Language c) Hypertext Mosaic Language d) Hotlink Modular Language
  5. What is Wide Area Network (WAN) a) interconnectivity of computers that are within a city b) interconnectivity of computer and network within a country C) interconnectivity of computers and network all over the world d) none of (a) to (c)
  6. The internet started as ARPANET and was developed by a) C.I.A b) F.B.I C) American Department of Defense d) K.G.B
  7. What is the full meaning of FTP a) File Transfer Program b) Forecasting Transaction Program c) Forward Transfer Program

b) cryptotext c) plaintext d) private key

  1. _____ is the output of decryption a) compiler B) plaintext c) algorithm d) ciphertext
  2. ______ is used for hiding the meaning of messages a) cryptanalysis b) cryptosystem C) encryption d) none of (a) to (c)
  3. ______ is the combination of encryption and decryption A) cryptosystem b) cryptanalysis c) both (a) and (b)
  4. Cryptograph has to do with enciphering a) no B) yes
  5. Cipher is a system that allows message to be understandable to people A) no b) yes
  6. Decipher is a system that allows something to be written badly a) yes B) no
  7. Cryptanalysis is a technique for ______ a) encrypting messages b) composing encryption keys C) deciphering without enciphering details d) none of (a) to (b)
  1. Encryption is used to convert cipher text to decipher text a) yes B) no
  2. Encryption keys are different from decryption keys A) no b) yes
  3. Caesar Cipher is _____ algorithm A) substitution b) transposition c) top-down d) none of (a) to (b)
  4. Hill top Cipher is ______ algorithm A) transposition b) bottom-up c) substitution d) top-down
  5. In symmetric encryption we use ____ key A) 1 b) 2 c) 3 d) 4
  6. In asymmetric encryption we use ____ key a) 1 B) 2 c) 3 d) 4
  7. An algorithm that could be determined given enough time and data is a _____ algorithm A) standard b) inferior c) breakable d) none of (a) to (b)
  1. You can merge the main document with data source in Microsoft Excel. In mail merge operation Microsoftword is usually the a) server b) source C) client d) none
  2. Where you can change automatic or manual calculation model in microsoft Excel a) Double CAL indicator on status bar B) Go to tool>>Options>>Calculation and mark the corresponding radio button c) Both of the above d) none of the above
  3. How can you show or hide the gridlines in Microsoft Excel worksheet? a) go to tool >> option>> view tab and mark or remove the check box named gridline b) click gridline tool on forms toolbar C) both of above d) none of above
  4. Which of the following Microsoft Excel screen components can not be turned on or off? a) formula bar b) status bar c) tool bar D) none of above
  5. What happen when you press Ctrl + X after selecting some cells in Microsoft Excel? a) the cell content of selected cells disappear from cells and stored in clipboard B) the cells selected are mark for cutting c) the selected cells are deleted and the cells are shifted left d) the selected cells are deleted and cells are shifted up
  6. What command will you use to convert a column of data into role in Microsoft Excel? a) cut and paste B) edit>>paste special>> transport

c) both of above d) none of above

  1. It is acceptable to let long text flow into adjacent cells on a worksheet when? a) data will be entered in the adjacent cells B) no data will be entered in the adjacent cells c) there is no suitable abbreviation for the text d) there is no time to format a text
  2. Which of the cell pointer in Microsoft Excel indicate that you can make selection? A) Doctor's symbol (Big plus) b) Small thin plus icon c) Mouse pointer with anchor at the tip d) none of above
  3. Which of the cell pointer in Microsoft Excel indicate that you can fill series a) Doctor's symbol (Big plus) B) Small thin plus icon c) Mouse pointer with anchor at the tip d) none of above
  4. Which of the cell pointer in Microsoft Excel indicate that you can move the contents of a cell to another cell a) Doctor's symbol (Big plus) b) Small thin plus icon C) Mouse pointer with anchor at the tip d) none of above
  5. You can activate a cell in Microsoft Excel by a) pressing the tab key b) clicking the cell c) pressing an arrow key D) all of above
  6. To get functions in Microsoft Excel, you need the insert function dialog box. how do you get it? a) right click a cell and then click insert b) click the insert menu and then click function C) type = in a cell

a) Show the formatting of a data label b) Show the name of a data series c) Show the value of data point D) b and c

  1. How will you change column width to fit the content? a) Single-click the boundary to the left of the column heading B) Double click the boundary to the right of the column heading c) Press Alt and single click anywhere in the column d) All of above
  2. When you work with large worksheet, you may need to a) Size the worksheet to fit on the specific number of pages b) Add and remove page breaks c) Specify only certain print areas D) All of above
  3. Hyperlinks cannot be a) Special shapes like stars and banners b) drawing objects like rectangles ovals c) pictures D) all can be hyperlinks
  4. You can use the horizontal and vertical scroll bar to a) split a worksheet into two panels B) view different rows and column c) edit the contents of a cell d) view different worksheets
  5. What do we call a computer program that organize data in rows and column of cells? You might use this type of program to keep a record of the money you earn working as a librarian during your first semester break A) spreadsheet program b) database program c) word processor program d) desktop publisher program
  6. You can add an image to a template by clicking the insert picture from file button on the _____ toolbar in Microsoft Excel a) standard

b) formatting c) drawing D) picture

  1. Which button do you click to add up a series of number in Microsoft Excel A) the autosum button b) the formula button c) the quicktotal button d) digital button
  2. When the formula bar is active in Microsoft Excel, you can see a) the edit formula button b) the cancel button c) the enter button D) all of the above
  3. To copy formatting from one area in a worksheet and apply it to another area, you would use: a) The Edit>Copy Format and Edit>Paste Format commands from the menu b) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu c) There is no way to copy and apply formatting in Microsoft Excel, You have to do it manually D) The format painter button on the standard toolbar
  4. Which area in Microsoft Excel window allow entering values and formula a) title bar b) menu bar C) formula bar d) standard toolbar
  5. To hold rows and column titles in place so that they do not scroll when you scroll a worksheet click the a) Unfreeze panes command on the window menu B) Freeze panes command on the window menu c) Hold title command on the Edit menu d) split command on the window menu
  6. To create a formula in Microsoft, you can use: a) values but not cell references
  1. Ctrl + X a) close document b) close word application C) cut the selected contents d) copy the selected contents
  2. Ctrl + Y a) undo the last action B) repeat the last action c) delete the last page d) delete the first page
  3. Ctrl + Z A) undo the last action b) redo the last action c) add the new page d) paste the contents from clipboard
  4. Page Up key a) moves the cursor one line up B) moves the cursor one screen up c) moves the cursor one page up d) moves the cursor one paragraph up
    1. Page Down key a) moves the cursor to the beginning of the document b) moves the cursor to beginning of document C) moves the cursor one screen down d) moves the cursor one paragraph down
  5. Home key a) moves the cursor to beginning of the document b) moves the cursor to the beginning of the paragraph c) moves the cursor to the beginning of the screen D) moves the cursor to beginning of the line
  6. End key A) moves the cursor end of the line b) moves the cursor end of the document c) moves the cursor end of the paragraph

d) moves the cursor end of the screen

  1. How to remove all character format a) Shift + Spacebar b) Shift + Enter key C) Ctrl + Spacebar d) Ctrl + Enter
  2. Which of the following is a type of page orientation a) landscape b) portrait c) Gutter D) only a and b
  3. What is the shortcut key for manual line break? a) Ctrl + Enter b) Alt + Enter C) Shift + Enter d) Space + Enter
  4. How will Microsoft Word respond to repeated words? A) A Red waving line under the repeated word b) A Green waving line under the repeated c) A Blue waving line under the repeated word d) None of the above
  5. What is the use of "All caps" features in MS Word A) It changed all selected texts into capital letter b) It add captions for elected image c) It shows all the image captions d) None of the above
  6. The following are word processing packages except____ a) loco script b) Microsoft Word c) word perfect D) visicale
  7. To move up one screen at a time, press ____ a) Page Down

a) word processing b) editing C) desktop publishing d) data processing

  1. The use of computer to create, edit, save and print document made up of texts is called a) Mailing B) Word processing c) Desktop publishing d) Data processing
  2. The size and typeface of characters is called a) Alignment b) Formatting C) Font d) Enhancement
  3. To switch over to typeover mode so as to overwrite or replace text on screen, use____ key a) Shift b) Delete C) Insert d) Backspace
  4. The feature of word processing software that formats a letter, word or selected text with a large initial or capital letter is called a) Change case B) Drop cap c) Font d) Alignment