What happens if you select first and second slide and then click on New Slide button on toolbar?

a new slide is inserted as first slide in presentation

a new slide is inserted as second slide in presentation

a new slide is inserted as third slide in presentation

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

from edit menu choose clear and then formats

click on remove formatting tool on standard toolbar

double click the format painter and then press esc key in keyboard

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

click on sheet 3 and from edit menu choose delete

right click on sheet tab of third sheet and choose delete from the context menu

click on sheet 3 and from edit menu choose delete

While finding and replacing some data in Excel, which of the following statement is valid?

excel does not have option to match case for find

you can find and replace within the sheet or workbook

excel does not have option to match case for find

When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply

select the cells that contain number between 0 and 100 then click red colour on text colour tool

use =if() function to format the required numbers red

apply conditional formatting command on format menu

select the cells that contain number between 0 and 100 then click red colour on text colour tool

While finding and replacing some data in Excel, which of the following statement is valid?

Excel does not have option to match case for find

You can Find and Replace within the sheet or workbook

Excel does not have option to match case for find

56 + Mcqs in Office Automation Tools in Bachelor of Commerce (B Com) Page 1 McqOptions

1.	In MS Word to move the insertion point to the beginning of the next word command used is
A.	ctrl+rightarrow
B.	ctrl+left arrow
C.	ctrl+down arrow
D.	none of these
Answer» B. ctrl+left arrow

Discussion

2.	Which of the following font effect is not available in PowerPoint Font dialog box?
A.	underline
B.	shadow
C.	emboss
D.	strikethrough
Answer» E.

Discussion

3.	The segment in which business directly sells to the end consumer is called____________.
A.	c2c.
B.	p2p.
C.	b2c.
D.	g2g.
Answer» D. g2g.

Discussion

4.	Which of the following should you use if you want all the slide in the presentation to have the same look ?
A.	the slide layout option
B.	add a slide option
C.	outline view
D.	a presentation design template
Answer» E.

Discussion

5.	If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an)
A.	inclusion
B.	attachment
C.	reply
D.	forward
Answer» C. reply

Discussion

6.	Which of the following toolbars provide different options in various master views?
A.	common tasks toolbar
B.	drawing toolbar
C.	formatting toolbar
D.	standard toolbar
Answer» B. drawing toolbar

Discussion

7.	If you will be displaying or printing your document on another computer, you ll want to make sure and select the _____________ option under the Save tab.
A.	embed true type fonts
B.	embed fonts
C.	save true type fonts
D.	save fonts
Answer» B. embed fonts

Discussion

8.	If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an)
A.	Inclusion
B.	Attachment
C.	Reply
D.	Forward
Answer» C. Reply

Discussion

9.	What lets you to create new presentation by selecting ready-made font color and graphics effects?
A.	presentation template
B.	master slide
C.	design template
D.	animation scheme
Answer» D. animation scheme

Discussion

10.	Which command will you use in PowerPoint if you need to change the color of different objects without changing content?
A.	design template
B.	colour scheme
C.	font colour
D.	object colour
Answer» C. font colour

Discussion

11.	What PowerPoint feature will you use to apply motion effects to different objects of a slide?
A.	slide transition
B.	slide design
C.	animation objects
D.	animation scheme
Answer» E.

Discussion

12.	What feature will you use to apply motion effects in between a slide exits and another enters?
A.	slide transition
B.	slide design
C.	animation objects
D.	animation scheme
Answer» B. slide design

Discussion

13.	Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
A.	insert menu
B.	format menu
C.	tools menu
D.	slide show menu
Answer» E.

Discussion

14.	What happens if you select first and second slide and then click on New Slide button on toolbar?
A.	a new slide is inserted as first slide in presentation
B.	a new slide is inserted as second slide in presentation
C.	a new slide is inserted as third slide in presentation
D.	none of above
Answer» D. none of above

Discussion

15.	Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A.	square
B.	percentage
C.	goal seek
D.	divide
Answer» E.

Discussion

16.	If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
A.	from edit menu choose clear and then formats
B.	from edit menu choose delete
C.	click on remove formatting tool on standard toolbar
D.	double click the format painter and then press esc key in keyboard
Answer» B. from edit menu choose delete

Discussion

17.	By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A.	right click on sheet tab of third sheet and choose delete from the context menu
B.	click on sheet 3 and from edit menu choose delete
C.	both of above
D.	none of above
Answer» B. click on sheet 3 and from edit menu choose delete

Discussion

18.	While finding and replacing some data in Excel, which of the following statement is valid?
A.	you can find and replace within the sheet or workbook
B.	excel does not have option to match case for find
C.	both are valid
D.	none are valid
Answer» B. excel does not have option to match case for find

