What does COUNTA () function do?


Options: counts cells having alphabets B. counts empty cells C. counts cells having number D. counts non-empty cells

Ans:– D ,






More MS-Excel Related questions:


. Which bar is usually located below that Title Bar that provides categorized options?
Options: a. Menu bar b. Status Bar c. Tool bar d. Scroll bar

Ans: –  A , –  A


The selection of the solution technique to the implemented by a computing system should be made by
Options: an operations research expert,    a computer programmer,    system analysts,    a computing system user

Ans:D ,D


If the English Philosopher Thomas Hobbes could be called 'grandfather' of artificial intelligence, then who could be called its father?
Options: A.M. Turning,    John McCarthy,    Allen Newell,    Herbert Simon

Ans:A ,A


Which of the following Operating System does not implement multitasking truly?
Options: Windows 98 B. Windows NT C. Windows XP D. MS DOS

Ans:– D ,


If the values Earliest time and Latest time of an event are not equal then such events are referred to as:
Options: critical,    optimum,    non-critical,    All of the above

Ans:C ,C


A random-access data storage device which gives rapid access to data is
Options: Magnetic tape,    Punched card,    Disk storage unit,    Buffer

Ans:C ,C


A Database Management System (DBMS) is
Options: Collection of interrelated data B. Collection of programs to access data C. Collection of data describing one particular enterprise D. All of the above

Ans:– D ,


A transistor has how many doped regions?
Options: 1,    2,    3,    4

Ans:C ,C


Properly arranged data is called
Options: A) Field B) Words C) Information D) File

Ans:-C,-C


You have a class A network address 10.0.0.0 with 40 subnets, but are required to add 60 new subnets very soon. You would like to still allow for the largest possible number of host IDs per subnet. Which subnet mask should you assign?
Options: 255.240.0.0,    255.248.0.0,    255.252.0.0,    255.254.0.0

Ans:D ,D


Which of the following is not a part of Slide Design
Options: a. Design Template b. Color Scheme c. Animation Scheme d. Slide Layout

Ans: – D , – D


The CPU chip used in a computer is partially made out of
Options: silica,    carbon,    copper,    gold

Ans:A,A


The physical layer, in reference to the OSI model, defines
Options: data link procedures that provide for the exchange of data via frames that can be sent and received,    the interface between the X.25 network and packet mode device,    the virtual circuit interface to packet-switched service,    All of the above

Ans:B ,B


. Which of the following have the fastest access time?
Options: Semiconductor Memories B. Magnetic Disks C. Magnetic Tapes D. Compact Disks

Ans: – A ,


Which technique is being investigated as an approach to automatic programming?
Options: generative CAI,    specification by example,    All of the above,    non-hierarchical planning

Ans:B ,B


An information processor includes
Options: the data base and the model base,    the central processing unit,    incoming data and outgoing information,    incoming data, the central processing unit, the model base, outgoing information, and the data base

Ans:D ,D


The coming together of three technologies i.e. microelectronics, computing and communications has ushered in
Options: information explosion,    information technology,    business revolution,    educational upgradation

Ans:B ,B


The online, softcopy display of a customer's charge account to respond to an inquiry is an example of a(n):
Options: regularly scheduled report,    on-demand report,    exception report,    forecasting report

Ans:B ,B


. How do you print your slides in a handout that includes lines for notes?
Options: a. In the print dialog box, select handout and set the number of slides per page to 3 b. In the print dialog box, select handout and set the number of slides per page, then select the include comment page option c. In the print dialog box select note page instead of handout d. All of above

Ans:3 – A ,3 – A


How many characters form a secondary name for a file?
Options: a. 8 b. 12 c. 3 d. None of the above

Ans:b   ,12


What is the first octet range for a class B IP address?
Options: 128 - 255,    1 - 127,    192 - 223,    128 - 191

Ans:D ,D


How many types of flow are there in a semiconductor?
Options: 0,    1,    2,    3

Ans:B ,B


A good query system
Options: can accept English language commands,    allows non-programmers to access information stored in a database,    can be accessed only by data processing professionals,    both (a) and (b)

Ans:B ,B


A stand-alone system which produces one page of printed output at a time is
Options: Page printer,    Line printer,    Laser printer,    Dot matrix printer

Ans:A ,A


Objects on the slide that hold text are called
Options: a. Placeholders b. Object holders c. Auto layouts d. Text holders

Ans: – A , – A


