Computer Gk For All Competitive Exams Series #32

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. The cell reference for a range of cells that starts in cell Bl

and goes over to column G and down to row 10 is ….

(1) G1-G10

(2) B1.G10

(3) B1;G10

(4) B1:G10√

(5) None of these

  1. A user wishes to remove a spreadsheet from a

workbook. Which is the correct sequence ofsgyents that will

do this?

(1) Go to File-Save As – Save As Type – Excel worksheet

(2) Right click on the spreadsheet tab and setect

DELETE√

(3) Right click on the spreadsheet and select Insert –

Entire Column

(4) None of above

(5) None of these

Computer Gk For All Competitive Exams Series #33

Computer Gk For All Competitive Exams Series #31

  1. What feature enables you to adjust or back solve the

value in a cell to reach a desired outcome in a formula?

(1) Scenario Summary report

(2) Goal Seek

(3) Forecasting

(4) Trend line√

(5) None of these

  1. what term describes a background that appears as

a grainy, non smooth surface

(1) gradient√

(2) pattern

(3) solid

(4) texture

(5) None of these

  1. Excel is a

(1) Graphic program

(2) None of these

(3) Word processor

(4) A spreadsheet√

(5) None of these

  1. To create an interactive Pivot Table for the web, you use

a Microsoft Office Web component called

(1) HTML

(2) Pivot Table Field List

(3) Pivot Table List

(4) Pivot Table Report√

(5) None of these

  1. What function cJtsplays row data in a column or column

data in a row?

(1) Hypertink (2) Index

(3) Transpose√

(4) Rows

(5) None of these

  1. When you insert an Excel file into a Word document, the

data are

(1) Hyperlinked (2) Placed in a word table√

(3) Linked

(4) Embedded

(5) None of these

  1. Except for the …… function, a formula with a logical

function shows the word “TRUE” or “FALSE” as a result

(1) IF√ (2) AND

(3) OR (4) NOT

(5) None of these

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

(1) Insert

(2) Format

(3) Tools√

(4) Data

(5) None of these

  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 workbook 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

Computer Gk For All Competitive Exams Series #33

Computer Gk For All Competitive Exams Series #31

  1. Which of the following is a correct 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) All of above

(5) None of these√

  1. A function inside 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 area.

(2) On the file menu, click print, 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

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

Comments

comments

Leave a Comment

error: