Computer Science Final - All Multiple Choice

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

To change the width of a column like the one in the accompanying figure, hold down the ____ key while dragging markers on the ruler.

ALT

To start a new line in a cell, press the ____ keys.

ALT+ENTER

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

AVERAGE

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accounting number format

One way to add a correctly spelled word to the custom dictionary is to tap or click the ____ button in the Spelling and Grammar dialog box.

Add to Dictionary

Press the ____ key(s) to erase one character to the left of the insertion point.

BACKSPACE

When you type the wrong character, you can press the ____ key to erase all the characters back to and including the one that is incorrect.

BACKSPACE

One way to delete a note is to tap or click immediately to the left of the note reference mark in the document text and then press the ____ key twice.

DELETE

Press the ____ key(s) to erase one character to the right of the insertion point.

DELETE

Designers and graphic artists can print finished publications on a color printer, take them to a professional printer, or post them on the web in a format that can be viewed by those without what kind of software?

DTP

Which of the following kinds of software is software that enables professional designers to create sophisticated documents that contain text, graphics, and many colors?

DTP

If you tap or click the Increase Font Size button too many times and make the font size too big, you can tap or click the ____ button until the desired font size is displayed.

Decrease Font Size

Tap or click the ____ up or down arrows to adjust a delay time.

Delay

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

Dialog Box Launcher

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

What effect does the Accounting Number Format have on the selected cells?

Displays cell contents with two decimal places that align vertically

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Double-click or double-tap

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Fill Formatting Only

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

Fill Months

The ____ feature automatically locates specific text and then replaces it with desired text.

Find and Replace

As shown in the accompanying figure, tap or click the ____ arrow to display the Font gallery.

Font

____ changes picture color into black, white, and shades of gray.

Grayscale

The Increase Font Size button appears on the ____ tab.

HOME

To move to the beginning of a line with the keyboard, press the ____ key(s).

HOME

Which of the following keys moves the insertion point to the beginning of data in a cell?

HOME

Which of the following is the path to the Copy and Paste buttons?

HOME tab | Clipboard group

Which of the following is the path to the Sum arrow?

HOME tab | Editing group

Which of the following is the path to the Comma Style button?

HOME tab | Number group

Which of the following is the path to the Conditional Formatting button?

HOME tab | Styles group

____ are the alternate designs that exist for each theme.

Variants

Which of the following terms is used to describe a program that hides in a computer and allows someone from a remote location to take full control of the computer?

a rootkit

What is product activation?

a technique to ensure software is not installed on more computers than legally licensed

PowerPoint assumes every new slide, except for a blank slide, has ____.

a title

Which of the following terms is used to describe a program that copies itself repeatedly, using up resources and possibly shutting down the computer or network?

a worm

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

Which of the following keys toggles between Insert mode and Overtype mode?

INSERT

. When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

Identification of how to format various elements of the worksheet

To search for formatting or a special character, click the _____ button to expand the Find dialog box.

More

. ____ adds designs that repeat in rows across a slide.

Pattern fill

To instruct PowerPoint to confirm each change, click the Find Next button in the ____ dialog box.

Replace

____ text often provides a strong visual appeal.

Rotated

To move from the second cell in the table in the accompanying figure back to the previous cell, press the ____ key(s).

SHIFT+TAB

The ____ command moves the selected object underneath all objects on the slide.

Send to Back

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.

Shapes

To see the height and width of the currently selected graphic, look in the ____ group on the Picture Tools Format tab.

Size

Reading view is similar to ____ view because each slide displays individually, but the slides do not fill the entire screen.

Slide Show

____ view allows you to look at several slides at one time.

Slide Sorter

To search for a special character, use the ____ button in the expanded Find dialog box.

Special

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Standard

To advance rightward from one cell to the next in a table, press the ____ key.

TAB

To move from the first cell in the table in the accompanying figure to the next cell, press the ____ key(s).

TAB

____ is/are used to place worksheet, column, and row titles on a worksheet.

Text

Tap or click the Texture button to display the ____ gallery, as shown in the accompanying figure.

Texture

