Name:     ID: 
 
Email: 

Semester Exam- Touch Systems

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

 1. 

Both a mouse and a keyboard are computer input devices.
 

 2. 

A bit is typically composed of eight bytes.
 

 3. 

RAM and ROM are the two basic types of computer memory for storing data.
 

 4. 

The operating system is the most critical piece of software in any computer.
 

 5. 

The Charm Bar is a universal toolbar in Macintosh OS X.
 

 6. 

USB and thumb drives are external storage devices that allow storage and transfer of several gigabytes of data without a network connection.
 

 7. 

Newer versions of Microsoft Office applications (Office 2010 and Office 2013) no longer include menus as part of the software.
 

 8. 

Clicking a scroll bar arrow moves the document in large increments.
 

 9. 

Using all caps is a good way to emphasize portions of text in your e-mails or other social network messages.
 

 10. 

When two or more computers are connected either by cable or wireless connection, the computers are part of a network.
 

 11. 

A table is an arrangement of data in columns and cells.
 

 12. 

Columns in a table are labeled alphabetically from left to right.
 

 13. 

A table should have no more than four columns.
 

 14. 

A secondary heading in a table should be keyed in ALL CAPS.
 

 15. 

If your table has a source note, you may position it beneath the gridlines of the table at the table’s left edge.
 

 16. 

It is possible to hide the gridlines on a table.
 

 17. 

To move back to a previous cell, tap Shift + Tab.
 

 18. 

Tables are most attractive when they are centered horizontally on the page.
 

 19. 

You will most often use bottom vertical alignment for table column headings and center vertical alignment for data rows beneath the headings.
 

 20. 

Within columns, words are typically either left-aligned or center-aligned.
 

 21. 

Visual aids usually make a speaker more effective in delivering his or her message.
 

 22. 

Presentation software creates visuals that can be projected onto a large screen or shown on a single computer.
 

 23. 

The design themes that come with PowerPoint cannot be changed by the user.
 

 24. 

Normal View (Slides) is especially helpful for rearranging slides and for applying features to several slides at one time.
 

 25. 

A presentation should begin with a title slide.
 

 26. 

Use the Title and Content layout for lists to guide discussion and help the audience follow a speaker’s ideas.
 

 27. 

Tables should rarely be used in presentations because many viewers find them confusing.
 

 28. 

Numeric information can be easier to understand when shown as a graph or chart rather than in text or table form.
 

 29. 

Pie charts can show the proportional relationship of two or more sets of values.
 

 30. 

When you deliver a presentation, look confident, be natural, and let your personality come through.
 

 31. 

In a worksheet, rows run vertically and are labeled with a letter; columns run horizontally and are labeled with a number.
 

 32. 

One big advantage of spreadsheet software is that when a number is changed in the spreadsheet, all related “answers” are automatically recalculated.
 

 33. 

In a worksheet, you can create or edit text in the formula bar.
 

 34. 

When text is entered in a worksheet cell, it is right-aligned.
 

 35. 

Gridlines and row/column headings may or may not be printed on a spreadsheet.
 

 36. 

When you use the Clear command to clear the contents of a cell, the surrounding cells are automatically shifted to replace the deleted cell.
 

 37. 

The cut and copy features in spreadsheet software work much the same as the cut and copy features in word processing software.
 

 38. 

You can copy a range of cells, but you cannot cut a range of cells.
 

 39. 

By default, numbers that are keyed into a worksheet are displayed in the Number format.
 

 40. 

Spreadsheet software has built-in predefined formulas called arguments.
 

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

 41. 

One example of a communications program is
a.
Adobe Acrobat
c.
Microsoft Power Point
b.
Microsoft Outlook
d.
Microsoft Access
 

 42. 

Which type of software helps you maintain your computer and perform other routine tasks associated with file maintenance?
a.
Utility Software
c.
Communication Software
b.
Application Software
d.
Online Applications
 

 43. 

One common type of peripheral device is.
a.
CPU.
c.
wireless network router.
b.
the operating system.
d.
application software.
 

 44. 

Programs such as Microsoft Word, Microsoft Excel, Adobe Photoshop, and Adobe Acrobat are commonly known collectively as
a.
application software.
c.
online applications.
b.
communications programs.
d.
multimedia programs.
 

 45. 

Which of these is NOT a typcial use or function of the computer mouse?
a.
CLICK
c.
RIGHT-CLICK
b.
DRAG
d.
ZOOM IN
 

 46. 

To select a word or text in Word,
a.
use the mouse to click and drag over the flashing cursor, then move on to the word or text.
b.
use the mouse to drag over the text, then choose “highlight” from the Charm Bar.
c.
use the mouse to place the insertion point at the beginning of the word, then choose “highlight” from the toolbar.
d.
use the mouse to place the insertion point at the beginning of the word, then click and drag over the word or text until it is highlighted.
 

 47. 

A website address may also be referred to as the
a.
URL .
c.
HTML.
b.
domain.
d.
WAN.
 

 48. 

Web page content such as photographs, documents, clip art images, videos, music, and other scanned and downloadable content is protected by
a.
netiquette.
c.
confidentiality .
b.
copyright law .
d.
Internet laws.
 

 49. 

File Explorer, formerly Windows Explorer, is a program that allows you to
a.
create files to store folders and other documents.
b.
see how files and folders are organized on your computer.
c.
create folders to store files.
d.
both b and c.
 

 50. 

Google, Microsoft Bing, and Yahoo search are collectively known as
a.
browsers.
c.
search engines.
b.
service providers.
d.
search domains.
 

 51. 

Rows in a table are labeled
a.
numerically from bottom to top.
c.
alphabetically from left to right.
b.
numerically from top to bottom.
d.
alphabetically from right to left.
 

 52. 

All of the following statements about the main heading in a table are correct EXCEPT
a.
it is usually keyed in ALL CAPS.
b.
it can be centered in the first row of the table.
c.
it can be placed above the gridlines of the table itself.
d.
it should be centered in the first column of the table.
 

 53. 

To move from one cell to another in a filled-in table, do any of the following EXCEPT
a.
use the arrow keys.
b.
tap Tab.
c.
tap Enter.
d.
use the mouse, then click the desired cell.
 

 54. 

Which of the following can typically appear at the bottom left in the last row of a table?
a.
a source note
b.
the name of the person who keyed the table
c.
the date the table was prepared
d.
a secondary heading
 

 55. 

You can quickly enhance the appearance of a table by using the __________ feature.
a.
Drawing
c.
Table Styles
b.
Page Layout
d.
Convert Table to Text
 

 56. 

Use ________to quickly copy formatting from one place to another.
a.
Layout Alignment
c.
Format Adjust
b.
Format Painter
d.
AutoFit Window
 

 57. 

Which of the following statements about table column width is INCORRECT?
a.
The first column in a table should always be the widest.
b.
Each column should be only slightly wider than the longest data entry in the column.
c.
Table columns should be identical widths or markedly different widths.
d.
Columns that are only slightly different widths should be avoided.
 

 58. 

Which of the following statements about table row height is INCORRECT?
a.
All rows, including title rows, may be the same height.
b.
The column heading row height should never be more than the data entry rows.
c.
It is acceptable for the main heading row height to be slightly more than the secondary heading row height.
d.
The secondary heading row height be may be slightly more than the column heading row.
 

 59. 

Within rows, data entries can be aligned at the
a.
top.
c.
bottom.
b.
center.
d.
all of the above.
 

 60. 

Whole numbers should be right-aligned in a table if
a.
the numbers are more than four digits long.
b.
a column total is shown.
c.
any of the numbers contain decimals.
d.
the words in the table are also right-aligned.
 

 61. 

Presentations are given to
a.
inform.
c.
persuade.
b.
entertain.
d.
all of the above.
 

 62. 

Which of the following is a type of electronic presentation software?
a.
Microsoft Excel
c.
Microsoft InfoPath
b.
Microsoft PowerPoint
d.
all of the above
 

 63. 

All of the following are common presentation layouts EXCEPT
a.
Landscape layout.
c.
Two Content layout.
b.
Title Slide layout.
d.
Content with Caption layout.
 

 64. 

Which view option would you use if you wanted to see how your slides will look on the screen?
a.
Normal View
c.
Slide Show View
b.
Notes Page View
d.
Slide Sorter View
 

 65. 

Graphic images should
a.
be placed on almost every slide in a presentation.
b.
rarely be used in a presentation to make a humorous point.
c.
be relevant to your topic and contribute to your presentation.
d.
all of the above
 

 66. 

Which of the following would be BEST suited to showing quantity changes over time or distance?
a.
bar graph
c.
pie chart
b.
line graph
d.
table
 

 67. 

Which of the following is best to AVOID with communication online?
a.
occasionally sending friends a few jokes or cute pictures you’ve found
b.
insulting arguments that have become too hostile to continue in person
c.
sarcasm or a joking, flippant tone
d.
both b and c
 

 68. 

Which of the following elements in a graph is usually used for categories?
a.
scale
c.
the Y-axis
b.
tick marks
d.
the X-axis
 

 69. 

To which of the following is copyright law relevant, so that permission to use the piece may be needed in some cases?
a.
music and photography
c.
video
b.
clip art
d.
all of the above
 

 70. 

Which of the following is NOT a good tip to follow to improve your presentation skills?
a.
know how to use the visuals
c.
know your message
b.
avoid eye contact with your audience
d.
avoid speaking in a monotone voice
 

 71. 

A group of related worksheets form a file is called a
a.
chart.
c.
workbook.
b.
spreadsheet.
d.
cell.
 

 72. 

To make the first cell in a row active, tap
a.
Home.
c.
Ctrl + Alt.
b.
Ctrl + Home.
d.
Alt + Home.
 

 73. 

The worksheet filename is displayed in the
a.
worksheet tab.
c.
status bar.
b.
title bar.
d.
cell reference box.
 

 74. 

Spreadsheet data that is to be used in calculations must be entered as a
a.
heading.
c.
range.
b.
label.
d.
value.
 

 75. 

The __________ deletes the contents AND format of a cell.
a.
Edit command
c.
Delete command
b.
Clear command
d.
Delete key
 

 76. 

To select a range of cells,
a.
highlight the cell in one corner, hold down the left mouse button, and drag to the cell in the opposite corner.
b.
highlight the cell in one corner, hold down the right mouse button, and drag to the cell in the opposite corner.
c.
double-click the cell in one corner with the left mouse button, then double-click the cell in the opposite corner.
d.
double-click the cell in one corner with the right mouse button, then double-click the cell in the opposite corner.
 

 77. 

Which of the following best describes the General number format?
a.
displays value with $, two default decimal places, and comma separators
b.
displays value as keyed
c.
displays value with a fixed number of decimal places
d.
multiplies value keyed by 100 and displays value and two default decimal places with percent sign
 

 78. 

Lucy wants to use a function to add the numbers in Cells A1 through A10. How should she enter the function in the formula bar?
a.
*SUM(A1:A10)
c.
=ADD(A1:A10)
b.
=SUM(A1,A10)
d.
=SUM(A1:A10)
 

 79. 

Which of the following type of chart always appears as an object within a worksheet?
a.
pie chart
c.
embedded chart
b.
chart sheet
d.
both b and c, but not a
 

 80. 

Numbers or words that identify values displayed in a chart are called
a.
titles.
c.
gridlines.
b.
data labels.
d.
legends.
 

Completion
Complete each statement.
 

 81. 

Adobe ________ is used to create animations for use on the Web and in software applications.
 

 

 82. 

________ is copyrighted commercial software that can be used for free on a trial basis, before making a decision on whether or not to purchase it.
 

 

 83. 

Three basic considerations when choosing software include: your budget, what you need to accomplish with the software, and  _________ for the software and how well they match the hardware you have.
 

 

 84. 

Giving personal and financial information to others online, especially if shopping at sites that are unsecured, may put you at risk for ______theft.
 

 

 85. 

With ______ computing, your software and files are stored on remote computers, and you can access them through the Internet using any computer.
 

 

 86. 

When information in a table spans more than one row, a useful feature to join cells in the same row to create a longer cell is ________.
 

 

 87. 

The secondary heading of a table may be placed a DS below the __________ title above the gridlines.
 

 

 88. 

The data entries in a table are referred to as the __________ of the table.
 

 

 89. 

When the table grid is used, ________on the grid to select the number of columns and rows needed for the table.
 

 

 90. 

If a table is centered on the page __________, it has equal top and bottom margins.
 

 

 91. 

Electronic __________ are computer-generated visual aids that can be used to help communicate information.
 

 

 92. 

__________ refers to the way text and graphics are arranged on a slide.
 

 

 93. 

Tables can be created in PowerPoint, or they can be created in Microsoft Word or ________ and inserted into PowerPoint.
 

 

 94. 

The part of a graph or chart that identifies the shading, coloring, or patterns used for the information shown in the graph is called the __________.
 

 

 95. 

__________ charts are best used to display parts of a whole.
 

 

 96. 

The cells in a spreadsheet are arranged in columns and rows on a(n) __________.
 

 

 97. 

The __________ cell of a worksheet is the cell with the thick border around it; this is the cell in which information is entered.
 

 

 98. 

Lines through a chart that identify intervals on the axes are called __________.
 

 

 99. 

The __________ feature enables you to change information already entered in a cell.
 

 

 100. 

A(n) __________ is a key used to identify a chart’s data categories.
 

 



 
         Start Over