. What is the shortcut key to insert new sheet in current workbook?


Options: F11 B. Alt + F11 C. Ctrl + F11 D. Shift + F11

Ans:– D ,


Description: mcqquestions

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

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


Which of the following is not a relational database?
Options: dBASE IV,    4th Dimension,    FoxPro,    Reflex

Ans:D ,D


Which of the following is not a requirement of structured design?
Options: It should be made up of a hierarchy of modules,    It should use many GOTO statements,    The code should be executed in a top-to-bottom fashion within each module,    Each module should be as independent as possible of all other modules, except its parent

Ans:B ,B


What will be the output of the program (myprog.c) given below if it is executed from the command line? cmd> myprog one two three /* myprog.c */ #include<stdio.h> #include<stdlib.h> int main(int argc, char **argv) { int i; for(i=1; i<=3; i++) printf("%u\n", &argv[i]); return 0; } If the first value printed by the above program is 65517, what will be the rest of output?


Options: 65525 65531,    65519 65521,    65517 65517,    65521 65525

Ans:B ,B


_____ help prevent power surges.
Options: Surge suppressor,    Spike protector,    UPS system,    High-grade multi-meter

Ans:A ,A


A micro processor chip used in a PC system
Options: Performs the arithmetic-logic and control functions,    Is the only chip cound in most PC models,    Almost always operates on by-bits of data at a time,    Performs the primary storage function

Ans:A ,A


to view headers and footers, you must switch to
Options: normal view B. print layout view C. print preview mode D. both B and C

Ans:– D ,


Ctrl + J
Options: a. Align Justify b. Insert Hyperlink c. Search d. Print

Ans:–  A,–  A


Which of the following is a type of DBMS software?
Options: database manipulation language,    query language,    utilities,    report writer

Ans:A ,A


What is the keyboard shortcut for creating a chart from the selected cell range?
Options: A. F2 B. F4 C. F8 D. F11

Ans:– D ,F11


The mouse pointer moves erratically, what is the possible cause? The mouse
Options: ball is dirty,    is not connected,    driver is not installed properly,    has an incorrect IRQ setting

Ans:A ,A


If a piece of data is stored in two places in the database, then 
Options: a . storage space is wasted b . changing the data in one spot will cause data inconsistency c . in can be more easily accessed d . both and b

Ans:.d,.d


A proportional plus integral contro¬ller can:
Options: has no transient response,    can compensate for lag,    can increase the system type,    both (b) and (c)

Ans:D ,D


. Background color or effects applied on a document is not visible in
Options: a. Web layout view b. Print Layout view c. Reading View d. Print Preview

Ans:– D,– D


. The report footer section is most useful for displaying:
Options: a. grand totals b. Column headings c. subtotals d. page numbers

Ans:– a,– a


. What is the symbol for dividing? A ./ B. % C. & D. #
Options: A ./ B. % C. & D. #

Ans:– A ,/


A menu-driven operating system is one which allows you to pick up from the menu of choices it displays on the screen. What is the name given to the images which are used in such image oriented menus?
Options: Icon,    Figure,    Symbol,    option

Ans:A ,A


The memory address of the first element of an array is called
Options: a. floor address b. foundation address c. first address d. base address

Ans: b, b


What is the size of a sector?
Options: 512 bytes,    256 bytes,    512 Kb,    1024 bytes

Ans:A ,A


Which of the following can store information in the form of microscopic pits on metal disks.
Options: Laser disks,    Tape cassettes,    RAM cartridge,    Punched cards

Ans:A ,A


Which of following is Not one of Excel’s what-if function?
Options: a. Goal seek b. Solver c. Scenario manager d. Auto Outline

Ans:#8211; d,#8211; d


Point out the error in the program #include<stdio.h> #define SI(p, n, r) float si; si=p*n*r/100; int main() { float p=2500, r=3.5; int n=3; SI(p, n, r); SI(1500, 2, 2.5); return 0; }
Options: 26250.00 7500.00,    Nothing will print,    Error: Multiple declaration of si,    Garbage values

Ans:C ,C


In functional decomposition, the data flow diagram
Options: is ignored,    is partitioned according to the "closeness" of the datagrams and data storage items,    is partitioned according to the logical "closeness" of the actigrams,    both (a) and (c)

Ans:C ,C


. A function inside another function is called _______
Options: a. Nested function b. Round function c. Sum function d. Text function

Ans:– a,– a


What will be the output of the program ? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a u; u.ch[0]=3; u.ch[1]=2; printf("%d, %d, %d\n", u.ch[0], u.ch[1], u.i); return 0; }
Options: 3, 2, 515,    515, 2, 3,    3, 2, 5,    515, 515, 4

Ans:A ,A


The new organization established to implement the Fifth Generation Project is called:
Options: ICOT (Institute for New Generation Computer Technology),    MITI (Ministry of International Trade and Industry),    MCC (Microelectronics and Computer Technology Corporation),    SCP (Stategic Computing Program)

Ans:A ,A


. Which of the following methods can not be used to enter data in a cell?
Options: a. Pressing an arrow key b. Pressing the tab key c. Pressing the Esc key d. Clicking the enter button to the formula bar

Ans:– c,– c


. A graphical user interface displays
Options: a. Graphics b. Text c. Both of above d. None of above

Ans:7 – c ,7 – c


A type of line printer that uses an embossed steel band to form the letters printed on the paper is
Options: Golf ball printer,    Dot-matrix printer,    Laser printer,    Band printer

Ans:D,D


. Which of the following in not Outer join?
Options: Left outer join B. Right outer join C. Full outer join D. All of the above

Ans: – D ,


. Any and every command can be found on the
Options: a. Drawing toolbar b. Formatting toolbar c. Standard toolbar d. Menu bar

Ans:1 – D ,1 – D


Name of the first guided weapon in the world which used a programmable digital computer:
Options: Sting Ray Torpedo,    Mk 46 Torpedo,    Air-Launched Cruise Missile (ALCM),    Tomahawk Missile

Ans:A,A


You can group noncontiguous worksheets with
Options: The alt+enter key B. The ctrl key and mouse C. The shift key and the mouse D. The group button on the standard toolbar

Ans: – B ,


Which generation of computer is still under development
Options: A) Fourth Generation B) Fifth Generation C) Sixth Generation D) Seventh Generation

Ans:-B,-B


The command to count the number of files in the current directory by using pipes, is
Options: ls | wc,    ls -l | wc -l,    ls | wc -w,    ls | ws -c

Ans:C ,C


The executive vice-president usually has responsibility for the
Options: physical system of the firm,    conceptual information system of the firm,    vice-president of finance,    All of the above

Ans:A ,A


66. A (n) _____is a dot or other symbol positioned at the beginning of a paragraph.
Options: a. bullet b. logo c. cell d. target

Ans:– A ,– A


Business Intelligence (BI) reporting analyses can be performed using ________ .
Options: standard SQL only,    extensions to SQL only,    OLAP only,    both standard SQL and extensions to SQL

Ans:A ,A


Which number system is usually followed in a typical 32-bit computer?
Options:  2 B.  10      C.  16 D.  32

Ans:– A ,


The explanation facility of an expert system may be used to:
Options: construct a diagnostic model,    expedite the debugging process,    explain the system's reasoning process,    All of the above

Ans:E ,E


47. If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should:
Options: a. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box. b. Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect. c. AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an AutoCorrect entry. d. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK.

Ans:– A ,– A


Which of the following is not true of future computers?
Options: increased use of CAD/CAM techniques,    faster turnaround time,    developments in artificial intelligence systems,   All are true

Ans:D,all are true


Input/output function prototypes and macros are defined in which header file?
Options: conio.h,    stdlib.h,    stdio.h,    dos.h

Ans:C ,C


Flood guns bombard the phosphor surface of the tube in which one of the following types of CRT technology?
Options: Direct view storage tube,    Raster scan CRT,    Refresh-vector CRT,    Stroke CRT

Ans:A ,A


2. Which is the valid filename assign in MS-DOS?
Options: a. Ram*.txt b. Ram?.doc c. Ram_$.txt d. None of above

Ans:Correct Answer: c,Correct Answer: c


. you can use the formula palette to
Options: a. format cells containing numbers b. create and edit formulas containing functions c. entered assumptions data d. copy a range of cells

Ans:– b,– b


An optical input device that interprets pencil marks on paper media is
Options: O.M.R,    Punch card reader,    Optical scanners,    Magnetic tape

Ans:A ,A


The brain of any computer system is
Options: ALU,    Memory,    CPU,    Control unit

Ans:C ,C


Which is NOT one of the most common types of SQL CHECK constraints?
Options: System date,    Range checks,    Lists of values,    Comparing one column value to another within the same table

Ans:A ,A


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

www.000webhost.com