What should be add before a fraction to avoid entering it as a date?

Options: // B. FR C. Zero D. Zero Space

Ans:– D ,

Description: mcqquestions

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

Hits Today: 15874 | 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-Excel Related questions:

. What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options: A) Compiler B) Interpreter C) Debugger D) Assembler


Snapshot of the data in the database at a given instant of time is called
Options: Database Schema B. Database Instance C. Database Snapshot D. All of the above

Ans:– B ,

How does a parallel port communicate information to a peripheral device?
Options: one bit at a time,    8 bytes at a time,    one byte at a time,    16,555 bytes at a time

Ans:C ,C

. In order to perform a calculation in a spreadsheet, you need to use a:
Options: a. table b. formula c. field d. variable

Ans:– b,– b

What SQL command can be used to add columns to a table?
Options: MODIFY TABLE TableName ADD COLUMN ColumnName,    MODIFY TABLE TableName ADD ColumnName,    ALTER TABLE TableName ADD COLUMN ColumnName,    ALTER TABLE TableName ADD ColumnName

Ans:D ,D

Using the following illustration, what would be the IP address of E0 if you were using the eighth subnet? The network ID is and you need to use the last available IP address in the range. The zero subnet should not be considered valid for this question.

Ans:A ,A

Which command displays RIP routing updates?
Options: show ip route,    debug ip rip,    show protocols,    debug ip route

Ans:B ,B

You can create a new presentation by completing all of the following except
Options: a. Clicking the new button on the standard toolbar b. Clicking file, new c. Clicking file open d. Pressing ctrl + N

Ans: – C , – C

9. ….share characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:Correct Answer: a,Correct Answer: a

Excel uniquely identifies cells within a worksheet with a cell name
Options: Cell names,Column numbers and row letters,Column letters and row numbers,Cell locator coordinates

Ans:C,Column letters and row numbers

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

. Which of the following memories allows simultaneous read and write operations?
Options: A) ROM B) RAM C) EPROM D) None of above


A top-to-bottom relationship among the items in a database is established by a 
Options: a. hierarchical schema b. network schema c. relational schema d. all of the above


A path by which communication is achieved between a central processor and other devices is called
Options: Audit trail,    Network,    Bus,    Channel

Ans:C ,C

Which of the following registers is loaded with the contents of the memory location pointed by the PC?
Options: Memory Address Register,    Memory Data Register,    Instruction Register,    Program Counter


What is the name of the computer program that contains the distilled knowledge of an expert?
Options: Data base management system,    Management information System,    Expert system,    Artificial intelligence

Ans:C ,C

What is route poisoning?
Options: It sends back the protocol received from a router as a poison pill, which stops the regular updates.,    It is information received from a router that can't be sent back to the originating router.,    It prevents regular update messages from reinstating a route that has just come up.,    It describes when a router sets the metric for a downed link to infinity.

Ans:D ,D

Which policy replace a page if it is not in the favoured subset of a process's pages?
Options: FIFO,    LRU,    LFU,    Working set

Ans:D ,D

. Which function can not be used for calculated controls in a report?
Options: a. SUM b. AVG c. MPT d. COUNT

Ans:– c,– c

. You can detect spelling and grammar errors by
Options: a. Press Shift + F7 b. Press Ctrl + F7 c. Press Alt+ F7 d. Press F7

Ans:– D,– D

Which of the following commands is used to absolutely assign all permissions to the owner, read and write permissions to the group and only executable permission to the others of the file note?
Options: chmod 761 note,    chmod 671 note,    chmod 167 note,    chmod 4=rwx, g=rw note

Ans:A ,A

. What is the use of a master document in Word 2010?
Options: It organize and maintain a Fonts & Pictures by creating a master folder B. It organize and maintain a Heading and Styles by creating a master list C. It organize and maintain a Long document by dividing it into several subdocuments D. It organize and maintain a Styles and Links by creating a separate master document

Ans:– C ,

For what purposes are views used?
Options: To hide columns only,    To hide rows only,    To hide complicated SQL statements only,    All of the above are uses for SQL views.

