Which is an example of a function?

Options: =add(A1:A2) B. =A1+A2 C. =SUM(A1:A2) D. A1+A2

Ans:– C ,

Description: mcqquestions

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

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

Which of the following is best for quick copy operation?
Options: Copy and Paste B. Windows Clipboard C. Drag and Drop D. Auto Text

Ans:– C ,

62. How can you increase the font size of selected text by one point every time?
Options: a. By pressing Ctrl + ] b. By pressing Ctrl + [ c. By pressing Ctrl + } d. By pressing Ctrl + {

Ans:– A ,– A

The prime concern of financial control is
Options: accounting for the liabilities incurred,    meeting payroll commitments,    providing financial status information,    All of the above

Ans:C ,C

A software that allows a personal computer to pretend it as a terminal is
Options: auto-dialing,    bulletin board,    modem,    terminal emulation

Ans:A ,A

. Which of the following setup options can not be set in the page setup dialog box?
Options: a. Printer selection b. Vertical or horizontal placement c. Orientation d. Row and column titles

Ans:– a,– a

A file produced by a spreadsheet 
Options: a. is generally stored on disk in an ASCII text fromat b. can be used as is by the DBMS c. both a and b d. none of the above


Which of the following is the correct order of evaluation for the below expression? z = x + y * z / 4 % 2 - 1
Options: * / % + - =,    = * / % + -,    / * % - + =,    * % / - + =

Ans:A ,A

. How can you optimize performance of your computer?
Options: a. Delete unused files b. Defrag disk c. Scan for virus d. All of above

Ans:8 – d ,8 – d

Which of the following is not an alternative name for primary memory?
Options: Main memory,    Primary storage,    Internal storage,    Mass storage

Ans:D ,D

Page Up Key
Options: a. Moves the cursor one line up b. Moves the cursor one screen up c. Moves the cursor one page up d. Moves the cursor one paragraph up

Ans:–  B,–  B

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
Options: Delete,    Update,    Sort key,    Index

Ans:B ,B

. In order to perform a calculation in a spreadsheet, you need to use a:
Options: table B. formula C. field D. variable

Ans: – B ,

Nonmodifiable procedures are called
Options: serially usable procedures,    concurrent procedures,    reentrant procedures,    topdown procedures

Ans:C ,C

What should you replace if the brightness or contrast adjustments were malfunctioning on a laptop?
Options: fuse,    led display,    adjustment switch,    led display cable

Ans:B ,B

Which of the following is not Computer Hardware?
Options: Mouse B. Monitor C. Antivirus D. Printer

Ans:– C ,

Which document sums up the general provisions of purchase, terms and agreement, warranties, and maintenance?
Options: The contract,    The project evaluation,    The financial report.,    The purchasing report

Ans:A ,A

The step-by-step instructions that solve a problem are called _____.
Options: An algorithm,    A list,    A plan,    A sequential structure

Ans:A ,A

. What does Belady’s Anomaly related to?
Options: a. Page Replacement Algorithm b. Memory Management Algorithm c. Deadlock Prevention Algorithm d. Disk Scheduling Algorithm

Ans:6 – a ,6 – a

A process that is repeated, evaluated, and refined is called:
Options: diagnostic,    descriptive,    interpretive,    iterative

Ans:D ,D

If a switch receives a frame and the source MAC address is not in the MAC address table but the destination address is, what will the switch do with the frame?
Options: Discard it and send an error message back to the originating host,    Flood the network with the frame,    Add the source address and port to the MAC address table and forward the frame out the destination port,    Add the destination to the MAC address table and then forward the frame

Ans:C ,C

. … controls the way in which the computer system functions and provides a means by which users can interact with the computer
Options: a. The platform b. The operating system c. Application software d. The motherboard

Ans:1 – b ,1 – b

.   Which of the following includes special effects that can be applied to drawing objects?
Options: a. Gradient fills b. Line color and style c. Rotating d. All of above

Ans:1 – D ,1 – D

. Perforated paper used as input of output media is known as
Options: A) paper tapes B) magnetic tape C) punched papers tape D) card punch


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


An Access database object that is used to enter, view or edit records
Options: a. Table b. Form c. Query d. Report

Ans:ndash; b,ndash; b

The 7-bit ASCII code widely used
Options: For data communication work,    In IBM mainframe models,    For coding external memory,    In large machines produced by non-IBM vendors

