Computer Gk For All Competitive Exams Series #39

Computer Gk For All Competitive Exams Series #39

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. To create a formula, you first:

(1) Select the cell you want to place the formula into√

(2) Type the equals sign (-) to tell Excel that you’re about to

enter a formula

(3) Enter the formula using any input values and the

appropriate mathematical operators that make up your

formula

(4) Choose the new command from the file menu

(5) None of these

Computer Gk For All Competitive Exams Series #40

Computer Gk For All Competitive Exams Series #38

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

must

(1) Select the cells containing the title text plus the range

over which the title text is to be centered√

(2) Widen the columns

(3) Select the cells containing the title text plus the range

over which the title text is to be enfettered

(4) Format the cells with the comma style

(5) None of these

  1. How do you delete a column?

(1) Select the column heading you want to delete and select

the Delete Row button on the standard toolbar

(2) Select the column heading you want to delete and select

Insert Delete from the menu

(3) Select the row heading you want to delete “and select

Edit>Delete from the menu

(4) Right click the column heading you want to delet and

select delete from .the shortcut menu√

(5) None of these

  1. How can you find specific information in a list?

(1) Select Tools > Finder from the menu

(2) Click the Find button on the standard toolbar

(3) Select Insert > Find from the menu

(4) Select Data > Form from the menu to open the Data√

Form dialog box and click the Criteria button

(5) None of these

  1. When integrating word and excel, word is usually the

(1) Server

(2) Destination

(3) Client

(4) Both b and c√

(5) None of these

  1. When a label is too long to fit within a worksheet cell,

you typically must

(1) Shorten the label

(2) Increase the column width√

(3) Decrease the column width

(4) Adjust the row height

(5) None of these

  1. The name box

(1) Shows the location of the previously active cell

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

(3) Appears below the status bar

(4) Appears below the menu bar

(5) None of these

  1. Comments put in cells are called

(1) Smart tip

(2) Cell tip√

(3) Web tip

(4) Soft tip

(5) None of these

  1. Which is used to perform what if analysis?

(1) Solver (2) Goal seek

(3) Scenario Manager

(4) Allof above√

(5) None of these

  1. You can use the horizontal and vertical scroll bars to

(1) Split a, worksheet into two panes

(2)View different rows and columns edit the contents of a cell√

(3) Edit the contents of a cell

(4) view different worksheets

(5) None of these

  1. Hyperlinks can be

(1) Text

(2) Drawing objects

(3) Pictures

(4) All of above√

(5) None of these

  1. To activate the previous cell in a pre-selected range,

press

(1) The Alt key

(2) The Tab key

(3) The Enter key

(4) All of the above

(5) None of these√

  1. Which button do you click to add up a series of

numbers?

(1) The autosum button√

(2) The Formula button

(3) The quicktotal button

(4) The total button

(5) None of these

  1. When the formula bar is active, you can see

(1) The edit formula button

(2) The cancel button

(3) The enter button

(4) All of the above√

(5) None of these

  1. To copy formatting from one area in a worksheet and

apply it to another area you would use:

(1) The Edit>Copy Format and Edit>Paste Format commands

form the menu.

(2) The Copy and Apply Formatting dialog box, located

under the Format>Copy and Apply menu.

(3) There is no way to copy and apply formatting in Excel –

You have to do it manually

(4) The Format Painter button on the standard toolbar√

(5) None of these

  1. In a worksheet you can select

(1) The entire worksheet

(2) Rows√

(3) Columns

(4) All of the above

(5) None of these

  1. When you link data maintained in an excel workbook to

a word document

(1) The word document can not be edit

(2) The word document contains a reference to the original

source application√

(3) The word document must contain a hyperlink

(4) The word document contains a copy of the actual data

(5) None of these

  1. Which area in an excel window allows entering values

and formulas

(1) Title bar

(2) Menu bar

(3) Formula bar√

(4) Standard toolbar

(5) None of these

Computer Gk For All Competitive Exams Series #40

Computer Gk For All Competitive Exams Series #38

  1. To hold row and column titles in place so that they do

not scroll when you scroll a worksheet click the

(1) Unfreeze panes command on the window menu

(2) Freeze panes command on the window menu√

(3) Hold titles command on the edit menu

(4) Split command on the window menu

(5) None of these

  1. To edit in an embedded excel worksheet object in a

word document

(1) Use the excel menu bar and toolbars inside the word

application√

(2) Edit the hyperlink

(3) Edit the data in a excel source application

(4) Use the word menu bar and toolbars

(5) None of these

  1. To create a formula, you can use:

(1) Values but not cell references

(2) Cell references but not values

(3) Values or cell references although not both at the same

time

(4) Value and cell references√

(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 #39”

Leave a Comment

error: