Current Affairs PDF

Computer Questions Set- 82

By
AC Team 1
-

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

Hello Aspirants. Welcome to Online Computer Quiz in AffairsCloud.com. Here we are creating quiz covering important topics in computer awareness, which is common for all the SBI/IBPS/LDC exams and other competitive exams. We have included questions that are repeatedly asked in many bank exams !!!

 

  1. Which function calculates your monthly mortage payment________
    (1) PMT (payments)
    (2) NPER (number of periods)
    (3) PV (present value)
    (4) All of above
    (5) None of these
    (1) PMT (payments)

  2. You can open the Sort dialog box by choosing Sort from the_______menu.
    (1) View
    (2) Format
    (3) Tools
    (4) Data
    (5) None of these
    (4) Data

  3. In MS Access, a table can have________primary key /keys.
    (1) One
    (2) Two
    (3) Three
    (4) Four
    (5) None of these
    (1) One

  4. _______cells involves creating a single cell by combining two or more selected cells.
    (1) Formatting
    (2) Merging
    (3) Embedding
    (4) Splitting
    (5) None of these
    (2) Merging

  5. The horizontal and vertical lines on a worksheet are called________
    (1) cells
    (2) sheets
    (3) blocklines
    (4) gridlines
    (5) None of these
    (1) cells

  6. The most common subtotal used Subtotals command is the________function, which causes Excel to display a sum each time the corurol field change.
    (1) ADD
    (2) SUM
    (3) TOTAL
    (4) LIST
    (5) None of these
    (2) SUM

  7. By default, Excel positions text in a cell_______
    (1) left-aligned
    (2) right-aligned
    (3) centered
    (4) justified
    (5) None of these
    (1) left-aligned

  8. To centre a paragraph using shortcut keys, press_______
    (1) CTRL + C
    (2) CTRL + E
    (3) CTRL + L
    (4) CTRL + R
    (5) None of these
    (2) CTRL + E

  9. Which types of charts can excel produce________
    (1) Line graphs and pie charts only
    (2) Only line graphs
    (3) Bar charts, line graphs and pie charts
    (4) Bar charts and line graphs only
    (5) None of these
    (3) Bar charts, line graphs and pie charts

  10. How are data organized in a spreadsheet________
    (1) Lines and spaces
    (2) Layers and planes
    (3) Rows and columns
    (4) Height and width
    (5) None of these
    (3) Rows and columns





RELATED ARTICLESMORE FROM AUTHOR