Which of the following function will use to find the highest number in a series of number?


Options: MAX(B1:B3) B. MAXIMUM (B1:B3) C. HIGH (B1:B3) D. HIGHEST(B1:B3)

Ans:– A ,


Description: mcqquestions

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

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


Terminals are required for
Options: realtime, batch processing, and timesharing,    realtime, timesharing, and distributed processing,    realtime, distributed processing, and manager inquiry,    realtime, timesharing, and message switching

Ans:D ,D


Most AC power is obtained from:
Options: generators,    batteries,    oscillators,    lightning

Ans:C ,C


hat is the shortcut key to split a table?
Options: Ctrl + Alt + Enter B. Ctrl + Shift + Enter C. Alt + Shift + Enter D. Alt + Space + Enter

Ans:– B ,


Which was the world's first minicomputer and when was it introduced?
Options: PDP-1, 1958,    1MB System/36, 1960,    PDP-11 1961,    VAX 11/780, 1962

Ans:A ,A


The peak value of a sine waveform is:
Options: the amplitude at 70.7% of the maximum value,    the amplitude at 90% of the maximum value,    the amplitude at 1.41 times the maximum value,    the maximum positive or negative value

Ans:D ,D


If you do not know which version of MS-DOS you are working with, which command will you use after having booted your operating system?
Options: FORMAT command,    DIR command,    VER command,    DISK command

Ans:C ,C


What will be the output of the program? #include<stdio.h> #define MAX(a, b) (a > b ? a : b) int main() { int x; x = MAX(3+2, 2+7); printf("%d\n", x); return 0; }
Options: 8,    9,    6,    5

Ans:B ,B


. We can restore the deleted files and folders from
Options: a. Recycle bin b. My document c. Control panel d. All of the above

Ans:2 – a ,2 – a


. RATS stand for
Options: A) Regression Analysis Time Series B) Regression Analysis Time Sharing C) Real Analysis Series D) All of above

Ans:A,A


. “Ctrl + Up Arrow” is used to
Options: Moves the cursor one page up B. Moves the cursor one line up C. Moves the cursor one screen up D. Moves the cursor one paragraph up

Ans:– D ,


. Which of the following is not a basic step in creating a worksheet?
Options: a. Save the workbook b. Modify the worksheet c. Enter text and data d. Copy the worksheet

Ans:– d,– d


  Which PowerPoint feature allows the user to create a simple presentation without having to spend too much time on it?
Options: AutoContent Wizard B. Animation C. Color Schemes D. Chart Wizard

Ans:– A ,


Advantages of Relational Database Management systems are
Options: Flexibility, of relating different logical files,    Security controls can be more easily implemented.,    Data independence since it allows the database to grow by adding new attributes and relations.,    All of the above

Ans:D ,D


. It is possible to _______ a data source before performing a merge.
Options: a. create b. modify c. sort d. all of the above

Ans:– D,– D


You have purchased a MAU (Multistation Access Unit) from your computer supplier and now must decide what type of network card you should install in the workstations. Which of the following would be the most appropriate?
Options: Fast SCSI Wide,    Token-Ring,    ArcServe,    Ethernet

Ans:B ,B


When was the world's first laptop computer introduced in the market and by whom?
Options: Hewlett-Packard, 1980,    Epson, 1981,    Laplink Travelling Software Inc, 1982.,    Tandy Model-200, 1985

Ans:B ,B


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

Ans:– B ,


A goal of data mining includes which of the following?
Options: To explain some observed event or condition,    To confirm that data exists,    To analyze data for expected relationships,    To create a new data warehouse

Ans:A ,A


When seeking to upgrade for a particular motherboard what do you need to know?
Options: memory,    hard drive,    make & model,    dimm

Ans:C ,C


Corporate modeling software can be used for
Options: cash planning,    operational budgeting,    capital budgeting,    All of the above

Ans:D ,D


. The question mark (?) indicates in file searching
Options: a. A single character b. A group of character c. Questions d. None of above

Ans:8 – a ,8 – a


The Average case occur in linear search algorithm
Options: a. When Item is somewhere in the middle of the array b. When Item is not in the array at all c. When Item is the last element in the array d. When Item is the last element in the array or is not there at all  

Ans:a,a


If you select Insert >> Picture >> From File
Options: a. You can insert pictures and clipart b. You can insert clipart only c. you can insert pictures only d. None of above

Ans: – C , – C


Which of the following is used for modulation and demodulation?
Options: modem,    protocols,    gateway,    multiplexer

Ans:A ,A


82. Which option in File pull-down menu is used to close a file in MSWord?
Options: a. New b. Quit c. Close d. Exit

Ans:–  C ,–  C


The heart of any computer is the
Options: CPU,    Memory,    I/O Unit,    Disks

Ans:A,A


. Which one is the last column header in Excel 2007?
Options: a. XFD b. XFX c. XFL d. XFT

Ans:– a,– a


In analyzing the compilation of PL/I program, the description "creation of more optimal matrix" is associated with
Options: Assembly and output,    Code generation,    Syntax analysis,    Machine independent optimization

Ans:D ,D


The wildcard in a WHERE clause is useful when?
Options: An exact match is necessary in a SELECT statement.,    An exact match is not possible in a SELECT statement.,    An exact match is necessary in a CREATE statement.,    An exact match is not possible in a CREATE statement.

Ans:B ,B


. The full form of ALU is
Options: A) Arithmetic Logic Unit B) Array Logic Unit C) Application Logic Unit D) None of above

Ans:A,A


Programming a robot by physically moving it through the trajectory you want it to follow is called:
Options: contact sensing control,    continuous-path control,    robot vision control,    pick-and-place control

Ans:B ,B


0. What is the use of “All Caps” feature in MS-Word?
Options: It changes all selected text into Capital Letter B. It adds captions for selected Image C. It shows all the image captions D. None of the above

Ans: – A ,


. In the IBM PC-At, what do the words AT stand for
Options: A) Additional Terminals B) Advance technology C) Applied technology D) Advanced terminology

Ans:B,B


For you to create a swap partition by using fdisk, what must the partition's system ID type be?
Options: 83,    82,    5,    4

Ans:B ,B


The control of the jobs running within a system is
Options: Job monitoring,    Job stream,    Job min,    Job step

Ans:A ,A


Small squares, called _____, on the selection rectangle that surrounds a graphic can be used to change the dimensions of the graphic.
Options: a. scroll boxes b. sizing handles c. status indicators d. move handles

Ans:– B,– B


. Data can be import into Access Database from
Options: a. Word Files b. Excel Files c. PowerPoint Files d. HTML Files

Ans:– b,– b


The symbols used in describing the syntax of a programming language are
Options: 0,    {},    "",    <>

Ans:D ,D


If no multivalued attributes exist in a relation, then the relation is in what normal form?
Options: First normal form,    Second normal form,    Third normal form,    Fourth normal form

Ans:A ,A


. Following is not a database model
Options: a. Network database model b. Relational database model c. Object oriented database model d. None

Ans:4 – d ,4 – d


In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options: all columns of the table are to be returned.,    all records meeting the full criteria are to be returned.,    all records with even partial criteria met are to be returned.,    None of the above is correct.

Ans:A ,A


. 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


Any device that performs signal conversion is
Options: Modulator,    Modem,    Keyboard,    Plotter

Ans:A,(Aanswer


. A numeric value can be treated as label value if …… precedes it.
Options: a. Apostrophe (‘) b. Exclamation (!) c. Hash (#) d. Tilde (~)

Ans:– a,– a


The intersection of a column and row in a spreadsheet is called a bon or
Options: Key,    Field,    Cell,    Menu

Ans:C ,C


. The Table _______________ Wizard analyzes a database and recommends changes for normalization.
Options: a. Analyzer b. Documenter c. Cleanup d. Normalization

Ans:8 – a ,8 – a


Which of the following commands will take you directly to the root directory no matter what subdirectory you are currently in?
Options: CD \root,    CD\,    CD\..,    CD..

Ans:B ,B


. Digital devices are
Options: A) Digital Clock B) Automobile speed meter C) Clock with a dial and two hands D) All of them

Ans:2-A,2-A


In which of the following areas may ICAI programs prove to be useful?
Options: educational institutions,    corporations,    department of Defence,    All of the above

Ans:D ,D


. Magnetic disks are the most popular medium for
Options: A) Direct access B) Sequential access C) Both of above D) None of above

Ans:C,C

www.000webhost.com