What is the shortcut key to Update Formula in a table?


Options: F9 B. Alt + F9 C. Ctrl + F9 D. Shift + F9

Ans:– A ,


Description: mcqquestions

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

Hits Today: 15104 | 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-Word Related questions:


. To insert slide numbers
Options: a.  Insert a text box and select Insert >> Page Number b.  Insert a textbox and select Insert >> Number >> PageNumber c.  Choose Insert >> Slide Number d.  Insert a new text box and select Insert >> slide Number

Ans:8 – D ,8 – D


. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
Options: a. Formula b. Field c. Data d. Query

Ans:A,– a


MAC is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique or multiple-access transmission media,    a very common bit-oriented data link protocol issued to ISO.,    network access standard for connecting stations to a circuit-switched network

Ans:A ,A


Punched-card equipment was first introduced in Britain in 1904 by a small company. What was the name of that company?
Options: The Tabulator Ltd.,    Tabulator Machine Company,    International Business Machines (IBM),    Accounting & Tabulating Corpn. of Great Britain

Ans:A ,A


. Which electronic component was made out of semiconductor material?
Options: A) Vacuum tubes B) Transistors C) Ics D) All of above

Ans:C,C


On a leased line installation a known good external modem shows no carrier detect light. Where is the problem most likely to be?
Options: In the modem,    In the phone line,    In the computer,    In the DTC equipment

Ans:B ,B


The ALU of a computer responds to the commands coming from
Options: A) Primary memory B) Control section C) External memory D) Cache memory

Ans:-B,-B


What is the maximum number of IP addresses that can be assigned to hosts on a local subnet that uses the 255.255.255.224 subnet mask?
Options: 14,    15,    16,    30

Ans:D ,D


The probability that a single bit will be in error on a typical public telephone line using 4800 bps modem is 10 to the power -3. If no error detection mechanism is used, the residual error rate for a communication line using 9-bit frames is approximately equal to
Options: 0.003,    0.009,    0.991,    0.999

Ans:B ,B


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


Conversion of hexadecimal number 1D7F16 to a decimal number is
Options: 755110,    877110,    555710,    778110

Ans:A,A


. SQL stands for __________.
Options: a. Standard Query Language b. Structured Query Language c. Simplified Query Language d. Static Query Language

Ans:5 – b ,5 – b


. Gutter position can be set in following positions
Options: Left & Right B. Left & Top C. Left & Bottom D. Left Only

Ans:– B ,


The process of fetching and executing instructions, one at a time, in the order of increasing addresses is known as
Options: instruction execution,    straight line sequencing,    instruction fetch,    random sequencing

Ans:B ,B


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


Data items in the fixed asset record of a newly purchased asset that a well-designed application program could obtain automatically include
Options: estimated disposal data,    source,    first cost,    All of the above

Ans:D ,D


8. In a document what is the maximum number of columns that can be inserted in MS Word Table?
Options: a. 35 b. 15 c. 63 d. 65

Ans:#8211; C ,#8211; C


What will be the output of the program? #include<stdio.h> #define MIN(x, y) (x<y)? x : y; int main() { int x=3, y=4, z; z = MIN(x+y/2, y-1); if(z > 0) printf("%d\n", z); return 0; }
Options: 3,    4,    0,    No output

Ans:A ,A


EDP auditors can be used in the
Options: implementation phase of MIS development,    planning phase of MIS development,    analysis and design phase of MIS development,    All of the above

Ans:D ,D


Which of the following languages is often translated to pseudo code?
Options: Assembly,    FORTRAN,    PASCAL,    BASIC

Ans:C ,C


. While Finding and Replacing some data in Excel, which of the following statement is valid?
Options: a.  You can Find and Replace within the sheet or workbook b.  Excel does not have option to match case for find c.  Both are valid d.  None are valid

Ans:– a,– a


Which of the following does not affect the resolution of a video display image?
Options: bandwidth,    raster scan rate,    vertical and horizontal lines of resolution,    screen size

Ans:D ,D


Which of the following are valid ways to refer only to host 172.16.30.55 in an IP access list? 172.16.30.55 0.0.0.255 172.16.30.55 0.0.0.0 any 172.16.30.55 host 172.16.30.55 0.0.0.0 172.16.30.55 ip any 172.16.30.55
Options: 1 and 4,    2 and 4,    1, 4 and 6,    3 and 5

Ans:B ,B


What sign is used to back up over typing errors in vi?
Options: !,    $,    #,    @

Ans:C ,C


An AND gate
Options: implements logic addition,    is equivalent to a series switching circuit,    is an any or all gate,    is equivalent to a parallel switching circuit

Ans:B ,B


. Can you set 0.5 inch left indentation for a cell in Excel?
Options: a. Excel does not have indentation feature b. You can specify indentation only if you turn the rulers on c. Indentation can be set from Format Cells dialog box d. The indentation can be specified only when printing

Ans:– c,– c


A programmer would most likely prepare a
Options: general system flowchart,    specific system flowchart,    general program flowchart,    specific program flowchart

Ans:D ,D


What command is used to display your current working directory?
Options: path,    pwd,    prompt $p$g,    dir

Ans:B ,B


Codes which do not require to be frequently updated also promote user efficiency due to
Options: Simplicity,    Sortability,    Stability,    Expansibility

Ans:C ,C


. Shimmer, Sparkle text, Blinking Background etc. are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – D , – D


The term MIPS refers to _____
Options: millions of instructions per second,    multiple instructions per second,    megabytes of instructions per seconds,    millions input processor set

Ans:A ,A


Thesaurus tool in MS Word is used for
Options:  A) Spelling suggestions, B) Grammar options, C) Synonyms and Antonyms words, D) All of above,

Ans:-C,-C


Which of the following is a machine for reading documents that are encoded in a way that is readable by person and machine.
Options: Document reader,    Distributed system,    Artificial intelligence,    Document sorter

Ans:A ,A


One of a class of storage devices that can access storage locations in any order is
Options: DTE,    DASD,    DDE,    DDC

Ans:B ,B


Which of the following terms refers to the degree to which data in a database system are accurate and correct?
Options: data security,    data validity,    data independence,    data integrity

Ans:D ,D


If you get both local and remote echoes, every character you type will appear on the screen
Options: once,    twice,    three times,    never

Ans:B ,B


. The delete confirmation generated by …switch
Options: a. /p b. /b c. /w d. /c

Ans:4 – a ,4 – a


Which of the following communications lines is best suited to interactive processing applications?
Options: narrowband channels,    simplex lines,    full-duplex lines,    mixed band channels

Ans:C ,C


Magnetic tape can serve as :
Options: secondary-storage media,    output media,    input media,    All of the above

Ans:D,D


Customer data (name and address, shipping instructions, credit terms, etc.) is provided by the:
Options: manufacturing information system,    order entry subsystem,    billing subsystem,    marketing information system

Ans:C ,C


What causes the depletion layer?
Options: Doping,    Recombination,    Barrier potential,    Ions

Ans:C ,C


Size of the primary memory of a PC ranges between
Options: 2KB to 8KB B. 64KB & 256KB C. 256KB & 640KB D. None of these

Ans:– C ,


When the Q point moves along the load line, the voltage increases when the current
Options: Decreases,    Stays the same,    Increases,    Can be any of above

Ans:C ,C


Which of the following is a type of systems software used on microcomputers?
Options: MS-DOS,    PC-DOS,    Unix,    All of the above

Ans:D ,D


Which of the following function will use to find the highest number in a series of number?
Options: MAX(B1:B3) B. MAXIMUM (B1:B3) C. HIGH (B1:B3) D. HIGHEST(B1:B3)

Ans:– A ,


What PPP protocol provides dynamic addressing, authentication, and multilink?
Options: NCP,    HDLC,    LCP,    X.25

Ans:C ,C


Which of the following is a graphic representation of the modules in the System and the interconnection between them
Options: Pie chart,    Flow chart,    Structural chart,    System chart

Ans:C ,C


. Which of the following function will return a value of 8?
Options: a. ROUNDUP(8.4999, 0) b. ROUNDDOWN(8.4999, 0) c. ROUND(8.4999, 0) d. Only B and C

Ans:– d,– d


A common boundary between two systems is called
Options: Interdiction,    Interface,    Surface,    None of the above

Ans:B ,B


The entity integrity rule states that:
Options: no primary key attribute may be null.,    no primary key can be composite.,    no primary key may be unique.,    no primary key may be equal to a value in a foreign key.

Ans:A ,A

www.000webhost.com