Name:     ID: 
 
Email: 

2018 Final Exam -160 Questions

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

 1. 

An Excel ____ allows data to be summarized and charted easily.
a.
worksheet
c.
document
b.
workflow
d.
presentation
 

 2. 

To enter data in a cell, you must first select the ____.
a.
row
c.
column
b.
worksheet
d.
cell
 

 3. 

____ is/are used to place worksheet, column, and row titles on a worksheet.
a.
Color
c.
Links
b.
Text
d.
Tabs
 

 4. 

Clicking the ____ box completes an entry.
a.
Cancel
c.
Enter
b.
Formula
d.
Tab
 

 5. 

The ____ is a blinking vertical line that indicates where the next typed character will appear.
a.
scroll box
c.
insertion point
b.
sheet tab
d.
split bar
 

 6. 

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
a.
AutoComplete
c.
AutoFormat
b.
AutoCorrect
d.
AutoTyping
 

 7. 

Pressing the ____ key to complete an entry activates the adjacent cell to the right.
a.
RIGHT ARROW
c.
UP ARROW
b.
LEFT ARROW
d.
DOWN ARROW
 

 8. 

By default, text is ____ in a cell.
a.
left-aligned
c.
justified
b.
centered
d.
right-aligned
 

 9. 

The range of cells receiving copied content is called the ____ area.
a.
fill
c.
location
b.
range
d.
paste
 
 
nar001-1.jpg
 

 10. 

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
a.
range
c.
nearby cell
b.
bunch
d.
neighbor
 

 11. 

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
a.
semi-colon (;)
c.
period (.)
b.
colon (:)
d.
none of the above
 

 12. 

The range of cells receiving the content of copied cells is called the ____.
a.
receiver cell
c.
receiving range
b.
final cell
d.
destination area
 

 13. 

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.
a.
selection handle
c.
fill handle
b.
sizing handle
d.
copy handle
 

 14. 

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
a.
quotation mark (“)
c.
plus (+)
b.
colon (:)
d.
equal sign (=)
 

 15. 

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
a.
save
c.
format
b.
print
d.
clear
 

 16. 

Combining two or more selected cells into one cell is called ____ cells.
a.
merging
c.
combining
b.
mixing
d.
spanning
 

 17. 

What effect does the Accounting Number Format have on the selected cells?
a.
Converts alphabetic characters to numbers
b.
Displays cell contents with two decimal places that align vertically
c.
Performs tax calculations
d.
Copies the numbers of one cell to another
 

 18. 

What effect does the Comma Style format have on the selected cells?
a.
Converts decimals to commas within a cell
b.
Converts decimals to commas within merged cells
c.
Displays cell contents with two decimal places and commas as thousands separators
d.
Allows for substitution of selected characters
 

 19. 

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
a.
ALT
c.
CTRL
b.
ESC
d.
TAB
 

 20. 

A ____ is a prewritten formula that is built into Excel.
a.
function
c.
task
b.
feature
d.
calculation
 

 21. 

To start a new line in a cell, press the ____ keys.
a.
CTRL+ENTER
c.
ALT+ENTER
b.
TAB+ENTER
d.
SHIFT+ENTER
 

 22. 

Which of the following calculations multiplies 23 by 0.01?
a.
=23%
c.
=23+.01
b.
=23
d.
=24-.01
 

 23. 

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
a.
40
c.
48
b.
26
d.
13
 

 24. 

The ____ function determines the lowest number in a range.
a.
LOW
c.
LEAST
b.
BASE
d.
MIN
 

 25. 

A ____ is text and graphics that print at the top of each page.
a.
header
c.
margin
b.
topper
d.
crown
 

 26. 

A ____ is text and graphics that print at the bottom of every page.
a.
footer
c.
margin
b.
toe
d.
stopper
 

 27. 

The default view in Excel is called ____ view.
a.
Normal
c.
Basic
b.
Standard
d.
Values
 

 28. 

