. What is the correct way to refer the cell A10 on sheet3 from sheet1?


Options: sheet3!A10 B. sheet1!A10 C. Sheet3.A10 D. A10

Ans: – A ,


Description: mcqquestions

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

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


A 4 KHz noiseless channel with one sample every 125 per sec, is used to transmit digital signals. Find the bit rate (bits per second) that are sent, if CCITT 2.048 Mbps encoding is used.
Options: 500 Kbps,    32 Kbps,    8 Kbps,    64 Kbps.

Ans:D ,D


. When you link data maintained in Excel workbook to a Word document
Options: a. The Word document cannot be edited b. The Word document contains a reference to the original source application c. The word document must contain a hyperlink d. The word document contains a copy of the actual data

Ans:– b,– b


Transmission of computerised data from one location to another is called
Options: data transfer,    data flow,    data communication,    data management

Ans:C ,C


Which of the following is considered a high-level language?
Options: Machine language,    FORTRAN,    Assembly language,    All of the above

Ans:B ,B


Which key do you press to force a page break?
Options: CTRL+ALT B. CTRL+ break C. CTRL+ Enter D. none of the above

Ans:– C ,


What command is used to add printing jobs to the queue?
Options: lpd,    lpr,    lpq,    lpc

Ans:B ,B


. Which of the following is not a type of Microsoft Access database object?
Options: a. Table b. Form c. Worksheets d. Modules

Ans:2 – c ,2 – c


In inkjet printers, what is the most common problem with the paper tray?
Options: inconsistent printing,    malfunctioning pick-up rollers,    misalignment of the sheet feeder,    paper jamming on the ink cartridge

Ans:B ,B


. Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
Options: a. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. b. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box c. Apply a selected background color d. All of above

Ans:– b,– b


An algorithm is best described as
Options: A computer language,    A step by step procedure for solving a problem,    A branch of mathematics,    All of the above

Ans:B ,B


What router command allows you to determine whether an IP access list is enabled on a particular interface?
Options: show ip port,    show access-lists,    show ip interface,    show access-lists interface

Ans:C ,C


Point out the error in the following program. #include<stdio.h> #include<stdarg.h> void varfun(int n, ...); int main() { varfun(3, 7, -11, 0); return 0; } void varfun(int n, ...) { va_list ptr; int num; num = va_arg(ptr, int); printf("%d", num); }
Options: Error: ptr has to be set at begining ,    Error: ptr must be type of va_list,    Error: invalid access to list member,    No error

Ans:A ,A


The fundamental requirements of private-to-public network interconnection methods which need to be provided in gateways is/are
Options: universal accessibility for private network Data Terminal Equipment (DTE),    adequate cost control mechanisms for administration of the private networks,    to assign address to private network DTEs,    a and b both

Ans:D ,D


In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Options: ALTER INDEX,    REDEFINE INDEX,    MODIFY INDEX,    DO INDEX

Ans:A ,A


A _____ means that one record in a particular record type is related to only one record of another record type.
Options: One-to-one relationship,    One-to-many relationship,    Many-to-one relationship,    Many-to-many relationship

Ans:A ,A


A shared lock allows which of the following types of transactions to occur?
Options: Delete,    Insert,    Read,    Update

Ans:C ,C


What is the control units function in the CPU?
Options: a. To transfer data to primary storage b . to store program instruction c . to perform logic operations d . to decode program instruction

Ans:2.d,2.d


to edit the text within the boxes of an organization chart, you
Options: a. select the box and text, then make changes b. select the box, then make the changes c. highlight the text, them make the changes d. a and b both

Ans: – A , – A


Which is valid statement
Options: A. 1 KB = 1024 Bytes B. 1 MB = 1024 Bytes C. 1 KB = 1000 Bytes D. 1 MB = 1000 Bytes

Ans:A,


The essential features of a number system are
Options: Radix,    Set of distinct counting digits,    bits,    Both (a) & (b)

Ans:D ,D


The primary job of the operating system of a computer is to
Options: command resources,    manage resources,    provide utilities,    be user friendly

Ans:B ,B


Which command will be used with vi editor to replace single character under cursor with any number of characters?
Options: s,    S,    a,    i

Ans:A ,A


What protocol(s) is(are) allowed a user to retrieve her/his mail from the mail server to her/his mail reader?
Options: POP3,    FTP,    MAP,    All of the above

Ans:A ,A


