Study Guide

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

D . Rename Field

MC: To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name. A . Change Column B . Rename Column C . Change Field D . Rename Field

C . programs

MC: Office 365 is a collection of ____ and services. A . clouds B . databases C . programs D . accounts

A . Click-to-Run

MC: Office 365 uses a quick-start installation technology, called ____, that downloads and installs the basics within minutes. A . Click-to-Run B . Office on Demand C . Click-to-Install D . Install on Demand

A . title of the source

MC: On the works cited page, list works by each author's last name or, if the author's name is not available, by the _____. A . title of the source B . publisher C . date of the source D . MLA citation number

A . RIGHT ARROW

MC: Pressing the ____ key to complete an entry activates the adjacent cell to the right. A . RIGHT ARROW B . LEFT ARROW C . UP ARROW D . DOWN ARROW

D . brown, gold, and yellow

MC: Sepia changes picture colors into ____. A . black, white, and gray B . red, blue, and green C . orange, yellow, and blue D . brown, gold, and yellow

D . all of the above

MC: The Word Count dialog box displays the number of words as well as the number of _____ in the current document. A . lines B . characters C . paragraphs D . all of the above

D . Auto Fill Options

MC: The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. A . Copy Options B . Replace Options C . Formatting Options D . Auto Fill Options

B . AutoCorrect

MC: The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. A . AutoComplete B . AutoCorrect C . AutoFormat D . AutoTyping

A . Color

MC: The ____ gallery has a wide variety of preset formatting combinations for coloring pictures. A . Color B . Design C . Style D . Format

C . insertion point

MC: The ____ is a blinking vertical line that indicates where the next typed character will appear. A . scroll box B . sheet tab C . insertion point D . split bar

C . fill handle

MC: The ____ is the small black square located in the lower-right corner of the heavy border around the active cell. A . selection handle B . sizing handle C . fill handle D . copy handle

True

Mod. T/F: Examples of how you can modify or format text include changing its shape, size, color, and position on the slide. _________________________

False, no spacing

Mod. T/F: The Normal style defines line spacing as single and does not insert any additional blank space between lines when you press the ENTER key.

False, totals

Mod. T/F: To display the Total row in a datasheet, tap or click the Sum button on the ribbon. ____________________

False, asterisk *

Mod. T/F: To include all fields in the design grid, double-click the question mark (?) in the field list. ____________________

False, Search

Mod. T/F: To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

False, Superscript

Mod. T/F: Typing an ordinal followed by a space or a hyphen makes part of the ordinal into a(n) subscript . _________________________

tab

SA: Each _________________________ contains a collection of groups.

End of cell mark

SA: Each cell in a Word table has a(n) ____________________, which is a formatting mark that assists with selecting and formatting cells.

#reference!

SA: Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

5

SA: For each theme, PowerPoint provides 30 preset gradient fills with ____________________ designs for each of the six major theme colors

D . equal sign (=)

MC: The ____ preceding a formula alerts Excel that you are entering a formula or function and not text. A . quotation mark (") B . colon (:) C . plus (+) D . equal sign (=)

C . CTRL+SPACEBAR

MC: The ____ shortcut keys remove character formatting. A . CTRL+0 (zero) B . CTRL+I C . CTRL+SPACEBAR D . CTRL+U

C . CTRL+SHIFT+W

MC: The ____ shortcut keys underline words, and not spaces. A . CTRL+U B . CTRL+W C . CTRL+SHIFT+W D . CTRL+SHIFT+PLUS SIGN

B . AutoCorrect

MC: The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them. A . AutoEntry B . AutoCorrect C . AutoAdd D . AutoSpell

B . New (blank)

MC: To add a record to a table, tap or click the ____ record button. A . Add New B . New (blank) C . Last D . Insert (New)

Flase

T/F: A thin red border indicates the active cell.

True

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

True

T/F: Each Office app has its own Help home page.

True

T/F: Graphics in documents help clarify and emphasize details so they appeal to audience members with different backgrounds.

True

T/F: If you want to move a table to a new location, point to the upper-right corner of the table until the table move handle appears, point to the table move handle, and then drag it to move the entire table to a new location.

False

T/F: It is not possible to use keywords to search for themes.

True

T/F: One method of changing the size of a window is to drag the window borders.

True

T/F: One way to distribute a document is to post it on cloud storage such as SkyDrive.

False

T/F: PowerPoint displays a few themes that are similar to one another

False

T/F: The NETWORKDAYS function checks a formula for correctness.

True

T/F: The asterisk (*) wildcard represents any collection of characters.

True

T/F: The path to the Logical button is (FORMULAS tab | Function Library group).

False

T/F: The question mark (?) wildcard represents any collection of characters.

True

T/F: The range of entries that identifies the major groups for a clustered column chart are called the category names.

True

T/F: The text in the accompanying figure shows shapes inserted and formatted.

True

T/F: To delete the contents of a cell, select the cell contents and then press the DELETE or BACKSPACE key.

True

T/F: When Excel cannot calculate a formula, it displays an error message in a cell.

False

T/F: You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

False

T/F: You cannot preview the data to be updated in an update query before actually performing the update

D . CTRL+SHIFT+>

30. MC: To decrease a font size, use the ____ shortcut keys. A . CTRL+< B . CTRL+SHIFT+< C . CTRL+< D . CTRL+SHIFT+>

A . left-aligned

35. MC: By default, text is ____ in a cell. A . left-aligned B . centered C . justified D . right-aligned

D . CTRL+END

64. MC: To move to the end of the document, press the ____ key(s). A . DOWN ARROW B . END C . CTRL+DOWN ARROW D . CTRL+END

A . one

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

Slide indicator

SA: When you drag the scroll box, the _________________________ shows the number and title of the slide you are about to display.

True

T/F: A lookup field allows the user to select from a list of values when updating the contents of a field.

True

T/F: A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

True

T/F: A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

False

T/F: When you create a calculated field, users can update the field.

False

T/F: When you enter text data in a criterion, you must enclose the text in quotation marks.

True

T/F: When you move a file, it no longer appears in the original folder.

False

T/F: 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.

False

T/F: Worksheet titles and subtitles should be as wordy as possible.

False

T/F: You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

D . CTRL+E

28. MC: The shortcut keys used to center a paragraph are ____. A . CTRL+T B . CTRL+M C . CTRL+SHIFT+T D . CTRL+E

B . 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 ____. A . Office Button menu B . Quick Access Toolbar C . ribbon D . any of the above

B . relative

MC: A ____ reference is an adjusted cell reference in a copied and pasted formula. A . revised B . relative C . recycled D . retained

A . offsets

MC: A background feature called _____ allows you to move the background from the slide borders in varying distances by a percentage. A . offsets B . onsets C . reduction D . expansion

D . footnote

MC: 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. A . keynote B . citation C . endnote D . footnote

A. Citation

MC: A tag name is an identifier that links a(n) ____ to a source. A . citation B . index C . attribute D . field

D . indirect

MC: 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. A . contiguous B . indexed C . direct D . indirect

F, Sub datasheet

Mod. T/F: When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book rep in a split form . ____________________

True

Mod. T/F: Wildcards are symbols that represent any character or combination of characters. ____________________

Table

SA: A Word ____________________ is a collection of rows and columns.

Tab Stop

SA: A(n) ____________________ is a location on the horizontal ruler that tells Word where to position the insertion point when you press the TAB key on the keyboard.

Incline

SA: A(n) ____________________ object is an object that is part of a paragraph.

Bullet list

SA: A(n) _________________________ is a list of paragraphs, each of which is preceded by a bullet.

Satus bar

SA: As shown in the accompanying figure, the _________________________ shows the current page followed by the total number of pages in the document, the number of words in the document, and an icon to check spelling and grammar.

Selected

SA: Dashed lines around the border of a placeholder indicate that the placeholder is _________________________, as shown in the accompanying figure.

D . cloud

MC: Microsoft Office 365 uses the ____ to deliver a subscription-based service offering the newest Office suite and much more. A . app B . tile C . operating system D . cloud

D . >

MC: All of the following are valid Excel arithmetic operators EXCEPT ____. A . | B . * C . % D . >

D. Horizontal Ruler

MC: Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____. A . Quick Access Toolbar B . Office Button menu C . vertical ruler D . horizontal ruler

C . Enter

MC: Clicking the ____ box completes an entry. A . Cancel B . Formula C . Enter D . Tab

C . saturation

MC: Color ____ changes the intensity of colors. A . tone B . density C . saturation D . brightness

A . cast

MC: Color ____ indicates that one color is dominating a picture. A . cast B . tone C . saturation D . hue

D . single-spaced, left-aligned, and a smaller font size than the text in the research paper

MC: Footnote text is _____. A . double-spaced, right-aligned, and a smaller font size than the text in the research paper B . double-spaced, left-aligned, and the same font size as the text in the research paper C . double-spaced, left-aligned, and a smaller font size than the text in the research paper D . single-spaced, left-aligned, and a smaller font size than the text in the research paper

D . all of the above

MC: Headers and footers can include text and graphics, as well as the _____. A . current date B . page number C . current time D . all of the above

A . Exactly

MC: If the top of a set of characters is chopped off, the problem may be that the line spacing is set to ____. A . Exactly B . Cut C . About D . Near

B . Design view

MC: In the accompanying figure, the Book Rep table displays in ____. A . Structure view B . Design view C . Layout view D . Table view

D . primary key

MC: 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 B . foreign key C . main key D . primary key

A . row selector

MC: In the accompanying figure, the small box or bar to the left of each field is called the ____. A . row selector B . field selector C . field bar D . current field bar

B . Delete Field

MC: 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 B . Delete Field C . Delete Column D . Remove Column

B . Insert Field

MC: To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu. A . Insert Column B . Insert Field C . Add Column D . Add Field

C . Replace

MC: To instruct PowerPoint to confirm each change, click the Find Next button in the ____ dialog box. A . Update B . Relocate C . Replace D . Find

B . CTRL+DOWN ARROW

MC: To move down one paragraph, press the ____ key(s). A . ALT+DOWN ARROW B . CTRL+DOWN ARROW C . DOWN ARROW D . F1

C . HOME

MC: To move to the beginning of a line with the keyboard, press the ____ key(s). A . LEFT ARROW B . CTRL+HOME C . HOME D . PAGE UP

A . ALT+CTRL+PAGE DOWN

MC: To move to the bottom of a document window, press the ____ key(s). A . ALT+CTRL+PAGE DOWN B . CTRL+PAGE DOWN C . ALT+PAGE DOWN D . PAGE DOWN

C . CTRL+RIGHT ARROW

MC: To move to the right one word, press the ____ key(s). A . ALT+RIGHT ARROW B . F1 C . CTRL+RIGHT ARROW D . RIGHT ARROW

B . ALT+CTRL+PAGE UP

MC: To move to the top of a document window, press the ____ key(s). A . CTRL+PAGE UP B . ALT+CTRL+PAGE UP C . PAGE UP D . ALT+PAGE UP

D . CTRL+UP ARROW

MC: To move up one paragraph, press the ____ key(s). A . F1 B . ALT+UP ARROW C . UP ARROW D . CTRL+UP ARROW

D . Design View

MC: To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu A . Table Design B . Layout View C . Structure View D . Design View

B . Format

MC: To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency. A . Field Size B . Format C . Caption D . Description

C . ALT+ENTER

MC: To start a new line in a cell, press the ____ keys. A . CTRL+ENTER B . TAB+ENTER C . ALT+ENTER D . SHIFT+ENTER

A . 20xx

MC: When you enter a two-digit year that is less than 30, Excel changes the year to ____. A . 20xx B . 30xx C . 18xx D . 19xx

A . =23%

MC: Which of the following calculations multiplies 23 by 0.01? A . =23% B . =23 C . =23+.01 D . =24-.01

C . format

MC: You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. A . save B . print C . format D . clear

A . F2

MC: You can place an insertion point by tapping or clicking in the field or by pressing ____. A . F2 B . F3 C . F4 D . F5

C . tiling

MC: You can use _____options to repeat a background image many times vertically and horizontally on a slide. A . formatting B . duplicating C . tiling D . arranging

B . Pattern fill

MC: ____ adds designs that repeat in rows across a slide. A . Solid fill B . Pattern fill C . Gradient fill D . Texture fill

A . Cloud computing

MC: ____ can help businesses be more efficient and save them money by shifting usage and the consumption of resources, such as servers and programs, from a local environment to the Internet. A . Cloud computing B . Operating systems C . Applications D . Databases

B . Grayscale

MC: ____ changes picture color into black, white, and shades of gray. A . Blackscale B . Grayscale C . Whitescale D . Colorscale

A . Recolor

MC: ____ effects convert colors in a picture to a wide variety of hues. A . Recolor B . Redesign C . Reorganize D . Repair

C . Office 2013

MC: ____ is the name of the perpetual software package that includes individual applications that can be installed on a single computer. A . Office 365 B . Microsoft Exchange C . Office 2013 D . Microsoft Office Web

A,B,C,D

MR: In addition to the core desktop Office suite, Office 365 provides access to ____. A. email B. calendars C. conferencing D. file sharing

A,B,C

MR: Office 365 website creation tools include those for adding ____. A. a theme B. graphics C. fonts D. a storage device

True

Mod. T/F: A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________

True

Mod. T/F: A default value is a value that Access will display on the screen in a particular field before the user begins adding a record. ____________________

False, its foreign

Mod. T/F: A secondary key is a field in one table whose values are required to match the primary key of another table. ____________________

False, aggregate

Mod. T/F: A summary function is a function that performs some mathematical function against a group of records. ____________________

False, theme

Mod. T/F: Each document format determines the color scheme, font set, and layout of a presentation. _________________________

Building block

SA: If the same text or graphic is used frequently, you can store the text or graphic as a(n) ____________________ and then insert the stored entry in the open document, as well as in future documents.

Multi-value

SA: If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

sections

SA: In OneNote, the pages are grouped into _________________________.

Clear Formatting

SA: In Word, the term, ____________________, refers to returning the formatting to the Normal style.

Worksheets

SA: Inside a workbook in Excel are sheets, each of which is called a(n) _________________________.

Reconstruction the database

SA: Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

Oral

SA: One of the more common uses of a presentation is to enhance a(n) _________________________ presentation.

Shift+>

SA: One way to increase font size is to press CTRL+ _________________________.

Wrep

SA: PowerPoint 2013 does not allow you to _________________________ text around a picture or other graphic.

Left

SA: PowerPoint inserts text to the _________________________ of the insertion point.

Thesaurus

SA: PowerPoint provides a(n) ____________________, a list of synonyms and antonyms, to help you find replacement words.

Nonbreaking Hyphen

SA: Press CTRL+SHIFT+HYPHEN to enter a(n) ____________________, which is a special type of hyphen that prevents two words separated by a hyphen from splitting at the end of a line.

Shift+Tab

SA: Press the ____________________ key(s) to select the previous cell from the one in which the insertion point appears.

Ignore

SA: Pressing the _________________________ button when a word is highlighted on the Spelling pane causes PowerPoint to flag that word again if it appears later in the document.

F5

SA: Pressing the _________________________ function key runs the slide show starting with the first slide

CTRL+P

SA: Pressing the _________________________ keyboard shortcut keys displays the Print tab in Backstage view.

Find and replace

SA: The ____________________ feature automatically locates specific text and then replaces it with desired text.

Fill months

SA: The ____________________ option on the Auto Fill Options menu fills the destination area with a series of

Quick access tool bar

SA: The _________________________ provides convenient, one-tap or one-click access to frequently used commands.

Drag & Drop

SA: The process of sliding or dragging and then dropping a thumbnail in a new location is called _________________________.

Keyboard shortcut

SA: When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.

In the center

SA: When you insert a clip on a slide without a clip content placeholder, the clip is inserted ________________________ of the slide, as shown in the accompanying figure.

Tilling percent

SA: With tiling options, the smaller the ____________________, the greater the number of times an image is repeated.

Custom

SA: You can create your own ____________________ fill sequences for use with the fill handle

Row boundary

SA: You can drag a(n) ____________________, which is the border at the bottom of a row, until the row is the desired height.

Low from query

SA: You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

Transparency

SA: You can tap or click the up or down arrows in the Transparency box to move the ____________________ slider in the Format Background dialog box in one-percent increments.

work error

SA: You work on objects such as tables, forms, and reports in the Access _________________________.

offset

SA: ____________________ is a background feature that allows you to move the background from the slide borders in varying distances by percentages.

Fill series

SA: ____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Floating

SA: ____________________ objects give you more flexibility because you can position them anywhere on the page.

Printing

SA: _________________________ a presentation enables you to distribute the document to others in a form that can be read or viewed but typically not edited.

Navigation

SA: _________________________ is the process of finding a location on a storage device.


Kaugnay na mga set ng pag-aaral

Chapter 11 : Water and Major Minerals HW

View Set

807 CH 11: Hematopoetic Disorders

View Set

What is science and how does it work?- quiz questions

View Set

Cognitive Psych Chapter 8: Everyday Memory and Memory Errors

View Set

Evolve Hesi Leadership- Prioritizing Care

View Set

Insurance Pt. 3! Chpt. 1 Exam Pt. 1

View Set

Chapter 13 Preterm and Postterm Newborns

View Set

Chapter 39 Assessment of Musculoskeletal Fxn

View Set