When you use the keyboard to scroll to a different position in the document, the ____ automatically moves when you press the desired keys.

insertion point

What is the real-time exchange of messages, files, audio, and/or video with another online user called?

instant messaging

In the accompanying figure, the split double arrow mouse pointer ____.

is the result of moving the mouse pointer to the boundary between column heading A and column heading B

By default, slides in a new presentation are in ____ orientation.

landscape

Using the____, you can choose the arrangement of placeholders on a new slide.

layout gallery

PowerPoint's varied themes and ____ help give presentations a unified and aesthetically pleasing look.

layouts

A ____ paragraph places the first character of a text line near the left border of a placeholder.

left-aligned

By default, text is ____ in a cell.

left-aligned

What kind of software assists in the preparation of a will, for example?

legal

What type of software can your parents use to create a will without visiting an attorney?

legal software

Which category of applications allows you to locate a nearby restaurant or check the weather forecast?

lifestyle

All of the following are guidelines about the appearance of letterhead elements EXCEPT ____.

make the font size of your name the same size as the rest of the text in the letterhead

Which of the following kinds of players is a program that allows you to view images and animation, listen to audio, and watch video files on your computer?

media

Combining two or more selected cells into one cell is called ____ cells.

merging

All of the following are vertical alignment options EXCEPT ____.

middle

The Italic button is located on the ____.

mini toolbar

What kind of software allows users to combine text, graphics, audio, video, and animation into an interactive application?

multimedia authoring

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

nested

Which of the following kinds of software enables users to enter typed text, handwritten comments, drawings, or sketches anywhere on a page and then save the page as part of a notebook?

note taking

An advertisement on a web site touts that the software for sale enables users to enter typed text, handwritten comments, drawings, or sketches anywhere on a page and then save the page. What kind of software is this ad selling?

note taking software

A background feature called ____ allows you to move the background from the slide borders in varying distances by a percentage.

offsets

To increase the font size of selected text, chose the Increase Font Size button, located ____.

on the mini toolbar

The rule when using MLA style is to press the SPACEBAR ____ time(s) after periods, colons, and other punctuation marks.

one

PowerPoint increased the weight of a line in ____ increments.

one-fourth

You are working for a book publisher and devising the height of the pages that will be required to print a given book. The text for the book is about 10 points. What will be the approximate height of each character in the book?

one-sixth of an inch

Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.

one-third

The Trim Video feature allows you to trim your clip by time measurements that are accurate to ____ of a second.

one-thousandth

Which type of software has no restrictions from the copyright holder regarding modifications of the software's internal instructions and its redistribution?

open source software

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 difference between the effects and the styles is that each effect has several ____, providing you with more control over the exact look of the image.

options

The WordArt ____ is the exterior border surrounding each letter or symbol.

outline

Which kind of software allows users to draw pictures, shapes, and other graphical images with various on-screen tools such as a pen, brush, and eyedropper?

paint

The range of cells receiving copied content is called the ____ area.

paste

Which of the following is a utility that detects and protects a computer from unauthorized intrusions?

personal firewall

Business documents can include all of the following EXCEPT ____.

personal letters

Which of the following is a scam in which a perpetrator sends an official looking e-mail that attempts to obtain a user's personal and financial information?

phishing

You have received an email that is directing you to a phony website that looks like the website for your mortgage company. What kind of message is this?

phishing

When you purchase a digital camera, what type of software often is included with the purchase?

photo editing software

Formatting text in a shape follows the same techniques as formatting text in a ____.

placeholder

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.

placeholder

Which the following is a filtering program that stops pop-up ads from displaying on web pages?

pop-up blocker

PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.

predefined

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.

presentation

Which of the following kinds of software allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group?

presentation

When you install Word, it selects a series of ____ that it searches through when you use the Research task pane.

services

Adding a ____ to text adds depth and helps the letters display prominently.

shadow

Which of the following increases or decreases how crisp the objects in a photo appear?

sharpness

In a business letter, type the ____ at least four blank lines below the complimentary close, allowing room for the author to sign his or her name.

signature block

The small squares and circles around a selected graphic are called ____ handles.

sizing

PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.

slides

Which of the following is a collection of individual programs sold as a unit?

software suite

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

sparkline

A program has been placed on your smartphone without your knowledge and it is collecting personal information about you. What kind of application is this?

spyware

In reference to search utilities, what does an index do?

stores information about a file, including its name, date created, and author name

A ____ is a named group of formatting characteristics.

style

Your new calendar application allows you to make sure that your mobile device and your corporation's server both have the latest version of any updated information. What is the term for this capability?

synchronization

A thesaurus can be used to look up a(n) _____, or a word similar in meaning to a given word.

synonym

A word with a meaning similar to that of another word is called a ____.

synonym

Define the term, payload, as it pertains to computer crime.

the destructive event or prank the virus is intended to deliver

When a word processing program user formats a document, what does the user change?

the document's appearance

When a document contains text displayed in 10-point Cambria, to what does the 10-point refer?

the font size

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

theme

The presentation ____ determines the formatting characteristics of fonts and colors.

theme

When you begin creating a new PowerPoint presentation, you need to select a ____.

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

A(n) ____ is a book of synonyms.

thesaurus

You can use ____ options to repeat a background image many times vertically and horizontally on a slide.

tiling

What kind of software helps users of all skill levels create web pages that include graphics, video, audio, animation, and other special effects?

website authoring

Press the ENTER key in all of the following circumstances EXCEPT ____.

when the insertion point reaches the right margin

Which of the following kinds of software allows users to create and manipulate documents containing mostly text and sometimes graphics?

word processing

If someone you know is purchasing word processing software, what features can she expect to find in the software?

wordwrap, spell checker, clip art

According to the MLA style, the _____ is a list of sources that are referenced directly in a research paper.

works cited page

An Excel ____ allows data to be summarized and charted easily.

worksheet

When using spreadsheet software like the kind in the accompanying figure, what are the rows and columns collectively called?

worksheet

To move to the end of the document, press the ____ key(s).

CTRL+END

You can move the insertion point into the next text placeholder by pressing the ____ keyboard shortcut keys.

CTRL+ENTER

Pressing the ____ keyboard shortcut key(s) selects cell A1.

CTRL+HOME

You can insert a new slide by pressing the ____ keyboard shortcut keys.

CTRL+M

To insert a tab character in a cell, you must press ____.

CTRL+TAB

To paste copied cell contents, you can press the ____ keys.

CTRL+V

____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.

Character

____ help one slide flow gracefully into the next during a slide show.

Transitions

____ allows you to see through the background, so that any text on the slide is visible.

Transparency

You can change the transparency of a picture used as a slide's background with the ____.

Transparency slider

PowerPoint's ____ feature allows you to set the timing for a video clip.

Trim Video

You can set play options for a video clip with buttons in the Video Options group on the ____ tab.

VIDEO TOOLS PLAYBACK

A ____ is text and graphics that print at the bottom of every page.

footer

A note reference mark signals that an explanatory note exists at the bottom of the page as a(n) ____, as shown in the accompanying figure.

footnote

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

Which of the following performs calculations on the data in a worksheet like the one in the accompanying figure and displays the resulting value in a cell?

formula

A ____ is a prewritten formula that is built into Excel.

function

One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.

graphical elements

Files containing ____ are available from a variety of sources.

graphics

Sending electronic documents is a way to contribute to ____ computing.

green

An accompanying ____ gives audience members reference notes and review material for your presentation.

handout

Printing ____ is useful for reviewing a presentation.

handouts

A ____ is text and graphics that print at the top of each page.

header

The Notes pane is ____ until you tap or click the Notes button on the status bar to open the pane.

hidden

Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.

horizontal ruler

What kind of software provides the capabilities of adjusting or enhancing image colors, adding special effects such as shadows and glows, and the like?

image editing

Which of the following kinds of software provides the capabilities of paint software and also includes the ability to enhance and modify existing images and pictures?

image editing

Which of the following is a utility that allows users to display, copy, and print the contents of a graphics file?

image viewer

In a spreadsheet program, how is data organized?

in rows and columns collectively called a worksheet

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

indirect

The ____ is a blinking vertical line that indicates where the next typed character will appear.

insertion point

Which of the following keys can you press to run a slide show starting with slide 1?

F5

The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them.

AutoCorrect

You can click the ____ button to undo an automatic correction.

AutoCorrect Options

You can select a document by using the ____ key.

CTRL+A

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

CTRL+B

When you decrease the row height to ____, the row is hidden

0

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

0

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

AutoCorrect

Error messages begin with the ____ symbol.

#

____ refers to cells not wide enough to display the entire entry.

#####

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

#REF!

Which of the following is the path to the Goal Seek button?

(DATA tab | Data Tools group)

Which of the following is the path to the Shape Fill button?

(DRAWING TOOLS FORMAT tab | Shape Styles group)

To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the ____.

(DRAWING TOOLS FORMAT tab | Size group)

Which of the following is the path to the Increase or Decrease Indent button?

(HOME tab | Alignment group)

Which of the following is the path to the Insert Cells arrow?

(HOME tab | Cells group)

The path to the Format Painter button is ____.

(HOME tab | Clipboard group)

What is the correct path to the Bold button?

(HOME tab | Font group)

The path to the text alignment buttons is ____.

(HOME tab | Paragraph group)

Which of the following is the Ribbon path to the Cell Styles button?

(HOME tab | Styles group)

Which of the following is the path to the Insert Video button?

(INSERT tab | Media group)

Which of the following is the path to the Send Backward button?

(PICTURE TOOLS FORMAT tab | Arrange group)

The Picture Effects button is located on the ____, as shown in the accompanying figure.

(PICTURE TOOLS FORMAT tab | Picture Styles group)

The Picture Styles gallery, shown in the accompanying figure, is displayed by clicking the More button located on the ____.

(PICTURE TOOLS FORMAT tab | Picture Styles group)

Which of the following is the path to the Zoom button?

(VIEW tab | Zoom group)

Word, by default, places a tab stop at every ____ mark on the ruler.

.5"

A point is ____ of an inch in height.

1/72

Every theme has ____ standard colors.

10

Excel remembers the last ____ actions you have completed.

100

On most computers, the default font size in Word is ____.

11

When you install PowerPoint, the default setting allows you to reverse up to the last ____ changes by tapping or clicking the Undo button on the Quick Access Toolbar.

20

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

20xx

Which of the following patterns extends the fill series to 575, 550, 525?

625, 600

Which comparison operator means "not equal to"?

<>

Which of the following formulas contains an absolute cell reference?

=$B$4

Which of the following calculations multiplies 23 by 0.01?

=23%

All of the following are valid Excel arithmetic operators EXCEPT ____.

>

Why is a fragmented disk slower than one that is defragmented?

A fragmented disk has many files stored in noncontiguous sectors.

To copy cell contents, you can select the cell and then press the ____ keys.

CTRL+C

____ are types of changes that occur when text has been omitted from a document and must be inserted later.

Additions

To display the Color gallery, with the graphic selected, tap or click the Color button in the ____ group on the PICTURE TOOLS FORMAT tab.

Adjust

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

Alignment

When data in a spreadsheet program is changed, what occurs?

All calculations can be recalculated.

____ includes special visual and sound effects applied to text or other content.

Animation

____ allow you to control how objects enter, move on, and exit slides.

Animation effects

To display the Rotate gallery, with the graphic selected, tap or click the Rotate Objects button in the ____ group on the Picture Tools Format tab.

Arrange

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

Which of the following Option buttons gives options for filling cells following a fill operation?

Auto Fill Options

If you use the ____ template, as opposed to a formatted theme, you must make all design decisions.

Blank Presentation

____ determines the overall lightness or darkness of an entire image.

Brightness

Click ____ to move a stacked object toward the top of the stack.

Bring Forward

Click ____ to move a stacked object to the top of the stack.

Bring to Front

Which of the following kinds of software is a sophisticated type of application software that assists a professional user in creating engineering, architectural, and scientific designs?

