COMP101 - FINAL EXAM

[Kelly]

Knowledge Work Presentation and Software Skills Final Exam

COMP101 - FINAL EXAM

How many margins are on a page?
b. Four (top, bottom, right, left)

How can you highlight text without using the mouse?
a. Use the arrow keys while holding down a Shift key

How do you open the Header and Footer toolbar?
c. On the Edit menu, click Header and Footer.

Why the document you created at home displays with a different font at school?
d. Because the font you used at home is not installed on your school computer

Which of these toolbars allows changing of Fonts and their sizes?
b. Formatting

Which bar is usually located below that Title Bar that provides categorized options?
b. Menu bar

Which would you choose to move selected text from one place to another?
b. Cut and Paste

Which option in File pull-down menu is used to close a file in MS Word?
a. Close

Which would you choose to save a document with a new name?
a. Click File > Save As

In order to save an existing document with a different name you need to:
b. Use the Save as... command

How do you rearrange the data in ascending or descending order?
c. Data > Sort

Which of the following is an example of a range address in Excel?
b. A1:B3

If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:
a. Type the data in A1 and Merge cells A1:E1

A fast way to add up this column of numbers is to click in the cell below the numbers and then:
a. Click the AutoSum button on the Standard toolbar, then press ENTER.

In the formula, which symbol specifies the fixed columns or rows?
b. $

When you start to select a range of cells in Excel, you will see a thick white, cross shaped pointer called a ________________.
b. Selection pointer

What is the correct way to refer the cell A10 on sheet3 from sheet1?
e. Sheet3!A10

Which is not the function of “Edit, Clear” command in Excel?
b. Delete cells

How do you display current date only in MS Excel?
c. Today ()

An Excel Workbook is a collection of __________.
e. Worksheets and Charts

During slide show in Powerpoint, what is the shortcut key to move the last slide?
d. End

What is the key shortcut to open the existing presentation in powerpoint?
a. Ctrl + O

A ____ ends all slide shows unless the option setting is deselected in Powerpoint.
d. Black slide

To print a presentation using shortcut keys, press ____.
d. CTRL+P

The drawing tools format tab or contextual tab appears when you do what?
a. When you click a shape or text place holder

Power Point presentation is a collection of ________
a. Slides and Handouts
b. Speaker’s notes
c. All of the above (Answer)
d. Outlines

These are effects that are in place when you switch from one slide to the next.
a. Transitions

To insert new slide in the current Presentation, we can choose:
a. Ctrl+M

To start the slide show from the first slide in Powerpoint. What is the shortcut key?
b. Alt+F5

To open the existing presentation, press_______________.
a. Ctrl + O

Once you create an appointment in Outlook Calendar, you can't change it to another type of calendar entry.
False

Can you copy / paste text form MS Word 2013 into MS Outlook 2013?
d. Yes!

How do you create a meeting from an e-mail message?
b. Drag it from your Inbox to your Calendar.

In Outlook, File extension for an Archive file is _____________.
d. pst

Which type of calendar entry should you use if others at your workplace are involved?
a. Meeting

How do you create a meeting from an e-mail message?
a. Drag it from your Inbox to your Calendar

What does CC... mean in an e.mail message window.
d. Carbon copy

Which steps among the following should a user perform regularly to maintain a reasonable mailbox size:
c. Archive

Is there a spellchecker in outlook 2013?
a. Yes!

Although MS Outlook is often used mainly as an e-mail application, it also provides features among the following:
a. Task and contact management

Which Chart can be created in Excel?
a. Scatter
b. Pie
c. All of the above (Answer)
d. Line
e. Area

What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
a. 5,436.80

Microsoft Excel is a powerful ___________ package.
c. Spreadsheet package

Which function is not available in the Consolidate dialog box in Excel?
e. Pmt

Excel displays the current cell address in the __________.
e. Name Box

How can you highlight text without using the mouse?
d. Use the arrow keys while holding down a Shift key

What would you see while spell checking the phrase "My father was write"?
b. No errors

The best way to create a heading in a document is to:
a. Apply a heading style.

Which key deletes the character to the right of the cursor?
a. Delete

Which key should be pressed to start a new paragraph in MS Word?
b. Enter Key