. In Excel, by default Numeric Values appears in


Options: Left aligned B. Right aligned C. Center aligned D. Justify aligned

Ans:– B ,


Description: mcqquestions

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

Hits Today: 14316 | Level: Moderate




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


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

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

More MS-Excel Related questions:


. What is the easiest way to place same graphic in same place in all slides
Options: a. Place graphic in Notes Master b. Place graphic in Slide Master c. Place graphic in Handout Master d. Place graphic manually in all slide

Ans:3 – B ,3 – B


. The _____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
Options: a. font b. font size c. point d. paragraph formatting

Ans:– A,– A


Which, of the following, is true for testing and debugging?
Options: Testing checks for logical errors in the programs, while debugging is a process of correcting those errors in the program,    Testing detects the syntax errors in the program while debugging corrects those errors in the program,    Testing and debugging indicate the same thing,    All of the above

Ans:A ,A


. 1 The wheel on a mouse can make it easier to __________.
Options: a. scroll through documents b. select objects c. open documents d. change volume

Ans:7 – a ,7 – a


If the values of a variable in one module is indirectly changed by another module, this situation is called
Options: A)internal change b.inter-module change c.side effect d.side-module update

Ans:C,Side effect


A compound key
Options: is made up a several pieces of information,    uniquely identifies an item in a list,    both (a) and (b),    is a combination of each unique key

Ans:C ,C


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

Ans:C ,C


A Turnaround document
Options: is circulated among all the staff of an organization.,    is circulated among all the heads of departments of an organization.,    is output at one point which later comes back as an input,    All of the above

Ans:C ,C


To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,


Which language was created by Charles H. Moore at National Radio Astronomy Observatory.
Options: BASIC,    FORTH,    dBASE,    COBOL

Ans:B ,B


. in MS Access, which data type is appropriate to store large text and numbers?
Options: a. Text b. Memo c. OLE d. Large Text

Ans:– b,– b


WRAM is used on a
Options: modem,    video card,    motherboard,    ata connector

Ans:B ,B


Point out the error in the following program. #include<stdio.h> struct emp { char name[20]; int age; }; int main() { emp int xx; int a; printf("%d\n", &a); return 0; }
Options: Error: in printf,    Error: in emp int xx;,    No error.,    None of these.

Ans:B ,B


. Which command is used to open the directory?
Options: a. Open b. Chdir c. Move d. All of above

Ans:2 – b ,2 – b


Which of the following is not one of the major components of decision-support system?
Options: language system,    knowledge system,    expert system,    problem-processing system

Ans:C ,C


Which of the following is an absolute cell reference?
Options: a. !A!1 b. $A$1 c. #a#1 d. A1

Ans:#8211; b,#8211; b


The main purpose of the off line device is
Options: To reduce the no.of operator errors in recording data,    To save computer time,    To save floor space in the computer centre,    All of the above

Ans:B ,B


Speed of Laser Printer is measured in
Options: LPM B. PPM C. DPI D. DPS

Ans:– B ,


. Which of the following is not an action query?
Options: a. add b. delete c. make-table d. update

Ans:– a,– a


. Which data type is better to use for storing the price of an item?
Options: a. Text b. AutoNumber c. Number d. Currency

Ans:– d,– d


How many collision domains are created when you segment a network with a 12-port switch?
Options: 1,    2,    5,    12

Ans:D ,D


    Which of the following extensions suggest that the file is a backup copy
Options: a.    Bak b.    Bas c.    Com d.    Txt

Ans:.a,Correct Answer: a. Bak


Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B,(Banswer


A file produced by a spreadsheet
Options: is generally stored on disk in an ASCII text format,    can be used as it by the DBMS,    can be used for graphic,    All of the above

Ans:A ,A


. A factor which would strongly influence a business person to adopt a computer is its

Options: A) Accuracy B) Reliability C) Speed D) All of above

Ans:D,D


