Computer Gk For All Competitive Exams Series #41 | Hindigk50k
Computer Gk For All Competitive Exams Series #41

Computer Gk For All Competitive Exams Series #41

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. How can you show or hide the gridlines in Excel

Worksheet?

(1) Go to Tools >> Options > > View tab and mark or

remove the check box named Gridline

(2) Click Gridline tool on Forms toolbar

(3) Both of above√

(4) Press F7

(5) None of these

Computer Gk For All Competitive Exams Series #42

Computer Gk For All Competitive Exams Series #40

  1. Which of the following Excel screen components can

NOT be turned on or off ?

(1) Formula Bar

(2) Status Bar

(3) Tool Bar

(4) All of above

(5) None of these√

  1. What happens when you press Ctrl + X after selecting

some cells in Excel?

(1) The cell content of selected cells disappear from cell and

stored in clipboard

(2) The cells selected are marked for cutting√

(3)The selected cells are deleted and the ceils are shifted left

(4)The selected cells are deleted and cells are shifted up

(5) None of these

  1. Which of the following option is not available in Paste

Speciat dialog box?

(1) Add (2) Subtract

(3) Divide (4) SORT√

(5) None of these

  1. Which command will you choose to convert a column of

data into row?

(1) Cut and Paste

(2) Edit » Paste Special » Transpose√

(3) Both of above

(4) Press F7

(5) None of these

  1. It is acceptable to let long text flow into adjacent cells on

a worksheet when

(1) data will be entered in the adjecent cells

(2) no data will be entered in the adjacent cells√

(3) there is no suitable abbrevition for the text

(4) there is not time to format the text

(5) None of these

  1. Which of the cell pointer indicates you that you can

make selection?

(1) Doctor’s symbol (Big Plus) √

(2) small thin plus icon

(3) Mouse Pointer with anchor at the tip

(4) Press F3 + Ctrl

(5) None of these

808.Which of the cell pointer indicates that you can fill

series?

(1) Doctor’s symbol (Big Plus)

(2) small thin plus icon√

(3) Mouse Pointer with anchor at the tip

(4) All of above

(5) None of these

  1. Which of the cell pointer indicate that you can move the

content to other cell?

(1) Doctor’s symbol (Big Plus)

(2) small thin plus icon

(3) Mouse Pointer with anchor at the tip√

(4) All of above

(5) None of these

  1. You can auto fit the width of column by

(1) double clicking on the column name orr-column header

(2) Double click on the cell pointer in worksheet

(3) Double clicking on column right border on column

header√

(4) Double clicking on the column left border of column

header

(5) None of these

  1. Long text can be broken down into many lines within a

cell. You can do this through We have 83

(1) Wrap Text in Format > > Cells guests online√

(2) Justify in Edit > > Cells

(3) Text Wraping in Format » Cells, Layout tab

(4) All of above

(5) None of these

  1. When a row of data is to be converted into columns

(1) Copy the cells in row, select the same number of cells

in row and paste

(2) Copy the cells in column then choose Edit > > Paste

Special, then click Transpose and OK

(3) Copy the cells then go to Format > > Cells then on

Alignment tab click Transpose check box and click OK

(4) Select the cells then place the cell pointer on new cell

and choose Edit » Paste Special, mark Transpose check box

and click OK. √

(5) None of these

  1. Ctrl +p shortcut key in Excel will

(1) Open the font dialog box

(2) Apply double underline for the active cell

(3) Fill down in the selection√

(4) All of above

(5) None of these .

814.The short cut key Ctrl +R is used in Excel to

(1) Right align the content of cell

(2) Remove the cell contents of selected cells

(3) Fill the selection with active t cells to the right√

(4) All of above

(5) None of these

  1. The command Edit »Fill Across Worksheet is active

only when

(1) One sheet is selected

(2) When many sheets are selected√

(3) When no sheet is selected

(4) All of above

(5) None of these

  1. Which of the following series type is not valid for Fill

Series dialog box?

(1) Linear (2) Growth

(3) Autofill (4) Time√

(5) None of these

  1. Which of the following you can paste selectively using

Paste Special command?

(1) Validation (2) Formats

(3) Formulas (4) All of above√

(5) None of these

  1. Paste Special allows some operation while you paste to

new cell. Which of the following operation is valid?

(1) Square (2) Percentage

(3) Goal Seek (4) Divide√

(5) None of these

  1. L Edit» Delete command

(1) Deletes the content of a cell

(2) Deletes Formats of cell

(3) Deletes the comment of cell

(4) Deletes selected cells√

(5) None of these

Computer Gk For All Competitive Exams Series #42

Computer Gk For All Competitive Exams Series #40

820.To remove the content of selected cells you must issue

_____ command

(1) Edit» Delete

(2) Edit » Clear » Contents√

(3) Edit »> Clear» All

(4) Data » Delete

(5) None of these

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

Comments

comments

1 thought on “Computer Gk For All Competitive Exams Series #41

Leave a Comment