The default header for a worksheet is


Options: Username B. Date and Time C. Sheet tab Name D. None

Ans:– D ,


Description: Its like Book1 -Microsoft Excel

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

Hits Today: 11009 | 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 prefix for billion which is equal to _____ is called as billi.
Options: 100,    10000,    1000,    10

Ans:D ,D


.   to add a new row to a table you would
Options: a. click the insert rows command on the insert menu b. press the enter key c. click the insert rows button on the standard toolbar d. none of the above

Ans:8 – D ,8 – D


Which of the following is correct in VLSM?
Options: Can have subnets of different sizes B. Subnets must be in same size             C. No required of subnet D. All of above

Ans:– A ,


After doing a low-level format, what would be the next step in configuring the hard drive in a system?
Options: Format DOS partition,    Install operating system,    Configure DMA channel and back-up interrupt,    Partition had disk

Ans:A ,A


. Tab scroll buttons are place on Excel screen
Options: a.  towards the bottom right corner b.  towards the bottom left corner c.  towards the top right corner d.  towards the top left corner

Ans:– b,– b


    Which command lists the contents of current directory of a disk
Options: a.    Copy b.    Tree c.    Cd d.    Dir

Ans:D,Correct Answer: Dir


File specification books are created primarily for the use of
Options: systems analysts,    programmers,    operators,    managers

Ans:B ,B


Batch processing is appropriate if
Options: a large computer system is available,    only a small computer system is available,    only a few transactions are involved,    All of the above

Ans:E ,E


. The key F12 opens a
Options: a. Save As dialog box b. Open dialog box c. Save dialog box d. Close dialog box

Ans:– A,– A


Which command is used to remove a directory?
Options: rd,    rmdir,    dldir,    rdir

Ans:B ,B


Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options: MUST COVER,    MUST NOT,    Both of the above.,    None of the above is correct.

Ans:A ,A


A human cannot feel a static discharge as high as _____ volts.
Options: 200,    2000,    10000,    50000

Ans:A ,A


A statement - by - statement description of a procedure is detailed in a;
Options: written narrative,    procedure's log,    systems flowchart,    record layout

Ans:A ,A


The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
Options: Dirty data,    Inconsistent data,    Too much data,    Non-integrated data

Ans:C ,C


. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
Options: A) Magnetic core memory B) Magnetic tape memory C) Magnetic disk memory D) Magnetic bubble memory

Ans:D,D


The heart of automation technology is.
Options: robots,    computers,    control,    sensors

Ans:B ,B


To make possible the efficient on-line servicing of many teleprocessing system users on large computer systems, designers are developing
Options: communication systems,    multiprogramming systems,    virtual storage systems,    All of the above

Ans:D ,D


. Which of the following is related to fifth generation computers?

Options: A) Knowledge information processing system B) Very large scale integration (VLSI) C) Both of above D) Only b

Ans:A,A


. Which device is used to backup the data?
Options: A) Floppy Disk B) Tape C) Network Drive D) All of the above

Ans:D,D


A mechanism for arranging controlled access to a shared resource is
Options: Retrieving,    Sorting,    Balleting,    Lock-out

Ans:D ,D


. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
Options: a. datasheet border b. datasheet underline c. Column Header underline d. vertical gridline

Ans:– c,– c


On a systems flowchart, the online manual keeping of input data is identified by using the
Options: online storage symbol,    Online keyboard symbol,    keeping operation symbols,    manual operation symbols

Ans:B ,B


“Ctrl + Down Arrow” is used to
Options: a. Moves the cursor one paragraph down b. Moves the cursor one line down c. Moves the cursor one page down d. Moves the cursor one screen down

Ans:–  A,–  A


Typewriter terminals can print computer-generated data at a rate of
Options: 10 characters per second,    120 characters per second,    120 characters per minute,    1200 characters per minute

Ans:B ,B


The explanation facility of an expert system may be used to:
Options: construct a diagnostic model,    expedite the debugging process,    explain the system's reasoning process,    All of the above

Ans:E ,E


Structured data may include which of the following?
Options: Photo image,    Video clip,    Dates,    None of the above.

Ans:C ,C


In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Options: The line numbers reported match the line numbers you see in your text editor.,    SQL*Plus will automatically show the errors to you.,    To see the errors, enter SHOW ERRORS in SQL*Plus.,    If there are no syntax errors, you will receive the message "NO ERRORS."

Ans:C ,C


Which of the following functional components of a computer is responsible for the transient or temporary storage used by the CPU?
Options: Input,    Output,    CPU .,    Memory

Ans:D ,D


You are working with a network that has the network ID 192.168.10.0. What subnet should you use that supports four subnets and a maximum number of hosts?
Options: 255.255.255.192,    255.255.255.224,    255.255.255.240,    255.255.255.248

Ans:B ,B


What will be the output of the program? #include<stdio.h> int main() { const c = -11; const int d = 34; printf("%d, %d\n", c, d); return 0; }
Options: Error,    -11, 34,    11, 34,    None of these

Ans:B ,B


Which JDBC driver Type(s) can be used in either applet or servlet code?
Options: Both Type 1 and Type 2,    Both Type 1 and Type 3,    Both Type 3 and Type 4,    Type 4 only

Ans:C ,C


. A computer can solve more than one kind of problem. This is related to which of the following characteristics?
Options: A) Accuracy B) Reliability C) Versatility D) Automatic

Ans:8-C,8-C


Which of the following is not an output device?
Options:  Scanner B.  Printer C.  Flat Screen D.  Touch Screen

Ans:– A ,


What will be the output of the program? #include<stdio.h> int main() { float *p; printf("%d\n", sizeof(p)); return 0; }
Options: 2 in 16bit compiler, 4 in 32bit compiler,    4 in 16bit compiler, 2 in 32bit compiler,    4 in 16bit compiler, 4 in 32bit compiler,    2 in 16bit compiler, 2 in 32bit compiler

Ans:A ,A


What will be the output of the program ? #include<stdio.h> int main() { static int arr[] = {0, 1, 2, 3, 4}; int *p[] = {arr, arr+1, arr+2, arr+3, arr+4}; int **ptr=p; ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *++ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); ++*ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); return 0; }
Options: 0, 0, 0 1, 1, 1 2, 2, 2 3, 3, 3,    1, 1, 2 2, 2, 3 3, 3, 4 4, 4, 1,    1, 1, 1 2, 2, 2 3, 3, 3 3, 4, 4,    0, 1, 2 1, 2, 3 2, 3, 4 3, 4, 5

Ans:C ,C


Referential integrity means
Options: a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key field of child table if that value does not exist in  the primary key of the parent table c. Do not enter a value in the foreign key field of a parent table if that value does  not exist in the primary key of the child table d. All of above

Ans:ndash; a,ndash; a


A programming language intended to solve a no. of different types of problems is
Options: COBOL,    General purpose programming language,    BASIC,    FORTRAN

Ans:B ,B


When was the X Window System born?
Options: 1984,    1989,    1988,    1990

Ans:A ,A


Assembly code data base is associated with
Options: a permanent table which lists all key words and special symbols of the language in symbolic form,    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 or the tokens as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    assembly language version of the program which is created by the code generation phase and is input to the assembly phase

Ans:D ,D


. The effect applied to display when slides changes in slide show view is
Options: a.  Slide Animation b.  Custom Animation c.  Custom Transition d.  Slide Transition

Ans:7 – D ,7 – D


An application suitable for sequential processing is
Options: A) Processing of grades B) Payroll processing C) Both a and b D) All of above

Ans:-C,-C


2. Which command is used to see the sub-directory structure of drive?
Options: a. Tree b. List c. Subdir d. Subtree

Ans:Correct Answer: a ,Correct Answer: a


Which option is used with cmp command to give a detailed list of the byte number and the differing bytes in octal for each character that differs in both the files?
Options: -l,    -d,    -r,    -b

Ans:A ,A


One byte can be used to encode any integer between 'O' and -inclusive
Options: 16,    256,    128,    255

Ans:D ,D


Memory
Options: is a device that performs a sequence of operations specified by instructions in memory.,    is the device where information is stored,    is a sequence of instructions,    is typically characterized by interactive processing and time-slicing of the CPU's time to allow quick response to each user.

Ans:B ,B


Data has to be _____ before it can be converted into information.
Options: transformed,    processed,    changed,    engineered

Ans:B ,B


Impact printers
Options: strike a ribbon against the paper to produce character images,    include ink-jet and thermal devices,    are more expensive than Laser printers,    use optical technology

Ans:A ,A


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


Want your logo in the same position on every slide, automatically? Insert it on the
Options: a. Handout master b. Notes master c. Slide master d. All of the above

Ans: – C , – C


Material consisting of text and numbers is best presented as
Options: a. A table slide b. A bullet slide c. A title slide d. All of the above

Ans: – A , – A

www.000webhost.com