Deck 11: Microsoft Office and Technology

Question 1

Which function will you use to enter current time in a worksheet cell?

A) =today()
B) =now()
C) =time()
D) =current Time()

Answer 1

=time()

Question 2

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 2

from Format >> Auto format

Question 3

Which of the following is not true regarding Conditional Formatting?

A) You can add more than one condition to check
B) You can set condition to look for Bold and apply Italics on them.
C) You can apply Font, border and pattern formats that meets the specified conditions
D) You can delete any condition from Conditional Formatting dialog box if

Answer 3

You can apply Font, border and pattern formats that meets the specified conditions

Question 4

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

Question 5

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

Question 6

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

Question 7

The difference between Slide Design and Auto Content Wizard is

A) Both are same
B) Auto content Wizard is just the wizard version of Slide Design
C) Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
D) Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices

Question 8

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

Question 9

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

Question 10

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

A) Underline
B) Shadow
C) Emboss
D) Strikethrough

Question 11

Material consisting of text and numbers is best presented as

A) A table slide
B) A bullet slide
C) A title slide
D) none

Question 12

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

Question 13

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

Question 14

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

Question 15

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

A) judge
B) sysop
C) narrator
D) censor

Question 16

_______ 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.

Question 17

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.

Question 18

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.

Question 19

DSA stands for______________.

A) Digital Signature Algorithm.
B) Digital System architecture.
C) Digital system analysis.
D) Digital Signature Authentication.

Question 20

ATM is a service that can run over____.

A) SONET.
B) SDH.
C) B-ISDN.
D) ISDN.