Ohana Komputer Microsoft Office Assessment

Question Title

* 1. Please type your name and/or organization.

Question Title

* 2. What computer area are you interested in?

Computer Basics

Internet and Email

Microsoft Word

Microsoft Excel

Microsoft Access

Microsoft PowerPoint

Microsoft Outlook

Graphics and Audio

Below are questions to rate your expertise in the following Microsoft Office programs: Microsoft Excel, Microsoft Word, Microsoft PowerPoint and Microsoft Outlook.

Please only answer questions you know, if you do not know an answer check 'I Don't know' as this will help determine the computer lessons that are needed. This test is designed to be completed within one half hour.

Thank you for your time.

Microsoft Excel

Question Title

* 3. Which key(s) do you press (while clicking the mouse) to select two or more nonadjacent cells?

CTRL

ALT

SHIFT

I don't know

Question Title

* 4. Which function would you use to change text in a cell so the first letters are capitalized?

PROPER

UPPER

CAPITAL

CONCATENATE

I don't know

Question Title

* 5. If you wanted cell contents to change to red every time a value drops below a certain value. What feature would you use?

Auto Sum

Conditional Formatting

Auto Paint

AutoFill

I don't know

Question Title

* 6. When working with Charts, what is a Data Table?

A Pivot Table of Data that is tied to your chart

The table of data that appears with details, when you click on an item in your chart

A diagram linked to your chart that displays data from another document

A Table that appears at the bottom of your chart that displays the numerical data

I don't know

Question Title

* 7. You have created a long, detailed spreadsheet. To get the first row and first column to repeat on every page when printed. What feature would you use?

'Set Print Area' in Page Setup

'Print Titles' in Page Setup

Header & Footer, 'Add Headers' button

'View Headings' check box, in the Sheet Options

I don't know

Question Title

* 8. To quickly populate a series of cells with the months of the year, what feature would be best to use without having to type all twelve months?

Click-and-drag using the Auto Fill handle

Copy and Paste

Auto Format

Select the cells, right-click and select Insert Months

I don't know

Question Title

* 9. To create a drop-down list, where people can select an item from options provided what feature should be used?

Macro

Conditional Formatting

A 'List type' Data Validation

A Signature Line

I don't know

Question Title

* 10. You created a spreadsheet that lists all of the sales for all sales regions for XYZ company. You would like to subtotal these values by region. How would you most efficiently do this.

Beneath every region, insert a 'Row'. Then, add an 'Auto sum' to calculate the values by region

On the 'Data' tab, click the 'Subtotal' button. Set your preferences by region and click 'OK'

Beneath every region, insert a 'Row'. On the 'Data' tab, click the 'Group' button. Highlight the cells you want to group. Then, add an 'Auto sum' to calculate the values by region

Highlight the regions and use the 'Consolidate' feature in the 'Data Tools'

I don't know

Question Title

* 11. A company has changed its name from XYZ Company to XYZ Inc. To quickly change all 150 instances of this in the spreadsheet, one should:

Use the CTRL key, highlight all of the instances that read XYZ Company, and type the new company name.

On the Home tab, click the 'Find & Select' icon and select 'Replace'. Enter XYZ Company in the 'Find what' field and enter XYZ Inc in the 'Replace with' field. Click 'Replace All' or 'Replace'

On the Home tab, click the 'Find & Select' icon and select 'Find'. Enter XYZ Company in the 'Find what' and as each one is found, type XYZ Inc

Highlight the text XYZ Company, and right-click on it. Select Find all Matching text from the menu.

I don't know

Microsoft Word

Question Title

* 12. You are revising a Microsoft® document that a team member created, and you want its author to be able to review your suggested changes before they become part of the document. What feature do you use?

Reviewing and Editing

Comments

Track Changes

Permissions

I don't know

Question Title

* 13. You want to create an organizational chart in your document. What feature will enable you to do this the fastest and most efficiently?

'Insert' Tab, Clip Art

'Insert' Tab, Shapes

'Insert' Tab, SmartArt

'Insert' Tab, Object

I don't know

Question Title

* 14. To insert a watermark that says "Draft" in a document. You would go to:

1. Click the Design tab. 2. Click the Watermark button. 3. Scroll down the samples and select either DRAFT 1 or DRAFT 2.

1. Click the Insert tab. 2. Click the Clip Art button. The Clip Art task pane will open. 3. In the Search for field, enter the word 'DRAFT' and click Go. 4. Click the DRAFT clip art that you prefer to insert the graphic.

