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

841. 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

842. 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

844. 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

845. 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

846. 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

847. The default font used In Excel is

(1) Arlal√ (2) Algerial

(3) Times New Roman

(4) Preetl

(5) None of these

848. Comments put in cells are called…..

(1) Smart Tip

(2) Cell Tip√

(3) Web Tip

(4) Soft Tip

(5) None of these

849. 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

850. 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

851. 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

852. 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

853. 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

854. 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

855. Concatenation of text can be done using

(1) Apostrophe (‘)

(2) Exclamation (I)

(3) Hash(#)

(4) Ampersand (&)√

(5) None of these

856. 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

857. 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

860. 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