ISYS 100 Final Exam Study Guide

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

Systems Programming Midterm Review

View Set

Computer Hardware and Peripherals 2

View Set

keratinization and the epithelial system

View Set