. Which tool is used to generate printout of a table’s structure?
Options: a. Analyzer b. Designer c. Documenter d. Generator

Ans:– c,– c


Which of the following is not true about documentation?
Options: Documentation, of a system, should be as clear and direct as possible,    Documentation increases the maintenance time and cost,    Documentation gives better understanding of the problem,    All of the above

Ans:B ,B


 In PowerPoint, when the mouse pointer appears as this it indicates that the Draw Table feature is on
Options:  Solid plus sign B.  Solid arrow C.  I-beam D.  Pencil

Ans:– D ,


Which of the following is not an advantage of the structured approach to system development?
Options: it focuses on the physical aspects of the system,    the system specification is very graphic,    the user area is studied thoroughly,    the documentation is Cumulative

Ans:A ,A


NIS
Options: is Network Information Service,    is a simple directory service whose main purpose is to allow remote authentication of systems on local network systems,    was formerly known as yellow pages,    allows configuration-such as password and group files

Ans:A ,A


In SQL, which command is used to create a database user?
Options: ADD USER TO DATABASE,    MK USER,    CREATE USER,    All of the above

Ans:C ,C


IBM-PC is an example of
Options: A main frame,    Machine-in-built,    Micro computer,    Special purpose

Ans:C ,C


An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Options: data source.,    driver manager.,    driver.,    API.

Ans:A ,A


A 4 KHz noise less channel with one sample ever 125 per sec is used to transmit digital signals. Differential PCM with 4 bit relative signal value is used. Then how many bits per second are actually sent?
Options: 32 Kbps,    64 Kbps,    8 Kbps,    128 Kbps.

Ans:A ,A


Which of the following is not currently a topic in computer science?
Options: Speech recognition,    Artificial intelligence,    Thermodynamics,    Multiprocessing

Ans:C ,C


. An online backing storage system capable of storing larger quantities of data is
Options: A) CPU B) Memory C) Mass storage D) Secondary storage

Ans:C,C


How can you remove tab stop markers from ruler?
Options: a. Double click the tab marker and choose Clear All b. Drag the tab stop marker out of the ruler c. Right click the tab stop marker and choose remove d. All of above

Ans:– B,– B


Which of the following name does not relate to stacks?
Options: a. FIFO lists b. LIFO list c. Piles d. Push-down lists

Ans: a, a


A device that stores one item of information is
Options: Memory element,    Block Compaction,    MDR,    Memory guard

Ans:A ,A


. The content and application of the Search tool CANNOT be retained when you ______.
Options: a. format an object b. resize a column c. use Datasheet View d. close an object

Ans:1 – d ,1 – d


System generation:
Options: is always quite simple,    is always very difficult,    varies in difficulty between systems,    requires extensive tools to be understandable

Ans:C ,C


Operational budgeting require how many data files that would not otherwise be needed?
Options: 3,    2,    1,    0

Ans:D ,D


When used with I/O devices, the term intelligent implies
Options: a color output capability,    speech processing capability,    high speed printing capability,    feature to support offline and online tasks

Ans:D ,D


On a class B network, how many hosts are available at each site with a subnet mask of 248?
Options: 16,382,    8,190,    4,094,    2,046

Ans:D ,D


. What determines a table’s sort order?
Options: a. AutoNumber field b. Index field c. Field order d. Primary key

Ans:– b,– b


. In MS Word, Ctrl+S is for …..
Options: a. Scenarios b. Size c. Save d. Spelling Check

Ans:–  C,–  C


Visual clues that are helpful in computer vision include:
Options: colour and motion,    depth and texture,    height and weight,    a and b above

Ans:D ,D


Which of the following statements are correct about the program? #include<stdio.h> int main() { printf("%p\n", main()); return 0; }
Options: It prints garbage values infinitely,    Runs infinitely without printing anything,    Error: main() cannot be called inside printf(),    No Error and print nothing

Ans:B ,B


. “New Comment” option can be found under _________ tab
Options: Insert B. Data C. Review D. View

Ans:– C ,


Which would you choose to create a bar diagram?
Options: Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

Ans:– B ,


. Which tab in Font dialog box contain options to apply font effects?
Options: a. Font tab b. Character Spacing c. Text Effects d. Standard Toolbar

Ans: – A , – A


In a PowerPoint presentation
Options: a. Sound clips can be inserted but not movie clips b. Movie clips can be inserted but not sound clips c. Both cannot be inserted d. Both can be inserted

Ans: – D , – D

www.000webhost.com