MS Excel Questions Answers for bank exams IBPS PO, IBPS RRB, NIACL, NICL, LIC, BOI, Bank of Baroda and other competitive exams
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
thanks AZ_/_
insert the current date or time Ctrl] and ; (semicolon) or Ctrl and : (colon)
ty:))
5th ans CC===CTRL + ;
ty AZ
CTRL + T===for new tab?
TY
ctrl+; =current date
thank you team AZ for all new questions and i appreciate you for your arduous efforts….
nice nd new questions…tyy azz..:):)
ctrl+ ; for current date
ctrl+shift+; for current time
please correct it
thank u mam
957191 797824Hello, Neat post. There is really a problem with your web site in internet explorer, could test thisK IE nonetheless will be the marketplace leader and a large portion of people will leave out your excellent writing due to this dilemma. 27589