1. Click the Page Layout tab. 2. Click the Watermark button. 3. Scroll down the samples and select either DRAFT 1 or DRAFT

1. Right-click and select Background. 2. Select a Watermark from the background styles.

I don't know

Question Title

* 15. You have a document with a lot of text that would look more organized in a table. How could you most efficiently get the content into a table?

Select the content you want to put in a table. Click the 'Insert' tab and click 'Table'. Select 'Convert Text to Table'. Select the number of columns/rows and click 'OK'.

Click the 'Insert' tab and click 'Table'. Drag the mouse to the number of rows and columns needed. Then, copy and paste the content into each cell.

Click the 'Insert' tab and click 'Table'. Drag the mouse to the number of rows and columns needed. Then, drag-and-drop the content into each cell.

Select the content you want to put into a table. Right-click and select 'Tab Stop'. Set the tab stop to desired width.

I don't know

Question Title

* 16. If you've just formatted some text so that it stands out, how could you quickly copy that formatting to use on other text?

Click anywhere in the formatted text. Click the 'Home' tab and in the 'Font' group, click where you want the same format, and start to type.

Select the formatted text. On the 'Home' tab and the 'Font' group, click 'Reveal Formatting'. Make note of what formatting you need to change. Select the new text and make the appropriate changes.

Select the formatted text. On the 'Home' tab, in the 'Clipboard' group, click the 'Format Painter' button. Go down to the text you want to format and click or highlight it.

Select the formatted text. On the 'Home' tab, in the 'Styles' group, click the 'Change Style' button, then select 'Apply Formatting'.

I don't know

Question Title

* 17. You inserted a picture into a document. You would like the text to wrap around the picture. The best way to do this is to:

Insert the picture. Then, on the 'Picture Tools Format' contextual tab, click the 'Text Wrapping' button. Select 'Tight' or 'Square'.

Insert a two column table. Remove the border. Put the picture in one column and the text in the adjacent column.

Insert the picture and put the picture in a text box. Then, the text will wrap around it.

Set a '0.5 inch' tab stop on either side of your picture so that the text will end and start around your picture.

I don't know

Question Title

* 18. You've used Word Heading Styles to format the title and sub-title text throughout a document. You would like to create a table of contents that automatically pulls in the title/sub-title text. How could this be done?

Click the 'References' tab and click the 'Table of Contents' button. Select a preset table of content formula and click 'OK'.

Select the titles and sub-titles in your document. On the 'Insert' tab, click 'Table'. Then select 'Create Table of Contents'.

On the 'Home' tab, in the 'Styles' group, open the 'Styles' gallery and select 'Apply Styles to Table'.

On the 'References' tab, select 'Mark Entry'. Mark each title or sub-title text that you want to appear in the table of contents. Click the 'Insert Table of Contents' button when done.

I don't know

Question Title

* 19. You are creating a thank you letter. You would like to personalize each letter so that it says each client's name in the salutation. What feature do you use?

Online collaboration

Mail Merge

Track Changes

Compare and Merge Document

I don't know

Question Title

* 20. You've created a document and would like to have 1.5 spacing between each line of text. How can you do this?

Press the 'Enter' key on the keyboard at the end of each line of text.

On the 'Home' tab, in the 'Paragraph' group, click the 'Line Spacing' button and select '1.5'.

Highlight the text and right-click. Select 'Line Spacing' from the list and choose '1.5'.

Select text and press 'ALT' + 'Enter' for each 0.5 desired between text.

I don't know

Question Title

* 21. You have a block of text along with a confidentiality statement you use repeatedly. What is the best way to automate the process without having to type it over and over again?

Save the text as a 'Caption', and click 'Insert Caption' to reuse when needed.

Use the 'Merge Field' options from the 'Mailings' tab.

Save the text as a 'Style' and reuse from the 'Style Gallery'.

Save the text as a 'Quick Part' and reuse from the 'Insert' Tab in the 'Quick Parts' menu.

I don't know

Microsoft® PowerPoint

Question Title

* 22. In Microsoft® PowerPoint, Save, Save As, Print Preview, Print, Options, and Recent can be found:

Under the 'File' Tab

Under the 'Home' Tab

Under the 'Tools' Menu

Under the 'View' Tab

I don't know

Question Title

* 23. Microsoft® PowerPoint has a feature called Themes that affects colors, fonts and effects. To create your own Theme, you need to:

On the 'Home' tab apply desired formatting from the 'Font' group. Click the 'Reset' button in the 'Slides' group to save the the Theme.

