Computer Gk For All Competitive Exams Series #44

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. In EXCEL, you can sum a large range of data by simply

selecting a tool button called …..?

(1) AutoFill

(2) Auto correct

(3) Auto sum√

(4) Auto format

(5) None of these

Computer Gk For All Competitive Exams Series #45

Computer Gk For All Competitive Exams Series #43

 

  1. To select an entire column in MS-EXCEL, press?

(1) CTRL + C

(2) CTRL + Arrow key

(3) CTRL + S

(4) All of the above√

(5) None of these

  1. To return the remainder after a number Is divided by a

divisor In EXCEL we use the function?

(1) ROUND ( )

(2) FACTQ

(3) MODQ√

(4) DIV()

(5) None of these

  1. Which function Is not available In the Consolidate dialog

box?

(1) Pmt√

(2) Average

(3) Max

(4) Sum

(5) None of these

  1. Which Is not tha function of “Edit, Clear” command?

(1) Delete contents

(2) Del ete notes

(3) Delete eel Is√

(4) Del ete formats

(5) None of these

  1. Microsoft Excel Is a powerful………..

(1) Word processing package

(2) Spreadsheet package√

(3) Communication S/W Package ,

(4) DBMS package

(5) None of these

  1. How do you rearrange the data In ascending or

descending order?

(1) Data, Sort√

(2) Data, Form

(3) Data, Table

(4) Data Subtotals

(5) None of these

  1. Which Chart can be created in Excel?

(1) Area

(2) Line

(3) Pie

(4) All of the above√

(5) None of these

  1. What will be the output If you format the cell containing

5436.8 as ‘#,##0.00’?

(1) 5,430.00

(2) 5,436.80. √

(3) 5,436.8

(4) 6.8

(5) None of these

  1. How do you display current date and time In MS Excel?

(1) date( ) (2) Today ( )

(3) now( ) √

(4) time( )

(5) None of these

  1. How do you display current date

only in MS Excel?

(1) date ( ) (2) Today ( ) √

(3) now( )

(4) time()

(5) None of these

  1. How do you wrap the text in a cell?

(1) Format, cells, font

(2) Format, cells, protection

(3) format, cells, number

(4) Format cells, alignment√

(5) None of these

  1. What does COUNTA ( ) function do?

(1) counts cells having alphabets

(2) counts empty eel Is

(3) counts cells having number

(4) counts non-empty cells√

(5) None of these

  1. What Is the short cut key to highlight the entire column?

(1) Ctrl+C

(2) Ctrl+Enter

(3) Ctrl+PageUp

(4) Ctrl+SpaceBar√

(5) None of: ese

  1. In the formula, which symbol specifies the fixed

columns or rows?

(1) A.S (2) *√

(3) %

(4) &

(5) None of these

  1. Excel displays the current cell address In the……….

(1) Formula bar

(2) Status Bar

(3) Name Box√

(4) Title Bar

(5) None of these

  1. What Is the correct way to refer the cell AID on sheets

from sheetl?

(1) sheet3IA10√

(2) sheetllAlO

(3) Sheets-A10

(4) A10

(5) None of these

878.Which language is used to create macros in Excel?

(1) Visual Basic 4√

(2) C

(3) Visual C++

(4) Java

(5) None of these

  1. Which of the following is not a term of MS-Excel?

(1) Cells (2) Rows

(3) Columns

(4) Document√

(5) None of these

Computer Gk For All Competitive Exams Series #45

Computer Gk For All Competitive Exams Series #43

  1. How many worksheets can a workbook have?

(1) 3 (2) 8

(3) 255

(4) All of above√

(5) None of these

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

Comments

comments

Leave a Comment

error: