Quiz Questions

COPA (ITISKILL7739C0)

Question 1 1 Marks
Which dialog box in Power Point allows to change slides automatically in a period of time?
A
Action setting
B
Slide transition
C
Slide animation
D
Custom animation
Question 2 1 Marks
Which menu is used to apply various effects to the text in a slide?
A
Animation
B
Design
C
Transitions
D
Slide show
Question 3 1 Marks
What type of software program is power point?
A
Word Processor
B
Spread Sheet
C
Presentation Graphics
D
Database Management
Question 4 1 Marks
Which option is used to create a presentation automatically in Power Point?
A
Template
B
Blank Presentation
C
Auto content wizard
D
Standard test bar
Question 5 1 Marks
How many panes are these in backstage view in power point 2010?
A
3
B
5
C
7
D
9
Question 6 1 Marks
Which option is used to display the selected slides only for presentation?
A
From Beginning
B
From current slide
C
Broadcast slide show
D
Custom slide show
Question 7 1 Marks
Which shortcut key is used to create a new slide in power point?
A
Ctrl + C
B
Ctrl + N
C
Ctrl + M
D
Ctrl + S
Question 8 1 Marks
Which option is used to insert the related hints of a slide?
A
Note Master
B
Presentation Master
C
Slide Master
D
Hints Master
Question 9 1 Marks
Which holder holds text, title and picture in power point?
A
Contemt Holder
B
Image Holder
C
Place Holder
D
Slide Holder
Question 10 1 Marks
Which template makes specify common design elements in all slides in the presentation?
A
Fax template
B
User template
C
Data template
D
Master template
Question 11 1 Marks
Which function key is used to run a powerpoint presentation?
A
F3
B
F5
C
F7
D
F9
Question 12 1 Marks
Which shortcut key is used to create new presentation in powerpoint?
A
Ctrl + P
B
Ctrl + N
C
Ctrl + M
D
Ctrl + X
Question 13 1 Marks
Which view hides the hidden slides in Power Point?
A
Normal
B
Notes Page
C
Reading view
D
Slide Sorter
Question 14 1 Marks
Which option offers a built in design through a dialog box?
A
Auto content wizard
B
Blank Presentation
C
Standard tool bar
D
Template
Question 15 1 Marks
Which combination of key is used to show the laser pointer during slide show?
A
Alt + left mouse button
B
Alt + right mouse button
C
Ctrl + left mouse button
D
Ctrl + right mouse button
Question 16 1 Marks
Which tool allows user to select different layout for slide?
A
Apply design
B
Bullets
C
New slide
D
Slide Layout
Question 17 1 Marks
Which combination of key is used to select all slides from current slide to first slide?
A
Alt + Home
B
Ctrl + Home
C
Shift + Home
D
Tab + Home
Question 18 1 Marks
Which shortcut key is used to invoke thesaurus dialog box in Power Point?
A
Shift+F7
B
Ctrl+F7
C
Alt+F7
D
Ctrl+Alt+F7
Question 19 1 Marks
Which one of the following is extension of power point 2010 presentation file?
A
.potx
B
.pptx
C
.ppsx
D
.thmx
Question 20 1 Marks
Which contains miniature representation of slides?
A
Slides
B
Handout
C
Template
D
Slide master
Question 21 1 Marks
Which key is used to stop a power point presentation?
A
ESC
B
Tab
C
Ctrl
D
Enter
Question 22 1 Marks
Which menu is used to select a predefined chart style?
A
Animation
B
Design
C
Slide show
D
Transitions
Question 23 1 Marks
Which item, contains text graphics, charts, sound, video, etc., in power point
A
Slides
B
Folder
C
Handouts
D
Desktop screen
Question 24 1 Marks
Which menu is used to apply various visual effects to the slide in power point?
A
Animation
B
Design
C
Slide show
D
Transitions
Question 25 1 Marks
Which one of the following is a effect option in power point presentation?
A
Diamond
B
Fade
C
Push
D
Reveal
Question 26 1 Marks
How columns are named in MS Excel?
A
Alphabetically
B
Numerically
C
Alphanumerically
D
Special characters
Question 27 1 Marks
What is the purpose of ?Enter Key? in MS Excel?
A
Moves cell pointer to previous column
B
Moves cell pointer to next column
C
Moves cell pointer to previous row
D
Moves cell pointer to next row
Question 28 1 Marks
What is the purpose 'Tab' key in MS Excel?
A
Moves cell pointer to previous column
B
Moves cell pointer to next column
C
Moves cell pointer previous row
D
Moves cell pointer next row
Question 29 1 Marks
Which one of the following is a ?Date & Time? function in Excel?
A
FIND()
B
MOD()
C
NOW()
D
MID()
Question 30 1 Marks
Which function key is used to open save as dialogue box in MS Excel?
A
F2
B
F5
C
F7
D
F12
Question 31 1 Marks
Which type of key should combine with ctrl key to create a macro key in Excel?
A
Numeric
B
Alphabetic
C
Alphanumeric
D
Special characters
Question 32 1 Marks
Which key is used to make multiple line in a single cell?
A
Alt + Enter
B
Tab + Enter
C
Ctrl + Enter
D
Shift + Enter
Question 33 1 Marks
Which symbol is used to execute formulas in MS Excel?
A
"="
B
" ' "
C
"#"
D
" " "
Question 34 1 Marks
Which function is used to add the values in a range?
A
Count()
B
Sum()
C
ABS()
D
Sumif()
Question 35 1 Marks
Which one of the following will starts with ?=? sign in Excel 2010?
A
Data
B
Text
C
Numbers
D
Formulas
Question 36 1 Marks
How does the single element in a worksheet known as in Excel?
A
Cell
B
Column
C
Range
D
Row
Question 37 1 Marks
Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?
A
Formula
B
Data
C
Review
D
View
Question 38 1 Marks
How rows are numbered in MS Excel?
A
Alphabetically
B
Numerically
C
Alphanumerically
D
Special characters
Question 39 1 Marks
Which sequence of operation is used to insert the hidden formula bar in Excel worksheet?
A
View-Show/hide-Formula bar
B
Insert-show/hide-Formula bar
C
Data-show/hide-Formula bar
D
Home-show/hide-formula bar
Question 40 1 Marks
What do you mean by A3,B13:B20,C7 reference in Excel?
A
Range
B
Union
C
Formula
D
General
Question 41 1 Marks
Which key is used to move the insertion point to the beginning of the current sheet?
A
Pageup
B
Home
C
Ctrl + pageup
D
Ctrl + Home
Question 42 1 Marks
Which tab is used to change the display of worksheet area and the data it contains?
A
Page Layout
B
Data
C
Review
D
View
Question 43 1 Marks
Which option in MS Excel is used to display the rows that meet certain conditions?
A
Find
B
Filter
C
Format
D
Sort
Question 44 1 Marks
Which tool in Ms office is best for organizing data and making lists?
A
Access
B
Excel
C
Power Point
D
Word
Question 45 1 Marks
Which function is used to find the middle number in a range?
A
MEDIAN()
B
MID()
C
TRIM()
D
MODE()
Question 46 1 Marks
Where does the result displays when a formula is entered in Excel?
A
Current Cell
B
Next Cell
C
Previous Cell
D
Formula Bar
Question 47 1 Marks
Which bar lies top of the window in Excel Screen?
A
Status Bar
B
Ruler
C
Title Bar
D
Scroll Bar
Question 48 1 Marks
How Cells are named in MS Excel?
A
Alphabetically
B
Numerically
C
Alphanumerically
D
Special Character
Question 49 1 Marks
Which tab in Excel is used when importing, querying, outlining and subtotaling the data placed into a worksheet's data list?
A
Formula
B
Data
C
Review
D
Insert
Question 50 1 Marks
Which option in Excel is used to rearrange the rows base on the content of a particular column?
A
Find
B
Filter
C
Sort
D
Format