. It is a database object to view, change, and analyze data in different ways
Options: a. Query b. Form c. Report d. None of the above

Ans:9 – a ,9 – a


Which of the following is not the External Security Threats?
Options: Front-door Threats B. Back-door Threats C. Underground Threats D. Denial of Service (DoS)

Ans:– C ,


Which command will show you the IOS version running on your router?
Options: sh IOS,    sh flash,    sh version,    sh running-config

Ans:C ,C


If a host on a network has the address 172.16.45.14/30, what is the subnetwork this host belongs to?
Options: 172.16.45.0,    172.16.45.4,    172.16.45.8,    172.16.45.12

Ans:D ,D


While running DOS on a PC, which command would be used to duplicate the entire diskette?
Options: COPY,    DISKCOPY,    CHKDSK,    TYPE

Ans:B ,B


A name applied by Intel corp. to high speed MOS technology is called
Options: HDLC,    LAP,    HMOS,    SDLC

Ans:C ,C


What command is used to display the top of the file?
Options: grep,    more,    head,    cat

Ans:C ,C


Light sensors:
Options: cannot be used a s limit switches.,    come in a wide variety of mounting styles,    work in direct sunlight,    never use infrared light as light source

Ans:B ,B


In OLE DB, a service provider:
Options: does not own data only.,    transforms data through OLE DB interfaces only.,    is both a consumer and a provider of data only.,    All of the above are true of an OLE DB service provider.

Ans:D ,D


Two connected routers are configured with RIP routing. What will be the result when a router receives a routing update that contains a higher-cost path to a network already in its routing table?
Options: The updated information will be added to the existing routing table.,    The update will be ignored and no further action will occur.,    The updated information will replace the existing routing table entry.,    The existing routing table entry will be deleted from the routing table and all routers will exchange routing updates to reach convergence.

Ans:B ,B


Which of the following would be a good starting point for troubleshooting if your router is not translating?
Options: Reboot.,    Call Cisco.,    Check your interfaces for the correct configuration.,    Run the debug all command.

Ans:C ,C


9. ….share characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:Correct Answer: a,Correct Answer: a


How many times "IndiaBIX" is get printed? #include<stdio.h> int main() { int x; for(x=-1; x<=10; x++) { if(x < 5) continue; else break; printf("IndiaBIX"); } return 0; }
Options: Infinite times,    11 times,    0 times,    10 times

Ans:C ,C


. In Computer Architecture a Bus is _________
Options: a collection of various software B. a collection of various computers C. a collection of shared communication wires D. a collection of chairs where the user sits

Ans:– C ,


Design qualifications do not normally include
Options: Output requirements,    Input and storage requirements,    Control provisions,    Blueprints

Ans:D ,D


What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register

Ans:B,B


. You were giving your presentation, and you need to click a slide that’s few slides back. How do you get there?
Options: a. Press ESC to get back into a normal view; click the slide thumbnail in normal view; then click the resume slide show button b. Press backspace until your desired slide c. Right click, point to go on the shortcut menu, point to by title, and click the slide you want to go to d. All of above

Ans:6 – C ,6 – C


What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options:  Compiler B.  Interpreter C.  Debugger D.  Assembler

Ans:– D ,


What is the term which represents the use of links between information of all sorts whether text, graphics, video oi audio-based?
Options: Hypertext,    Hypermedia,    HyperCard,    Wildcard

Ans:B ,B


Concurrency control is important for which of the following reasons?
Options: To ensure data integrity when updates occur to the database in a multiuser environment,    To ensure data integrity when updates occur to the database in a single-user environment,    To ensure data integrity while reading data occurs to the database in a multiuser environment,    To ensure data integrity while reading data occurs to the database in a single-user environment

Ans:A ,A


Which common bus specification provides the fastest data transfer rate?
Options: VL bus,    ISA,    PCI,    All of the above

Ans:C ,C


. to activate the previous cell in a pre-selected range, press
Options: a. the Alt key b. the Tab key c. the Enter key d. none of above

Ans:– d,– d


What TCP/IP protocol is used for remote terminal connection service?
Options: UDP,    RARP,    FTP,    TELNET

Ans:D ,D


Which of the following format of partition tables does Linux use?
Options: Linux,    BSD,    UnixWare,    DOS

Ans:D ,D


Programming a robot by physically moving it through the trajectory you want it to follow is called:
Options: contact sensing control,    continuous-path control,    robot vision control,    pick-and-place control

Ans:B ,B

www.000webhost.com