Which of the following patterns extends the fill series to 575, 550, 525?
a.
650, 600
c.
560, 580
b.
625, 600
d.
500, 475
 
 
nar003-1.jpg
 

 29. 

In the accompanying figure, the split double arrow mouse pointer ____.
a.
indicates a hidden column
b.
allows text to be entered at that location
c.
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
d.
indicates the proposed width of column A
 

 30. 

Error messages begin with the ____ symbol.
a.
?
c.
!
b.
=
d.
#
 

 31. 

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
a.
section
c.
special
b.
sparkline
d.
sparkle
 

 32. 

A ____ is a duplicate of content on a storage medium that you can use in case the original is lost, damaged, or destroyed.
a.
platter
c.
backup
b.
track
d.
head crash
 

 33. 

A(n) ____ is system software.
a.
spreadsheet program
c.
word processing program
b.
operating system
d.
presentation graphics program
 

 34. 

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
a.
calendar
c.
presentation
b.
worksheet
d.
database
 

 35. 

____ help one slide flow gracefully into the next during a slide show.
a.
Videos
c.
Variants
b.
Transitions
d.
Shapes
 

 36. 

An accompanying ____ gives audience members reference notes and review material for your presentation.
a.
handout
c.
file
b.
slide
d.
database
 

 37. 

When you begin creating a new PowerPoint presentation, you need to select a ____.
a.
variant
c.
document
b.
theme
d.
slide
 

 38. 

A ____ is a specific design with coordinating colors, fonts, and special effects.
a.
placeholder
c.
chart
b.
slide show
d.
document theme
 

 39. 

____ are the alternate designs that exist for each theme.
a.
Layouts
c.
Variants
b.
Ions
d.
Placeholders
 

 40. 

PowerPoint assumes every new slide, except for a blank slide, has ____.
a.
clip art
c.
large font sizes
b.
a title
d.
transitions
 

 41. 

By default, slides in a new presentation are in ____ orientation.
a.
right to left
c.
top to bottom
b.
landscape
d.
portrait
 

 42. 

Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.
a.
size
c.
format
b.
style
d.
font
 

 43. 

____ text has a slanted appearance.
a.
Colored
c.
Bolded
b.
Highlighted
d.
Italicized
 

 44. 

In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
a.
demoting
c.
promoting
b.
decreasing
d.
increasing
 

 45. 

The process of moving a slide object to a new location using the mouse pointer is called ____.
a.
drop and drag
c.
drag and drip
b.
drag and drop
d.
drip and drop
 

 46. 

A slide ____ is a special animation effect used to progress from one slide to the next slide in a slide show.
a.
animation
c.
transition
b.
layout
d.
theme
 

 47. 

The default view in Word is ____.
a.
Print Layout view
c.
Web Layout view
b.
Headline view
d.
Outline view
 

 48. 

To enter a blank line into a document, press the ____ key without typing any text on the line.
a.
CTRL
c.
ENTER
b.
ALT
d.
ESC
 

 49. 

Press the ENTER key in all of the following circumstances EXCEPT ____.
a.
to insert a blank line into a document
b.
when the insertion point reaches the right margin
c.
to begin a new paragraph
d.
in response to prompts in Word dialog boxes
 

 50. 

When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a(n) ____.
a.
black circle
c.
X
b.
green check mark
d.
red check mark
 

 51. 

____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
a.
Document
c.
Paragraph
b.
Character
d.
Object
 

 52. 

Word includes a variety of document ____ to assist you with coordinating visual elements in a document.
a.
layouts
c.
themes
b.
formats
d.
graphs
 

 53. 

The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
a.
font
c.
point
b.
font size
d.
paragraph formatting
 

 54. 

A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.
a.
headline
c.
bulleted
b.
centered
d.
indexed
 

 55. 

The file type ____ identifies a Word 365 document.
a.
.doc
c.
.dot
b.
.docx
d.
.doct
 

 56. 

