. How do you rearrange the data in ascending or descending order?

Options: Data, Sort B. Data, Form C. Data, Table D. Data Subtotals

Ans: – A ,

Description: mcqquestions

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

Hits Today: 5790 | 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 is a slide transition?
Options: Overheads B. Letters C. A special effect used to introduce a slide in a slide show D. The way one slide looks

Ans:– C ,

.   To adjust the width of table columns, you
Options: a. Click table menu. Column width, then make adjustments b. Drag the vertical gridline between two columns c. Drag the column markers on the table ruler bar d. b and c

Ans:7 – D ,7 – D

The name given to the test that determines whether a machine can think is the:
Options: Gaussian test,    McCarthy test,    Turing test,    Boolean test

Ans:C ,C

A _____ is simply an arrangement where multiple disk drives appear as a single disk drive to the user.
Options: disk,    disk array,    bunch of disks,    disk pack


Which WLAN IEEE specification allows up to 54Mbps at 2.4GHz?
Options: A,    B,    G,    N

Ans:C ,C

_______ provides a connection-oriented reliable service for sending messages
Options: TCP B. IP C. UDP D. All of the above

Ans:– A ,

What is to be use to add text in Slide?
Options: Text Box B. Note Box C. Text Layer D. Comment Box

Ans:– A ,

On-line data entry is most suitable in the case of
Options: updating payroll master,    entering monthly journal entries,    Processing payment of cheque in a bank,    All of the above

Ans:C ,C

Special software to create a job queue is called a
Options: Drive,    Spooler,    Interpreter,    Linkage editor

Ans:B ,B

. Which of the following is the default join between two recordsets?
Options: a. Inner join b. Left outer join c. Right outer join d. Self join

Ans:2 – a ,2 – a

. Which command is used to list out deleted files in DOS?
Options: a. list b. Undelete/list c. Recover d. All of the above

Ans:3 – b ,3 – b

. From which generation computers the printers were used?
Options: A) first B) second C) third D) fourth


The generic two-level data warehouse architecture includes which of the following?
Options: At least one data mart,    Data that can extracted from numerous internal and external sources,    Near real-time updates,    All of the above.

Ans:B ,B

You can embed a MS-Organization Chart in a slide by
Options: a. Clicking the object command on the edit menu b. Clicking the object command on the edit menu c. Clicking the insert new slide button the standard toolbar, then double click the organization chart button on the formatting toolbar d. Clicking the MS-Organization Chart button on the standard toolbar

Ans: – B , – B

In SQL, the CREATE VIEW command is used
Options: to recompile view,    to define a view of one or more tables or views,    to recompile a table,    to create a trigger

Ans:B ,B

In a step-down transformer, which is larger?
Options: Primary voltage,    Secondary voltage,    Neither,    Impossible to say

Ans:A ,A

. Part of the POST process is to ensure that the test of essential peripheral device coincides with the hardware configuration that stored in
Options: a. ROM b. The hard drive c. CMOS d. Cache Memory

Ans:2 – c ,2 – c

HIMEM.SYS controls:
Options: DOS=HIGH,    RMDRIVE.SYS,    SMARTDRV.SYS,    Extended Memory

Ans:D ,D

. Microprocessors can be used to make
Options: A) Computer B) Digital systems C) Calculators D) All of the above


The other Col# are inactive when you’ve select 3 columns. How will you activate those boxes?
Options:  A) double click on spacing box, B) double click on inactive Col#, C) Remove mark from Line between checkbox, D) Remove mark from Equal Column Width check box, 


. Using windows explorer, a plus (+) sign in front of a folder indicates
Options: a. An open folder b. The folder contains subfolder c. A text file d. A graphic file

Ans:7 – b ,7 – b

. What are the three options available in Insert >> Picture menu?
Options: a.  Clipart, Pictures, Shapes b.  Clipart, From File, Shapes c.  Clipart, From Files, AutoShapes d.  Clipart, Pictures, AutoShapes

Ans:7 – C ,7 – C

Relocation bits used by relocating loader are specified (generated) by
Options: Relocating loader itself,    Linker,    Assembler or translator,    Macro processor

Ans:B ,B

Which key is used to increase left indent?
Options: Ctrl+I B. Ctrl+M C. Alt+I D. F10

Ans:– B ,

Distributed Queue Dual Bus is a standard for
Options: LAN,    MAN,    WAN,   LAN and MAN

Ans:D,LAN and MAN

. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Options: a. Edit b. Insert c. Format d. Tools

Ans:– d,– d

Which of the following is used for serial access storage only?
Options: RAM,    Magnetic tape,    Magnetic disk,    Core memory


Which of the following are kinds of instructions?
Options: Input,    Arithmetic,    Conditional branching,    All of the above

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 on ly 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 the Alt key and clicking the format painter button

Ans:#8211; b,#8211; b

What is the term used for describing the judgmental or commonsense part of problem solving?
Options: Heuristic,    Critical,    Value based,    Analytical

Ans:A ,A

The EXISTS keyword will be true if:
Options: any row in the subquery meets the condition only.,    all rows in the subquery fail the condition only.,    both of these two conditions are met.,    neither of these two conditions is met.

Ans:A ,A

Bulletin board system
Options: is a public access message system,    is a modem capable of accepting commands,    converts analog signals to digital signals,    converts digital signals to analog signals

Ans:A ,A

To create queries in Access
Options: a. You can drag and drop fields on query builders b. you can type the SQL command in SQL view c. You can use query wizard or design view d. All of above

Ans:ndash; d,ndash; d

You can add a row using SQL in a database with which of the following?
Options: ADD,    CREATE,    INSERT,    MAKE

Ans:C ,C

When applying a square waveform to a capacitor, the circuit tends to:
Options: peak the voltage and round off the current waveforms,    peak the current and round off the voltage waveforms,    round off both the voltage and current waveforms,    peak both the voltage and current waveforms

Ans:B ,B

A data element in a record, that uniquely distinguishes the record, from all other records, is called
Options: response time,    Key,    System review,    test data

Ans:B ,B

. Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Options: a. merge the two files b. create the main document c. set the mailing list parameters d. create the data source

Ans:– C,– C

Disketts and hard disks are
Options: Direct access devices,    Sequential access devices,    Slower than magnetic tape,    Used only in mainframe computers

Ans:A ,A

The Thevenin resistance is equal in value to the
Options: Load resistance,    Half the load resistance,    Internal resistance of a Morton circuit,    Open-load resistance

Ans:A ,A

The current trend, of computer usage is mainly interactive; the trend, earlier, was
Options: batch processing,    parallel processing,    random processing,    multi-task processing

Ans:A ,A

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

When you copy a formula
Options: a. Excel erases the original copy of the formula b. Excel edits cell references in the newly copied formula c. Excel adjusts absolute cell references d. Excel doesn’t adjust relative cell references

Ans:#8211; b,#8211; b

A loader is
Options: a program that places programs into memory and prepares them for execution,    a program that automate the translation of assembly language into machine language,    is a program that appears to execute a source program as if it were machine language,    program that accepts a program written in a high level language and produces an object program

Ans:A ,A

When was punched-card equipment used for the first time to process the British census?
Options: 1910,    1907,    1911,    1914

Ans:C ,C

Which command is used to display the top of the file?
Options: cat,    head,    more,    grep

Ans:B ,B

A servo controlled robot:
Options: stop only at fixed points on each axis,    can accelerate,    must be hydraulically driven,    must be electrically driven

Ans:B ,B

. The octal equivalence of 111010 is
Options: A) 81 B) 72 C) 71 D) None of above


. What is the short cut key to highlight the entire column?
Options: a. Ctrl+C b. Ctrl+Enter c. Ctrl+Page Up d. Ctrl+Space Bar

Ans:– d,– d

Which is an example of a formula?
Options: =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)

Ans:– A ,

. Which of the following statements about criteria in a query is NOT true?
Options: a. Criteria can contain wildcard characters. b. Criteria in a query selects or excludes certain records. c. Criteria cannot be specified as an expression. d. Multiple criteria can be specified using AND, OR, and relational operators.

Ans:0 – c ,0 – c