Discussion

19.	Special category of Number tab in Format Cells dialog box can be used to apply formats like
A.	zip code
B.	phone number
C.	both of above
D.	none of above
Answer» D. none of above

Discussion

20.	Which of the following format you can decide to apply or not in AutoFormat dialog box?
A.	number format
B.	border format
C.	font format
D.	all of above
Answer» E.

Discussion

21.	Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from
A.	from format >> cells
B.	from format >> auto format
C.	from table >> auto format
D.	all of above
Answer» C. from table >> auto format

Discussion

22.	When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply
A.	use =if() function to format the required numbers red
B.	apply conditional formatting command on format menu
C.	select the cells that contain number between 0 and 100 then click red colour on text colour tool
D.	all of above
Answer» C. select the cells that contain number between 0 and 100 then click red colour on text colour tool

Discussion

23.	What PowerPoint feature will you use to apply motion effects to different objects of a slide?
A.	Slide Transition
B.	Slide Design
C.	Animation Objects
D.	Animation Scheme
Answer» E.

Discussion

24.	You can check the conditions against __________ when applying conditional formatting
A.	cell value
B.	formula
C.	both of above
D.	none of above
Answer» D. none of above

Discussion

25.	What do you call software that prevents certain Web pages from being displayed?
A.	child safe software.
B.	dutch dike software.
C.	filtering software.
D.	spam blockers.
Answer» E.

Discussion

26.	Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from
A.	from Format >> Cells
B.	from Format >> Auto format
C.	from Table >> Auto format
D.	All of above
Answer» C. from Table >> Auto format

Discussion

27.	If you want to keep track of different editions of a document which features will you use?
A.	editions
B.	versions
C.	track change
D.	all of above
Answer» C. track change

Discussion

28.	___________ monitors all the traffic that flows between the two networks but block certain traffic completely which may be intruder.
A.	firewall.
B.	anti-virus.
C.	software.
D.	hardware.
Answer» B. anti-virus.

Discussion

29.	______ provides the continuous access to the wireless network services and the flexible communication between the people.
A.	network.
B.	laptop.
C.	mobile computing.
D.	personal computing.
Answer» D. personal computing.

Discussion

30.	While finding and replacing some data in Excel, which of the following statement is valid?
A.	You can Find and Replace within the sheet or workbook
B.	Excel does not have option to match case for find
C.	Both are valid
D.	None are valid
Answer» B. Excel does not have option to match case for find

Discussion

31.	A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.
A.	Mail.
B.	Buddy.
C.	Chat.
D.	Message.
Answer» D. Message.

Discussion

32.	A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.
A.	mail.
B.	buddy.
C.	chat.
D.	message.
Answer» D. message.

Discussion

33.	A ____________ is a small program that helps to automate a frequently used series of commands in most productivity software tools.
A.	macro
B.	utility
C.	template
D.	wizard
Answer» B. utility

Discussion

34.	A ____________ is a small program that helps to automate a frequently used series of commands in most productivity software tools.
A.	Macro
B.	Utility
C.	Template
D.	Wizard
Answer» B. Utility

Discussion

35.	A_________ is a software program used for viewing various kinds of Internet resources found on the World Wide Web.
A.	bookmark.
B.	intranet.
C.	domain.
D.	browser.
Answer» E.

Discussion

36.	A___________ identifies a user s personal preferences and settings and allows the web site's server to retrieve your information from its database.
A.	Cookie.
B.	View history.
C.	Prototype.
D.	Profile.
Answer» B. View history.

Discussion

37.	A___________ identifies a user s personal preferences and settings and allows the web site's server to retrieve your information from its database.
A.	cookie.
B.	view history.
C.	prototype.
D.	profile.
Answer» B. view history.

Discussion

38.	Discussion groups may have a __________ who monitors the postings and enforces the site s rules.
A.	judge
B.	sysop
C.	narrator
D.	censor
Answer» C. narrator

Discussion

39.	In email, addresses separate the user name from the ISP using the __________ symbol.
A.	&
B.
C.	@%
D.	$
Answer» C. @%

Discussion

40.	Which of these services would you probably not be able to get from a typical Internet service provider (ISP)?
A.	an email address.
B.	access to a web server.
C.	a connection to the internet.
D.	technical help.
Answer» E.

Discussion

41.	Using any host computer on the internet as if you were directly connected is called__________.
A.	ftp.
B.	telnet.
C.	e mail.
D.	ppp.
Answer» B. telnet.

Discussion

