What is the shortcut key to Update Formula in a table?

Options: F9 B. Alt + F9 C. Ctrl + F9 D. Shift + F9

Ans:– A ,

Description: mcqquestions

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

Hits Today: 10207 | Level: Moderate


Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.

Got some suggestion about this question or to make this site better? Please leave your comments below.

More MS-Word Related questions:

A server-side extension is needed to do what?
Options: Allow a request from a client to access the database.,    Allow a request from a client to access a HTML-formatted page.,    Allow a request from a client to access Web pages.,    All of the above.

Ans:A ,A

Sort/Report generators
Options: a . are faster than index/report generators b . require more disk space than indexed/report generators c . do not need to sort before generating report d . both a and b

Ans:D,Both A and B

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

Ans:D ,D

. You can use the format painter multiple times before you turn it off by
Options: a. You can use the format painter button only one time when you click it b. Double clicking the format painter button c. Pressing the Ctrl key and clicking the format painter button d. Pressing Alt key and clicking the format painter button

Ans:– b,– b

A memory that does not change its contents without external causes is known as
Options: Dynamic memory,    Static memory,    RAM,    EEPROM


An operating system is a program or a group of programs that
Options: Helps in checking the spelling of Word B. Maintain the relationship in Database C. Manages the resources of the Computer D. Performs the calculations of cells in Excel

Ans:– C ,

In CRC there is no error if the remainder at the receiver is _____.
Options: equal to the remainder at the sender,    zero,    nonzero,    the quotient at the sender

Ans:B ,B

Which of the following are benefits of VLANs? They increase the size of collision domains. They allow logical grouping of users by function. They can enhance network security. They increase the size of broadcast domains while decreasing the number of collision domains. They simplify switch administration. They increase the number of broadcast domains while decreasing the size of the broadcast domains.
Options: 1 and 5,    2 and 4,    1, 3 and 5,    2, 3 and 6

Ans:D ,D

Which of the following is used as "Input device" for the computer?
Options: Printer,    VDU,    TV,    Light pen

Ans:D ,D

It is a database object to view, change, and analyze data in different ways
Options: a. query b. form c. report d. None of the above

Ans:ndash; a,ndash; a

The imitation of one device or system by another is
Options: Simulation,    Emulation,    Resilience,    Compaction

Ans:B ,B

A word processor would most likely be used to do
Options: a. keep an account of money spent b. do a computer search in media center c. maintain an inventory d. type a biography

Ans:– D,D

60. You need to jump to the next column breaking current column right at the cursor position. How can you break column?
Options: a. Pressing Ctrl+Enter b. Pressing Alt+Shift+Enter c. Break command from Insert menu d. Both b and c

Ans:– C ,– C

The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in Electronic Data Processing system is called
Options: ASCII,    EBCDII,    BCD,    All of the above

Ans:A ,A

. Oncetext has been cut to the clipboard, you can .....that text into another document
Options: a. Paste b. Copy c. Transfer d. None of the above

Ans: a, a

Production machines were first controlled by the computer by means of
Options: punched cards,    punched paper tape,    magnetic tape,    magnetic cards

Ans:B ,B

Point out the error in the following program. #include<stdio.h> #include<stdarg.h> int main() { void display(int num, ...); display(4, 12.5, 13.5, 14.5, 44.3); return 0; } void display(int num, ...) { float c; int j; va_list ptr; va_start(ptr, num); for(j=1; j<=num; j++) { c = va_arg(ptr, float); printf("%f", c); } }
Options: Error: invalid va_list declaration,    Error: var c data type mismatch,    No error,    No error and Nothing will print

Ans:B ,B

. For what Antikyathera was used?
Options: A) For counting B) For Calculating tax collection C) For calculating astronomical positions D) For calculating firing weapons


. Which bar is usually located below that Title Bar that provides categorized options?
Options: a. Menu bar b. Status Bar c. Tool bar d. Scroll bar

Ans: –  A , –  A

Which of the following is a type of preventative maintenance used on a hard drive?
Options: Disk check diagnostics,    Head alignment diagnostics,    Initializing,    Uninstalling programs

Ans:A ,A

You are unsuccessful in telnetting into a remote device. What could the problem be? IP addresses are incorrect. Access control list is filtering Telnet. There is a defective serial cable. The VTY password is missing.
Options: 1 only,    3 only,    2 and 4 only,    All of the above

Ans:C ,C

The first AI programming language was called:
Options: BASIC,    FORTRAN,    IPL,    LISP

Ans:C ,C

. Which of the following helps to reduce spelling error in the document?
Options: a. Auto Format b. Auto Correct c. Smart Tags d. Auto Text

Ans:–  B,–  B

The PROJECT command will create new table that has
Options: more fields than the original table,    more rows than the original table,   None of the above,    all the fields of master table

Ans:E ,C

From a data systems design viewpoint, the number of different types of general ledger entries is
Options: six,    three,    four,    one

Ans:C ,C

For speech understanding systems to gain widespread acceptance in office automation, they must feature:
Options: speaker independence,    speaker dependence,    isolated word recognition,    All of the above

Ans:A ,A

Human beings are referred to as Homosapiens. Which device is called Silico sapiens?
Options: Monitor,    Hardware,    Robot,    Computer


. Line spacing refers to
Options: a. The space between the lines of text b. The height of the line c. The length of the line d. a and c

Ans:6 – A ,6 – A

DHCP is the abbreviation of
Options:  Dynamic Host Control Protocol B.  Dynamic Host Configuration Protocol C.  Dynamic Hyper Control Protocol D.  Dynamic Hyper Configuration Protocol

Ans:– B ,

. DOS uses a special batch file named?
Options: a. Autoexec.bat b. Autoexe.bat c. Autoexecute.bat d. Auto.bat

Ans:5 – a ,5 – a

. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Options: a. Standard b. Formatting c. Drawing d. Picture

Ans:– d,– d

How would you allow device drivers and TSR's to be loaded into Upper Memory Blocks?
Options: DOS=High,    Devicehigh=,    Loadhigh=,    DOS=UMB

Ans:D ,D

Systems that supply data for operations execution or supervision all concern
Options: exception reports,    computing systems,    orders,    All of the above

Ans:C ,C

COM1 is typically represented by which of the following?
Options: 15 pin port,    9 pin male port,    9 pin female port,    25 pin male port

Ans:B ,B

If you want to group the records in the abc database, you could use the Jobcode as the _____.
Options: Delete,    Update,    Sort Key,    Index

Ans:C ,C

How many truth table entries are necessary for a four-input circuit?
Options: 4,    8,    12,    16

Ans:D ,D

. Which of the following is invalid field name?
Options: a. Student.Address b. Student’sAddress c. Student_Address d. Student Address

Ans:– a,– a

A pen shaped device which can sense light, and is used to point at spots on a video screen.
Options: Mouse,    Light pen,    Joystick,    Plotter


What is the first thing you could do to check for damage to a printer after receiving it?
Options: Run MSD diagnostics,    Attach it to a PC and print something,    Check the cables,    Unbox it and examine it for physical damage

Ans:D ,D

18. Which command is used to delete all the files extension .txt on the current drive and directory?
Options: a. Del .txt b. Erase .txt c. Del *.txt d. Del *.*/p

Ans:Correct Answer: c ,Correct Answer: c

If the values of a variable in one module is indirectly changed by another module, this situation is called
Options: A)internal change b.inter-module change c.side effect d.side-module update

Ans:C,Side effect

Which combination of keys allows you to perform a warm boot?
Options: Ctrl+ESC,    Ctrl+Alt+DEL,    Ctrl+Shift+DEL,    Ctrl+Shift+ENTER

Ans:B ,B

Which of the following is correct for a gated D-type flip-flop?
Options: The Q output is either SET or RESET as soon as the D input goes HIGH or LOW.,    The output complement follows the input when enabled.,    Only one of the inputs can be HIGH at a time.,    The output toggles if one of the inputs is held HIGH.

Ans:A ,A

Which of the following is correct regarding Class B Address of IP address
Options: Network bit – 14, Host bit – 16 B. Network bit – 16, Host bit – 14 C. Network bit – 18, Host bit – 16 D. Network bit – 12, Host bit – 14

Ans:– A ,

Which of the following statements mentioning the name of the array begins DOES NOT yield the base address? 1: When array name is used with the sizeof operator. 2: When array name is operand of the & operator. 3: When array name is passed to scanf() function. 4: When array name is passed to printf() function.
Options: A,    A, B,    B,    B, D

Ans:B ,B

. 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

Which command displays the configuration register setting?
Options: show ip route,    show boot version,    show version,    show flash

Ans:C ,C

When configuring a new network interface card for installation, which of the following would be a valid I/O address?
Options: 378,    2F8,    3F8,    360

Ans:D ,D

Linked lists are best suited
Options: a. for relatively permanent collections of data b. for the size of the structure and the data in the structure are constantly changing c. for both of above situation d. for none of above situation  


The Paste Special command lets you copy and paste:
Options: a. Multiply the selection by a copied value b. Cell comments c. Formatting options d. The resulting values of a formula instead of the actual formula

Ans:#8211; d,#8211; d