Computer Gk For All Competitive Exams Series #33

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. Youar German supplier still invoices 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

Computer Gk For All Competitive Exams Series #34

Computer Gk For All Competitive Exams Series #32

  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

accuracy. 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 bf these

  1. Which of the following methods can not be used to enter

data in a cell?

(1) Pressing an arrow key

(2) Pressing the tab key

(3) Pressing the Esc key√

(4) Qlicking the enter button to the formula bar

  1. Which of the following will not set text in selected cells to

italics?

(1) Pressing Ctrl + I on the keyboard

(2) Using the Tools – Wizard -Web Form menu item√

(3) Using the Format – Cells -Font menu item

(4) All of the above

(5) None of these

  1. Which of the following methods cannot be used to edit

the content of cell?

(1) Pressing the Alt key√

(2) Clicking the formula bar

(3) Pressing F2

(4) Double clicking the cell

(5) None of these

  1. You can activate a cell by

(1) Pressing the Tab key

(2) Clicking the cell

(3) Pressing an arrow key

(4) All of above√

(5) None of these

  1. Which of the following setup options can not be set in the

page setup dialog box?

(1) Printer selection√

(2) Vertical or horizontal placement

(3) Orientation

(4) Row and column titles

(5) None of these

  1. What term refers to a specific set of values saved with

the workbook?

(1) Range (2)

(3) Trend line√

(4) What-if analysis

(5) None of these

  1. Got functions? No? You need the insert function dialog

box. How do you get it?

(1) Right click a cell and then click insert

(2) Click the insert menu and then click function√

(3) Type – in a cell

(4) All of the above

(5) None of these

  1. Which of the following describes how to select all the

cells in a single column?

(1) Right click on column and select Pick from list

(2) Use data – text to columns menu item

(3) Left click on the gray column title button√

(4) Pressing Ctrl + A on the keyboard

(5) None of these

  1. When you use the fill effects in the format data series

dialog box, you can not

(1) rotate text on the chart√

(2) select a fore ground color

(3) select a pattern

(4) select a background color

(5) None of these

  1. Paper spreadsheets can have all the same advantages

as an electronic spreadsheet except which of the following?

(1) Rows and columns

(2) Headings

(3) Speed√

(4) All of above

(5) None of these

  1. Which of the following is not a basic step in creating a

worksheet?

(1) Save the workbook

(2) Modify the worksheet

(3) Enter text and data

(4) Copy the worksheet√

(5) None of these

  1. What’s a quick way to extend these numbers to a longer

sequence, for instance 1 through 20?

(1) Select both cells, and then drag the fill handle over the

range you- want, for instance 18 more rows√

(2) Select the range you want, include both cells, point to

fill on the Edit menu, and then click down.

(3) Copy the second cell, click in the cell below it, on the

standard toolbar click the down arrow on the Paste button,

and then click Paste Special

(4) All of above

(5) None of these

  1. To insert three columns between columns D and E you

would

(1) Select column D

(2) Select column E√

(3) Select columns E, F and G

(4) Select columns D, E, and F

(5) None of these

  1. To center worksheet titles across a range of cell, you

must

(1) Select the cells containing the title text and use the fill

handle to center the text across a range of cells√

(2) Widen the columns

(3) Select the cells containing the title text and use the fill

handle to center the text across a range of cells

(4) Widen the column

(5) None of these

Computer Gk For All Competitive Exams Series #34

Computer Gk For All Competitive Exams Series #32

658.When integrating Ms-Word and Excel, Word is usually the

(1) Server

(2) Source

(3) Client√

(4) None

(5) None of these

  1. Charts tips can

(1) Show the formatting of a data label

(2) Show the name of a data series

(3) Show the value of data point

(4) b and c√

(5) None of these

  1. The Name box

(1) Shows the location of the previously active cell

(2) Appears t the left of the formula bar√

(3) Appears below the status bar

(4) Appears below the menu bar

(5) None of these

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

Comments

comments

Leave a Comment

error: