Computer Gk For All Competitive Exams Series #42

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 Delete key of keyboard is assigned to which

command in Excel?

(1) Edit » Clear» Contents√

(2) Edit» Clear» All

(3) Edit» Delete

(4) All of above

(5) None of these

Computer Gk For All Competitive Exams Series #43

Computer Gk For All Competitive Exams Series #41

  1. If you need to remove only the formatting done in a

range (numbers and formula typed there should not be

removed), you must

(1) From Edit menu choose Clear and then Formats√

(2) From Edit menu choose Delete

(3) Click on Remove Formatting tool on Standard Toolbar

(4) Double click the Format Painter and then press Esc key

in keyboard

(5) None of these

  1. By default Excel provides 3 worksheets. You need only

two of them, how will you delete the third one?

(1) Right click on Sheet Tab of third sheet and choose Delete

from the context menu√

(2) Click on Sheet 3 and from Edit menu choose Delete

(3) Click on Sheet 3 and from Edit menu choose Insert

(4) None of above

(5) None of these

  1. Which of the following action removes a sheet from

workbook?

(1) Select the sheet, then choose Edit > > Delete Sheet√

(2) Select the sheet then choose Format » Sheet » Hide

(3) Press Insert

(4) All of above

(5) None of these

  1. While Finding and Replacing some data in Excel, which

of the following statement is valid?

(1) You can Find and Replace within the sheet or workbook√

(2) Excel does not have option to match case for find

(3) Excel cannot replace

(4) None are valid

(5) None of these

  1. Which of the following is not true about Find and

Replace in Excel

(1) You can search for bold and replace with italics

(2) You can decide whether to look for the whole word or not

(3) You can search in formula too

(4) You can search by rows or columns or sheets√

(5) None of these

  1. You can move a sheet from one workbook into new

book by

(1) From Edit menu choose Move or Copy sheet mark the

Create a copy and Click OK

(2) From Edit menu choose Move of Copy then choose

{Move to end) and click OK

(3) From Edit menu choose Move or Copy then select {new

book) from To Book list and click OK√

(4) All of above

(5) None of these

  1. What is the short cut key to replace a data with another

in sheet?

(1) Ctrl + R (2) Ctrl + Shift + R

(3) Ctrl + H (4) Ctrl + F√

(5) None of these

  1. Which of the following is invalid regarding the Protection

in Excel?

(1) Protect Sheet

(2) Protect Workbook

(3) Protect Workspace√

(4) All of above are valid

(5) None of these

830.The Trace Precedence on Auditing shows

(1) Which cells are used in current formula√

(2) In which formula the current cell is used

(3) Which cells are used in this formula and in which

formula this cell is used

(4) None of above

(5) None of these

831.The Trace Dependence in auditing shows

(1) Which cells are used in current formula

(2) In which formula the current cell is used√

(3) Which cells are used in this formula and in which

formula this cell is used

(4) All of above

(5) None of these

  1. The arrows created by Auditing can be removed by

(1) Click on the arrow and press Delete ‘

(2) Click on Remove All arrows on Formula Auditing

toolbar√

(3) Both of above

(4) Press insert

(5) None of these

  1. Which of the following options i not available to remove

arrows of Formula Auditing?

(1) Remove all preceden arrows

(2) Remove all dependent arrows

(3) Remove all arrows

(4) Remove all arrows for this cell√

(5) None of these

  1. Excel is a good application for What IF analysis. Which

of the following tool help you for this?

(1) Formul Auditing

(2) Research

(3) Track Change

(4) Goal Seek√

(5) None of these

  1. Which of the following tool you will use in Excel to see

what must be the value of a cell to get required result?

(1) Formul Auditing

(2) Research

(3) Track Change

(4) Goal Seek√

(5) None of these

  1. To apply Goal Seek command your cell pointer must be in

(1) The Changing cell whose value you need to find

(2) The Result Cell where formula is entered√

(3) The cell where your targeted value is entered

(4) All of above

(5) None of these

Computer Gk For All Competitive Exams Series #43

Computer Gk For All Competitive Exams Series #41

  1. Which of the following is not What IF analysis tool in

Excel?

(1) Goal Seek (2) Scenarios

(3) Macros√

(4) All of above

(5) None of these

  1. You can set Excel in Automatic or Manual calculation

mode. If it is in manual mode which key you will press to

update the formula values?

(1) F9√ (2) F5

(3) F8 (4) F11

(5) None of these

  1. By default the cell pointer moves down when you press

Enter. From where can you change this setting?

(1) Tools > > Options » View tab

(2) Tools » Options » Calculation tab

(3) Tools » Options » Edit tab√

(4) Tools » Options » Transition tab

(5) None of these

  1. When you start typing the same value as of some cells

on same column, Excel automatically shows that text. This

feature is known as

(1) AutoFill (2) AutoCorrect

(3) AutoComplete√

(4) AutoFormat

(5) None of these

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

Comments

comments

Leave a Comment

error: