ISYS 100 Final Exam Study Guide
Which of the following calculations multiplies 23 by 0.01?
23%
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Using the mouse to move or copy cells is called ____.
Drag and Drop
With ____ editing, Word automatically displays a Paste Options button near the pasted or moved text.
Drag and Drop
A(n) ____ is a placeholder for data whose contents can change.
Field
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Format
One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.
Graphical Elements
____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.
Graphics
____ changes picture color into black, white, and shades of gray.
Grayscale
An accompanying ____ gives audience members reference notes and review material for your presentation.
Handout
Business documents can include all of the following EXCEPT ____.
Personal Letters
Microsoft Outlook uses a special file format called a ____ to save your email files, calendar entries, and contacts.
Personal Storage Table
The file type ____ identifies a Word 2016 document.
docx
To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.
Design View
A ____ is a specific design with coordinating colors, fonts, and special effects.
Document Theme
PowerPoint displays many ____ that are varied and appealing and give you an excellent start at designing a presentation.
Themes
Word includes a variety of document ____ to assist you with coordinating visual elements in a document.
Themes
____ determines the overall lightness or darkness of an entire image.
Brightness
A ____ paragraph places the first character of a text line near the left border of a placeholder.
Left Aligned
An Excel ____ allows data to be summarized and charted easily.
Worksheet
When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a(n) ____.
X
____ help one slide flow gracefully into the next during a slide show.
Transition
Headers print in the top margin ____ inch from the top of every page.
One - Half
Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.
One- Third
To move to the beginning of a line with the keyboard, press the ____ key(s).
Home
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.
Horizontal Ruler
PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.
Slides
When a placeholder is selected, the ____ are displayed.
Section Handles
Which of the following is not a valid format symbol?
Semicolon
To enter data in a cell, you must first select the ____.
Cell
An email ____ is an app that allows you to compose, send, receive, store, and delete email messages.
Client
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
The Office ____ is a temporary storage area.
Clipboard
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
Colon (:)
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
Constant
PowerPoint assumes every new slide, except for a blank slide, has ____.
A Title
____ in a suite typically use a similar interface and share features.
Apps
Which of the following is a valid folder name?
CIS 101
To create a new folder, press ____.
Ctrl+Shift+N
A ____ is a prewritten formula that is built into Excel.
Function
Files containing ____ are available from a variety of sources.
Graphics
A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
Presentation
In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
Relational
A ____ reference is an adjusted cell reference in a copied and pasted formula.
Relative
The ____ introduces the presentation to the audience.
Title Slide
When you open a new presentation, a slide with the default ____ layout appears.
Title Slide
Windows enables each user to establish a ____, which identifies to Windows the resources, such as apps and storage locations, a user can access when working with the computer.
User Account
The ____ is the part of an email address that identifies a specific user.
User Name
Access is a ____.
database management system
By default, slides in a new presentation are in ____ orientation.
Landscape
By default, the Normal style places ____ points of blank space after each paragraph.
8
Which of the following formulas contains an absolute cell reference?
=$b$4
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
One way to add a correctly spelled word to the custom dictionary is to click the ____ button in the Spelling and Grammar dialog box.
Add to dictionary
When you have an email account, you also have an email ____.
Address
To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.
Advanced
Cell references in a formula are called ____.
Assumptions
A ____ symbol is another name for a dot symbol.
Bullet
Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to a(n) ____.
Em Dash
Clicking the ____ box completes an entry.
Enter
To enter a blank line into a document, press the ____ key without typing any text on the line.
Enter
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
____ effects determine how slide elements disappear.
Exit
If a flagged word is spelled correctly, right-click it and then click ____ on the shortcut menu to instruct Word not to flag future occurrences of the same word in this document.
Ignore All
Word provides a(n) ____ button, which increases the font size of selected text each time you tap or click the button.
Increase Font Size
The ____ function displays the highest value in a range.
Max
One method of displaying the entire contents of a window is to ____ it.
Maximize
The information in the ____ routes a message to its recipients and identifies the subject of the message.
Message Header
The ____ function determines the lowest number in a range.
Min
To create a split form, select the table in the Navigation Pane, click CREATE on the ribbon, click the ____ button on the CREATE tab to display a menu, and then click Split Form on the menu.
More Forms
Email is the transmission of messages and files between computers or smart devices over a(n) ____.
Network
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
Now
To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
Open
A(n) ____ is a computer program that coordinates all the activities of computer hardware.
Operating System
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
Operations
The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.
Placeholder
The default view in Word is ____.
Print Layout
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Qtr2
To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.
Query Design
To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu.
Remove Hyperlink
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
Reserved
When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.
Rotate
Color ____ changes the intensity of colors.
Saturation
A message's ____ advises the recipient on how to treat the contents of the message.
Sensitivity Level
Modified Multiple Choice You can use the rulers to ____.
Set tab stops, change page margins, adjust column widths
A field whose data type is ____ can contain any characters.
Short Text
The ____ command exits running apps, shuts down Windows, and then turns off the computer.
Shut Down
The ____ screen enables you to sign in to your user account and makes the computer available for use.
Sign-In
The ____ command saves your work, turns off the computer fans and hard disk, and then places the computer in a lower-power state.
Sleep
A ____ is a named group of formatting characteristics.
Style
The presentation ____ determines the formatting characteristics of fonts and colors.
Theme
A(n) ____ is a book of synonyms.
Thesaurus
Which of the following is an extension of the fill pattern Sunday, Tuesday?
Thursday, Saturday, Monday
When a filter is in effect, you can redisplay all records by clicking the ____ button on the HOME tab.
Toggle Filter
You can make one color in a graphic ____, that is, removing its color.
Transparent
PowerPoint's ____ feature allows you to set the timing for a video clip.
Trim Video
Press the ENTER key in all of the following circumstances EXCEPT ____.
When it insertion point reaches the right margins
All of the following are guidelines about the appearance of letterhead elements EXCEPT ____.
make your name the same size text as the letterhead text
A letterhead should contain all of the following EXCEPT ____.
the company's objective