Computer Gk For All Competitive Exams Series #36

Computer Gk For All Competitive Exams Series #36

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. How many characters can be typed in a single cell in

Excel?

(1) 256 (2) 1024

(3) 32,000 (4) 65,535√

(5) None of these

  1. A worksheet can have a maximum of…. Number of

rows

(1) 256 (2) 1024

(3) 32,000 (4) 65,535√

(5) None of these

Computer Gk For All Competitive Exams Series #37

Computer Gk For All Competitive Exams Series #35

  1. Which of the following is not an example of a value?

(1) 350

(2) May 10,2001

(3) 57%

(4) Serial Number 50771√

(5) None of these

  1. The chart wizard term data series refers to

(1) A chart legend

(2) A collection of chart data markers√

(3) A set of values you plot in a chart

(4) A data label

(5) None of these

  1. The Chart wizard term data categories refers to;

(1) A chart plot area

(2) A horizontal axis√

(3) The organization of individual values with a chart’s data

series

(4) The data range that supply chart data

(5) None of these

  1. A worksheet range is a

(1) A command used for data modeling

(2) A range of values such as from 23 to 234

(3) A group of cells√

(4) A group of worksheets

  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

  1. Tab scrolling button

(1) Allow you to view a different worksheet

(2) Allow you to view additional worksheet rows down

(3) Allow you to view additional worksheet columns to the

right

(4) Allow you to view additional sheets tabs√

(5) None of these

  1. Data can be arranged in a worksheet in a easy to

understand manner using

(1) auto formatting

(2) applying styles

(3) changing fonts

(4) all of above√

(5) None of these

  1. You can use drag-and-drop to embed excel worksheet

data in a word document

(1) By dragging a range of excel data to the word button on

the taskbar while pressing the Ctrl key√

(2) By dragging a range of excel data to the word button on

the taskbar while pressing Shift key

(3) By dragging a range of excel data to the word button on

the taskbar while pressing Alt key

(4) None of above

(5) None of these

  1. Excel uniquely identifies cells within a worksheet with a

cell name

(1) Cell names

(2) Column numbers and row letters

(3) Column letters and row numbers√

(4) Cell locator coordinates

(5) None of these

  1. To view a cell comment

(1) click the edit comment command on the insert menu

(2) click the display comment command on the window

menu

(3) position the mouse pointer over the cell√

(4) click the comment command on the view menu

(5) None of these

  1. When you want to insert a blank imbedded excel object

in a word document you can

(1) Click the object command on the insert menu√

(2) Click the office links button on the standard toolbar

(3) Click the create worksheet button on the formatting

toolbar

(4) Click the import excel command on the file menu

(5) None of these

  1. To save a workbook, you:

(1) Click the save button on the standard toolbar from the

menu√

(2) Press Ctrl+F5

(3) Click Save on the Windows Start button

(4) Select Edit>Save

(5) None of these

  1. You can edit a cell by

(t) Clicking the formula button

(2) Double clicking the cell to edit it in-place√

(3) Selecting Edit > Edit Cell from the menu

(4) None of above

(5) None of these

  1. You can select a single range of cells by

(1) Clicking the upper-left cell in a group of cells and then

pressing the Shift key while clicking the lower right cell in a

group of cells

(2) Pressing the Ctrl key while dragging over the desired

cells

(3) Pressing the Shift key and an arrow key

(4) Dragging over the desired cells Correct√

(5) None of these

Computer Gk For All Competitive Exams Series #37

Computer Gk For All Competitive Exams Series #35

  1. Which elements of worksheet can be protected from

accidental modification

(1) Contents

(2) Objects

(3) Scenarios

(4) All of above√

(5) None of these

  1. You can use the drag and drop method to

(1) Copy cell contents

(2) Move cell contents

(3) Add cell contents

(4) a and b√

(5) None of these

  1. lt is acceptable of let long text flow into adjacent cells on

a worksheet when

(1) Data will be entered in the adjacent cells

(2) No data will be entered in the adjacent cells√

(3) There is not suitable abbreviation of the text

(4) There is not time to format the next

(5) None of these

  1. How can you delete a record?

(1) Delete the column from the worksheet

(2) Select Data > Form from the menu to open the Data√

Form dialog box, find the record and Click the Delete button

(3) Select Data > Delete Record from the menu

(4) Click the Delete button on the Standard toolbar

(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 #36”

Leave a Comment

error: