Which area in an Excel window allows entering values and formulas?


Options: Title Bar B. Menu Bar C. Formula Bar D. Standard Tool Bar

Ans:– C ,


Description: mcqquestions

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

Hits Today: 11768 | 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:


_____ attempt to provide the same judgmental advice that human experts such as doctors provide.
Options: ES,    AI,    KBS,    RAND

Ans:A ,A


The real "brain" of an artificial intelligence system is referred to as:
Options: bubble memory,    the expert system,    recursive technology,    natural language interfaces

Ans:B ,B


The value of a capacitor can be made larger by:
Options: increasing the area of the plates,    decreasing the area of the plates,    increasing the frequency of the applied voltage,    increasing the voltage applied to the plates

Ans:A ,A


What is the frequency range of the IEEE 802.11g standard?
Options: 2.4Gbps,    5Gbps,    2.4GHz,    5GHz

Ans:C ,C


The advantage(s) of incorporating the macro processor into pass 1 is(are):
Options: many functions do not have to be implemented twice.,    Functions are combined and it is not necessary to create intermediate files as output from the macros processor and input to the assembler.,    more flexibility is available to the programmer in that he may use all the features of the assembler in conjunction with macros.,    all of the above

Ans:D ,D


Which of the following is an unordered collection of elements that may contain duplicates?
Options: Set,    Bag,    List,    Dictionary

Ans:B ,B


. Which of the following are the best units of data on an external storage device?
Options: A) Bits B) Bytes C) Hertz D) Clock cycles

Ans:B,B


Can you tell what passes into and out from the computer via its ports?
Options: Data,    Bytes,    Graphics,    Pictures

Ans:B,B


A lock that allows concurrent transactions to access different rows of the same table is known as a
Options: Field-level lock B. Row-level lock C. Table-level lock D. Database-level lock

Ans:– A ,


ODL supports which of the following types of association relationships?
Options: Unary,    Unary and Binary,    Unary and Binary and Ternary,    Unary and Binary and Ternary and higher

Ans:B ,B


. Which is not external command?
Options: a. Doskey b. Verify c. Print d. Find

Ans:4 – b ,4 – b


An internal storage consisting of arrays of small rings of magnetic material called ferrite is
Options: Magnetic tape,    Magnetic core,    Magnetic disk,    Optical mark reader

Ans:B ,B


When entering field name, how many characters you can type in maximum?
Options: a. 60 b. 64 c. 68 d. Any number of character

Ans:ndash; b,ndash; b


. What lets you to create new presentation by selecting ready-made font color and graphics effects?
Options: a.  Presentation Template b.  Master Slide c.  Design Template d.  Animation Scheme

Ans:1 – C ,1 – C


Indicate which is a pre-emptive scheduling algorithm
Options: Round-robin,    Shortest-job-next,    Priority-based,    All of the above

Ans:A ,A


The journal voucher file includes
Options: general ledger accounts involved,    date of entry,    rupees posted to each account,    All of the above

Ans:B ,B


The number of management layers in a firm is determined by
Options: the scalar principle,    the span of control,    the degree of unity in the command,    the number of managers in the firm

Ans:B ,B


Which of the following is true concerning a procedure?
Options: You do not create them with SQL.,    They do not need to have a unique name.,    They include procedural and SQL statements.,    They are the same thing as a function.

Ans:C ,C


. When you cut or copy the text or picture, it stores temporarily in the
Options: a. File b. Clipboard c. Icon d. All of above

Ans:3 – b ,3 – b


RAM is used as a short memory because it is
Options: Volatile,    Has small capacity,    Is very expensive,    Is programmable

Ans:A ,A


Which one of the following equations most directly leads to the resistance of an ordinary household light bulb, assuming that you know the power and voltage rating?
Options: R = E2/P,    P = PR,    P = E2/R,    I = P/E

Ans:A ,A


switching between portrait and landscape modes involves the:
Options: header and footer toolbar,print layout view, page setup dialog box, none of the above

Ans:C,page setup dialog box


The CPU of a computer transfers print output to a temporary disk memory at high speed and then gets back to processing another job without waiting for the output to got to the printer. In this way, the CPU does not remain idle due to its own high speed as compared to the low speed of the printer. What is the name of this memory?
Options: External memory,    I/O memory,    ROM,    Buffer memory

Ans:D,D


System programs such as Compilers are designed so that they are
Options: reenterable,    non reusable,    serially usable,    recursive

Ans:A ,A


How to remove the unwanted action from recorded macro without recording the whole macro again?
Options: By using the Find and Edit Action Option B. By clicking on the Refresh button in the Macro toolbar C. By edit the macro in the Visual Basic Editor D. Macro cannot be edited.

Ans:– C ,


