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

Computer Gk For All Competitive Exams Series #43

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. The default and maxium number of sheets for a new

workbook in Excel 2003 is

(1) 3 and 255 (2) 3 and 256√

(3) 1 and 255

(4) 1 and 256

(5) None of these

Computer Gk For All Competitive Exams Series #44

Computer Gk For All Competitive Exams Series #42

  1. When you enter Sunday and fill right, Excel fill in with

Monday, Tuesday and so on. From where Excel knows what

to fill in next?

(1) Auto Complete

(2) AutoFormat

(3) Custom List√

(4) Calculation Automatic

(5) None of these

843.The minimum and maximum value you can set for Save

AutoRecovery Info in Excel are

(1) 1 and 120 minutes√

(2) O and 120 minutes

(3) 2 and 60 minutes

(4) 1 and 10 minutes

(5) None of these

  1. Which of the following can not be hidden from Tools >

> Options then View tab?

(1) Startup Task Pane

(2) Formula bar

(3) Status bar

(4) Scroll Bar√

(5) None of these

  1. What happens if you remove the check mark from Row

& Column headers on Options dialog box?

(1) This will remove row headings and column headings of

your data

(2) This will remove the column headings (A, B, C,

(3) This will remove row and column heading of chart√

(4) This will remove row and column heading of table

(5) None of these

  1. The default font size in Excel worksheet is

(1) 10 points√

(2) 12 points

(3) 14 points

(4) None of above .

(5) None of these

  1. The default font used In Excel is

(1) Arlal√ (2) Algerial

(3) Times New Roman

(4) Preetl

(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. Comments can be added to cells using…..

(1) Edlt-> Comments

(2) Insert •> Comment√

(3) Fl I e-> Qomments

(4) Vlew-> Comments

(5) None of these

  1. Which menu option can be used to split windows Into

two?

(1) Format •> Widow

(2) VI ew •> Widow=> Split

(3) Wlndow->Spllt√

(4) Vlew->Spllt

(5) None of these

  1. Getting data from a cell located in a different sheet is

called.

(1) Accessing

(2) Referencing√

(3) Updating

(4) Functioning

(5) None of these

Computer Gk For All Competitive Exams Series #44

Computer Gk For All Competitive Exams Series #42

  1. Which of the following is not a valid data type in Excel?

(1) Number

(2) Character√

(3) Label

(4) Date/Time

(5) None of these

  1. Which elements of a worksheet can be protected from

accidental modification?

(1) Contents (2) Objects

(3) Scenarios

(4) All of the above√

(5) None of these

  1. A numeric value can be treated as label value If……

precedes It.

(1) Apostrophe (‘) √

(2) Exclamation (I)

(3) Hash (#)

(4) Tilde(~)

(5) None of these

  1. Concatenation of text can be done using

(1) Apostrophe (‘)

(2) Exclamation (I)

(3) Hash(#)

(4) Ampersand (&)√

(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 Tool Bar

(5) None of these

  1. Multiple calculations can be made In a single formula

using….

(1) Standard Formulas

(2) Array Formula√

(3) Complex Formulas

(4) Smart Formula

858.An Excel Workbook is a collection of…….

(1) Workbooks

(2) Worksheets

(3) Charts

(4) Worksheets and Charts√

(5) None of these

859.What do you mean by a Workspace?

(1) Group of Col umns

(2) Group of Worksheets

(3) Group of Rows

(4) Group of Workbooks√

(5) None of these

  1. MS-EXCEL is based on .-…..-?

(1) WINDOWS√ (2) DOS

(3) UNIX (4) OS/2

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

Leave a Comment

error: