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

1. Which is not an advantage of using computerized spreadsheets?

A. flexibility of moving entries B. ability of generate tables
C. cost of initial setup D. speed of calculation

2. To select several cells or ranges that are not touching each other, you would … while selecting

A. hold down the Ctrl key B. hold down the Shift key
C. hold down the Alt key D. hold down Ctrl + Shift key

3. what is the AutoSummarize feature used for in Word 2000

A. It creates a 250 word, 500 word or 1000 word summary of the document B. It adds Automatic headwers, bold and italic characters as well as automatic formatting of the document to give the look of a well summarized document
C. it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs D. It identifies the key points in a document for your to share with others or quickly scan

4. A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button…..

A. only the cells with white background will print B. the whole sheet will print
C. only the cells with gray background will print D. nothing will print because some cells with data have been omitted

5. A constant is another name for this type of data:

A. description B. formula
C. number D. equation

6. You can insert labels for

A. All the data markers on a chart B. A data series
C. A selected data marker D. All

7. What does SUMIF function do?

A. Adds up cell values based on a condition B. Adds all the numbers in a range of cells
C. Returns a subtotal in a list or database D. All of above

8. Graphics objects on a chart are used to

A. Add emphasis to chart data B. Help explain the chart data
C. Add interest to a chart D. All

9. Which of the following displays the contents of the active cell?

A. Active cell B. Formula bar
C. Menu bar D. Name box

10. Book1 is an example of how … are numbered and named during each work session

A. Active cell B. Formula bar
C. Menu bar D. Name box

Related Topics

Basics of Computers
Ms Excel For IBPS Mains
Keyboard Shortcuts
Computer Knowledge Interview
Computer Networking Basics

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

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