____ are types of changes that occur when text has been omitted from a document and must be inserted later.
a.
Additions
c.
Modifications
b.
Deletions
d.
All of the above
 

 57. 

Headers and footers can include text and graphics, as well as the _____.
a.
current date
c.
current time
b.
page number
d.
all of the above
 

 58. 

The rule when using MLA style is to press the SPACEBAR ____ time(s) after periods, colons, and other punctuation marks.
a.
one
c.
three
b.
two
d.
either A or B
 

 59. 

Automatic page breaks are determined by ____.
a.
paper size
c.
margin settings
b.
line spacing
d.
all of the above
 

 60. 

Word shades fields ____ on the screen.
a.
blue
c.
green
b.
gray
d.
tan
 

 61. 

The Office ____ is a temporary storage area.
a.
Warehouse
c.
Storehouse
b.
Clipboard
d.
Gallery
 

 62. 

____ is the newest version of Microsoft Windows.
a.
Windows 8
c.
Microsoft Office 2016
b.
SkyDrive
d.
Microsoft Office 365
 

 63. 

A(n) ____ is a set of computer instructions.
a.
computer program
c.
operating program
b.
gesture
d.
user account
 

 64. 

A ____ is a window that can remain open and visible while you work in a document.
a.
dialog box
c.
navigation pane
b.
toolbar
d.
task pane
 

 65. 

The buttons, arrows, and boxes on the mini toolbar vary, depending on whether you are using Touch mode versus ____ mode.
a.
View
c.
Mouse
b.
Design
d.
Screen
 

 66. 

Most users reply on ____ for finding, viewing, and managing information on their computers.
a.
search boxes
c.
the resolution finder
b.
the address bar
d.
folder windows
 

 67. 

The ____ tab opens the Backstage view for each Office app.
a.
VIEW
c.
FILE
b.
BACKSTAGE
d.
MENU
 

 68. 

____ indicates the number of pixels that a computer uses to display the letters, numbers, graphics, and background on a screen.
a.
Screen view
c.
Pixel resolution
b.
Ribbon resolution
d.
Screen resolution
 

 69. 

____ is the process of organizing files in folders.
a.
File storage
c.
File movement
b.
File management
d.
File organizing
 

 70. 

When you delete a file from a ____, the deleted file is stored in the Recycle Bin.
a.
folder
c.
document
b.
hard disk
d.
USB flash drive
 

 71. 

A method used to change the size of a(n) ____ is to drag the window borders.
a.
icon
c.
window
b.
file
d.
folder
 

 72. 

A workstation is a computer connected to ____.
a.
a browser
c.
the Internet
b.
a server
d.
another workstation
 

 73. 

A(n) ____ is an internal network that uses Internet technologies.
a.
intranet
c.
portal
b.
Internet
d.
blog
 

 74. 

The ____ allows you to discard unneeded objects.
a.
Recycle Bin
c.
Recycle Box
b.
Trash Box
d.
Trash Bin
 
 

nar004-1.jpg
 

 75. 

Referring to the accompanying figure, the window shown is ____.
a.
minimized
c.
closed
b.
maximized
d.
inactive
 

 76. 

A Web ____ allows you to explore the Internet and display Web pages.
a.
explorer
c.
manager
b.
browser
d.
agent
 

 77. 

The ____ button on the title bar of a window closes the window.
a.
Start
c.
End
b.
Close
d.
Shut Down
 

 78. 

Clicking the Restore ____ button will return the window to the size it was before it was maximized.
a.
Up
c.
Window
b.
Down
d.
Now
 

 79. 

Within a Folder window, the ____ pane on the left contains the Favorites section, Libraries section, Computer section, and the Network section.
a.
Folders
c.
Navigation
b.
Explorer
d.
Computer
 

 80. 

A ____ is a set of computer instructions that carries out a task on the computer.
a.
server
c.
program
b.
folder
d.
file
 

 81. 

When you create a document using a program such as WordPad, the document is stored in the main memory (____) of the computer.
a.
RAM
c.
CPU
b.
ROM
d.
DVD
 

 82. 

A ____ is an example of a file.
a.
WordPad document
c.
saved e-mail message
b.
Excel spreadsheet
d.
all of the above
 

 83. 

After saving a document with a file name, the file name will display on the ____ bar.
a.
address
c.
title
b.
task
d.
notification
 

 84. 

Placing a shortcut to a folder on the ____ can make it easier to locate and open the folder.
a.
Start menu
c.
either a. or b.
b.
desktop
d.
neither a. nor b.
 

 85. 

There are several different ways to select multiple items. If items are next to each other, you can select the first item, then while holding down the ____ key, you can select the other items.
a.
CTRL
c.
TAB
b.
SHIFT
d.
F8
 

 86. 

Access is a ____.
a.
word processing software tool
c.
workbook management system
b.
file management system
d.
database management system
 

 87. 

A(n) ____ contains information about a given person, product, or event.
a.
attribute
c.
field
b.
record
d.
column
 

 88. 

A field whose data type is ____ can contain any characters.
a.
Alpha
c.
Normal
b.
Character
d.
Short Text
 

 89. 

To define an additional field in Datasheet view, tap or click the ____ column heading.
a.
New Field
c.
Click to Add
b.
Add Field
d.
Insert Field
 

 90. 

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.
a.
Remove Field
c.
Delete Column
b.
Delete Field
d.
Remove Column
 
 
nar005-1.jpg
 

 91. 

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.
a.
principal key
c.
main key
b.
foreign key
d.
primary key
 

 92. 

To import data to a table, tap or click the ____ tab on the ribbon.
a.
DATABASE TOOLS
c.
EXTERNAL DATA
b.
FILE
d.
IMPORT
 

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

 1. 

Worksheet titles and subtitles should be as wordy as possible.
 

 2. 

A thin red border indicates the active cell.
 

 3. 

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.
 

 4. 

When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.
 

 5. 

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
 

 6. 

The equal sign (=) precedes a formula.
 

 7. 

The most common error when entering a formula is to reference the wrong cell in the formula.
 

 8. 

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
 

 9. 

The range automatically selected by Excel is always correct.
 

 10. 

You cannot format an entire column at once.
 

 11. 

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
 

 12. 

Rotated text allows you to fit more text into a smaller column width.
 

 13. 

Technology, while useful, cannot help you more efficiently and effectively access and search for information.
 

 14. 

Digital literacy involves having a current knowledge and understanding of computers, mobile devices, the Internet, and related technologies.
 

 15. 

A computer is an electronic device that can accept data and process it according to specified rules, but that cannot produce information.
 

 16. 

USB flash drives are not convenient for mobile users.
 

 17. 

The types of services offered by cloud storage providers vary.
 

 18. 

A slide show is another name for a PowerPoint presentation.
 

 19. 

You easily can give slides in a presentation a professional and integrated appearance by using a placeholder.
 

 20. 

The default slide layouts are set up in portrait orientation.
 

 21. 

A level is a position within a structure, such as an outline, that indicates the magnitude of importance.
 

 22. 

The Font Color gallery is located in the Color Group on the DESIGN tab.
 

 23. 

A clip is a single media file, such as a photo, illustration, sound, or video.
 

 24. 

Unlike clip art, you cannot resize a photograph using sizing handles.
 

 25. 

A star next to a slide indicates that animation effects have been applied to that slide.
 

 26. 

If Word finds a potential error in a document, a red, green, or blue wavy underline flags the problem.
 

 27. 

Each time the ENTER key is pressed, Word creates a new paragraph.
 

 28. 

Wordwrap forces you to stop typing words and press the ENTER key at the end of each line.
 

 29. 

Formatting marks may not display properly on the screen with some fonts.
 

 30. 

Word inserts text to the right of the insertion point.
 

 31. 

Although a variety of different styles of documentation exist for report preparation, each style requires the same basic information.
 

 32. 

