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 ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 11425 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More MS-Excel Related questions:


In LISP, the atom that stands for "true" is
Options: t,    ml,    y,    time

Ans:A ,A


A acronym for the organisation that publishes programming language standard is
Options: ASCn,    BCD,    ANSI,    EBCDIC

Ans:C ,C


hat is the shortcut key to display field codes?
Options: Alt + F9 B. Ctrl + F9 C. Shift + F9 D. Space + F9

Ans:– A ,


Which of the following is the largest manufacturer of Hard Disk Drives?
Options:  IBM B.  Seagate C.  Microsoft D.  3M

Ans:– B ,


If you want to have more than one Telnet session open at the same time, what keystroke combination would you use?
Options: Tab+Spacebar,    Ctrl+X, then 6,    Ctrl+Shift+X, then 6,    Ctrl+Shift+6, then X

Ans:D ,D


A characteristic of card systems is:
Options: slowness in processing data,    using cards as records of transactions,    needing a larger DP staff,    all the above

Ans:D,D


Most disk drives have a single read/ write head for each disk surface. What is the advantage of suing multiple heads on each movable access arm?
Options: Reduced seek time,    Less latency time,    Reduced search time,    Less disk speed

Ans:A ,A


Which of the following is not an advantage of multiprogramming?
Options: increased throughput,    shorter response time,    decreased operating-system overhead,    ability to assign priorities to jobs

Ans:C ,C


Productivity is defined as:
Options: number of items manufactured per day,    output per man-hour of labour,    cost per day,    cost per unit

Ans:B ,B


The computer has been applied most effectively in
Options: marketing,    manufacturing,    personnel,    engineering

Ans:B ,B


Features of XML include which of the following?
Options: The tags are used to describe the appearance of the content.,    Addresses the structuring and manipulation of the data involved.,    Governs the display of information in a Web browser.,    All of the above.

Ans:B ,B


One millisecond is
Options: A) 1 second B) 10th of a seconds C) 1000th of a seconds D) 10000th of a seconds

Ans:-C,-C


. A smart tag will be removed from a cell when
Options: the cell is moved B. the cell is hidden C. the data in the cell is changed or deleted D. the formatting of the cell is changed

Ans:– C ,


The Average case occur in linear search algorithm
Options: a. When Item is somewhere in the middle of the array b. When Item is not in the array at all c. When Item is the last element in the array d. When Item is the last element in the array or is not there at all  

Ans:a,a


. Which of the following database objects extracts information from one or more tables or queries?
Options: a. Forms b. Queries c. Reports d. Tables

Ans:8 – b ,8 – b


Many things can be done to minimize downtime loss. Identify two of them.
Options: establish a user forum program,    stock critical spare parts,    provide an extra workstation,    both b and c

Ans:D ,D


Rapid prototyping proves the quality of a design by
Options: having a program simulate the real system,    having the system analyst present an overview of the design to users, programmers, and consultants,    having a data flow diagram,    both (a) and (b)

Ans:A ,A


What TCP/IP protocol is used for transferring electronic mail messages from one machine to another?
Options: FTP,    SNMP,    SMTP,    RPC

Ans:C ,C


Which of the following filename extension suggests that the file is a backup copy of another file?
Options: BAK *,    BAS,    COM,    TXT

Ans:A ,A


If you wanted to deny FTP access from network 200.200.10.0 to network 200.199.11.0 but allow everything else, which of the following command strings is valid?
Options: access-list 110 deny 200.200.10.0 to network 200.199.11.0 eq ftp access-list 111 permit ip any 0.0.0.0 255.255.255.255,    access-list 1 deny ftp 200.200.10.0 200.199.11.0 any any,    access-list 100 deny tcp 200.200.10.0 0.0.0.255 200.199.11.0 0.0.0.255 eq ftp,    access-list 198 deny tcp 200.200.10.0 0.0.0.255 200.199.11.0 0.0.0.255 eq ftp access-list 198 permit ip any 0.0.0.0 255.255.255.255

Ans:D ,D


When mapping a supertype/subtype relationship which of the following is true?
Options: The supertype primary key is assigned to each subtype.,    The subtype primary key is assigned to each supertype.,    There is no link between the supertype/subtype entities.,    There is no primary key/foreign key relationship between a supertype/subtype.

Ans:A ,A


The system unit of a personal computer typically contains all of the following except:
Options: microprocessor,    disk controller,    serial interface,    modem

Ans:D ,D


