MS-EXCEL can be used to automate


Options: Financial statements, Business forecasting B. Transaction registers, inventory control C. Accounts receivable, accounts payable D. Any of the above

Ans:– D ,


Description: mcqquestions

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

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


If you do not know which version of MS-DOS you are working with, which command will you use after having booted your operating system?
Options: FORMAT command,    DIR command,    VER command,    DISK command

Ans:C ,C


To build a modularized kernel, the kernel-headers and kernel-source packages must first be installed. Where will you find the kernel-headers and kernel-source?
Options: /usr/local,    /usr/src/linux,    /usr/sre/redhat,    /usr/bin

Ans:B ,B


If the base supply voltage increases, the Q point moves
Options: down,    up,    nowhere,    off the load line

Ans:A ,A


. RATS stand for
Options: A) Regression Analysis Time Series B) Regression Analysis Time Sharing C) Real Analysis Series D) All of above

Ans:A,A


Inheritance is which of the following?
Options: When a supertype entity inherits values of the subtype attribute,    When a subtype entity inherits values of the supertype attribute,    When a supertype entity inherits values of another supertype attribute,    When a subtype entity inherits values of another subtype attribute

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


You record the algorithm in the _____ column of the IPO chart.
Options: Input,    Output,    Processing,    Purpose

Ans:C ,C


To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,


. Queries can be created in Access by
Options: a. Typing Queries in SQL View b. Drag and Drop fields on Query Builder c. Using Query Wizard d. All of the Above

Ans:– d,– d


. The �.can be defined as the entire windows display and can be envisioned as the electronic equivalent of your own desk�s surface
Options: a. Desktop b. Windows c. Dialog box d. None of above

Ans:6 – a ,6 – a


Point out the error in the following program. #include<stdio.h> #include<stdarg.h> int main() { void display(char *s, int num1, int num2, ...); display("Hello", 4, 2, 12.5, 13.5, 14.5, 44.0); return 0; } void display(char *s, int num1, int num2, ...) { double c; char s; va_list ptr; va_start(ptr, s); c = va_arg(ptr, double); printf("%f", c); }
Options: Error: invalid arguments in function display(),    Error: too many parameters,    Error: in va_start(ptr, s);,    No error

Ans:C ,C


In Decision trees
Options: nodes represent the conditions, with the right side of tree listing the actions to be taken,    the root is drawn on the left and is the starting point on the decision sequence.,    the branch depends on the condition and decisions to made,    All of the above

Ans:D ,D


. Which of the following is NOT true about background images?
Options: a. They are similar to watermarks in Word. b. They are displayed behind the controls in a form. c. They do not print when a form or a report is printed. d. They can be inserted on a form or a report.

Ans:8 – c ,8 – c


. You accidentally erased a record in the sheeWhat command can be used to restore it immediately?
Options: a. Insert b. Copy c. Undo d. Replace

Ans:– c,– c


. What is the use of bookmarks in Microsoft Word?
Options: To easily correct the spelling errors B. To quickly jump to a specific location in the document C. To quickly jump to the ending of the document D. To create a link within the document

Ans:– B ,


. To copy the hidden system files of DOS to another disk you can use the command
Options: a. Copy b. Ren c. Sys d. Diskcopy

Ans:Correct Answer: c ,Correct Answer: c


Which part of the diskette should never be touched?
Options: Hub,    Centre,    Oval slot,    Corner

Ans:C ,C


What will be the output of the program? #include<stdio.h> typedef unsigned long int uli; typedef uli u; int main() { uli a; u b = -1; a = -1; printf("%lu, %lu", a, b); return 0; }
Options: 4343445454, 4343445454,    4545455434, 4545455434,    4294967295, 4294967295,    Garbage values

Ans:C ,C


. EBCDIC can code up to how many different characters?
Options: A) 256 B) 16 C) 32 D) 64

Ans:A,A


The two classifications of inputs are
Options: energies and maintenance,    maintenance and waste,    maintenance and signal,    products and waste

Ans:C ,C


Point out the error in the program? #include<stdio.h> int main() { struct a { float category:5; char scheme:4; }; printf("size=%d", sizeof(struct a)); return 0; }
Options: Error: invalid structure member in printf,    Error in this float category:5; statement,    No error,    None of above

Ans:B ,B


If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.
Options:  A) Embed Fonts, B) Embed True Type Fonts, C) Save True Type Fonts, D) Save Fonts,

Ans:-B,-B


During the system study, analysts determine manager's information needs by
Options: conducting tours of a nearby computer center,    asking questions,    showing samples of computer reports,    teaching short courses in programming languages

Ans:B ,B


Information in a memory that is no longer valid or wanted is known as
Options: non-volatile,    volatile,    surplus,    garbage

Ans:D ,D


14. What is the name of the latest server operating system developed by Microsoft?
Options: a. Windows NT b. Windows 2000 c. Windows XP d. Windows 2003

Ans:Correct Answer: d,Correct Answer: d


What is the default number of lines to drop for drop cap?
Options:  A) 3, B) 10, C) 15, D) 20,

Ans:-A,-A


11. While working with MS-DOS which command is used to combine file1 plus file2 into new file named file3?
Options: a. Copy file3 file1+file2 b. Copy file1+file2 file3 c. Copy file1+file2+file3 d. Copy file2 file1+file3

Ans:Correct Answer: b,Correct Answer: b


The function(s) of the Storage Assignment is/are:
Options: to assign storage to all variables referenced in the source program,    to assign storage to all temporary locations that are necessary for intermediate results,    to assign storage to literals, and to ensure that the storage is allocated and appropriate locations are initialized,    All of the above

Ans:D ,D


The "end-effector" of a robot:
Options: can be an actual tool,    is the robot "hand",    may have a gripping action,    All of the above

Ans:D ,D


The term PUSH and POP is related to the
Options: a. array b. lists c. stacks d. all of above

Ans: c, c


You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Options: a. Pie chart b. Row chart c. Line chart d. Column chart

Ans:#8211; c,#8211; c


What is the result of adding an IP address to the DNS server search order
Options: It restricts browsing to that DNS server,    It overrides the local systems IP address,    It tells the DNS Server where the local system is located,    It tells the local system where the DNS Server is located

Ans:D ,D


Who was the father of Punched Card Processing?
Options: J Presper Eckert,    Charles Babbage,    Dr. Herman Hollerith,    Blaise Pascal

Ans:C ,C


Assuming 100% efficiency, what is the power being consumed at the secondary winding of the transformer described in question 91?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A


9. Which was the last version of MSDOS that was released separately?
Options: a. 5.0 b. 6.0 c. 6.11 d. 6.22

Ans:Correct Answer: d,Correct Answer: d


A relationship should be specified how in the ODL?
Options: One direction starting with the first class,    One direction starting with the second class,    Neither direction.,    Both directions.

Ans:D ,D


Which of the following is based on Multi Valued Dependency?
Options: a. First b. Second c. Third d. Fourth

Ans:– d ,


Interconnected networks need communication processors such as switches, routers, hubs, and gateways. Select the best fit for answer:
Options: TCP/IP,    Protocol,    Open Systems,    Internetwork processor

Ans:D ,D


Which of the following is the allocation method of a disk space?
Options: Contiguous allocation B. Linked allocation C. Indexed allocation D. All of the Above

Ans:– D ,


While working with MS-DOS, which command is used to specify the size of the disk to format.
Options: FORMAT/F : size,    FORMAT/N : sector,    FORMAT/T : tracks,    FORMAT/V

Ans:A ,A


An autonomous homogenous environment is which of the following?
Options: The same DBMS is at each node and each DBMS works independently.,    The same DBMS is at each node and a central DBMS coordinates database access.,    A different DBMS is at each node and each DBMS works independently.,    A different DBMS is at each node and a central DBMS coordinates database access.

Ans:A ,A


A zener regulator has an input voltage from 15 to 20 V and a load current from 5 to 20 mA. If the zener voltage is 6.8 V, what value should the series resistor have?
Options: 310 Ohm,    400 Ohm,    410 Ohm,    550 Ohm

Ans:C ,C


Which of the following is usually a special one-time operation that must be completed over a limited time period?
Options: Batch,    Patch,    Project,    Word

Ans:C ,C


What command is used to create a backup configuration?
Options: copy running backup,    copy running-config startup-config,    config mem,    wr mem

Ans:B ,B


Ctrl + P
Options: a. Open Paragraph Dialog Box b. Open Page Format Dialog Box c. Open Save Dialog Box d. Open Print Dialog box

Ans:–  D,–  D


. The two basic types of record access methods are:

Options: A) Sequential and random B) Sequential and indexed C) Direct and immediate D) Online and real time

Ans:A,A


A computer system consisting of its processor, memory and I/O devices accepts data, processes it and produces the output results. Can you tell in which component is the raw data fed?
Options: Mass Memory,    Main memory,    Logic unit,    Arithmetic unit

Ans:B,B


The average time necessary for the correct sector of a disk to arrive at the read write head is _____
Options: Down time,    Seek time,    Rotational delay,    Access time

Ans:C ,C


Which of the following divides the high speed signal into frequency bands?
Options: t-switch,    modem,    frequency-division multiplexer,    time-division multiplexer

Ans:C ,C


A machine associated with card-based data processing is
Options: Codomain,    Collator,    Cartridge,    Digitizer

Ans:B ,B

www.000webhost.com