What is the impedance of a circuit composed of a 100 ohm resistor connected in parallel with an inductor that has a reactance of 200 W?
Options: 77.7 ohm,    89.3 ohm,    88.8 ohm,    224 ohm

Ans:B ,B


. The spelling dialog box can be involved by choosing spelling from ________ menu.
Options: a. insert b. file c. tools d. view

Ans:– c,– c


. In the IBM PC-At, what do the words AT stand for
Options: A) Additional Terminals B) Advance technology C) Applied technology D) Advanced terminology

Ans:B,B


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

Ans:3 – a ,3 – a


The difference between memory and storage is that memory is _____ and storage is __
Options: A) Temporary, permanent B) Permanent, temporary C) Slow, fast D) All of above

Ans:-A,-A


During system study, data can be collected through
Options: questionnaires,    interviews,    on-site observations,    All of the above

Ans:D ,D


Binary numbers need more places for counting because:
Options: 0's and 1's can be added in front of them,    0's and 1's have to be properly placed,    They are always big numbers,    Binary base is small

Ans:D ,D


It is an association established between common fields of two tables.
Options: a. line b. relationship c. primary key d. records

Ans:ndash; b,ndash; b


Detected money errors are corrected with
Options: debit entries,    credit entries,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Data mining applications are used accomplish which of the following tasks?
Options: Process transactions only,    Do RFM analysis only,    Do what-if analysis only,    Do both RFM and what-if analysis

Ans:C ,C


Data division is the third division of a _____ program.
Options: COBOL,    BASIC,    PASCAL,    FORTH

Ans:A ,A


A pointer is
Options: A keyword used to create variables,    A variable that stores address of an instruction,    A variable that stores address of other variable,    All of the above

Ans:C ,C


What is the loopback address?
Options: 127.0.0.1,    255.0.0.0,    255.255.0.0,    255.255.255.255.0

Ans:A ,A


. Which of the following are the cheapest memory devices in terms of Cost/Bit?
Options: A) Semiconductor memories B) Magnetic Disks C) Compact Disks D) Magnetic Tapes

Ans:C,C


The attribution of human form or qualities to things such as machines or computers is called
Options: cybernetics,    cybernation,    artificial intelligence,    anthropomorphism

Ans:D ,D


A small film-plate which is used for microfilming the output from a microcomputer screen is called
Options: microfilm,    microfiche,    film card,    COM

Ans:B ,B


Which of the following statement is true.
Options: The LRU algorithm pages out pages that have been used recently,    Thrashing is a natural consequence of virtual memory systems.,    Seek analysis is used for analysing control-unit busy problems.,    All of the above

Ans:C ,C


The prime concern of financial control is
Options: accounting for the liabilities incurred,    meeting payroll commitments,    providing financial status information,    All of the above

Ans:C ,C


. Which of the following is an example of a real time operating system?
Options: a. Lynx b. MS DOS c. Windows XP d. Process Control

Ans: d, d


The two form layout types which display multiple records at one time are tabular and___
Options: a. columnar b. justified c. date sheet d. pivot table

Ans:ndash; b,ndash; b


.    Which command displays only file and directory names without size, date and time information?
Options: a.    Dir/w b.    Dir a: c.    Dir /b d.    Dir /s

Ans:c,Correct Answer: dir/b


. How to specify cell range from A9 to A99 in Excel?
Options: (A9, A99) B. (A9 to A99) C. (A9 : A99) D. (A9 – A99)

Ans:– C ,


. Presentation designs regulate the formatting and layout for the slide and are commonly called
Options: a. Design templates b. Templates c. Placeholders d. Blueprints

Ans:4 – B ,4 – B


. MS-EXCEL can be used to automate
Options: a. Financial statements, Business forecasting b. Transaction registers, inventory control c. Accounts receivable, accounts payable d. Any of the above

Ans:– d,– d


In a _____ one module of the new information system is activates at a time.
Options: System Development Life Cycle,    CASE tool,    Phased Conversion,    Success factors

Ans:C ,C

www.000webhost.com