CAD

Which of the following programs allow designers to rotate designs of 3-D objects to view them from any angle?

CAD

If you want to select the first and third rows in the table in the accompanying figure, you select the first row, and then hold down the ____ key while selecting the third row.

CTRL

To select multiple cells, rows, or columns in the table in the accompanying figure if they are not adjacent to one another, select the first cell and then hold down the ____ key while selecting the next cell, row, or column.

CTRL

To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items.

CTRL

You can open the Format Cells dialog box by pressing the ____ keys.

CTRL+1

Press ____ to select the entire worksheet.

CTRL+A

____ is a predefined graphic.

Clip art

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 should use a ____ chart to compare values side by side, broken down by category.

Clustered Column

The ____ gallery has a wide variety of preset formatting combinations for coloring pictures.

Color

____ is the difference between the darkest and lightest areas of an image.

Contrast

____ is a font that resembles the letters that typewriters produced.

Courier New

To print a mailing label, tap or click the Labels button on the MAILINGS tab in the ____ group.

Create

The ____ tab automatically appears when a shape is selected in a document.

Drawing Tools Format

Which of the following keys moves the insertion point to the end of data in a cell?

END

Each time you press the ____ key, Word carries forward custom tab stops to the next paragraph.

ENTER

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

ENTER

Pressing the ____ key when entering title text in a placeholder creates a new paragraph.

ENTER

To enter a blank line into a document, press the ____ key without typing any text on the line.

ENTER

When you press the ____ key without entering any text after the automatic bullet character, Word turns off the automatic bullets feature.

ENTER

`Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.

ENTER

The ____ as shown in the accompanying figure is a formatting mark that indicates where the ____ was pressed

ENTER key

If you want to remove the AutoCorrect Options button from the screen, you can press the ____ key.

ESC

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

____ effects modify text and objects displayed on the screen.

Emphasis

Clicking the ____ box completes an entry.

Enter

____ effects determine how slide elements first appear on a slide.

Entrance

If the top of a set of characters is chopped off, the problem may be that the line spacing is set to ____.

Exactly

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

To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.

Format Painter

As an alternative to using the Color button on the PICTURE TOOLS FORMAT tab to display the Color gallery, you can right-click the graphic, click ____ on the shortcut menu, click the Picture button, expand the PICTURE COLOR section, and select the desired options.

Format Picture

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Goal

____ is one color shade gradually progressing to another shade of the same color or to another color.

Gradient fill

____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.

Graphics

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 ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

When you use a mouse to select a row or column in a table, Word displays a(n) ____.

Insert Control

Clicking the ____ opens the Insert Function dialog box.

Insert Function box in the formula bar

The ____ dialog box allows you to search for and insert files from a range of online sources.

Insert Media

The ____ dialog box allows you to search for clip art by using descriptive keywords.

Insert Pictures

Which of the following is an example of a photo sharing app?

Instagram

____ text has a slanted appearance.

Italicized

To center a page's contents vertically between the top and bottom margins, tap or click the Page Setup Dialog Box Launcher, tap or click the ____ tab, tap or click the vertical alignment box arrow, tap or click Center in the list, and then tap or click the OK button.

Layout

When you tap or click the ____ button for a selected graphic, Word provides options for changing how a graphic is positioned with text in a document.

Layout Options

Windows, Mac OS, and which other operating system constitute three desktop operating systems?

Linux

The ____ function displays the highest value in a range.

MAX

The ____ function determines the lowest number in a range.

MIN

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

You can type comments to yourself in the ____ for a specific slide while working in Normal view.

Navigation pane

As shown in the accompanying figure, the ____ arrow displays the Facet layout gallery.

New Slide

To delete WordArt text outline, click ____ in the Text Outline gallery.

No Outline

Having used the Color gallery to change the color of a graphic, with the graphic selected, tap or click ____ in the Color gallery to change a graphic back to its original color.

No Recolor

The default PowerPoint view is ____ view.

Normal

The default view in Excel is called ____ view.

Normal

You can type and format notes in the ____ pane.

Notes

The Bullets button is available on the HOME tab of the Ribbon in the ____ group.

Paragraph

Which of the following actions are provided by the Paste Options button?

Pastes synonyms or acronyms

____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point.

Pasting

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

Orientation

You are experiencing some problems with your operating system on your desktop and want to repair some problems with your hard disk. Which of the following will you use?

PC maintenance tool

What kind of file does Adobe Reader allow you to view?

PDF

____ view allows you to create or modify a worksheet while viewing how it will look in printed format

Page Layout

In Word, you can create electronic image files through the ____ tab in the Backstage view.

Print

The default view in Word is ____.

Print Layout view

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery

Print Selection

What is the term for a square-shaped coded graphic that corresponds to a web address or other information?

QR code

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Qtr2

If you accidentally replace the wrong text, just click the Undo button on the ____.

Quick Access Toolbar

If you do not want to keep a change automatically made by Word and you immediately notice the automatic correction, you can undo the change by clicking the Undo button on the ____.

Quick Access Toolbar

The Undo button is located on the ____.

Quick Access Toolbar

To save a presentation, tap or click the Save button on the ____.

Quick Access Toolbar

Which of the following is the path to the Spelling button?

REVIEW tab | Proofing group

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

RIGHT ARROW

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Range Finder

____ effects convert colors in a picture to a wide variety of hues.

Recolor

To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu.

Remove Hyperlink

You can select slide objects in order to delete them simultaneously by pressing the ____ key as you click each object.

SHIFT

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Thursday, Saturday, Monday

When you open a new presentation, a slide with the default ____ layout appears.

Title Slide

When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.

Title and Content

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Trace Error

If you follow the advice of your instructor and use CBT to learn about programming languages, how would you learn?

Typically you would employ self-paced instruction to use and complete exercises presented on your computer.

The ____ button allows you to erase recent cell entries.

Undo

____ allows you to type new text or convert existing text to WordArt.

WordArt styles

When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a(n) ____.

X

You are an expert in devising product activation schemes for software publishers. Which of the following is not one of the techniques you have used in the past?

You create the application to be available for download only.

After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.

Zoom

____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.

Zooming

Which of the following kinds of programs displays an online advertisement in a banner or pop-up window on webpages, email, or other Internet service?

adware

Which of the following is a method of entering functions?

all of the above ( keyboard, touch gesture, or pointer, the Sum menu, the Insert Function box in the formula bar d. the Name box area in the formula bar)

In Excel, a number can contain the characters ____.

all of the above (0 1 2 3 4 5 6 7 8 9; + - ( ) , /; . $ % E e)

. Which of the following are valid formulas?

all of the above (=3 ^ 4, =H3/H11, =11+9 d. =22-F15)

Headers and footers can include text and graphics, as well as the _____.

all of the above (current date, page number, current time)

Essential business letter elements include the ____.

all of the above (date line and inside address, message, signature block)

An effective business document should ____.

all of the above (have a professional appearance, convey its message concisely, convey its message clearly)

The Word Count dialog box displays the number of words as well as the number of _____ in the current document.

all of the above (lines, characters, paragraphs)

Which of the following is a bibliographic source?

all of the above (map, memo, letter)

Automatic page breaks are determined by ____.

all of the above (paper size, line spacing, margin settings)

An alternative to e-mail filtering is to purchase which of the following kinds of program that attempts to remove a message before it reaches a user's inbox?

anti-spam

As shown in the accompanying figure, which of the following kinds of program protects a computer against viruses by identifying and removing any computer viruses found in memory, on storage media, or on incoming files?

antivirus

What kind of software consists of programs designed to make users more productive and/or assist them with personal tasks?

application

Which of the following is a standard document property?

author

The date you change a file is an example of a(n) ____ property.

automatically updated

The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.

font

Which of the following (with examples such as Cambria and Calibri shown in the accompanying figure) is a name assigned to a specific design of characters?

font

When using the MLA style, position in-text parenthetical references either at the _____, as shown in the accompanying figure.

bottom of the page as footnotes or at the end of the paper as endnotes

Sepia changes picture colors into ____.

brown, gold, and yellow

A ____ symbol is another name for a dot symbol.

bullet

A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.

bulleted

Monitor dimensions and resolution affect how ____ display on the ribbon.

buttons

In the accompanying figure, 12 point and 28 point are measurements of which of the following?

font size

Color ____ indicates that one color is dominating a picture.

cast

To enter data in a cell, you must first select the ____.

cell

To select a ____ in the table in the accompanying figure, point to its left edge and click when the mouse pointer changes to a small solid upward angled pointing arrow.

cell

Charts can either be embedded in a worksheet or placed in a separate ____.

chart sheet

A tag name is an identifier that links a(n) ____ to a source.

citation

A ____ may be composed of a few individual objects or several complex groups of objects.

clip

Which of the following is a collection of electronic drawings, photos, and other images that can be inserted into documents?

clip art

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

colon (:)

Which of the following types of software do engineers, architects and scientists use to create designs?

computer-aided design software (CAD)

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

A photo's color intensity can be modified by changing the brightness and ____.

contrast

As you edit some photos from your summer vacation, you choose to make a beach photo much smaller in terms of its file size in order to be able to email it to your friends. Which tool will you use for this?

contrast

Which of the following adjusts the difference in appearance between light and dark areas of a photo?

contrast

You have a variety of helpful apps on your smartphone, including ones that allow you to remotely start your car or calculate a restaurant tip. In which of the following categories do these apps fall?

convenience

Clicking the Yes button in the dialog box in the accompanying picture ____.

converts the picture to a drawing object

You compose a new song and you now have exclusive rights to sell your song. Of which of the following is this an example?

copyright

As you edit some photos from your summer vacation, you decide to remove a blurry area of one of your photos. Which tool will you use for this?

crop

To manage day-to-day interactions with customers, including phone calls and e-mails, what type of software would a company use?

customer service software

A single point as shown in the accompanying figure is about what fraction of an inch in height?

d. 1/72

Which of the following (with examples such as the bold, italic, and underline shown in the accompanying figure) adds emphasis to a font?

font style

In a clustered column chart, the names of each column are part of the ____ series.

data

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

database

You have heard that it is possible to improve your computer's performance by storing all related files for a particular program together. What is the term for this?

defragmenting

In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.

demoting

The range of cells receiving the content of copied cells is called the ____.

destination area

You recently lost some files that were important to you so you have resolved to back up the contents of your hard disk on a series of rewritable DVDs. What kind of software will you use to do this?

disc burning

Which of the following tools searches for and removes unnecessary files?

disk cleanup

You need to purchase a new application on behalf of your company, one that will track product inventory and manage shipping status. Which kind of software will you buy?

distribution software

Which of the following kinds of software provides a means for sharing, distributing, and searching through documents by converting them into a format that can be viewed by any user?

document management

A ____ is a specific design with coordinating colors, fonts, and special effects.

document theme

The accompanying figure illustrates the screen you use to choose a ____.

document theme

The file type ____ identifies a Word 2013 document.

docx

You should ____ a function name in the Formula AutoComplete list to select the function.

double-click or double-tap

If you want to conserve ink or toner, you can instruct PowerPoint to print ____ documents.

draft quality

The process of moving a slide object to a new location using the mouse pointer is called ____.

drag and drop

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

Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.

font

What kind of application teaches a particular skill?

educational

Instead of printing and distributing a hard copy of a document, you can distribute the document ____.

electronically

Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to a(n) ____.

em dash

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

equal sign (=)

A(n) ____ is a placeholder for data whose contents can change.

field

Which of the following kinds of file utilities shrink the size of a file(s)?

file compression

You are using a tool on your computer to organize a variety of files in folders. What is the term for this kind of tool?

file manager

If your friend recently has participated in e-filing, what has she been doing?

filing her state and/or federal tax returns online

Solid ____ is one color used throughout the entire slide.

fill

WordArt ____ in the interior of a letter can consist of a solid color, texture, picture, or gradient.

fill

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

fill handle

You have created a specific named location on your hard disk to hold some songs you have purchased. What is the term for this location?

folder

Your friend has been assigned the task of creating visual aids to communicate ideas, messages, and other information to a sales group. What type of software should she use to complete this task?

presentation software

Which of the following are you, as a marketing manager, most likely to use to schedule the processes required in a new advertising campaign you are running?

project management

An engineer who needs to manage new product development might use what type of software?

project management software

Document ____ are the details about a file.

properties

Which kind of software can be distributed by anyone to others at no cost?

public-domain

Which of the following are valid steps toward virus protection?

purchase a reputable antivirus program, update antivirus definitions regularly

Which of the following is a request for specific data from a database?

query

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.

range

A ____ reference is an adjusted cell reference in a copied and pasted formula.

relative

The adjusted cell references in a copied and pasted formula are called ____ cell references

relative

During the infection stage, what three actions does a computer virus typically perform?

replicate itself, conceal itself, activate when a condition or event occurs

As you edit some photos from your summer vacation, you decide to shrink one of your favorite photos to produce a wallet size. Which tool will you use for this?

resize

In the event a backup file is used, which kind of program reverses the process and returns backed up files to their original form?

restore

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

A ____ paragraph places the last character of text near the right border of a paragraph.

right-aligned

When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.

rotate

In a business letter, the ____, if present, begins two lines below the last line of the inside address.

salutation

Color ____ changes the intensity of colors.

saturation

Which kind of program attempts to locate a file on your computer or mobile device based on criteria you specify?

search tool

What does a disk cleanup utility do?

searches for and removes unnecessary files

Point mode allows you to ____, as shown in the accompanying figure.

select cells for use in a formula using the mouse pointer

Dragging or sizing affects only a ____.

selected object

When a placeholder is selected, the ____ are displayed.

selection handles

Which of the following features is offered by WBT?

self-directed, self-paced instruction

Which of the following is not a valid format symbol?

semi-colon (;)

You have a new word processing program. Which of the following is least likely to be a feature in the program's spelling checker?

the capability to check the arithmetic in a table of calculations

A letterhead should contain all of the following EXCEPT ____.

the company's objective

Antivirus programs look for a specific pattern of virus code. What is this pattern called?

virus signature

On the works cited page, list works by each author's last name, as shown in the accompanying figure, or, if the author's name is not available, by the _____.

title of the source

The ____ introduces the presentation to the audience.

title slide

Which of the following are uses for application software?

to make users more productive

What was the original purpose of a screen saver?

to prevent images from being permanently etched on a monitor's screen

Which of the following kinds of malware is a malicious mobile app that uses a variety of fraudulent schemes to charge unsuspecting users for premium messaging services?

toll fraud

A slide ____ is a special animation effect used to progress from one slide to the next slide in a slide show.

transition

You can make one color in a graphic ____, that is, removing its color.

transparent

You would make a color in a graphic ____ if you wanted to remove part of a graphic or see text or colors behind a graphic.

transparent

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

two

There are ____ standard colors for text in a theme.

two

When working with a large worksheet, you can split the window into ____ panes.

two or four

The first step in creating an effective worksheet is to make sure you ____.

understand what is required

When you ____ a clip art picture, PowerPoint breaks it into its component objects, as shown in the accompanying figure.

ungroup

Which of the following is a utility that removes a program, as well as any associated entries in the system files?

uninstaller

Who can effectively use web page authoring software?

users of all skill levels

Many worksheet cells like those in the accompanying figure contain a number that can be used in a calculation. What is the name for this?

value

Which of the following kinds of software allows users to modify a segment of a video, called a clip?

video editing

Which of the following describes a potentially damaging computer program that affects, or infects, a computer negatively by altering the way the computer works without the user's knowledge or permission?

virus

Which of the following warns that the computer is infected and needs immediate attention?

virus hoax


Kaugnay na mga set ng pag-aaral

Table 48-7 (Drug therapy diabetes)

View Set

Software Design and Programming Basics

View Set

Lesson 11 - PS 3a: Central Tendency (Engl. Terminology)

View Set

Chapter 9: Adjusting Localization Options

View Set