Which of the following is not the responsibility of the utilities component of DBMS software?
Options: creating the physical and logical designs,    removing flagged records for deletion,    creating and maintaining the data dictionary,    monitoring performance

Ans:A ,A


Trailer labels contain
Options: file identification,    retention period,    both (a) and (b),    neither (a) nor (b)

Ans:D ,D


Your company is running IGRP using an AS of 10. You want to configure EIGRP on the network but want to migrate slowly to EIGRP and don't want to configure redistribution. What command would allow you to migrate over time to EIGRP without configuring redistribution?
Options: router eigrp 11,    router eigrp 10,    router eigrp 10 redistribute igrp,    router igrp combine eigrp 10

Ans:B ,B


Point out the error in the program f(int a, int b) { int a; a = 20; return a; }
Options: Missing parenthesis in return statement,    The function should be defined as int f(int a, int b),    Redeclaration of a,    None of above

Ans:C ,C


The distinguishable parts of a record are called
Options: files,    data,    fields,    database

Ans:C ,C


. Commonly network of network is called
Options: a. MS Word b. MS Excel c. Internet d. MS Access

Ans:9 – c ,9 – c


. The Cancel and Enter buttons appear in the:
Options: a. Title bar b. Formula bar c. Menu bar d. Sheet tabs

Ans:– b,– b


Nonmodifiable procedures are called
Options: serially usable procedures,    concurrent procedures,    reentrant procedures,    topdown procedures

Ans:C ,C


Which one of the following is not the function of Operating System?
Options:  Resource Management B.  File Management C.  Networking D.  Processor Management

Ans:– C ,


For a Macintosh to print successfully, the System Folder must contain:
Options: File sharing software,    A printer enabler,    The apple Garamond font set,    A printer driver

Ans:D ,D


How many pins on a VGA?
Options: 15.,    9,    25,    32

Ans:A ,A


What is the modem hang up command?
Options: ATHU,    ATH,    ATZ,    ATX

Ans:B ,B


The merging of a free electron and a hole is called
Options: Covalent bonding,    Lifetime,    Recombination,    Thermal energy

Ans:C ,C


Switches operates in which layer of the OSI model?
Options: Physical layer B. Data link layer C. Network layer D. Transport layer

Ans:B,Data link layer


The Fdisk command in DOS _____ .
Options: Partitions the hard drive for use,    Fixes erroneous hard drive,    Formats data sectors on a hard drive,    Checks hard drive for lost clusters

Ans:A ,A


Suppose a step-down transformer has a turns ration of 5:1. If the secondary current is 1A rms, what is the primary-current?
Options: 0.3 A,    0.2 A,    0.4 A,    0.6 A

Ans:B ,B


Transistorized computer circuits were introduced in the
Options: first generation,    second generation,    thir4 generation,    fourth generation

Ans:B ,B


Which network is a packet switching network?
Options: Ring network,    LAN,    Star network,    EuroNET

Ans:D ,D


A characteristic of a file server is which of the following?
Options: Manages file operations and is shared on a network.,    Manages file operations and is limited to one PC.,    Acts as a fat client and is shared on a network.,    Acts as a fat client and is limited to one PC.

Ans:A ,A


Which of the following helps to reduce spelling error in the document?
Options: Auto Format B. Auto Correct C. Smart Tags D. Auto Text

Ans:– B ,


. User action such as keystroke or mouse click are referred to as
Options: a. Interrupt b. Tasks c. Processes d. Event

Ans:3 – d ,3 – d


What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
Options: 5,430.00 B. 5,436.80 C. 5,436.8 D. 6.8

Ans:– B ,


The original LISP machines produced by both LMI and Symbolics were based on research performed at:
Options: CMU,    MIT,    Stanford University,    RAMD

Ans:B ,B


Memory access in RISC architecture is limited to instructions
Options: a. CALL and RET b. PUSH and POP c. STA and LDA d. MOV and JMP

Ans:10.c,10.c


Which language was devised by Dr. Seymour Aubrey Papert?
Options: APL,    COBOL,    LOGO,    FORTRAN

Ans:C ,C


A decrease in magnitude of current, voltage, a power of a signal in transmission between points, is known as
Options: Attenuation,    Amplitude,    Aloha,    Carrier

Ans:A ,A


. Which of the following machine was not invented by Charles Babbage?
Options: A) Tabulating Machine B) Analytical Engine C) Difference Engine D) Both C and D

Ans:A,A


. The instructions for starting the computer are house on
Options: A) Random access memory B) CD-Rom C) Read only memory chip D) All of above

Ans:7-C,7-C

www.000webhost.com