Computer Gk For All Competitive Exams Series #50

Computer Gk For All Competitive Exams Series #50

Hello readers,

If you are doing preparation for SSC, BANKS, LIC,HSSC Exams, come to us regularly. COMPUTER Gk  for SSC, BANKS, LIC,HSSC Exams like SSC CGL, SSC CHSL, BANK PO, BANK CLERK, LIC AO, haryana police, gram sachiv, clerk, canal patwari, HPSC etc. Computer General Knowledge  Computer General Knowledge Questions  haryana general knowledge and current affairs .  haryana Samanyagyan

MS- EXCEL

  1. Macros are “run” or executed from the…… menu.

(1) Insert

(2) Format

(3) Tools√

(4) Data

(5) None of these

Computer Gk For All Competitive Exams Series #49

  1. You can open the consolidate dialog box byt

choosing’ Consolidate from the…… menu.

(1) Insert

(2) Format

(3) Tools

(4) Data√

(5) None of these

  1. Each excel file is called a work-book because

(1) It can contain text and data

(2) It can be modified

(3) It can contain many sheets including worksheets and

chart sheets√

(4) You have to work hard to create it

(5) None of these

  1. 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

  1. 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

  1. What does the VLOOKUP function do?

(1) Looks up text that contain V

(2) Checks whether text is the same in one cell as in the next

(3) Finds related records√

(4) All of above

(5) None of these

  1. Gridlines

(1) May be turned off for display but turned on for printing

(2) May be turned on or off for printing

(3) The be turned off for display and printing

(4) a, b and c√

(5) None of these

  1. You can print only an embedded chart by

(1) Moving the chart to a chart sheet before you print.

(2) Formatting the chart before you print

(3) Selecting the chart before you print

(4) a and c√

(5) None of these

989.Which of the following is a cor-rect order of precedence

in a formula calculation?

(1) Multiplication and division, exponential positive and

negative value

(2) Multiplication and division, positive and negative values,

addition and subtraction

(3) Addition and subtraction, positive and negative values,

exponentiation

(4) None of above√

(5) None of these

  1. A function incite another function is called a …..function.

(1) Nested √ (2) Round

(3) Sum (4) Text

(5) None of these

  1. How should you print a selected area of a worksheet, if

you’ll want to print a different area next time?

(1) On the file menu, point to print area, and then click set

print are

(2) On the file menu, click print, j and then click selection |

under print what√

(3) On the view menu, click custom views, then click add

(4) All of above

(5) None of these

  1. Youar German supplier still in-voices for parts in

deutsche marks. How can you .have Excel convert those

sums to Euros?

(1) On the Insert menu, click Symbol and from the currency

symbols subset, select the Euro sign.

(2) On the tools menu, click Add-lns, and select the Euro

Currency Tools check box√

(3) Apply a selected background color

(4) All of above

(5) None of these

  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. If you are working in English (US), Chinese or

Japanese, Excel 2002 can speak data as you enter it, to help

you verify ac: curacy. How do you activate this feature?

(1) Point to speech on the tools menu, and then click show

text to speech toolbar. √

(2) Click validation on the data menu

(3) Point to speech on the tools menu, and then click

speech recognition

(4) All of above

(5) None of these

  1. 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

  1. when working in the page break preview, you can

(1) view exactly where each page break occurs

(2) add or remove page breaks

(3) change the print area

(4) all of above√

(5) None of these

Computer Gk For All Competitive Exams Series #49

  1. A data map is helpful

(1) When you have too much data to chart

(2) To show a geographic distri-bution of data√

(3) To compare data points

(4) To show changes in data over-time

(5) None of these

  1. In MS Access-,-a table can have__ primary key /keys.

(1) One√ (2) Two

(3) Three (4) Four

(5) None of these

  1. __ 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

  1. The horizontal and vertical lines on a worksheet are

called

(1) cells√ (2) sheets

(3) blocklines

(4) gridlines

(5) None of these

Thank you for reading the Computer gk questions answers for SSC, BANK, HSSC exams.

Comments

comments

Leave a Comment

error: