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: 12875 | 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:

The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in Electronic Data Processing system is called
Options: ASCII,    EBCDII,    BCD,    All of the above

Ans:A ,A

Which of the following hardware component is the most important to the operation of database management system?
Options: a . high resolution video display b . printer c . high speed, large capacity disk d . plotter


The computational technique used to compute the disk storage address of individual records is called:
Options: bubble memory,    key fielding,    dynamic reallocation,    hashing

Ans:D ,D

Compilers and interpreters are themselves
Options: High-level language,    Codes,    Programs,    Mnemonics


Point out the error in the following program (if it is compiled with Turbo C compiler). #include<stdio.h> int main() { display(); return 0; } void display() { printf("IndiaBIX.com"); }
Options: No error,    display() doesn't get invoked,    display() is called before it is defined,    None of these

Ans:C ,C

Uniform Symbols Table
Options: contains all constants in the program,    a permanent table of decision rules in the form of patterns for matching with the uniform symbol table to discover syntactic structure.,    consists of a full or partial list of the token's as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    a permanent table which lists all key words and special symbols of the language in symbolic form.

Ans:C ,C

. You should choose this mode if you don’t know how long you won’t use your computer but want to have the same desktop state when you resume
Options: a. Shut Down b. Restart c. Sleep d. Hibernate

Ans:4 – d ,4 – d

. … are list of commands that appear on the screen
Options: a. GUIS b. Icons c. Menus d. Windows

Ans:6 – c ,6 – c

What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?
Options: Application,    Host-to-Host,    Internet,    Network Access

Ans:B ,B

The % key allows you
Options: to move the cursor to a matching delimiter, when a delimiters a parenthesis, a bracket, or a brace.,    to move the cursor to the upperleft corner of the screen,    to move the cursor backward to the beginning of a word,    to move the cursor to the first column in the current line

Ans:A ,A

Which of the following SQL statements are helpful in database redesign?
Options: Correlated subqueries only,    EXISTS/NOT EXISTS expressions only,    Both of the above are helpful,    None of the above are helpful.

Ans:C ,C

Which of the following machines are characterised by electronic tube circuitry, delay line, rotating or electrostatic memory.
Options: First generation,    Fifth generation,    Third generation,    Second generation

Ans:A ,First generation Machines

What is the name of the printer which prints all the A's in a line before all the B's?
Options: Thermal printer,    Electrostatic printer,    Line printer,    Ink-jet printer


 In Power Point, this is a container for text or graphics.
Options: A. Slide master B. Table C. Placeholder D. Text box

Ans:– D , Text box

If the transient response of a system is overdamped:
Options: the value of the output exceeds the value of the input at times during the transient period.,    the value of the output never exceeds the value of the input during the transient period.,    the value of the output never stabilizes.,    All of the above

Ans:B ,B

Which is a permanent database in the general model of compiler?
Options: Literal Table,    Identifier Table,    Terminal Table,    Source code

Ans:C ,C

.   you can embed a organization chart in a slide by
Options: a. Clicking the object command on the edit menu b. clicking the insert new slide button on the standard toolbar, then double clicking the organization chart auto layout c. clicking the ms organization chart button on the formatting toolbar d. clicking the ms organization chart button on the standard toolbar

Ans:3 – B ,3 – B

You telnet to a router and make your necessary changes; now you want to end the Telnet session. What command do you type in?
Options: close,    disable,    disconnect,    exit

Ans:D ,D

Which one of the following equations most directly determines the amount of current flowing through a resistor when you know the value of the resistor and the voltage drop across it?
Options: E = PR,    E = I2R,    I = E/R,    I = ER

Ans:C ,C

Which one of the following properties of a magnetic circuit can be directly compared to current in an electrical circuit?
Options: Number of lines of force,    Flux density,    Reluctance,    Magnetomotive force

Ans:A ,A

Which command is used to display and create files?
Options: cat,    vi,    ed,    lyrix

Ans:A ,A

The total inductance of a series inductor circuit is:
Options: equal to the sum of the individual inductance values,    equal to the sum of the individual inductive-reactance values,    less than the value of the smallest inductor,    equal to the source voltage divided by total current

Ans:A ,A

. “Ctrl + Right Arrow” is used to
Options: Moves the cursor one word right B. Moves the cursor end of the line C. Moves the cursor end of the document D. Moves the cursor one Paragraph down

Ans:– A ,

Which field type can store photos?
Options: a. Hyperlink b. OLE c. Both of these can be used d. Access tables can’t store photos

Ans:ndash; b,ndash; b

. Which file keeps commands to execute automatically when OS is started?
Options: a. command . com b. any batch file c. autoexec.bat d. config.sys

Ans:9 – c ,9 – c

. Comments can be added to cells using …..
Options: a. Edit -> Comments b. Insert -> Comment c. File -> Comments d. View –> Comments

Ans:– b,– b

Which is an example of a formula?
Options: =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)

Ans:– A ,

What is the term used when you press and hold the left mouse key and move the mouse around the slide?
Options: a. Highlighting b. Dragging c. Selecting d. Moving

Ans: – B , – B

Which of the following is used for input and output both
Options: Graph plotter,    Teletype terminal,    Line printer,    All of the above

Ans:B ,B

54. If the number of columns is selected 1 and the line between check box is marked, where is the line drawn?
Options: a. in the left margin b. in the right margin c. both in left and right margin d. None of Above

Ans:– D ,– D

The first large scale electronic computer which became operational in 1946 and contained approximately 18000 vacuum tubes and could perform 300 multiplications per second was known as

Ans:B ,B

The command used to remove the directory is;
Options: rmdir,    rd,    remove,    rdir

Ans:A ,A

A hand-held device which reads marks or characters on paper by detecting photo-sensitivity is known as
Options: Light pen,    Optical-wand,    Plotter,    All of the above

Ans:B ,B

In a step-down transformer, which is larger?
Options: Primary voltage,    Secondary voltage,    Neither,    Impossible to say

Ans:A ,A

We can remove a relationship defined between two tables by
Options: a. From Edit menu choose Delete Relationship b. Select the relationship line and press Delete c. Choose Delete option from Relationship menu d. All of above

Ans:ndash; b,ndash; b

. SYS command is used to
Options: a. Copy DOS system files to new disk b. Copy DOS configuration files to a new disk c. Update the DOS system files d. None of above

Ans:Correct Answer: a ,Correct Answer: a

. Which option allows you to Bold all the negative values within the selected cell range:
Options: Zero Formatting B. Conditional Formatting       C. Compare Formatting D. Negative Formatting

Ans:– B ,

.   on which part of the chart are the values entered in a data sheet displayed?
Options: a. The title area b. The legend c. The y-axis d. The x-axis

Ans:8 – C ,8 – C

A data structure where elements can be added or removed at either end but not in the middle
Options: a. Linked lists b. Stacks c. Queues d. Deque

Ans:- d,- d

Which prefixes are available to Oracle triggers?
Options: :new only,    :old only,    Both :new and :old,    Neither :new nor :old

Ans:C ,C

. A Smart Tag can be set using the _____ tab in the property sheet.
Options: a. Format b. Tag c. View d. Data

Ans:9 – d ,9 – d

. The traditional mechanical mouse uses a __________ to track the pointer position on the screen.
Options: a. light sensor b. wheel c. ball d. ruler

Ans:1 – c ,1 – c

. Selecting text means, selecting?
Options: a. a word b. an entire sentence c. whole document d. any of the above

Ans: –  D , –  D

The keystrokes Ctrl + I is used to
Options:  A) Increase font size, B) Inserts a line break, C) Indicate the text should be bold, D) Applies italic format to selected text,


Which part of the system allows the user to interact with the compiler? (a) Memory
Options: Translator,    Communications processor,    Interpreter,    None of the above

Ans:D ,D

Which of the following are layers in the TCP/IP model? Application Session Transport Internet Data Link Physical
Options: 1 and 2,    1, 3 and 4,    2, 3 and 5,    3, 4 and 5

Ans:B ,B

What is the maximum data rate for the 802.11b standard?
Options: 6Mbps,    11Mbps,    22Mbps,    54Mbps

Ans:B ,B

Data System management has long-term viability as a separate business function because
Options: It requires much technical knowledge,    It requires large investments,    Specialists in data systems cannot be integrated into a marketing or manufacturing organization,    An integrated database accessible to all requires independent management

Ans:D ,D

What beep codes could indicate a system board or power supply failure?
Options: steady short beep,    no beep,    one long continuous beep tone, All of the above

Ans:E ,D

What does that acronym EGA stand for?
Options: Enhanced Graphics Array,    Extended Graphics Array,    Monochrome Graphics Adapter,    Enhanced Graphics Adapter

Ans:A ,A