According to MLA style, on each page of the research paper, precede the page number by the title of the paper.
 

 33. 

In the MLA style, notes are used only for optional content or bibliographic notes.
 

 34. 

The MLA style uses the term bibliographical references for works cited.
 

 35. 

To place your name to the left of the page number as required by the MLA style, you must create a header that contains the page number.
 

 36. 

Word never moves or adjusts automatic page breaks; however, Word adjusts manual page breaks that follow an automatic page break.
 

 37. 

An operating system is a computer program that coordinates all the activities of computer hardware.
 

 38. 

A scroll bar contains scroll arrows and a scroll box.
 

 39. 

You cannot open multiple documents in an Office program.
 

 40. 

Organizing files in folders is part of a process known as file management.
 

 41. 

When you move a file, it still appears in the original folder.
 

 42. 

The goal of an effective user interface is to be user-friendly, which means that the software is easy to use by people once they have extensive training.
 

 43. 

When opened, the Computer folder opens in a folder window.
 

 44. 

Shortcut menus often appear when you left-click an object.
 

 45. 

When you create a file, you must assign a file name to the file.
 

 46. 

Paper printouts are not an important form of output for electronic documents.
 

 47. 

A shortcut icon is the actual document or program.
 

Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.
 

 1. 

If you accidentally undo an action, you can use the Redo button to redo it. _________________________

 

 2. 

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

 

 3. 

The Accounting number format assigns a floating dollar sign. _________________________

 

 4. 

Computers contain many electronic and mechanical components known as software. _________________________

 

 5. 

An input device is any hardware component that allows you to enter data and instructions into a computer or mobile device. _________________________

 

 6. 

You interact with a program or application through its user interface. _________________________

 

 7. 

A(n) green wavy underline indicates the text may contain a contextual spelling error such as the misuse of homophones. _________________________

 

 8. 

Line spacing is the amount of space above and below a paragraph. _________________________

 

 9. 

The conclusion, which follows the introduction, consists of several paragraphs that support the topic. _________________________

 

Multiple Response
Identify one or more choices that best complete the statement or answer the question.
 
 
Modified Multiple Choice
 

 1. 

The characters that Excel displays on the screen are a specific ____.
 a.
font
 c.
size
 b.
style
 d.
color
 

 2. 

A ____ is information that exists on a physical medium such as paper.
 a.
hard copy
 c.
validation
 b.
column
 d.
printout
 

 3. 

Which of the following are formatting symbols?
 a.
Dollar sign ($)
 c.
Pound sign (#)
 b.
Comma (,)
 d.
Percent sign (%)
 

 4. 

Technology can enable you to more efficiently and effectively ____.
 a.
access information
 c.
communicate with other people
 b.
share personal ideas
 d.
manage finances
 

 5. 

Which of the following is an input device?
 a.
keyboard
 c.
printer
 b.
touch pad
 d.
display
 

 6. 

Which of the following is a storage device?
 a.
headphones
 c.
USB flash drive
 b.
solid-state drive
 d.
memory card
 

 7. 

You can format slide text by changing the ____.
 a.
font
 c.
point size
 b.
color
 d.
style
 

 8. 

In which of the following circumstances should you press the ENTER key?
 a.
To terminate a short line of text and advance to the next line
 b.
To begin a new paragraph
 

 9. 

You can use the rulers to ____.
 a.
set tab stops
 c.
format characters
 b.
change page margins
 d.
adjust column widths
 

 10. 

An operating system coordinates the activities of ____.
 a.
memory
 c.
storage devices
 b.
printers
 d.
scroll bars
 

 11. 

A path consists of ____.
 a.
a drive letter
 c.
a colon
 b.
one or more libraries
 d.
one or more folder names
 

 12. 

The Computer folder is the place you can go to access ____ that are connected to your computer.
 a.
hard disks
 c.
optical disk drives
 b.
removable media
 d.
network locations
 



 
         Start Over