Computer: MS Excel Questions Set 4

MS Excel Questions Answers for bank exams IBPS PO, IBPS RRB, NIACL, NICL, LIC, BOI, Bank of Baroda and other competitive exams

  1. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
    A) Re-format the spreadsheet
    B) Insert a row
    C) Increase the column width
    D) Use the space bar
    E) none of these
    View Answer
     Option B
  2. What is the keyboard shortcut for creating a chart from the selected cell range?
    A) F11
    B) F8
    C) F4
    D) F2
    E) none of these
    View Answer
     Option A
  3. If particular workbook have to open each time Excel started, where that workbook should be placed?
    A) AUTOEXEC Folder
    B) AUTOSTART Folder
    C) EXCELSTART Folder
    D) XLSTART Folder
    E) none of these
    View Answer
     Option D
  4. If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
    A) =A1 + “@” + B1
    B) =A1 # “@” # B1
    C) =A1 & “@” & B1
    D) =A1 $ “@” $ B1
    E) None of these
    View Answer
     Option C                 
  5. What is the shortcut key to insert current date in a cell?
    A) CTRL + D
    B) CTRL + T
    C) CTRL + ;
    D) CTRL + /
    E) none of these
    View Answer
     Option C
  6. You can zoom a worksheet
    A) With the mouse pointer in Print Preview
    B) With the zoom button on the Print Preview toolbar
    C) With the Zoom command on the view menu
    D) All of the above
    E) none of these
    View Answer
     Option D  
  7. Data marker on a chart are linked to data points in a worksheet, therefore,
    A) You can automatically apply formatting to a data series
    B) You can change the position of a data marker and automatically change the data point value in the worksheet
    C) You can change a data print value and automatically are draw the chart
    D) a and b
    E) none of these
    View Answer
     Option B
  8. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
    A) Unfreeze panes command on the window menu
    B) Freeze panes command on the window menu
    C) Hold titles command on the edit menu
    D) Split command on the window menu
    E) none of these
    View Answer
     Option B
  9. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
    A) F3
    B) F5
    C) F7
    D) F11
    E) None of these
    View Answer
     Option D
  10. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
    A) Goal Seek
    B) Scenario Summary report
    C) Forecasting
    D) Trend line
    E) None of these
    View Answer
     Option D

 

 

 

Related posts

11 Thoughts to “Computer: MS Excel Questions Set 4”

  1. ALISA(Trouper:)))))

    thanks AZ_/_

  2. Sachin Shukla

    insert the current date or time Ctrl] and ; (semicolon) or Ctrl and : (colon)

  3. Marry..

    5th ans CC===CTRL + ;

  4. Marry..

    CTRL + T===for new tab?

  5. wont rest until i get success

    TY

  6. swati

    ctrl+; =current date

    thank you team AZ for all new questions and i appreciate you for your arduous efforts….

  7. KaRi$hMa

    nice nd new questions…tyy azz..:):)

  8. KaRi$hMa

    ctrl+ ; for current date
    ctrl+shift+; for current time
    please correct it

Leave a Comment