Ans:A ,A

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

Ans:B ,B

. Which of the following data type is used to store logical value in MS Access?
Options: a. True/False b. On/Off c. Yes/No d. All of Above

Ans:– c,– c

When using PowerPoint, to play a PowerPoint show for previewing the show, select
Options: a. View, slide sorter b. View, slide c. View, slide show d. View outline

Ans: – C , – C

Suppose the peak value of a sinusoidal voltage is 50 V. What is the rms value?
Options: 37.4 V,    35.4 V,    38.74 V,    30.4 V

Ans:B ,B

. Who built the world’s first electronic calculator using telephone relays, light bulbs and batteries?
Options: A) Claude Shannon B) Konrard Zues C) George Stibits D) Howard H. Aiken


Which of the following is used to check for errors in RAM chips?
Options: ROM chip,    Microprocessor chip,    Parity chip,    EPROM chip

Ans:C ,C

Which of the following commands is not the vi Input mode command?
Options: rch,    R,    S,    j

Ans:D ,D

Which of the following is true when describing a global unicast address?
Options: Packets addressed to a unicast address are delivered to a single interface.,    These are your typical publicly routable addresses, just like a regular publicly routable address in IPv4.,    These are like private addresses in IPv4 in that they are not meant to be routed.,    These addresses are meant for nonrouting purposes, but they are almost globally unique so it is unlikely they will have an address overlap.

Ans:B ,B

Processors of all computers, whether micro, mini or mainframe must have 
Options: a. ALU b. Primary Storage c. Control unit d. All of above


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

Ans:C ,C

______ is used in operating system to separate mechanism from policy
Options: Single level implementation B. Two level implementation C. Multi level implementation D. None

Ans:– B ,

Which of the following is not an important principle for evaluating the raw data for decision-making:
Options: selection,    pattern,    everage,    overview

Ans:C ,C

Every video card must have?
Options: CMOS,    RAM,    CPU,    All of the above

Ans:B ,B

Indexed-Sequential organization
Options: means storing records in contiguous blocks according to a key.,    Stores records sequentially but uses an index to locate records,    uses an index for each key type,    has records placed randomly throughout the file

Ans:B ,B

. You can zoom a worksheet
Options: a. With the mouse pointer in Print Preview b. With the zoom button on the Print Preview toolbar c. With the Zoom command on the view menu d. All of the above

Ans:– d,– d

Which one of the following is a statement of KirchhofFs voltage law?
Options: The total voltage in a parallel circuit is less than the value of the smallest voltage,    The algebraic sum of voltages in a loop is equal to zero,    The voltage drop across a resistance is proportional to the value of resistance and the amount of current flowing through it,    The algebraic sum of voltages entering and leaving a point is equal to zero

Ans:B ,B

User-Friendly Systems are:
Options: required for object-oriented programming,    easy to develop,    common among traditional mainframe operating systems,    becoming more common

Ans:D ,D

. Which of the following is not a field type in access
Options: a. Memo b. Hyperlink c. Ole object d. Lookup wizard

Ans:0 – d ,0 – d

.Only filenames and extensions are to be displayed in wide format, which command you’ll use?
Options: a.    Dir/w b.    Dir a: c.    Dir/s d.    Dir/b

Ans:a,Correct Answer: Dir/w

. What does DMA stand for?
Options: A) Distinct Memory Access B) Direct Memory Access C) Direct Module Access D) Direct Memory Allocation


The special shell variable $* is used
Options: to exit status of ast command executed.,    to process number of the current shell,    to list the positional parameters,    to name the command being executed

Ans:C ,C

What will be the output of the program? #include<stdio.h> int main() { float d=2.25; printf("%e,", d); printf("%f,", d); printf("%g,", d); printf("%lf", d); return 0; }
Options: 2.2, 2.50, 2.50, 2.5,    2.2e, 2.25f, 2.00, 2.25,    2.250000e+000, 2.250000, 2.25, 2.250000,    Error

Ans:C ,C

Which of the following is not true about modifying table columns?
Options: You can drop a column at any time.,    You can add a column at any time as long as it is a NULL column.,    You can increase the number of characters in character columns or the number of digits in numeric columns,    You cannot increase or decrease the number of decimal places.

Ans:D ,D

What is the shortcut key to start presentation from current slide?
Options: F5 B. Alt + F5       C. Ctrl + F5 D. Shift + F5

Ans:– D ,