In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?

Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Ans:– C ,

Description: mcqquestions

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

Hits Today: 12864

More MS-Excel Related questions:

The register which holds the address of the location to or from which data are to be transferred is known as
Options: index register,    instruction register,    memory address register,    memory data register


. When you link data maintained in Excel workbook to a Word document
Options: a. The Word document cannot be edited b. The Word document contains a reference to the original source application c. The word document must contain a hyperlink d. The word document contains a copy of the actual data

Ans:– b,– b

The process of writing computer instructions in a programming language is known as
Options: Coding,    Processing,    Programming,    File


Normalization ________ data duplication.
Options: eliminates,    reduces,    increases,    maximizes

Ans:A ,A

. Programs designed to perform specific tasks is known as
Options: A) system software B) application software C) utility programs D) operating system


What command is used to count just the number of lines contained in a file?
Options: wc - r,    wc - w,    wc - c,    wc - l

Ans:D ,D

A star schema has what type of relationship between a dimension and fact table?
Options: Many-to-many,    One-to-one,    One-to-many,    All of the above.

Ans:C ,C

WRAM is used on a
Options: modem,    video card,    motherboard,    ata connector

Ans:B ,B

Individuals who intend to pursue a career as an information-system manager should have:
Options: technical expertise in information systems,    human-relations skills,    ability to communicate in written form,    two of the above

Ans:E ,E

A device that converts light energy to electrical energy is called a:
Options: thermocouple,    solar cell,    photodiode,    photo transistor

Ans:B ,B

. Which tool you will use to join some cells and place the content at the middle of joined cell?
Options: a.  From Format Cells dialog box click on Merge Cells check box b.  From Format Cells dialog box select the Centered alignment c.  From Format Cells dialog box choose Merge and Center check box d.  Click on Merge and Center tool on formatting toolbar

Ans:– d,– d

58. You can jump to the next column by
Options: a. Clicking with your mouse on the next column b. Press Alt + Down-arrow c. Both of above d. None of Above

Ans:– C ,– C

. Where can you set the shedding color for a range of cells in Excel?
Options: a. Choose required color form Patterns tab of Format Cells dialog box b. Choose required color on Fill Color tool in Formatting toolbar c. Choose required color on Fill Color tool in Drawing toolbar d. All of above

Ans:– d,– d

What type of RJ45 UTP cable do you use to connect a PC's COM port to a router or switch console port?
Options: Straight-through,    Crossover cable,    Crossover with a CSU/DSU,    Rolled

Ans:D ,D

. How do you magnify your document?
Options: a. View, Zoom b. Format, Font c. Tools, Options d. Tools, Customize

Ans: –  A , –  A

What will be the output of the program? #include<stdio.h> int main() { typedef float f; static f *fptr; float fval = 90; fptr = &fval; printf("%f\n", *fptr); return 0; }
Options: 9,    0,    90.000000,    90

Ans:C ,C

To select one hyperlink after another during a slide presentation, what do you press?
Options: a. Tab b. Ctrl + K c. Ctrl + h d. All of above

Ans: – A , – A

Which is built directly on the hardware?
Options: Computer Environment B. Application Software C. Operating System D. Database System

Ans:– C ,

What is the output of the program #include<stdio.h> int main() { struct emp { char name[20]; int age; float sal; }; struct emp e = {"Tiger"}; printf("%d, %f\n", e.age, e.sal); return 0; }
Options: 0, 0.000000,    Garbage values,    Error,    None of above

Ans:A ,A

. Which command will be used to display only the file name and extensions in wide format?
Options: a. Dir/b b. Dir A: c. Dir/s d. Dir/w

Ans:8 – d ,8 – d

The pieces of equipment which are attached to the CPU of a computer and which it can access are called
Options: output devices,    control units,    hardware,    disk drive

Ans:E ,E

An inventory management system should answer the questions
Options: what and why,    when and how much,    who and why,    where and when

Ans:B ,B

Presentation designs regulate the formatting and layout for the slide and are commonly called
Options: a. Design plates b. Templates c. Placeholders d. Blueprints

Ans: – B , – B

What IRQ is used for COM 2?
Options: 4,    3,    2,    1

Ans:B ,B

A popular technique for forecasting is
Options: correlation analysis,    regression analysis,    linear programming,    Monte Carlo

Ans:B ,B

. What should be the extension to execute files?
Options: EXE B. BAT C. COM D. All of the above

Ans: – D ,

. Which of the following field properties enforces the use of parentheses when keying an area code?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:0 – c ,0 – c

Information can be transferred between the DBMS and a
Options: a. spreadsheet program b. word processor program c. graphics program d. all of the above

Ans:D,All of the above

To produce high quality graphics (hardcopy) in color, you would want to use a/n
Options: A) RGB monitor B) Plotter C) Ink-jet printer D) Laser printer


. Ellipse Motion is a predefined ________
Options: a. Design Template b. Color Scheme c. Animation Scheme d. None of these

Ans:5 – C ,5 – C

The advantage(s) inherent to using high level languages is (are)
Options: Fewer people, less management and shorter transition in learning time,    Improved debugging capability, and superior documentation,    A greater degree of machine independence,    All of the above

Ans:D ,D

. When was Apple Macintosh II microcomputer introduced in the market?
Options: A) 1964 B) 1970 C) 1983 D) 1986


The section of the CPU that selects, interprets and sees to the execution of program instructions
Options: Memory,    Register unit,    Control unit,    ALU

Ans:C ,C

When you create a subdirectory within a directory, the process is known as _____
Options: directing,    making,    backing,    nesting

Ans:D ,D

Which of the following is used to insure the high quality of computer output?
Options: computer output microfilm,    output controls,    voice output systems,    liquid crystal display

Ans:B ,B

Which of the following devices would be classified as a robot by the Robot Institute of America?
Options: Automobile,    Pick-and-place manipulator,    Artificial hand,    All of the above

Ans:B ,B

Goals for the design of the logical schema include
Options: avoiding data inconsistency,    being able to construct queries easily,    being able to access data efficiently,    All of the above

Ans:D ,D

. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
Options: a. formula b. format c. layout d. record

Ans:3 – d ,3 – d

. The Software which contains rows and columns is called ______
Options: a. Database b. Drawing c. Spreadsheet d. Word processing

Ans:– c,– c

. Size of the primary memory of a PC ranges between
Options: A) 2KB to 8KB B) 64KB & 256KB C) 256KB & 640KB D) None of these


What is a Firewall in Computer Network?
Options:  The physical boundary of Network B.  An operating System of Computer Network       C.  A system designed to prevent unauthorized access D.  A web browsing Software

Ans:– C ,

A small film-plate which is used for microfilming the output from a microcomputer screen is called
Options: microfilm,    microfiche,    film card,    COM

Ans:B ,B

To copy formatting from one area in a worksheet and apply it to another area you would use:
Options: a. The Edit>Copy Format and Edit>Paste Format commands form the menu. b. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu. c. There is no way to copy and apply formatting in Excel – You have to do it manually d. The Format Painter button on the standard toolbar

Ans:#8211; d,#8211; d

How many bytes are occupied by near, far and huge pointers (DOS)?
Options: near=2 far=4 huge=4,    near=4 far=8 huge=8,    near=2 far=4 huge=8,    near=4 far=4 huge=8

Ans:A ,A

. The delete confirmation generated by …switch
Options: a. /p b. /b c. /w d. /c

Ans:4 – a ,4 – a

What should the configuration register value be after you successfully complete the password recovery procedure and return the router to normal operation?
Options: 0x2100,    0x2101,    0x2102,    0x2142

Ans:C ,C

.   What will happen if you release the mouse button before releasing the shift key when you draw a square?
Options: a. The square will not be a perfect square b. The square will not be at the center of the slide c. The square will be smaller d. The square will be larger

Ans:7 – A ,7 – A

Comments can be added to cells using …..
Options: Edit -> Comments B. Insert -> Comment     C. File -> Comments D. View –> Comments

Ans:– B ,

When mapping a multivalued attribute into a relation which of the following is true?
Options: One relation is created.,    Two relations are created.,    Three relations are created.,    Four relations are created.

Ans:B ,B

What's the best way to protect your hard drive data?
Options: regular backups,    periodically defrag it,    run chkdsk at least once a week,    run scandisk at least once a week

Ans:A ,A