After making desired formatting edits to a slide, expand the 'Themes Gallery' from the 'Design' tab on the Ribbon and select 'Save Current Theme' from the menu in the gallery.

After making desired formatting edits to a slide, select 'Save As' on the 'File' tab and save the presentation as a 'Template'.

Apply desired formatting to a slide, then right-click and select 'Publish Slide' from the menu.

I don't know

Question Title

* 24. When working in PowerPoint in Normal view, how do you access the Outline panel?

On the 'Home' tab on the Ribbon, click the 'Layout' button, then select 'Outline'.

Click the 'Outline' view button on the Status bar.

Click the 'View' tab on the Ribbon and click the 'Outline' button.

Click on the 'Outline' tab next to the 'Slides' tab.

I don't know

Question Title

* 25. To apply a Theme to all your slides, you would need to select the ____________ tab first.

Design

Format

Slide

Home

I don't know

Question Title

* 26. Which key do you press to go into Slide Show view and start your presentation on the first slide?

Esc

Alt

I don't know

Question Title

* 27. How do you print your slides in a handout that includes lines for notes?

Select the 'File' tab and select 'Print'. In the 'Print' settings, select 'Handouts' and select the '3 slides per page' option.

On the 'View' tab, click the 'Handout Master' button. Select the '3 slides per page' view and click 'Print'.

On the 'Design' tab, click the 'Page Setup' button. Select '3 Slide Handouts' from the options.

Select '3 slides' from the slide thumbnails by holding down the CTRL key. Then click 'Print'.

I don't know

Question Title

* 28. You would like to change the formatting of the bullets on every slide. You need to change the size, color, and type of the font. What is the most efficient and quickest way to do this?

Conditional Formatting

Slide Master

Copy and Paste

Edit > Find and Replace

I don't know

Question Title

* 29. How do you make an inserted sound file play continuously over several slides?

In the 'Animation' tab on the Ribbon, change the Duration of the sound to the desired number of minutes.

Using the 'Record Sound' feature, press the 'Record' button and play your music as you click through the whole slide show.

On the 'Audio Tools Playback' contextual tab, select 'Play Across Slides', from the Start drop-down options.

On the 'Audio Tools Playback' contextual tab, select 'Loop Until Stopped'.

I don't know

Question Title

* 30. You would like to create the graphic above. What is the most efficient way to do this?

Use Smart Art

Insert Auto shapes and text boxes

Insert Clip Art and text boxes

Import it from Visio

I don't know

Question Title

* 31. Which of the following can you NOT access from the 'Animations' tab on the Ribbon:

Set the effects of how one slide Transitions into the next

Set what triggers the animation

Paint a previously used animation onto different objects

Delay the start of an animation

I don't know

Question Title

* 32. Using an animation effect, how do you make text change to a Red color on a slide?

Apply the 'Red Font' Theme to the slide, then select the 'Fade Entrance' Animation from the gallery.

Select the 'Font Color' Emphasis effect from the 'Animation' gallery, then from the 'Effect Options', select 'Red'.

Apply the 'Red Font' Theme to the Slide, then select the 'Transparency' Emphasis Animation from the gallery.

Apply a red back ground to the slide and a white font color. Apply the 'Disappear' Animation from the gallery.

I don't know

Question Title

* 33. You would like to animate each line of text on a slide. Can you save time and do this on the Slide Show tab.

YES

I don't know

Question Title

* 34. How do you insert a picture of part of a website into a presentation?

Find the desired website, and press the 'Print Screen' button. Paste it into your slide.

On the 'Insert' tab, click the 'Hyperlink' button, then type in the URL for the website.

From the website, right-click and select 'Save Website as Picture'. Paste the saved picture into your slide.

On the 'Insert' tab, click the 'Screenshot' button and then select 'Screen Clipping'. Click-and-drag to select the desired portion of the website.

I don't know

Question Title

* 35. You have typed an outline of content in Microsoft Word. The easiest way to get this content into your PowerPoint is to:

Open the Word document then open PowerPoint and customize the screen sizes so that both are side by side. Then, 'copy' and 'paste' the content from the Word document into the PowerPoint.

On the 'Home' tab, in the 'Slides' group, click the arrow next to 'New Slide', and then click 'Slides' from 'Outline'. Select the file that contains the outline you want to insert in your presentation.

From the 'File' tab, select 'Import'. Locate and double-click the file that contains the outline that you want to insert in your presentation.

From the Word document, on the 'File' tab, select 'Export to PowerPoint'. Select the desired PowerPoint file.

