excel short cut key

Shift+Space: Select an entire row

Ctrl+Space: Select an entire column

Alt+Semicolon: Select visible cells

Ctrl+Plus: Insert new row or column above or to the left of selected row or column

Ctrl+Minus: Delete selected row or column

Alt+Plus: Calculate the sum of selected cells

Ctrl+N: Open new workbook

Ctrl+S: Save current workbook

F4: Repeat last action

Ctrl+Up/Down Arrow: Move to the first or last cell in a column

Ctrl+X: Cut data in selected cell(s)

Ctrl+9: Hide selected rows

Ctrl+0: Hide selected columns

Ctrl+T: Create table

Shift+Arrow key: Add one cell to selection

Ctrl+Period: Move active cell clockwise

Computer Application Practice Questions

• 
  

Computer Application Practice Questions

Part A

Q1: The ………… tells the computer how to use its components.    [S B I Clerk 2009; Punjab & Sindh Bank Clerk, 2010]

A) Utility                        B) Application                           C) Operating System                     D) Network                       E) None of the above

Q2: What does C O stands in C O B O L ?        [ I  B P S Clerk, 2012]

A) Common Object                        B) Common                           C) Computer Oriented                            D)   Common Operating          E) None of the above

Q3: A computer can’t ‘boot’ if it does not have the?                    [ Union Bank Of India Clerk, 2012]

A) Compiler                     B) Loader                      C) Operating System                   D) Assembler                   E) None of the above

Q4: The function of an assembler is?       [I B P S P. O. 2011]

A) To convert basic language into machine language.

B) To convert high-level language into machine language.

C) To convert assembly language into machine language.

D) To convert assembly language into a high-level language.

E) None of the above.

Q5: Which among the following is/ are interpreted language?                 [S B I P. O. 2011]

A) C                   B) C + +                  C) Java                      D) Visual Basic                 E) Both C) and D)

Q6: A linker program?             [R B I P. O. 2009]

A) places the program in the memory for the purpose of execution.

B) relocates the program to execute from the specific memory area allocated to it.

C) links the program with other programs needed for its execution.

D) interfaces the program with the entities generating its input data.

E) None of the above.

Q7: Which of the following system software resides in the main memory always?               [ I B P S Clerk, 2011]

A) Text Editor                          B) Assembler                     C) Linker                   D) Loader                 E) None of the above

 

Find Your Answers Here

Q1: C), Q2: B), Q3: C), Q4: C), Q5: E), Q6: C), Q7: D)

Part B

Q1: The ………….. program is used to convert mnemonic code to machine code.             [S B I Clerk 2011]

A) debug                     B) C ++                   C) F O R T R A N              D) Assembler                 E) None of the above

Q2: A set of rules for telling the computer what operations to perform is called a …….? [I B P S P. O. 2012]

A) procedural language                 B) structures                    C) natural language                   D) command language                         E) programming language

Q3: Machine Language                           [S B I P. O. 2013]

A) is the language in which programs were first written.

B) is the only language understood by the computer.

C) differs from one type of computer to another.

D) All of the above.

E) None of the above.

Q4: Assembly language                           [I B P S Clerk, 2011]

A) uses alphabetic codes in place of binary numbers used in machine language.

B) is the easiest language to write programs.

C) need not be translated into machine language.

D) All of the above.

E) None of the above.

Q5: Which of the following is not a computer language?               [S B I Clerk, 2012]

A) High-level language                       B) Machine language                      C) Low-level language                   D) Medium level language                       E) None of the above

Q6: Translator program used in assembly language is called                          [ S B I Clerk, 2012]

A) compiler                     B) interpreter                       C) translation                   D) translator                    E) assembler

Q7: A(n) …… program is one that is ready to run and does not need to be altered in any way.          [I B P S P.O. 2012]

A) interpreter                         B) high-level                    C) compiler                        D) C O B O L                   E) executable

Q8: ……………. is a cross between human language and a programming language.      [I B P S P.O. 2012]

A) Pseudo code                     B) Java                      C) The Java virtual machine                    D) The compiler                       E) None of the above

Find Your Answers Here

Q1: D), Q2: E), Q3: D), Q4: A), Q5: D), Q6: E), Q7: E), Q8: A)

Part C

Q1: Which of the following is a programming language for creating special programs like applets?           [I B P S Clerk, 2012]

A) Java                B) Cobal                 C) Domain name                    D) Net                   E) C O B O L

Q2: ……………… are words that a programming language has set aside for its own use.    [I B P S P. O. 2011]

A) Control words          B) Control structures                 C) Reserved words                    D) Reserved keys                    E) None of the above

Q3: C ++ language developed by?   [I B P S Clerk 2012]

A) Dennis Ritchie                     B) Charles Babbage                    C) Niklaus Wirth                    D) Bjarne Stroustroup            E) John McCharthy

Q4: In programming, repeating some statements is usually called                     [S S C   C G L, 2013]

A) looping                     B) control structure                  C) compiling                  D) structure                 E) None of the above

Q5: F O R T R A N stands for                        [S B I Clerk, 2011]

A) Formal Translation                   B) Formative Translation                   C) Formal Transaction                  D) Formal Translation                    E) Formula Translation

Q6: Software refers to                            [I B P S Clerk, 2012]

A) the physical components that a computer is made of

B) firmware                         C) programs                          D) people ware                          E) None of the above

Find Your Answers Here

Q1: A), Q2: C), Q3: D), Q4: A), Q5: E), Q6: C

OPERATING SYSTEM

OPARETING SYSTEM

OS	Developer	Date of Release
mac OS	Apple	2001
Android	Google	2008 – present
MS-DOS	Microsoft	1981
Windows 1.0	Microsoft	November 1985
Windows 2.03	Microsoft	December 1987
Windows 98	Microsoft	June 1998
NetWare	NetWare 6.5SP8 2010, Production Closed	1983
Firefox OS	Mozilla	2013
Unix	Bell Labs	1969

Types of OS

There are many types of OS available for the users. Some of these are as follows:

1. Batch OS: In a batch OS the users don’t feed the input directly into the computer. In other words, the users don’t directly interact with the OS. They upload their data onto an offline device like a punch card and then this device interacts with the OS. This is one of the most primitive kinds of the OS.
2. Single User OS: These operating systems are intended to be used on a personal computer. That is an OS that is designed in a way that it can handle one computer or one user only is known as the single user OS>
3. Multiple User OS: This kind of OS is used to control many devices at the same time. It has man terminals or points from where different users can interact with it at a given time.
4. GUI based: GUI means the Graphics User Interface based. In these OS, the user interacts with the OS through a graphical interface that can be understood easily. Examples are the Windows, Mac and Android OS.

   Booting

   When a computer starts, the OS has to be loaded first because it has to control all the other functions of hardware and software of the computer. This process is called booting. During booting the OS loads all the hardware and software applications that are preinstalled in the memory of the computer.

   Now let us see some questions that may be asked in this section of computer awareness.

   Q 1: _________________ allocates memory and other resources in a computer.

   A) CPU                B) ALU                  C) OS                      D) RAM

   Answer: If you read what was written above, you wouldn’t hesitate to answer this question as C) Operating System.

   Q 2: Pick the odd word out of the following:

   A) DOS             B) OS          C) S          D) Mac

   Answer: DOS, Mac, and OS represent the same thing. Thus the correct option here is C) S.

   Practice Questions

   Q 1: Pick the odd word out:

   A) Software               B) Hardware               C) CPU               D) Netware

   Ans: D) Netware

   Q 2: In the following question, pick the choice that will fill the gap perfectly:

   Firefox: Mozilla, Mac: Apple, Windows: Microsoft , _______

   A) Unix: Bell Labs           B) Android: Netware       C) Windows: Vista              D) Mac: safari

   Ans: A) Unix: Bell Labs