Quiz of the Ms-Excel (Week-22)

This set contains 10 multiple choice questions from Ms-Excel. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________
1. Shortcut Key of Autosum
A. Ctrl  + =
B. Shift + =
C. Ctrl  + Enter
D. Alt   + =


2. The Name box
a. Shows the location of the previously active cell
b. Appears  the left of the formula bar
c. Appears below the status bar
d. Appears below the menu bar


3. Hyperlinks cannot be
a. Special shapes like stars and banners
b. Drawing objects like rectangles ovals
c. Pictures
d. All can be hyperlinks
 

4. You can use the horizontal and vertical scroll bars to
a. Split a worksheet into two panes
b. View different rows and columns
c. Edit the contents of a cell
d. View different worksheets
 


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

6. You can open the consolidate dialog box byt choosing Consolidate from the ….. Tab.
a. Insert
b. Format
c. Tools
d. Data
 

7. Each excel file is called a workbook because
a. It can contain text and data
b. It can be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it


8.Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts
d. Bar charts and line graphs only


9. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
 

10. What does the VLOOKUP function do ?
a. Looks up text that contain ‘v’
b. Checks whether text is the same in one cell as in the next
c. Finds related records
d. All of above

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of All Computer Courses
>> Back to Notes of C-Language
>> Back to Shortcuts of All Computer Courses
>> Back to Video Tutorials of All Computer Courses
>> Back to Abbreviations

---------------------------------------------------------------------------------------------------------------

Quiz of the C-Language (Week-21)

This set contains 10 multiple choice questions from C-Language. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________
1. The Default Parameter Passing Mechanism is called as
A. Call by Value
B. Call by Reference
C. Call by Address
D. Call by Name


2. What is Dequeue?
A. Elements can be added from front
B. Elements can be added to or removed from either the front or rear
C. Elements can be added from rear
D. None of the above



3. Which is the correct syntax to declare constant pointer?
A. int *const constPtr;
B. *int constant constPtr;
C. const int *constPtr;
D. A and C both
 

4. What will be the output of the following statements ?
int i = 3;
printf("%d%d",i,i++);
a) 34
b) 43
c) 44
d) 33


5. Number of binary trees formed with 5 nodes are
A. 30
B. 36
C. 108
D. 42
 

6. The statement printf("%c", 100); will print?
A. prints 100
B. print garbage
C. prints ASCII equivalent of 100
D. None of the above
 

7. Recursive functions are executed in a?
A. First In First Out Order
B. Load Balancing
C. Parallel Fashion
D. Last In First Out Order


8. A binary tree with 27 nodes has _______ null branches.
A. 54
B. 27
C. 26
D. None of the above


9. What is the work of break keyword?
A. Halt execution of program
B. Restart execution of program
C. Exit from loop or switch statement
D. None of the above
 

10. perror( ) function used to ?
A. Work same as printf()
B. prints the error message specified by the compiler
C. prints the garbage value assigned by the compiler
D. None of the above

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of All Computer Courses
>> Back to Notes of C-Language
>> Back to Shortcuts of All Computer Courses
>> Back to Video Tutorials of All Computer Courses
>> Back to Abbreviations

---------------------------------------------------------------------------------------------------------------

Quiz of the Computer Fundamentals (Week-20)

This set contains 10 multiple choice questions from Computer Fundamentals. Each question has four possible options and there is one and only one correct answer for each question.
Note:-  explanation in below the questions

_________________________________________________________________________________

1. CD-ROM stands for

a. Compactable Read Only Memory
b. Compact Data Read Only Memory
c. Compactable Disk Read Only Memory
d. Compact Disk Read Only Memory

2. UNIVAC is
a. Universal Automatic Computer
b. Universal Array Computer
c. Unique Automatic Computer
d. Unvalued Automatic Computer

3. MSI stands for

a. Medium Scale Integrated Circuits
b. Medium System Integrated Circuits
c. Medium Scale Intelligent Circuit
d. Medium System Intelligent Circuit


4. The capacity of 3.5 inch floppy disk is
a. 1.40 MB
b. 1.44 GB
c. 1.40 GB
d. 1.44 MB
 

5. WAN stands for
a. Wire Area Network
b. Wide Area Network
c. Wide Array Net
d. Wireless Area Network
 

6. ALU is
a. Arithmetic Logic Unit
b. Array Logic Unit
c. Application Logic Unit
d. None of above


7. MICR stands for
a. Magnetic Ink Character Reader
b. Magnetic Ink Code Reader
c. Magnetic Ink Cases Reader
d. None


8. MU stands for
a. Memory Unit
b. Magnetic Memory
c. Main Memory
d. None
 