Ans:D ,D

If every non-key attribute is functionally dependent on the primary key, the relation will be in
Options: First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form

Ans:– C ,

The application layer of a network
Options: establishes, maintains, and terminates virtual circuits,    defines the user's port into the network,    consists of software being run on the computer connected to the network,    All of the above

Ans:C ,C

Periodically adding, changing and deleting file records is called file
Options: Updating,    upgrading,    restructuring,    renewing

Ans:A ,A

  Which of the following is not an option of the spelling dialog box?
Options: Ignore B. Ignore all C. Edit D. Change

Ans:– C ,

What is the name of the chip which has more than once processor on it?
Options: Parallel chip,    Multi-processor chip,    Transputer,    Parallel processor

Ans:C ,C

. Napier Bones were invented in
Options: A) 1614 B) 1617 C) 1620 D) None of above


. Which command is used to provide access to program located in other directory or disk?
Options: a. Tree b. Path c. Dir d. CD

Ans:5 – d ,5 – d

. Home Key
Options: Moves the cursor beginning of the document B. Moves the cursor beginning of the paragraph C. Moves the cursor beginning of the screen D. Moves the cursor beginning of the line

Ans:– D ,

The software used to drive microprocessor-based systems is called:
Options: assembly language programs,    firmware,    BASIC interpreter instructions,    flowchart instructions

Ans:A ,A

Point out the error in the program in 16-bit platform? #include<stdio.h> int main() { struct bits { int i:40; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 4,    2,    Error: Bit field too large,    Error: Invalid member access in structure

Ans:C ,C

  Dedicated Computer means
Options: Doesn’t have OS B. Used by single person C. Assigned to one and only one task D. All of Above

Ans:– C ,

Which of the following transfers data contained on computer cards to the computer system.
Options: Card sorter,    Card reader,    Magnetic disk,    Magnetic tape

Ans:B ,B

. A data map is helpful
Options: a. When you have too much data to chart b. To show a geographic distribution of data c. To compare data points d. To show changes in data over time

Ans:– b,– b

If attribute A determines both attributes B and C, then it is also true that:
Options: A → B.,    B → A.,    C → A.,    (B,C) → A.

Ans:A ,A

. The formats defined by _____ include character formatting, such as the font and font size; paragraph formatting, such as line spacing and text alignment; table formatting; and list formatting.
Options: a. options b. styles c. toolbars d. tabs

Ans: – B , – B

. Which file keeps commands to execute automatically when OS is started?
Options: a. command . com b. any batch file c. autoexec.bat d. config.sys

Ans:9 – c ,9 – c

.   Which is the best view for getting your thoughts for a presentation out on the computer?
Options: a. Outline view b. Notes page view c. Slide sorter view d. Slide view

Ans:5 – A ,5 – A

How many bits are used in the address bus?
Options: 7,    8,    9,    16

Ans:D ,D

Which three commands can be used to check LAN connectivity problems on a router? show interfaces show ip route tracert ping dns lookups
Options: 1 ,2 and 4,    2 and 5,    3 and 5,    None of the above

Ans:A ,A

What is meant by the term RAM?
Options: Memory which can only be read,    Memory which can be both^read and written to,    Memory which is used for permanent storage,    Memory which can only be written to


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, 


. Pick out odd
Options: a. Windows b. Window c. DOS d. Linux

Ans:5 – b ,5 – 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

A circular reference is
Options: a. Geometric modeling tool b. A cell that points to a drawing object c. A formula that either directly or indirectly depends on itself d. Always erroneous

Ans:#8211; c,#8211; c

. You can add or remove program
Options: a. Add/remove program from control panel b. Delete the shortcut icon from desktop c. Both a and b d. None of above

Ans:2 – a ,2 – a

The situation when in a linked list START=NULL is
Options: a. underflow b. overflow c. housefull d. saturated  


. What should be add before a fraction to avoid entering it as a date?
Options: a. // b. FR c. Zero d. Zero Space

Ans:– d,– d