. What is the shortcut key to insert current date in a cell?


Options: CTRL + D B. CTRL + T C. CTRL + ; D. CTRL + /

Ans: – C ,


Description: mcqquestions






More MS-Excel Related questions:


Which command is used with vi editor scroll half page backward?
Options: [Control-d],    [Control - u],    [Control-c],    [Control -P]

Ans:B ,B


Who developed a mechanical device in the 17th century that could add, subtract, multiply, divide and find square roots?
Options: Napier,    Babbage,    Pascal,    Leibnitz

Ans:D ,D


Which menu do you choose to create header? (in MS Office 2003)
Options: format, header and footer B. view, header C. insert, header and footer D. view, header and footer

Ans:– A ,


To get the Thevenin voltage, you have to
Options: Short the load resistor,    Open the load resister,    Short the voltage source,    Open the voltage source

Ans:A ,A


What is the first octet range for a class B IP address?
Options: 128 - 255,    1 - 127,    192 - 223,    128 - 191

Ans:D ,D


Which of the following resources must be protected by the operating system?
Options: I/O B. Memory C. CPU D. All of the above

Ans:– D ,


An advantage of blocking a tape is that
Options: additional processing time is consumed,    the direct file method can be emulated,    tapes contain less data and longer tapes,    less tape is used to store the same amount of data

Ans:D ,D


What command is used to display the characteristics of a process?
Options: au,    ps,    du,    pid

Ans:B ,B


Underlined character on the menu or dialog box known as
Options: a. Hot spot, b. Hot key, c. Pane, d. Underline word

Ans:b,Hot key


Operating system functions may include
Options: input/output control,    virtual storage,    multiprogramming,    All of the above

Ans:D ,D


.   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


What is the first octet range for a class C IP address?
Options: 192 - 255,    192 - 223,    192 - 226,    128 - 191

Ans:B ,B


The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B ,B


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: – D , – D


Corporate modeling software can be used for
Options: cash planning,    operational budgeting,    capital budgeting,    All of the above

Ans:D ,D


In comparison with static RAM memory, the dynamic RAM memory has
Options: lower bit density and higher power consumption,    higher bit density and higher power consumption,    lower bit density and lower power consumption,    higher bit density and lower power consumption

Ans:D,D


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

Ans:B ,B


. A __________ enables you to view data from a table based on a specific criterion
Options: a. Form b. Query c. Macro d. Report

Ans:0 – b ,0 – b


What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Options: Full media,    Graphics media,    Multimedia,    Hypertext

Ans:C ,C


The file created yesterday is called the
Options: "son" file,    "father" file,    "mother" file,    "grandfather file"

Ans:B ,B


. Essential files of DOS are
Options: a. Command.com and IO.Sys b. IO.Sys and DOS.Sys c. DOS.Sys and Command.com d. Autoexec.bat and Config.sys

Ans:2 – b ,2 – b


What will be the output of the program? #include<stdio.h> #include<stdarg.h> void fun(char *msg, ...); int main() { fun("IndiaBIX", 1, 4, 7, 11, 0); return 0; } void fun(char *msg, ...) { va_list ptr; int num; va_start(ptr, msg); num = va_arg(ptr, int); num = va_arg(ptr, int); printf("%d", num); }
Options: IndiaBIX 1 7 11 0,    1,    4,    7

Ans:C ,C


. Serial access memories are useful in applications where
Options: A) Data consists of numbers B) Short access time is required C) Each stored word is processed differently D) Data naturally needs to flow in and out in serial form

Ans:2-D,2-D


Which of the following commands will display the current IP addressing and the layer 1 and 2 status of an interface? show version show protocols show interfaces show controllers show ip interface
Options: 1, 2 and 4,    2, 3 and 5,    3 and 4 only,    None of the above

Ans:B ,B


The PowerPoint view that displays only text (title and bullets) is
Options: a. Slide show b. Slide sorter view c. Notes page view d. Outline view

Ans: – D , – D


Instructions and memory address are represented by
Options: A) Character code B) Binary codes C) Binary word D) Parity bit

Ans:-B,-B


The front-end processor is dedicated to perform which of the following function(s)?
Options: polling,    synchronization,    error checking,    All of the above

