Name:     ID: 
 
Email: 

Final Semester 2

True/False
Indicate whether the statement is true or false.
 

 1. 

Each formula begins with a quotation mark (“).
 

 2. 

The formula =B5+C5 is an example of a multiplication operation.
 

 3. 

COUNT CELLS determine how many entries are included in the range.
 

 4. 

Whenever you select a range, the Ribbon shows the results of common calculations for the selected cells.
 

 5. 

You can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges.
 

 6. 

Some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions.
 

 7. 

A text function can be used to convert text in a cell to all uppercase or lowercase letters.
 

 8. 

The rounding operation requires two arguments, which are separated by a comma.
 

 9. 

The template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting.
 

 10. 

The worksheet cell is the hyperlink, not the contents entered in that cell.
 

 11. 

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.
 

 12. 

Each workbook opens with five worksheets.
 

 13. 

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.
 

 14. 

You designate the portion of the workbook to print on the Area tab in Backstage view.
 

 15. 

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.
 

 16. 

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.
 

 17. 

A chart sheet does not have worksheet cells and cannot contain data or formulas.
 

 18. 

When you select the chart style, click a 3-D chart subtype to create a 3-D chart.
 

 19. 

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.
 

 20. 

Microsoft PowerPoint 2010 is a Microsoft Office program that can help you create a
professional, computerized slide show to use as part of a presentation.
 

 21. 

A slide show is a series of slides.
 

 22. 

The Slide pane is NOT useful for adding and editing text.
 

 23. 

You can create a presentation by opening an existing presentation, making changes, then saving with a new name.
 

 24. 

You can use a theme to change the appearance of your slides without changing the content.
 

 25. 

The best view to use when you work on the transitions is Slide Show view.
 

 26. 

SmartArt graphics, dynamic and exciting graphics, are available for you to use on your slides in PowerPoint.
 

 27. 

The main difference between linking and embedding is where you store the data and how you update the data after you place it in the destination file.
 

 28. 

You can use a Slide Library to store favorite slides that you want to reuse again and again.
 

 29. 

You can save a presentation as a Word document to use as a handout, or create other documents using the text and slides from the presentation.
 

 30. 

To copy attributes to more than one object or section of text, select the object whose attributes you want to copy, double-click the Paste icon, and then click each of the objects or sections of text you want to format.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 31. 

After you finish typing a formula in a cell, you must enter it by pressing the ____.
a.
Enter key
c.
Enter button on the formula bar
b.
Tab key
d.
any of the above
 

 32. 

When evaluating formulas, the ____ of parentheses is evaluated first.
a.
innermost set
c.
set that starts farthest to the right
b.
outermost set
d.
set that starts farthest to the left
 

 33. 

You cannot enter a formula with an incorrect structure in Excel. If you attempt to do so, a(n) ____ appears, explaining the error and providing a possible correction.
a.
error message
c.
Formula Wizard
b.
dialog box
d.
none of the above
 

 34. 

The Sum button is located in the ____ group on the Home tab of the Ribbon.
a.
Commands
c.
Editing
b.
Formulas
d.
Data
 
 
FIGURE EX 4-1

nar001-1.jpg
 

 35. 

In Figure EX 4-1 above, number 3 is pointing to the ____ menu.
a.
Customize Calculations
c.
Show Formulas
b.
Calculations Options
d.
Manual Calculations
 

 36. 

Date and time functions can be used to convert serial numbers to a ____.
a.
month
c.
year
b.
day
d.
all of the above
 

 37. 

The ____ function replaces existing text in a specified cell with new text.
a.
FIND AND REPLACE
c.
SUBSTITUTE
b.
WRITE OVER
d.
REPLACE
 
 
Case EX 5-2
Sam is using the functions within Excel to complete questions in a school homework assignment.
 

 38. 

Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.
a.
date and time
c.
mathematical
b.
financial
d.
statistical
 

 39. 

To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button.
a.
Formulas
c.
Edit
b.
Format
d.
Styles
 

 40. 

To hide more than one row, select how many rows you want to hide, and then ____ the selection to show the short-cut menu.
a.
right-click
c.
highlight
b.
left-click
d.
double-click
 

 41. 

To insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears.
a.
Illustrations
c.
Data
b.
Shapes
d.
Formulas
 
 
FIGURE EX 6-1

nar003-1.jpg
 

 42. 

In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.
a.
Click the cell she wants to use for the hyperlink. On the Insert tab of the Ribbon, in the Links group, click the Hyperlink button.
b.
Right-click the cell or object, and then click Hyperlink on the shortcut menu
c.
either a. or b.
d.
neither a. nor b.
 

 43. 

In order to enter a ScreenTip to go with your hyperlink, you would click ScreenTip in the dialog box shown in Figure EX 6-1 above.  The Set Hyperlink ScreenTip ____ will appear.
a.
menu
c.
status bar
b.
wizard
d.
dialog box
 

 44. 

You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar.
a.
red
c.
gray
b.
white
d.
green
 
 
FIGURE EX 7-1

nar004-1.jpg
 

 45. 

The area indicated by #3 in Figure EX 7-1 above is ____.
a.
Sheet tabs for the inactive worksheets
c.
Tab scrolling buttons
b.
Sheet tabs for the active worksheets
d.
Custom sheet buttons
 
 
Case EX 7-1
Kristin wants to arrange multiple workbooks in a way where she can compare figures.
 

 46. 

Kristin wants to move the February worksheet from the February Statement workbook to the Annual Statement workbook. She intends to place the February worksheet after the January worksheet in the Annual Statement workbook. What should she do?
a.
In the Annual Statement workbook, right-click the January sheet tab, and then click Move or Copy on the shortcut menu.
b.
In the Annual Statement workbook, double-click the January sheet tab, and then click Arrange on the shortcut menu.
c.
In the February Statement workbook, double-click the February sheet tab, and then click Arrange on the shortcut menu.
d.
In the February Statement workbook, right-click the February sheet tab, and then click Move or Copy on the shortcut menu.
 

 47. 

To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.
a.
Format
c.
Format Selection
b.
Selection
d.
Chart Selection
 

 48. 

When you want to open an existing presentation that you have recently viewed, you can choose the presentation from the ____ list in Backstage view.
a.
Recent Presentations
c.
History
b.
Recent Slides
d.
Zoom Slider
 

 49. 

A(n) ____ is an effect you can apply to text, objects, graphics, or pictures to make those objects move during a slide show.
a.
animation
c.
media
b.
photography
d.
sliding
 

 50. 

In Slide Show view, each slide ____.
a.
takes up 1/4 the screen
b.
takes up 1/2 the screen
c.
fills the entire screen
d.
fills the center of the screen with room for editing
 
 
FIGURE PPT 1-1

nar006-1.jpg
 

 51. 

Referring to Figure PPT 1-1 above, the ____ on the slides can be text, images, charts, or tables.
a.
placeholders
c.
items
b.
outlines
d.
objects
 
 
Case PPT 1-2
Cindy is offering a training class on PowerPoint Slide Layouts to her fellow employees.
 

 52. 

Cindy starts by showing her class that the Title and Content layout provides ____ placeholders.
a.
one
c.
three
b.
two
d.
four
 

 53. 

To apply a different set of theme fonts to your presentation, on the Ribbon, click the Design tab, and then in the Themes group, click the Fonts button. A ____ opens listing the font sets for each theme.
a.
menu
c.
gallery
b.
sorter
d.
tab
 
 
Case PPT 2-2
Christina will have an Internet connection during her presentation, so she would like to add some hyperlinks.
 

 54. 

Christina inserted a hyperlink. The text will now be formatted ____.
a.
with a different color
c.
both a. and b.
b.
underlined
d.
neither a. nor b.
 

 55. 

To add an organization chart to a slide, you can apply a Content layout to a slide and then click the SmartArt Graphic ____ in the content placeholder.
a.
dialog box
c.
handle
b.
icon
d.
animation
 

 56. 

To create a shape from selected text, in the WordArt Styles group, click the Text Effects button, point to ____, and then click the shape you want.
a.
Change
c.
Move
b.
Edit
d.
Transform
 

 57. 

To include a table on a slide, you can use the Content slide layout and click the ____ icon to open the Insert Table dialog box.
a.
Insert Table
c.
Insert WordArt
b.
Insert SmartGraphic
d.
Insert Content
 

 58. 

The rotate commands on the Arrange menu do NOT include ____.
a.
Rotate Right 90°
c.
More Rotation Options
b.
Rotate Left 90°
d.
Flip Over
 
 

FIGURE PPT 3-1
nar009-1.jpg
 

 59. 

Referring to Figure PPT 3-1 above, the datasheet on the right-hand side of the window has data in it already. How could one change the data?
a.
Click the cell and then type the numbers or text in the Excel window
b.
Open up a separate Cell Data dialog box in the Excel window
c.
Click the datasheet and import it into PowerPoint, and then enter the data
d.
None of the above
 
 
FIGURE PPT 4-1

nar010-1.jpg
 

 60. 

Referring to Figure PPT 4-1 above, to make the screen appear blank, point to ____, and then click Black Screen or White Screen.
a.
Screen
c.
End Show
b.
Help
d.
Go To Slide
 



 
         Start Over