Study Guide Digital Literacy

A __________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. a. range c. nearby cell b. bunch d. neighbor

A

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet. a. Attachment c. Document b. File d. Extend

A

A saved database is referred to as a ____. a. file c. DBMS b. databook d. template

A

Combining two or more cells together is called __________ cells. a. merging c. combining b. mixing d. spanning

A

Dividing a cell into more than one cell is called __________. a. splitting c. dividing b. merging d. uncoupling

A

If the top of a set of characters is chopped off, then line spacing may be set to ____. a. Exactly c. About b. Cut d. Near

A

If you click the Grow Font button too many times and make the font size too big, you can click the ____ button until the desired font size is displayed. a. Shrink Font c. Reduce Font b. Small Font d. Reduce Selected Text

A

If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column's width. a. Column Width c. Width Adjustment b. Adjust Width d. Increase Column

A

If you want to remove the AutoCorrect Options button from the screen, you can press the ____ key. a. ESCAPE c. CTRL b. F5 d. SHIFT

A

In addition to creating a series of values, dragging the fill handle instructs Excel to ____ the format of a cell to a range. a. copy c. delete b. move d. cut

A

Longer worksheet names also can mean that ____ sheet tabs will show. a. fewer c. more b. all d. no more

A

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

A

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

A

To back up a database, use the ____ command on the Office Button menu. a. Manage c. Backup b. Data Tools d. Options

A

To import data stored on a Web site use a ____. a. Web query c. Web import b. Web search d. Web copy

A

To select a sentence, press and hold down the ____ key and then click the sentence. a. CTRL c. ESC b. SHIFT d. ALT

A

Which keyboard key moves the insertion point to the beginning of data in a cell? a. Home c. Insert b. Enter d. Tab

A

Which of the following is not a valid format symbol? a. semi-colon (;) c. dollar sign ($) b. percent sign (%) d. comma (,)

A

Word provides a(n) ____ button, which increases the font size of selected text each time you click the button. a. Grow Font c. Font Size b. Increase Font d. Enlarge Selected Text

A

You can place an insertion point by clicking in the field or by pressing ____. a. F2 c. F4 b. F3 d. F5

A

____ is another term for document properties. a. Metadata c. Enhanced text b. Key terms d. Indices

A

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

A

__________ are a collection of worksheets. a. Workbooks c. Papers b. Booklets d. Work hours

A

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

B

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added. a. Sequential c. Incremental b. AutoNumber d. AutoSequence

B

A(n) __________ is a list of additional commands associated with the selected command. a. Alt command c. call-out b. submenu d. Quick command

B

According to the MLA style, the _____ is a list of sources that are referenced directly in a research paper. a. parenthetical citations page c. explanatory notes page b. works cited page d. superscript reference page

B

At a minimum, your resume should present all of the following EXCEPT ____. a. contact information c. objective b. past salaries earned d. educational background

B

By default, the Normal style inserts a vertical space equal to ____ line(s) between each line of text. a. 1 c. 2 b. 1.15 d. 2.15

B

Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box. a. Rule Format c. New Format b. New Rule d. Format Rule

B

How many chart types does Excel offer? a. 5 c. 29 b. 11 d. 50

B

If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series. a. increment, decrement c. copy, cut b. decrement, increment d. cut, copy

B

If you prefer using the keyboard, instead of the mouse, you can press the ALT key on the keyboard to display a(n) __________. a. Keyboard picture c. Image mouse b. Key Tip badge d. Mouse image badge

B

In Access, table and field names can be up to ____ characters in length. a. 32 c. 128 b. 64 d. 255

B

In the ____ letter style, all components of the letter begin flush with the left margin. a. modified block style c. modified semi-block style b. block style d. all of the above

B

In the accompanying figure, the __________ button and __________ button next to the Help icon are used to minimize and restore the worksheet within the Excel window. a. Collapse, Expand c. Help, Answer b. Minimize, Restore d. Question, Answer

B

One way to create a table, is to click ____ on the Ribbon and then click the Table button. a. New c. Add b. Create d. Insert Table

B

One way to delete a note is to click immediately to the left of the note reference mark in the document text and then press the ____ key twice. a. BACKSPACE c. ESC b. DELETE d. F3

B

The ____ button lists formatting options following an insertion of cells, row, or columns. a. Paste Options c. Auto Fill Options b. Insert Options d. AutoCorrect Options

B

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

B

The ____, which automatically appears based on certain tasks you perform, contains commands related to changing the appearance of text in a document. a. Office Button c. Clip Organizer b. Mini toolbar d. ruler

B

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name. a. Rename Field c. Change Field b. Rename Column d. Change Column

B

To move left one word with the keyboard, press ____. a. HOME c. ALT+CTRL+LEFT ARROW b. CTRL+LEFT ARROW d. ALT+LEFT ARROW

B

To search for a special character, first click the More button in the Find dialog box and then use the ____ button. a. Characters c. Options b. Special d. Advanced

B

When you click the __________, located in the upper-left corner of the window as shown in the accompanying figure, Excel displays the Office Button menu. a. Open c. Start b. Office Button d. all of the above

B

Word, by default, places a tab stop at every ____ mark on the ruler. a. .25" c. .75" b. .5" d. 1"

B

You can check formulas for errors by clicking the ____ button on the Formulas tab on the Ribbon. a. Formula Checker c. Formula b. Error Checking d. Error Validating

B

You can magnify or shrink the appearance of a worksheet or chart by using the ____ button on the View tab on the Ribbon. a. Maximize c. Focus b. Zoom d. View Up/Down

B

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

B

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table. a. Picture c. OLE Object b. Image d. Bitmap

C

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. a. included c. nested b. other d. duplicate

C

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255. a. Unlimited c. Memo b. Variable d. Character

C

Copying, deleting, inserting, and moving ranges of cells have the potential to ____. a. improve consistency of the cells c. render a worksheet useless b. improve consistency of the worksheet d. improve consistency of the workbook

C

How do you activate Range Finder to verify a formula in a cell? a. Range Finder does not verify formulas c. Double-click in the cell b. Press the ESC key d. Click the Range Finder button

C

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____. a. 1732 c. 1932 b. 1832 d. 2032

C

In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject. a. object c. database b. relation d. tuple

C

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. a. inside address c. signature block b. message d. salutation

C

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it. a. 2 c. 3 b. 4 d. 5

C

The ____ shortcut keys remove character formatting a. CTRL+0 (zero) c. CTRL+SPACEBAR b. CTRL+I d. CTRL+U

C

The __________ toolbar, which appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet. a. Quick c. Mini b. Short d. Long

C

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab. a. Portrait/Landscape c. Landscape b. Orientation d. Switch Orientation

C

To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button. a. Insert c. Create b. New Object d. Report

C

To delete a character in a document, click next to the character and then press the ____ key to erase to the left of the insertion point. a. F5 c. BACKSPACE b. ALT+ESC d. DELETE

C

To delete a record, click the Record selector for the record, and then press the ____ key(s). a. CTRL+DELETE c. DELETE b. CTRL+Y d. CTRL+K

C

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu. a. Objects by Table c. Tables and Related Views b. Table Object d. Default

C

To right-align a paragraph, use the ____ shortcut keys. a. CTRL+T c. CTRL+R b. CTRL+M d. CTRL+K

C

To select a block of text, click at the beginning of the selection, scroll to the end of the selection, position the mouse pointer at the end of the selection, hold down the _____ key, and then click (or drag through the text). a. CTRL c. SHIFT b. ALT d. TAB

C

To specify AutoCorrect rules and exceptions to the rules, click ____ on the Office Button menu and then click Proofing in the dialog box that displays. a. Customize c. Access Options b. Manage d. Grammar

C

Using the ____ button on the Ribbon instructs Excel to display additional decimal places in a cell. a. AutoFormat c. Increase Decimal b. Currency Style d. Percent Style

C

When a cell entry is positioned at the far left in the cell, it is considered __________. a. left- and right-aligned c. left-aligned b. center-aligned d. right-aligned

C

While Excel is saving your file, it briefly displays a message on the status bar indicating __________. a. the number of cells used c. the amount of the file saved b. the author name d. you must click the Save button

C

____ characters often are used in a table of contents to precede page numbers. a. Key c. Leader b. Index d. Tracking

C

____ is the process of copying an item from the Clipboard into the document at the location of the insertion point. a. Clipping c. Pasting b. Dragging d. Dropping

C

A _____ is a window that can remain open and visible while you work in the document. a. Help panel c. command bar b. status bar d. task pane

D

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

D

Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____. a. Quick Access Toolbar c. vertical ruler b. Office Button menu d. horizontal ruler

D

Click Microsoft Office in the ____ list to display the Microsoft Office list. a. All Applications c. Start b. Excel d. All Programs

D

Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. a. recalculates new c. recalculates old b. recalculates some d. recalculates all

D

Excel rotates the chart 10 degrees in a ____ direction each time you click the Increase X Rotation button. a. forward tilt c. counterclockwise b. backward tilt d. clockwise

D

In Excel, a number can contain the characters __________. a. 0 1 2 3 4 5 6 7 8 9 c. . $ % E e b. + - ( ) , / d. all of the above

D

The Word Count button on the Review tab displays the number of words as well as the number of _____ in the current document. a. lines c. paragraphs b. characters d. all of the above

D

The ____ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted. a. end mark c. scroll point b. status bar d. insertion point

D

The commands to insert a chart are located on the __________ tab, as shown in the accompanying figure. a. Fast Chart c. Quick Chart b. Home d. Insert

D

To convert a hyperlink e-mail address to regular text, right-click the e-mail address and then click ____ on the shortcut menu. a. Edit Hyperlink c. Convert Hyperlink b. Select Hyperlink d. Remove Hyperlink

D

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type __________. a. 6,000T c. 6Q b. 6K000 d. 6E15

D

To increase a paragraph indent, use the _____ shortcut keys. a. CTRL+L c. CTRL+1 b. CTRL+E d. CTRL+M

D

To quit Access, click the ____ button on the right side of the Access title bar. a. Quit c. Quit Access b. End d. Close

D

To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ____. a. click the Cancel box c. click the Name box b. press the ESC key d. press the ENTER key

D

To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar. a. Cancel c. Back b. Escape d. Undo

D

What is the title of the blank workbook that opens when you first start Excel from the Windows Start menu? a. Workbook1 c. Book b. Work1 d. Book1

D

When you maximize a window, the Maximize button changes to a(n) ____ button. a. Minimize c. Original b. Return d. Restore Down

D

When you open an Excel file, the application name (Microsoft Excel) is displayed on a selected button on the taskbar. If you point to this button, the file name also appears in a(n) __________. a. cell c. toolbar b. row d. ScreenTip

D

Which of the following colors suggests neutrality? a. green c. red b. brown d. gray

D

Which of the following is a bibliographic source? a. map c. letter b. memo d. all of the above

D

____ are words or phrases that describe a document. a. Metakeys c. Anchors b. Enhanced ScreenTips d. Keywords

D

When you ____ a worksheet, Excel is able to display more columns and rows. a. shrink c. expand b. minimize d. maximize

A

Which key on the keyboard toggles between Insert mode and Overtype mode? a. Insert c. Tab b. Enter d. Num Lock

A

To erase a character to the right of the insertion point, press the _____ key. a. CANCEL c. DELETE b. BACKSPACE d. either b or c

C

To move to the beginning of a line with the keyboard, press ____. a. LEFT ARROW c. HOME b. CTRL+HOME d. PAGE UP

C

To change the save location for a database, click ____ in the Favorite Links section. a. Save in c. Desktop b. Searches d. Computer

D