Basic Computer Knowledge :: Ms Excel For IBPS PO LIC AAO Question And Answers

1. The view that puts a blue a blue line around each page that would be printed is the …..

A. Split View B. Page Break Preview
C. Normal View D. Print Preview

2. AutoCalculate will quickly add selected cells if you…..

A. right click on the status bar and select Sum B. click the AutoCalculate button on the toolbar
C. use the key combination Ctrl+$ D. Double click the selection

3. The cell labeled 23. 54 the cell labeled F5 refers to

A. row F column 5 B. column F row 5
C. function available in cells D. function key F4

4. when you are typing an equation into a cell the first thing that must be entered is

A. the first cell referenced B. an equal sign
C. quotation marks D. parenthesis

5. Using the AutoSum button will replace in the selected cell….

A. the sum of values  in the cell’s column B. a formula which will add values in the range Excel guesses you want to add
C. the sum of the cell’s row unless you change the range D. nothing until you select a range of cells

6. To copy cell contents using drag and drop, press the

A. End key B. Esc key
C. Shift key D. None of above

7. If you press …., the cell accepts your typing as its contents.

A. Enter B. Ctrl + Enter
C. TAB D. Insert

8. The autofill feature

A. Extends a sequential series of data B. Applies a boarder around selected cells
C. Automatically adds a range of cell values D. None of above

9. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

A. F3 B. F11
C. F7 D. F5

10. you can use the formula palette to

A. format cells containing numbers B. create and edit formulas containing functions
C. entered assumptions data D. copy a range of cells

Related Topics

Basic Computer Quiz
Computer LIC AAO 2016
Keyboard Shortcuts
Computer Model Paper 10

Who are all can get the advantages from this Ms Excel For IBPS PO LIC AAO Question and Answers section?

Those are all planning for any competitive examinations can use this segment to enhance their abilities.