9. ASCII stands for
a. American Stable Code for International Interchange
b. American Standard Case for Institutional Interchange
c. American Standard Code for Information Interchange
d. American Standard Code for Interchange Information 


10. EEPROM stand for
a. Electrically Erasable Programmable Read Only Memory
b. Easily Erasable Programmable Read Only Memory
c. Electronic Erasable Programmable Read Only Memory
d. None of the above

----------------------------------------------------------------------------------------------------------------------

Explanation

1.CD-ROM

There are no objects with the name as in other options. CD-ROM is a non-volatile optical data storage medium using the same physical format as audio compact disk, readable by a computer with a CD-ROM drive.

2. UNIVAC 

There are no computers with the name as in other options. UNIVAC was the first general purpose electronic digital computer designed for commercial use, produced by Universal Accounting Company of John Mauchly and J.P.Eckert in 1951.

3. MSI 

After the invention of IC chips the development of computers plunged into next phase. Small Scale Integration and Medium Scale Integration (SSI and MSI) were used in third generation of computers and Large Scale Integration and Very Large Scale Integration (LSI and VLSI) are being used in fourth generation of computers. 

4. The capacity of 3.5 inch floppy disk is

Microfloppy disks (3.5 inch) if it is high density (MF2HD) can store 1.44 MB and if it is low density (MF2DD), it can store 720 KB. Mini Floppy disks (5.25 inch) if it is high density (MD2HD) can store 1.2 MB and low density (MD2DD) stores 360 KB of data.

5. WAN 

There are three different classes of computer network namely, Local Area Network (LAN) that covers a small geographical area such as a room, a building or a compound; Metropolitan Area Network (MAN) that has a citywide coverage; and Wide Area Network (WAN) that covers the whole globe or beyond the globe.

6. ALU 

ALU is a unit in Central Processing Unit in a computer system that is responsible for arithmetic calculations and logical operations. Apart from ALU, the CPU contains MU (Memory Unit) and CU (Control Unit).

7. MICR

MICR (Magnetic Ink Character Reader) is kind of scanner that can scan and identify the writing of magnetic ink. This device is used in banks to verify signatures in Checks.

8.MU

It is the location to store the information. It can be divided into 2 parts. 

They are 

A.Primary memory unit 

B. secondary memory unit

9. ASCII 

ASCII is a code which converts characters – letters, digits, punctuations and control characters such as Alt, Tab etc – into numeral form. ASCII code is used to represent data internally in micro-computers. ASCII codes are 7 bits and can represent 0 to 127 and extended ASCII are 8 bits that represents 0 to 255.

10. EEPROM 

There are three types of ROM namely, PROM, EPROM and EEPROM. PROM can’t be reprogrammed, EPROM can be erased by exposing it in high intensity ultraviolet light and EEPROM can be erased and reprogrammed electrically. It is not needed to be removed from the computer to be modified.

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of C-Language

>> Back to Quiz of All Computer Courses

---------------------------------------------------------------------------------------------------------------

Quiz of the C-Language(Week-19)

This set contains 10 multiple choice questions from C-Language. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________

1. Find the assignment operator ?

A. &&
B. =,^
C. =
D. ||,!

2. int a=10; 
    printf("%d",a<<3); 
    find the a value ?        
A. 2
B. 82
C. 0
D. 80

3. What will be the output of the following statement ?
     int a=20;  printf("%d", a-- - --a );

A. 1
B. 2
C. 3
D. 4


4. a=0,b=1
    Which one of the following condition is true ?
A. a&&b
B. a||b
C. !(a&&b)
D. B & C


5. B-Means in B-Language?
A. Basic
B. Only 'B'
C. Bios
D. None of the above


6. Which header file using in Sound effects in C-Program ?
a) math.h
b) string.h
c) stdlib.h
d) dos.h


7. What will be the output of the following statement ?
     int a=4;a=25;b=20;a=10; printf("%d,%d",a,b);
a) 10,20
b) 4,20
c) 25,20
d) garbage value


8. Collection of words.
A. stories
B. paragraphs
C. sentences
D. None of the above


9.Range of short int
A. -126 to 125
B. -456 to 455
C. -128 to 127
D. -145 to 144


10. comma (,) is the ___________ operator?
A. logical
B. special
C. relational
D. conditional

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of C-Language

>> Back to Quiz of All Computer Courses

---------------------------------------------------------------------------------------------------------------

Quiz of the Ms-Power Point (Week-18)

This set contains 10 multiple choice questions from Ms-Power Point. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________

1. Which file format can be added to a PowerPoint show?
a. .jpg
b. .giv
c. .wav
d. All of the above


2. What is a motion path?
a. A type of animation entrance effect
b. A method of advancing slides
c. A method of moving items on a slide
d. All of the above

3. to preview a motion path effect using the custom animation task pane, you should

a. click the play button

b. click the show effect button

c. double click the motion path

d. all of above

4. special effects used to introduce slides in a presentation are called
a. effects
b. custom animations
c. transitions
d. present animations


5. What is a slide-title master pair?
a. The title area and text area of a specific slide
b. a slide master and title master merged into a single slide
c. A slide master and title master for a specific design template
d. All of above


6. To start Microsoft PowerPoint application
a. Click on Start >> Programs >> All Programs >> Microsoft PowerPoint
b. Hit Ctrl + R then type ppoint.exe and Enter
c. Click Start >> Run then type powerpnt then press Enter
d. All of above


7. PowerPoint presentations are widely used as
a. note outlines for teachers
b. project presentations by students
c. communication of planning
d. All of above


8. _______ controls all the main slide control tasks for your presentation.
a. Task Pane
b. Task Bar
c. Control Panel
d. None of above



9. A new presentation can be created from
a. Blank Presentation
b. From Existing Presentation
c. From Design Template
d. All of above

10. Which of the following statement is false?

a. If you choose to select from one of the pre-made slide layouts, you can change the positioning

b. If you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout.

c. Blank Slide is at the top of the ‘Content Layouts’ area in the Slide Layout panel.

d. All of above are false statements

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of C-Language

>> Back to Quiz of All Computer Courses

---------------------------------------------------------------------------------------------------------------

QUIZ of the C-Language-4 (Week-17)

This set contains 10 multiple choice questions from C-Language. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________

1. Which of the following shows the correct hierarchy of arithmetic operations in C

A. / + * -
B. * - / +
C. + - / *
D. * / + -

2. What is constant?
A. Constants have fixed values that do not change during the execution of a program
B. Constants have fixed values that change during the execution of a program
C. Constants have unknown values that may be change during the execution of a program
D. None of the above

3. What will be the output of the following statement ?
     int a=20;  printf("%d", a++ - --a - a--);

A. -21
B. -22
C. -20
D. -19


4. Which one of the following sentences is true ?
A. The body of a while loop is executed at least once.
B. The body of a do ... while loop is executed at least once.
C. The body of a do ... while loop is executed zero or more times.
D. A for loop can never be used in place of a while loop.


5. The statement printf("%c", 100); will print?
A. prints 100
B. print garbage
C. prints ASCII equivalent of 100
D. None of the above


6. What will be the output of the following statement ?
     int a=10; printf("%d &i",a,10);
a) error
b) 10
c) 10 10
d) none of these


7. What will be the output of the following statement ?
     int a = 4, b = 7,c; c = a = = b; printf("%i",c);
a) 0
b) error
c) 1
d) garbage value


8. In switch statement, each case instance value must be ___?
A. Constant
B. Variable
C. Special Symbol
D. None of the above


9.Queue is a _____________ list.
A. LIFO
B. LILO
C. FILO
D. FIFO


10. Bit-wise operators can operate upon?
A. double and chars
B. floats and doubles
C. ints and floats
D. ints and chars

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of C-Language

>> Back to Quiz of All Computer Courses

---------------------------------------------------------------------------------------------------------------

QUIZ of the Adobe PageMaker

This set contains 10 multiple choice questions from Adobe Page Maker. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________

1. First Desktop Publishing Program.

A) Photoshop
B) Corel Draw
C) Image Ready
D) Page Maker

2. Who is introduced PageMaker

A) Adobe Systems
B) Aldus
C) Ken thompson
D) Dennis ritchie

3. Which tool used to crop imported images down to size.

A) Pointer tool
B) Crop tool
C) Text tool
D) Frame tool

4. Which option used to paste numerical offset from the original object.

A) Cleae
B) Paste 
C) Paste multiple
D) Edit original

5. Shortcut of Ellipse frame tool 

A) Shift + Alt + F5
B) Shift + Ctrl + F5
C) Shift + F5
D) Shift + Alt + F6

6. Visiting Card Measurements in inches (Width * Height) ? 

A) 4.2 * 3
B) 5 * 4
C) 3.5 * 2.5
D) 3.5 * 2

7. Which year released Page Maker Windows version? 

A) 1985
B) 1986
C) 1987
D) 1988

8.  Name of the tool 

A) Rotate tool
B) Rectangle tool
C) Frame tool
D) Rectangle Frame tool
 

9. Which option used to you can change the shape of its corners, as you are required.

A) Mask
B) Rounded Corners 
C) Polygon Settings
D) None of above
  

10. What is creating in Page Maker?

A) Wedding Albums 
B) Draw the building plans 
C) Visiting cards & Wedding cards
D) All of the above

__________________________________________
>> Back to Quiz of All Computer Courses
___________________________________________________________________________________