42.	___________ is a type of Internet connection in which the PC must connect to a service provider using standard telephone lines.
A.	http.
B.	wireless.
C.	dsl.
D.	dial-up.
Answer» E.

Discussion

43.	Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
A.	Insert Menu
B.	Format Menu
C.	Tools Menu
D.	Slide Show Menu
Answer» E.

Discussion

44.	A screen element of MS Word that is usually located below the title bar that provides categorized options is...
A.	status bar
B.	menu bar
C.	tool bar
D.	all of the above
Answer» C. tool bar

Discussion

45.	_________ is a software program that secretly collects information and monitors your actions without your knowledge.
A.	ad ware.
B.	freeware.
C.	spy ware.
D.	hidden ware
Answer» D. hidden ware

Discussion

46.	The area that contains the URL or web address of the active web page is called the___________ bar.
A.	address
B.	menu.
C.	link.
D.	browser.
Answer» B. menu.

Discussion

47.	Discussion groups may have a __________ who monitors the postings and enforces the site s rules.
A.	judge
B.	sysop
C.	narrator
D.	censor
Answer» C. narrator

Discussion

48.	One major threat to data security is unauthorized network monitoring is also called as_____________.
A.	packet sniffing.
B.	message security.
C.	message confidentiality.
D.	system integrity.
Answer» B. message security.

Discussion

49.	A_________ engine is a software program used by a search site to retrieve web pages from a search database that match certain criteria.
A.	multimedia.
B.	virtual.
C.	serf.
D.	search.
Answer» E.

Discussion

50.	_______ refers to using the small portable and hand held computing devices such as PDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless enabled network.
A.	personal computing
B.	digital computing.
C.	network computing.
D.	mobile computing.
Answer» E.

Discussion

Explore topic-wise MCQs in Bachelor of Commerce (B Com).

In MS Word to move the insertion point to the beginning of the next word command used is

Which of the following font effect is not available in PowerPoint Font dialog box?

The segment in which business directly sells to the end consumer is called____________.

Which of the following should you use if you want all the slide in the presentation to have the same look ?

If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an)

Which of the following toolbars provide different options in various master views?

If you will be displaying or printing your document on another computer, you ll want to make sure and select the _____________ option under the Save tab.

If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an)

What lets you to create new presentation by selecting ready-made font color and graphics effects?

Which command will you use in PowerPoint if you need to change the color of different objects without changing content?

What PowerPoint feature will you use to apply motion effects to different objects of a slide?

What feature will you use to apply motion effects in between a slide exits and another enters?

Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

What happens if you select first and second slide and then click on New Slide button on toolbar?

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

While finding and replacing some data in Excel, which of the following statement is valid?

Special category of Number tab in Format Cells dialog box can be used to apply formats like

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from

When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply

What PowerPoint feature will you use to apply motion effects to different objects of a slide?

You can check the conditions against __________ when applying conditional formatting

What do you call software that prevents certain Web pages from being displayed?

Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from

If you want to keep track of different editions of a document which features will you use?

___________ monitors all the traffic that flows between the two networks but block certain traffic completely which may be intruder.

______ provides the continuous access to the wireless network services and the flexible communication between the people.

While finding and replacing some data in Excel, which of the following statement is valid?

A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.

A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.

A ____________ is a small program that helps to automate a frequently used series of commands in most productivity software tools.

A ____________ is a small program that helps to automate a frequently used series of commands in most productivity software tools.

A_________ is a software program used for viewing various kinds of Internet resources found on the World Wide Web.

A___________ identifies a user s personal preferences and settings and allows the web site's server to retrieve your information from its database.

A___________ identifies a user s personal preferences and settings and allows the web site's server to retrieve your information from its database.

Discussion groups may have a __________ who monitors the postings and enforces the site s rules.

In email, addresses separate the user name from the ISP using the __________ symbol.

Which of these services would you probably not be able to get from a typical Internet service provider (ISP)?

Using any host computer on the internet as if you were directly connected is called__________.

___________ is a type of Internet connection in which the PC must connect to a service provider using standard telephone lines.

Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

A screen element of MS Word that is usually located below the title bar that provides categorized options is...

_________ is a software program that secretly collects information and monitors your actions without your knowledge.

The area that contains the URL or web address of the active web page is called the___________ bar.

Discussion groups may have a __________ who monitors the postings and enforces the site s rules.

One major threat to data security is unauthorized network monitoring is also called as_____________.

A_________ engine is a software program used by a search site to retrieve web pages from a search database that match certain criteria.

_______ refers to using the small portable and hand held computing devices such as PDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless enabled network.