An Interpreter is
Options: is a program that appears to execute a source program as if it were machine language,    a program that automate the translation of assembly language into machine language,    program that accepts a program written in a high level language and produces an object program,    a program that places programs into memory and prepares them for execution

Ans:A ,A


The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    All of the above

Ans:E ,E


In analyzing the compilation of PL/I program, the term "Machine independent optimization" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:C ,C


The research and development department at your office has been experimenting with different technologies to help improve the performance of the network. One group has been examining the use of a broadband network versus a based band network. Select the correct statement about broadband and baseband.
Options: Broadband networks carry several channels on a single cable, whereas in a baseband network several cables carry one channel,    Baseband networks carry a single channel on a single cable, whereas broadband networks carry several channels on a single cable,    Baseband refers to local area networks, and broadband refers to wide area networks.,    Baseband operates at a standard bit rate, whereas broadband may operate at different rates as needed

Ans:B ,B


The startup routine runs, when machine boots up is known as
Options: a.POST b. BOOT up c. Operating Routine d. I/O operation

Ans:1  b.       ,1  b.      


You need to allow one host to be permitted to attach dynamically to each switch interface. Which two commands must you configure on your catalyst switch to meet this policy? Switch(config-if)# ip access-group 10 Switch(config-if)# switchport port-security maximum 1 Switch(config)# access-list 10 permit ip host 1 Switch(config-if)# switchport port-security violation shutdown Switch(config)# mac-address-table secure
Options: 1 and 3,    2 and 4,    2, 3 and 5,    4 and 5

Ans:B ,B


Multiplication of 1112 by 1012 is
Options: 1100112,    1000112,    1111002,    0001012

Ans:B ,B


A current source has an internal resistance of 100 kW. What is the largest load resistance if the current source must appear stiff?
Options: 2 k Ohm,    10 k Ohm,    20 k Ohm,    1 k Ohm

Ans:D ,D


The disk concept for reducing time lost from rotational delay is:
Options: fixed block addressing,    cylinder, track, sector data,    staggered addressing,    graduated block identification

Ans:C ,C


How many bytes of memory will the following code reserve? #include<stdio.h> #include<stdlib.h> int main() { int *p; p = (int *)malloc(256 * 256); if(p == NULL) printf("Allocation failed"); return 0; }
Options: 65536,    Allocation failed,    Error,    No output

Ans:B ,B


. You can move a sheet from one workbook into new book by
Options: a.  From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK b.  From Edit menu choose Move of Copy then choose (Move to end) and click OK c.  From Edit menu choose Move or Copy then select (new book) from To Book list and click OK d.  None of above

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


The first mechanical calculating machine was made by
Options: William Oughtred,    Gottfried Leibnitz,    Blaise Pascal,    Charles Babbage

Ans:C ,C


The memory address of the first element of an array is called
Options: a. floor address b. foundation address c. first address d. base address  

Ans:d,d


What is the acronym for Single In-Line Memory Module?
Options: SIMM,    SILMM,    SM,    SMM

Ans:A ,A


The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
Options: Database,    Table,    Flat file,    Data structure

Ans:C ,C


Which command is used to display all the lines with the string 'sales' from the file empl.lst?
Options: cut sales empl.lst,    /sales > empl.lst,    grep sales empl.lst,    cat | /sales > empl.lst

Ans:C ,C


Who founded the FSF?
Options: Linus Torvalds,    Richard Stallman,    Bob Young,    All of the above

Ans:B ,B


Which of the following might be used to convert high-level language instructions into machine language?
Options: system software,    applications software,    an operating environment,    an interpreter

Ans:D ,D


. IBM 1401 computer was
Options: A) Mainframe Computer B) Mini Computers C) Micro Computers D) None of above

Ans:A,A


. Which file system DOS typically use?
Options: a. FAT 16 b. FAT 32 c. NTFS d. LMFS

Ans:6 – a ,6 – a


Which part interprets program instructions and initiate control operations.
Options: Input,    Storage unit,    Logic unit,    Control unit

Ans:D,(Danswer


You want to ping the loopback address of your local host(with IPv6). What will you type?
Options: ping 127.0.0.1,    ping 0.0.0.0,    ping ::1,    trace 0.0.::1

Ans:C ,C


. If you need a text to show vertically in a cell. How will you achieve this?
Options: a. Choose Vertical on Text alignment in Format Cells dialog box b. Choose 90 Degrees in Orientation of Format Cells dialog box c. Choose Distributed from the Vertical drop down list of Format Cells dialog box d. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

Ans:– b,– b


Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
Options: Both TCP and IP are needed.,    TCP is needed but IP is not needed.,    TCP is not needed but IP is needed.,    Neither TCP and IP are needed.

Ans:A ,A

www.000webhost.com