Ans:E ,E


In which directory can you store system user default files used for creating user directories?
Options: /usr/tmp,    /etc/default,    /etc/skel,    /etc/users

Ans:C ,C


The insect type robot Attila is a more competent version of the robot Genghis an weights 1.7 kg. What is the number of microprocessors carried by its body?
Options: 15,    10,    33,    15

Ans:B ,B


A hashing scheme is used with
Options: sequential file organization,    direct file organization,    indexed sequential file organization,    partitioned file organization

Ans:B,B


Voltage is
Options: The flow of charged particles through a material,    The smallest electrically charged particle,    Trie force that causes electrons to flow,    The number of free electrons in an atom

Ans:C ,C


In LISP, the function (list-length <list>)
Options: returns a new list that is equal to <list> by copying the top-level element of <list>,    returns the length of <list>,    returns t if <list> is empty.,    All of the above

Ans:B ,B


If a piece of data is stored in two places in the database, then 
Options: a . storage space is wasted b . changing the data in one spot will cause data inconsistency c . in can be more easily accessed d . both and b

Ans:.d,.d


Match the device driver HIMEM.SYS to its operation.
Options: Supports (ANSI) terminal emulation,    Manages the use of extended memory,    Uses expanded memory on a 80386 processor,    Supports code page switching

Ans:B ,B


Which of the following statement is true?
Options: A switch creates a single collision domain and a single broadcast domain. A router creates a single collision domain.,    A switch creates separate collision domains but one broadcast domain. A router provides a separate broadcast domain.,    A switch creates a single collision domain and separate broadcast domains. A router provides a separate broadcast domain as well.,    A switch creates separate collision domains and separate broadcast domains. A router provides separate collision domains.

Ans:B ,B


What command is used to count the total number of lines, words, and characters contained in a file?
Options: countw,    wcount,    wc,    count p

Ans:C ,C


Which computer was considered the first electronic computer until 1973 when court invalidated the patent?
Options: A) ENIAC B) MARK I C) Z3 D) ABC

Ans:-A,-A


. The personnel who deals with the computer and its management put together are called
Options: A) Software B) Human ware C) Firmware D) Hardware

Ans:B,B


.   Which of the following tools enable you to add text to a slide without using the standard placeholders?
Options: a. Text box tool b. Line tool; c. Fill color d. Auto shapes tool

Ans:3 – A ,3 – A


. Apple company used chips from ______ for its computers
Options: A) Intel B) Motorola C) Both of above D) None of above

Ans:B,B


Which of the following pane is not available in Task Pane?
Options: a. Getting Started b. Clip Art c. Word Art d. Search Results

Ans:– C ,– C


Documentation is prepared
Options: at every stage,    at system design,    at system analysis,    at system development

Ans:A ,A


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


Which of the following is not Unary operation?
Options: Select B. Project C. Rename D. Union

Ans:– D ,


. Which of the following Excel screen components can NOT be turned on or off?
Options: a.  Formula Bar b.  Status Bar c.  Tool Bar d.  None of above

Ans:– d,– d


Which of the following is the largest manufacturer of Hard Disk Drives?
Options:  IBM B.  Seagate C.  Microsoft D.  3M

Ans:– B ,


Which command(s) is(are) used to redefine a column of the table in SQL ?
Options: ALTER TABLE,    DEFINE TABLE,    MODIFY TABLE,    All of the above

Ans:A ,A


The ALU and control unit of most of the microcomputers are combined and manufactured on a single silicon chip. What is it called?
Options: Monochip,    Microprocessor,    ALU,    Control Unit

Ans:B ,B


The fastest read/write time and most efficient data storage of any disk array type is:
Options: RAID-0.,    RAID-1.,    RAID-2.,    RAID-3.

Ans:A ,A


RS-232-G
Options: is an interface between two data circuit terminating equipment as examplified by a local and remote modem,    is an interface standard between Data terminal Equipment and Data Circuit Terminating Equipment,    specifies only the mechanical characteristics of an interface by providing a 25-pin connector,    requires only 7 pin out of 25 in order to transmit digital data over public telephone lines

Ans:B ,B

www.000webhost.com