Computer Gk For All Competitive Exams Series #35

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. You can open the scenario Manager dialog box by

choosing scenarios from the ….. menu.

(1) View (2) Insert

(3) Format

(4) Tools√

(5) None of these

  1. You can open the Sort dialog box by choosing Sort from

the ….. menu

(1)View

(2) Format

(3) Tools

(4) Data√

(5) None of these

Computer Gk For All Competitive Exams Series #36

Computer Gk For All Competitive Exams Series #34

  1. When working in the page break preview, you can

(1) view exactly where each page break occurs

(2) add or remove page breaks

(3) change the print area

(4) all of above√

(5) None of these

  1. A data map is helpful

(1) When you have too much data to chart

(2) To show a geographic distribution of data√

(3) To compare data points

(4) To show changes in data over time

(5) None of these

  1. Hounding errors can occur

(1) When you use multiplication, division or exponentiation

in a formula√

(2) When you use addition and subtraction in a formula

(3) Because Excel uses hidden decimal places in

computation

(4) When you show the results of formulas with different

decimal places’ than the calculated results

(5) None of these

  1. You can copy data or formulas

(1) With the copy, paste and cut commands on the edit

menu

(2) With commands on a shortcut menu

(3) With buttons on the standard toolbar

(4) All of the above√

(5) None of these

  1. You can zoom a worksheet

(1) With the mouse pointer in Print Preview

(2) With the zoom button on the Print Preview toolbar

(3) With the Zoom command on the view menu

(4) All of the above√

(5) None of these

  1. You can not link Excel worksheet data to a Word

document

(1) With the right drag method

(2) With a hyperlink

(3) With the copy and paste -special commands

(4) With the copy and paste buttons on the standard toolbar√

(5) None of these

  1. This type of software is similar to an accountant’s

worksheet

(1) Word processing

(2) Database

(3) Spreadsheets√

(4) Graphics

(5) None of these

  1. which function will calculate the number of workdays

between 6/9/2004 and 8/12/2004?

(1) Workday

(2) Date

(3) Networkdays

(4) All of the above√

(5) None of these

  1. Data marker on a chart are linked to data points in a .

worksheet therefore,

(1) You can automatically apply formatting to a data series

(2) You can change the position of a data marker and

automatically change the data point value in the worksheet√

(3) You can change a data print value and automatically are

draw the chart

(4) a and b

(5) None of these

  1. When you group worksheets

(1) You can enter variable data on multiple worksheets at

one time

(2) You can print more than*one worksheet at a time

(3) You can enter common data, formats, and formulas on

multiple worksheets at one time

(4) b, and c√

(5) None of these

  1. You can use the format painter , multiple times before

you turn it offby

(1) You can use the format painter button only one time

when you click it

(2) Double clicking the format painter button√

(3) Pressing the Ctrl key and clicking the format painter

button

(4) Pressing Alt key and clicking the format painter button

(5) None of these

694.The default header for a worksheet is

(1) Your name

(2) The date and time

(3) None√

(4) The sheet tab name

  1. Which of the following is an absolute cell reference?

(1) !A!1

(2) SA$1√

(3) #a#l

(4) Al

(5) None of these

  1. What symbol is used before a number to make it a

label?

(1) “(quote)

(2) = (equal) √

(3) _ (underscore)

(4) * (apostrophe)

(5) None of these

  1. Which symbol must ail formula begin with?

(1) = (2) +√

(3) ( (4) e

(5) None of these

Computer Gk For All Competitive Exams Series #36

Computer Gk For All Competitive Exams Series #34

  1. Which of the following formulas is not entered correctly?

(1) =10+50

(2) =B7*B1

(3) =B7+14

(4) 10+50√

(5) None of these

  1. Which of the following formulas will Excel Not be able to

calculate?

(1) =SUM(Sales)-A3√

(2) =SUM(A1:A5)*.5

(3) =SUM(A1:A5)/(10-10)

(4) =SUM(A1:A5)-10

(5) None of these

700.A typical worksheet has …. Number of columns

(1) 128

(2) 256√

(3) 512

(4) 1024

(5) None of these

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

Comments

comments

Leave a Comment

error: