Computer Gk For All Competitive Exams Series #40

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. Status indicators are located on the

(1) Vertical scroll bar

(2) Horizontal scroll bar

(3) Formula bar√

(4) Standard toolbar

(5) None of these

Computer Gk For All Competitive Exams Series #41

Computer Gk For All Competitive Exams Series #39

  1. Which of the following is the oldest spreadsheet

package?

(1) VisiCalc√ 2) Lotus 1-2-3

(3) Excel

(4) StarCalc

(5) None of these

  1. Pounding errors can occur

(1) When you use multiplication, division, or exponentiation

in a formula√

(2) When you use addition and subtraction in a formula

(3) Because excel uses hidden decimal places in

computation

(4) When you show the results of formulas with different

decimal places that the calculated results

(5) None of these

  1. You can copy data or formulas

(1) Wrth the copy, paste and cut commands on the edit

menu

(2) With commands on the shortcut menu

(3) Wjth buttons on the standard toolbars

(4) All of the above√

(5) None of these

  1. You can not link excel worksheet data to a word

document

(1) With the right drag method

(2) With a hyperlink

(3) With the copy and paste special commands

(4) With the copy and paste buttons on the standard

toolbar. √

(5) None of these

786.Which of the following is a popular DOS based spreadsheet

package?

(1) Word 2) Smart cell

(3) Excel

(4) Lotus 1-2-3√

(5) None of these

  1. An excel workbook is a collection of

(1) Workbooks

(2) Worksheets

(3) Charts

(4) Worksheets and charts√

(5) None of these

  1. Excel files have a default extension of

(1) Xls √ (2) Xlw

(3) Wkl (4) 123

(5) None of these

  1. You can use the format painter multiple times before

you turn it off by

(1) You can use the format painter button on ly one time

when you click it

(2) Double clicking the format painter button√

(3) Pressing the Ctrl key and clicking the format painter

button

(4) Pressing the Alt key and clicking the format painter

button

(5) None of these

  1. You can use the formula pallette to

(1) format cells containing numbers

(2) create and edit formula containing functions√

(3) enter assumptions data

(4) copy a range of cells

(5) None of these

  1. When a range is selected, how can you activate the

previous cell?

(1) Press the Alt key

(2) Press Tab

(3) Press Enter

(4) All of above√

(5) None of these

  1. Which tool you will use to join some cells and place the

content at the middle of joined cell?

(1) From Format Cells dialog box click on Merge Cells

check box

(2) From Format Cells dialog box select the Centered

alignment

(3) -From Format Cells dialog box choose Merge and

Center check box

(4) Click on Merge and Center tool on formatting toolbar

(5) None of these√

  1. Tab scroll buttons are place on Excel screen

(1) towards the bottom right corner

(2) towards the bottom left corner√

(3) towards the top right corner

(4) towards the top left corner

(5) None of these

  1. The Name box on to the left of formula bar

(1) shows the name of workbook currently working on

(2) shows tne name of worksheet currently working on

(3) shows the name of cell or range currently working on√

(4) All of above

(5) None of these

  1. Each excel file is a workbook that contains different

sheets. Which of the following can not be a sheet in

workbook?

(1) worksheet

(2) chart sheet

(3) module sheet

(4) data sheet√

(5) None of these

Computer Gk For All Competitive Exams Series #41

Computer Gk For All Competitive Exams Series #39

  1. Which of the following is not the correct method of

editing the cell content?

(1) Press the Alt key√

(2) Press the F2 key

(3) Click the formula bar

(4) Double click the cell

(5) None of these

797.You can merge the main document with data source

in Excel. In mail merge operation, Word is usually

(1) server

(2) source

(3) client√

(4) none

(5) None of these

  1. How can you update the values of formula cells if Auto

Calculate mode of Excel is disabled?

(1) F8

(2) F9√

(3) F10

(4) F11

(5) None of these

  1. You want to set such that when you type Baishakh and

drag the fill .handle. Excel should produce Jestha, Aashadh

and so on. What will you set to effect that?

(1) Fill Across Worksheet

(2) Custom List√

(3) Auto Fill Options

(4) Fill Series

(5) None of these

  1. Where can you change automatic or manual

calculation mode in Excel?

(1) Double CAL indicator on status bar

(2) Go to Tools > > Options > > Calculation and mark the

corresponding radio button√

(3) Both of above

(4) Press F7

(5) None of these

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

Comments

comments

Leave a Comment

error: