Computer Gk For All Competitive Exams Series #48 | Hindigk50k
Computer Gk For All Competitive Exams Series #48

Computer Gk For All Competitive Exams Series #48

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. A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button……

(1) nothing will print because some cells with data have

been omitted

(2) only the cells with gray back-ground will print

(3) the whole sheet will print

(4) only the cells with white background will print√

(5) None of these ‘-‘v

Computer Gk For All Competitive Exams Series #49

Computer Gk For All Competitive Exams Series #47

  1. A constant is another name for this type of data:

(1) number√ (2) equation

(3) formula

(4) description

(5) None of these

  1. The view that puts a blue a blue line around each page

that would be printed is the……

(1) Print Preview

(2) Normal View

(3) Page Break Preview√

(4) Split View

(5) None of these

  1. Auto Calculate will quickly add selected cells if you…….

(1) right click on the status bar and select Sum

(2) click the AutoCalculate but-ton on the toolbar√

(3) use the key combination Ctrl+$

(4) Double click the selection

(5) None of these

  1. The cell labeled 23. 54 the cell labeled F5 refers to

(1) row F column 5

(2) column F row 5√

(3) function available in cells

(4) function key F4

(5) None of these

  1. When you are typing an equation

into a cell the first thing that must be entered is

(1) the first cell referenced

(2) parenthesis

(3) quotation marks

(4) an equal sign√

(5) None of these

  1. Using the AutoSum button will replace in the selected

cell……

(1) the sum of values jn the cell’s column. √

(2). nothing until’ybu select a range of cells

(3) the sum of the cell’s row unless you change the range

(5) None of these

948.Bookl is an example of how …… are numbered and

named during each work session

(1) Active cell

(2) Formula bar

(3) Menu bar

(4) Name box√

(5) None of these

  1. Which of the following displays the contents of the

active cell?

(1) Active cell

(2) Formula bar√

(3) Menu bar

(4) Name box

(5) None of these

  1. Graphics objects on a chart are used to

(1) Add emphasis to chart data

(2) Add interest to a chart

(3) Help explain the chart data

(4) a, b, and c√

(5) None of these

  1. What does SUMIF function do?

(1) Adds up cell values based on a condition√

(2) Adds all the numbers in a range of cells

(3) Returns a subtotal in a list or database

(4) All of above

(5) None of these

  1. You can insert labels for

(1) All the data markers on a chart

(2) A data series

(3) A selected data marker

(4) All√

(5) None of these

  1. Tab scrolling buttons

(1) Allow you.to view a different worksheet

(2) Allow you to view additional worksheet row down

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

right

(4) Allow you to view additional sheet tabs√

(5) None of these

  1. All macro keyboard shortcuts include the…… key

(1) Alt (2) Ctrl√

(3) F11 (4) Shift

(5) None of these

  1. To open the Format Cells dialog box, press

(1) Alt* 1

(2) Ctrl + 1√

(3) Ctrl + Shift + 1

(4) Fl

(5) None of these

  1. You can add a hyperlink to your worksheet by pressing

(1) Alt + K

(2) Ctrl + H

(3) Ctrl + K√

(4) Ctrl + Shift + K

(5) None of these

  1. To” move to the previous worksheet, press

(1) Alt + PgUp

(2) Ctrl + PgUp

(3) Ctrl + PgDn

(4) Shift + Tab√

(5) None of these

  1. Hyperlinks can be

(1) Text

(2) Drawing objects

(3) Pictures

(4) All of above√

(5) None of these

Computer Gk For All Competitive Exams Series #49

Computer Gk For All Competitive Exams Series #47

  1. To activate the previous cell in a pre selected range,

press

(1) The Alt key (2) The Tab key

(3) The Enter key

(4) None of the above√

(5) None of these

  1. Which button do you click to add up a series of

numbers?

(1) The autosum button√

(2) The Formula button

(3) The quicktotal button

(4) The total button

(5) None of these

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

Comments

comments

Leave a Comment