computer fundamental questions answers

• The brain of any computer system is 

A.        ALU
B.        Memory
C.        CPU
D.        Control unit
E.        None of the above 

• Who invented the high level language c? 

a. Dennis M. Ritchie


b. Niklaus Writh


c. Seymour Papert


d. Donald Kunth

• The binary system uses base of 

A.        2
B.        10
C.        8
D.        16
E.        None of the above

• 1 KB is equal to 

A. 100 bytes                                B. 1000 bytes


C. 1024 bytes                               D. 1048 bytes

• For dial up internet connection, a computer must have 

A. Sound card                              B. CD drive


C. Modem                                    D. None of these

• Which of the following is not a valid memory? 

A. ROM                                       B. RAM


C. EEPROM                                 D. NIC

• Which of the following is not related to computer? 

A. mouse                                     B. cat


C. light pen                                  D. joystick

• What is the full form of LAN? 

A. Local Area Network                B. Large Access Network


C. Long Antenna Network           D. None of these

• What do you need to have for browsing internet? 

A. Internet Account with an ISP 
B. Telephone Line 
C. Computer with modem 
D. All of the above

• The following are examples of computer storage devices except 

A. diskettes                                  B. zip disks


C. scanners                                  D. hard drives

• If a computer is turned off without saving a new document 

A the computer will not be able to restart 
B the computer will reboot 
C the document will be lost 
D the default format will be changed

• RAM is commonly referred to

a) Solid state memory
b) Core memory
c) Non-volatile memory
d) Read/write memory

• The Language that the computer can understand is called

a- High Level Language
b- Machine Language
c- System Program
d- Assembaly Language

• CPU stands for?

Common Processing Unit
Central Process Unit
Central Processing Unit
Central Performance Unit

• ALU stands for? 

Arithmetic Logic Unit
Arithmetic Logical Unit
Arithmetic Logic Uniform
None of the above

•  Which of the following is not an output device?

 Scanner        
 Printer        
Flat Screen
Touch Screen

•  Which key combination save a document? 

A)           [Ctrl]+[A] 
B)           [Ctrl]+[S]
C)           [Alt]+[S] 
D)           [Ctrl]+[F]

• Which command reverses the last action performed in the worksheet? 

A)           Cut 
B)           Undo 
C)           Redo 
D)           Paste

• Which command allows you to reverse an Undo command?

A)           Redo 
B)           Repeat 
C)           Reset 
D)           Reverse

• Which key combination is the shortcut for the Undo command? 

A)           [Ctrl]+[Z] 
B)           [Ctrl]+[X] 
C)           [Ctrl]+[Y] 
D)           [Ctrl]+[U]

• One millisecond is

a. 1 second 
b. 10th of a seconds 
c. 1000th of a seconds 
d. 10000th of a seconds

• Connections to the Internet using a phone line and a modem are called __________ connections. 

A)           broadband 
B)           dish 
C)           digital 
D)           dial-up

• ASCII stands for

A.  American Standard Code for Information Interchange
B.  American Scientific Code for International Interchange
C.  American Standard Code for Intelligence Interchange
D.  American Scientific Code for Information Interchange

• Main storage is also called

A.  Accumulator
B.  Control Unit
C.  Register Unit
D.  Memory

• After copying the content how many times can you paste?

A.  1
B.  16
C.  32
D.  Many

• Which of these could be done using internet

a. E-mails
b. Shopping
c. Education
d. All choices are correct

•  Computer converts everything before processing to

a. Letters
b. Numbers from 0 to 9
c. Letters, digits or symbols
d. Zeros and ones numbers

• Excel files have a default extension of

 XLS
XLW
 WK1        
 123

• A Worksheet can have a maximum of ___ number of rows

 256
 1024        
 32,000        
 65,536

• A typical worksheet has ___ number of columns

 128
 256
 512        
 1024

• Which area in an Excel window allows entering values and formulas

 Title Bar
 Menu Bar
 Formula Bar
 Standard Tool Bar

• An Excel Workbook is a collection of

 Workbooks
 Worksheets
 Charts
 Worksheets and Charts

• Give an example of a cell address?

1. 11 25
2. 911
3. 41A
4. A21

• What is the symbol for dividing?

1. /
2. %
3. &
4. #

• What happens when you press Ctrl + X after selecting some cells in Excel? 

 A) The cell content of selected cells disappear from cell and stored in clipboard
 B) The cells selected are marked 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

•        An example of a  range address.

A.       A1:B3
B.        A1;B3
C.        A1-B3
D.       A1=B3
E.       A1*B3

• If you need a text to show vertically in a cell. How will you achieve this? 

 A) Choose Vertical on Text alignment in Format Cells dialog box
 B) Choose 90 Degrees in Orientation of Format Cells dialog box
 C) Choose Distributed from the Vertical drop down list of Format Cells dialog box
 D) Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

•  What is entered by the function =today() 

 A) The date value for the day according to system clock
 B) The time value according to system clock
 C) Today’s date as Text format
 D) All of above

•  Which function will you use to enter current time in a worksheet cell?

 A) =today()
 B) =now()
 C) =time()
 D) =currentTime()

• To copy cell contents using drag and drop, press the 

a.   End key 
b.   Shift key 
c.   Esc key 
d.   None of above


  

• Excel is a 

a.   Graphic program 
b.   None of these 
c.   Word processor 
d.   A spreadsheet

• You can activate a cell by 

a.   Pressing the Tab key 
b.   Clicking the cell 
c.   Pressing an arrow key 
d.   All of above 

• Shortcut  Key for  Copy selected text ………………………………

• Shortcut  Key for  Cut selected text ………………………………

• Shortcut  Key for  Bold  selected text  ………………………………

• Shortcut  Key for Save a document  ………………………………

•  Portrait and Landscape are

 A) Page Orientation
 B) Paper Size
 C) Page Layout
 D) All of above

•  ALU is

a. Arithmetic Logic Unit
b. Array Logic Unit
c. Application Logic Unit
d. None of above

•  In a worksheet you can select 

a.   The entire worksheet 
b.   Rows 
c.   Columns 
d.   a, b, and c

• You can copy data or formulas 

a.   With the copy, paste and cut commands on the edit menu 
b.   With commands on a shortcut menu 
c.   With buttons on the standard toolbar 
d.   All of the above