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

Computer Gk For All Competitive Exams Series #37

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. Right clicking something in Excel:

(1) Deletes the object

(2) Nothing the right mouse button is there for left handed

people

(3) Opens a shortcut menu listing everything you can do to

the object√

(4) Selects object

(5) None of these

  1. Documentation should include

(1) Destination and users of the output data

(2) Source of input data

(3) Information on the purpose of the workbook

(4) All the above√

(5) None of these

Computer Gk For All Competitive Exams Series #38

Computer Gk For All Competitive Exams Series #36

  1. Files created with Lotus 1-2-3 have an extension

(1) DOC

(2) XLS (3) 123√

(4) WK1

(5) None of these

  1. To delete an embedded objects, first

(1) Double click the object

(2) Select the object by clicking it

(3) Press the Shift + Delete ‘ keys

(4) Select it and then press the delete key√

(5) None of these

  1. Comments can be added to cells using

(1) Edit > Comments

(2) Insert > Comments√

(3) File > Comments

(4) View > Comments

(5) None of these

  1. Which of the following is not a worksheet design

criterion?

(1) Efficiency

(2) Aditibility

(3) Description√

(4) Clarity

(5) None of these

  1. To copy cell contents using drag and drop press the

(1) End key

(2) Shift key

(3) Ctrl key

(4) Esc key√

(5) None of these

  1. Which of the following is the latest version of Excel

(1) Excel 2000

(2) Excel 2002

(3) Excel ME

(4) Excel XP√

(5) None of these

  1. When you copy a formula

(1) Excel erases the original copy of the formula

(2) Excel edits cell references in the newly copied formula√

(3) Excel adjusts absolute cell references

(4) Excel doesn’t adjust relative cell references

(5) None of these

  1. The autofill feature

(1) extends a sequential series of data

(2) automatically adds range of cell values

(3) applies a boarder around the selected cells

(4) none of the above j√

(5) None of these

731.Which menu option can be used to split windows into two

(1) View > window > split

(2) Format > window

(3) Window > split√

(4) View > split

(5) None of these

  1. You can use the formula palette to

(1) Format cells containing numbers

(2) Create and edit formulas containing functions√

(3) Enter assumptions data

(4) Copy a range of cells

(5) None of these

  1. You can convert existing excel worksheet data an

charts to an HTML document by using

(1) Internet assistant wizard√

(2) FTP wizard

(3) Intranet wizard

(4) Import wizard

(5) None of these

  1. A circular reference is

(1) Geometric modeling tool

(2) A cell that points to a drawing object

(3) A formula that either directly or indirectly depends on

itself√

(4) Always erroneous

(5) None of these

735.Which of following is Not one of Excel’s what-if function?

(1) Goal seek (2) Solver

(3) Scenario manager (4) Auto Outline√

(5) None of these

  1. When you insert an excel file into a word document.

The data are

(1) Hyperlinked placed in a word table

(2) Linked√

(3) Embedded

(4) Use the word menu bar and toolbars

(5) None of these

  1. Which of the following is not information you can specify

using the solver?

(1) Input cells√ (2) Constraints

(3) Target cell

(4) Changing cells

(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. Excel probably considers the cell entry January 1, 2000

to be a

(1) Label (2) Value√

(3) Formula

(4) Text string

(5) None of these

Computer Gk For All Competitive Exams Series #38

Computer Gk For All Competitive Exams Series #36

  1. You can enter which types of data into worksheet cells?

(1) Labels, values, and formulas√

(2) Labe31s and values but not formulas

(3) Values and formulas but not labels

(4) Formulas only

(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 #37

Leave a Comment