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
- 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
- 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
- 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
- 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
- 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
- The default font used In Excel is
(1) Arlal√ (2) Algerial
(3) Times New Roman
(4) Preetl
(5) None of these
- Comments put in cells are called…..
(1) Smart Tip
(2) Cell Tip√
(3) Web Tip
(4) Soft Tip
(5) None of these
- 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
- 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
- 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
- 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
- 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
- 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
- Concatenation of text can be done using
(1) Apostrophe (‘)
(2) Exclamation (I)
(3) Hash(#)
(4) Ampersand (&)√
(5) None of these
- 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
- 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
- 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.
1 thought on “Computer Gk For All Competitive Exams Series #43”