I don't know

Question Title

* 36. You want to create a Chart on a PowerPoint slide, what is the easiest way to do this?

Create the chart in Excel and then cut and paste it into the slide.

Using the 'Shapes' options in PowerPoint, draw your desired chart shapes on the slide.

From PowerPoint, click the 'Insert' tab, then select 'Table'. Enter your desired data in the table.

From PowerPoint, click the 'Insert' tab, then select 'Chart'. Modify the data in the chart as needed.

I don't know

Question Title

* 37. You have a large PowerPoint presentation with over 300 slides. You have to give a modified version of this presentation for a new work group. Rather than creating or saving a new presentation, you can use this presentation and create _____________________ to show the desired slides for each unique presentation you give.

A Navigation Menu

A Custom Show

Hidden slides

Slide Show Timings

I don't know

Question Title

* 38. You want the company logo to display at the bottom of each slide. Where do you do this?

Header & Footer settings

Copy & Paste in Normal view

Slide Master

Themes gallery

I don't know

Microsoft Outlook

Question Title

* 39. To send a business letter to a group of contacts you should

In the 'Contact' view, click 'Mail Merge' from the 'Actions' group.

In the 'Contact' view, select the 'Contacts to send the letter to', then right click and choose 'export to word'.

Start Microsoft Excel, and choose 'Merge Contacts' from the 'Mailings' tab.

I don't know

Question Title

* 40. You can request a receipt to show an email has been read by...

Right clicking the 'Send' button and choosing 'Send with Receipt'.

Clicking the 'Send/Receive' tab, then the 'Receipted Mail' button

Clicking the 'Options' tab from the 'Message' window and choosing 'Request Receipt'

I don't know

Question Title

* 41. You need to ensure all mail from a particular client is stored in that clients folder on our folder list - how would you do this?

In the 'Search Line' type the clients name, drag the mouse over the emails, then drag them to the client's folder.

On the 'Home' tab choose 'Rules', and click on the 'Create Rule' button. Create a rule that looks for the address then moves the mail.

Open an email and select Message > Rules > Create Rule. Select From > Move the item to folder, then choose or create a folder.

I don't know

Question Title

* 42. How can you ensure that a particular meeting on the calendar is only visible to you?

Right click the appointment and choose 'Hide' from the menu.

Double click the appointment and choose 'Private' from the 'Tags' group.

Double click the appointment and type 'P' at the end of the start time.

I don't know

Question Title

* 43. You can show tasks by many different date periods - how would you change the work week for employees that work from Tuesday to Saturday?

In 'Calendar' view use the 'Arrange Dialogue Launcher' button and choose the days you want.

In 'Week' view drag the working days into the 'Work Week' bar.

Click Calendar in the left bar, and then specify the new time range in both Start time and End time boxes

I don't know

Question Title

* 44. You need to arrange a meeting for all employees in a particular department - you should...

Call up the member's contact details in the Address Book, and send them an email with the date and time of the meeting.

From the calendar select New Appointment then enter information and select Save & Close to save your appointment.

Right click the calendar and choose 'New Meeting Request', then complete the form and choose 'Send'.

I don't know

Question Title

* 45. On the task list, to arrange tasks in date order, then in alphabetical order you would

Click at the top of the 'Date' column, then on the top of the 'Subject' column.

Use the 'File' menu, and choose the 'Date Arrange' command.

Use the 'View' tab and use the 'View Settings' button.

I don't know

Question Title

* 46. To mark all contents of a folder as read, you would

Click the 'Folder' tab, and choose 'Mark All as Read' from the 'Clean Up' group.

Press Ctrl + Alt + R

Click the 'Filter Email' button and choose 'Mark All as Read'.

I don't know

Question Title

* 47. You want to set up a button to automatically send an email you've received on to your manager, rather than have to manually choose their name every time you would,

Click the 'Forward' button on the 'Home' tab then from the 'File' tab choose the 'Save As' button.

Click the 'Home' tab and choose 'To Manager' from quick steps

Click the 'Send / Receive' tab and choose 'Forward to Address Book' member and select your manager name.

I don't know

Question Title

* 48. What are categories?

Ways to assign a color code and name to an item to help find that item later and group it with other similar items

Different types of data, like appointments, to do tasks, email messages etc

A quick classification system for contacts, for example into business and personal

I don't know

Question Title

* 49. An appointment that happens every year, for example a birthday, is input as

A yearly appointment

Annualized

Recurring

I don't know

Thanks for completing the Microsoft Office Assessment.