Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in Microsoft Excel. It will be useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

  1. A(n) ____ is a pre written formula that is built into Excel.
    A. argument
    B. array
    C. worksheet
    D. function
    D. function

  2. ________ allows you to create or modify a worksheet while viewing how it will look in printed format.
    A. Normal View
    B. Page Layout View
    C. Print Preview
    D. Review
    B. Page Layout View

  3. The default view for a worksheet is______
    A. Normal View
    B. Standard View
    C. Page View
    D. Basic View
    A. Normal View

  4. To move the previous worksheet press _______
    A. Alt + PgUp
    B. Ctrl + PgUp
    C. Ctrl + PgDn
    D. Alt + PgDn
    B. Ctrl + PgUp

  5. The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called ________
    A. freezing
    B. locking
    C. selecting
    D. fixing
    A. freezing

  6. ______ keep the top row visible while scrolling through the rest of the Worksheet.
    A. Freeze Panes
    B. Freeze Topview
    C. Freeze First Column
    D. None of the above
    B. Freeze Topview

  7. To select several cells or ranges that are not touching each other, you would ____ while selecting
    A. Hold down the control button
    B. hold down the shift key
    C. hold down the control key
    D. hold down the control and shift key
    A. Hold down the control button

  8. To access the Go To dialog box in Excel you can press?
    A. Ctrl+G
    B. Ctrl+H
    C. Ctrl+O
    D. Ctrl+A
    A. Ctrl+G

  9. When you create two or four separate windows containing part of the spreadsheet that can be viewed, you have created _________
    A. sections
    B. panes
    C. views
    D. sub sheets
    B. panes

  10. A cell is referred to by its unique address, called a(n) ____, which is the coordinates of the intersection of a column and a row.
    A. Cell reference
    B. Name box
    C. Unit
    D. Active cell
    A. Cell reference

LEAVE A REPLY

Please enter your comment!
Please enter your name here