How can we help?

You can also find more resources in our Help Center.

bst midterm review

STUDY
PLAY
people who use the computer directly or use the info it provides are called computer users, end users, or sometimes, just users
true
most devices connected to the computer communicate with the monitor to carry out a task
false
a photo printer converts data from the computer into a beam of light that is focused on a photo-conductor drum, forming the images to be printed
false
magnetic disks use magnetic particles to store items such as data, instructions, and info on a disk's surface
true
although CDs have large storage capacities, even a CD cant hold many of todays complex programs
true
a key advantage of word processing software is that users easily can make changes in documents, such as correcting spelling; changing margins'and adding, deleting, or relocating entire paragraphs
true
passive-matrix screens display high-quality color that is viewable from all angles
false
a new workbook opens with 3 worksheets, but additional worksheets can be adeed as long as your computer has enough memory to accommodate them
true
to identify a cell, specify the row number first followed by the column letter
false
all commands on the mini toolbar also exist on the ribbon
true
when text is longer then the width of the column, excel displays the overflow characters in adjacent cells to the right
true
text entered in a cell cant be realigned
false
the following entries are considered text: 401AX21, 921-231, 619 321, 883XTY
true
when the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area
true
if each cell in a selected range is next to a row of numbers, excel assigns the SUM function to each cell in the selected range when the SUM button is clicked
true
excel can display characters in only 3 fonts colors: black, red and blue
false
if you save a workbook and then quit excel, all excel windows close
true
to use the name box to select any cell, click the name box and enter the cell reference of the cell you want to select
true
excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart
true
with the range to the chart selected, click the column button on the ribbon tab to initiate drawing the chart
true
excel automatically selects the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart, also called the x-axis or category axis
true
to use the autocalculate area, select the range of cells containing the numbers you want to check and then double-click the autocorrect area to display the status bar configuration shortcut menu
false
if a major error is made when typing data into a cell, click the cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning
true
when using in-cell editing, to a character or adjacent characters you can use the mouse to drag through the character or characters and then press the DELETE key or click the cut button on the standard toolbar
true
in insert mode, excel replaces the character to the right of the insertion point with the character typed
false
in overtype mode, excel inserts the typed character and moves all the characters to the right of the typed character one position to the right
false
the redo button allows previous actions to be repeated
true
press the SPACEBAR to clear a cell
false
the arithmetic operator, ^, directs excel to perform the division operation
false
cell references in formulas must be entered in uppercase, and spaces cant be added before or after arithmetic operators
false
regardless of the length and complexity of a formula, using point mode to enter formulas always is slower and less accurate the using the keyboard
false
when a formula is copied, excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values
true
a smart tag indicator is a block plus sign located in the center of the cell
false
the AVERAGE function requires that the arguement (the range) be included within parentheses before the function name
false
when point mode is used to enter a formula or function, the arrow keys can be used to complete the entry
false
excel has more than 400 functions
true
one of the least common mistakes made with excel is to include the wrong cell refernce in a formula
false
to use the range finder to verify that a formula contains the intended cell references, right-click the cell with the formula to be checked
false
excel does not allow the contents of a cell to be aligned vertically
false
the comma style button is located on the ribbon
true
when using conditional formatting, if the condition is true, then excel applies the formatting
true
with conditional formatting, if the value of the cell changes and no longer meets the specific condition, excel suppresses the condition formatting
true
a character is a dot on the screen that contains a color
false
a pixel is defiend as a letter, number, symbol, or puncuation mark in 10-point arial font, the default font by excel
false
the default row height in a blank worksheet is 12.75 points (or 17 pixels)
false
to skip correcting a word identified by the spell checker, click the ignore once button in the spelling dialog box
true
you can preview a worksheet using the print preview button on the menu bar
false
to import external data from a world wide web site, it is necessary to have access to the internet
true
when a workbook is sent as an attachment to an e-mail, the recipient can double-click the attachment to open it in excel, or save it on disk and then open it at a later time
true
when typing, the insertion point moves to the left, and when the end of a line is reached, it moves downward to the next line
false
the mouse pointer becomes different shapes depending on the task being performed in word and the pointers location on the screen
true
to remove the key tip badges shown in figure 1-4, press the ESC key until all the badges disappear
true
if word finds a potential error in a document, a red or green wavy underline flags the problem
true
a raised dot (.) shows where the ENTER key was pressed
false
each time the ENTER key is pressed, word creates a new paragraph
true
wordwrap forces you to stop typing words and press ENTER key at the end of each line
false
as you enter text in the word document window, you must press the ENTER key when the insertion point reaches the right margin
false
a document may wordwrap differently depending on the type of printer being used
true
if the computer is turned off or electrical power is lost, the document remains stored in the computers memory
false
paragraph formatting requires the paragraph to be selected prior to formatting
false
a single point is about 1/12 of an inch in height
false
word provides an undo button that can be used to cancel the most recent command or action
true
in addition to the basic solid underline, word has many decorative underlines that are available through the underline gallery
true
either the mouse or the keyboard can be used to scroll to a different location in a document
true
when using the keyboard to scroll, the insertion point remains stable
false
although text cant be seen once it scrolls off the screen, it remains in the document
true
a selected graphic can be resized using the shape height and shape width text boxes in the size group on the format tab in the picture tools tab
true
after a document is saved the first time, word automatically assigns a different file name each time it is saved subsequently
false
if you want to print multiple copies of a document, display the print dialog box by clicking the print button on the standard toolbar
false
to quit word, click the restore button on the right side of the title bar
false
word inserts text to the right of the insertion point
false
in word, the default typing mode is overtype mode
false
when used properly, the word knowledgebase system can increase productivity and reduce frustration by minimizing the time spent learning how to use word
false
although many different styles of documentation exist for report preparation, each style requires the same basic info
true
to follow the MLA style, single-space text on all pages with one and a half-inch top and bottom margins, and one-inch left and right margins
false
according to MLA style, on each page of the research paper, precede the page number by the title of the paper
false
using the MLA style of documentation, the title of the paper is center one double-space below the writers name and course info
true
in the MLA style, notes are used only for optional explanatory notes
false
the MLA style uses the term bibliographical references for works cited
false
to use click and type, you double-click a blank area of the document window
true
CTRL+B, CTRL+], and CTRL+U are all shortcut keys for formatting paragraphs
false
in addition to a predefined list of autocorrect spelling, capitalization, and grammar errors, you can create your own autocorrect entries to add to the list
true
to delete a note, select the note reference mark in the footnote text by dragging through the note reference mark, and then click the cut button on the home tab
false
to count words, click the word count indicator on the home tab to display the word count dialog box
false
if you add text, delete text, or modify text on a page, word recomputes the location of automatic page breaks and adjusts them accordingly
true
according to the MLA style, the first line of each entry on the works cited page begins at the left margin
true
word never moves or adjusts automatic page breaks; however, word adjusts manual page breaks that follow an automatic page break
false
the shortcut keys, CTRL+ENTER, instruct word to insert an automatic page break immediately above the insertion point and position the insertion point immediately below the automatic page break
false
when you drag the hanging indent marke, the left indent marker moves with it
true
the MLA style requires that the works cited be listed in alphabetic order by the authors last name or, if hte work has no author, by the works title
true
when you point to an icon on the select browse object menu, word displays the associated command name at the top of the menu
true
to move the text, you first select the text to be moved and then use drag-and-drop editing or the cut-and-paste technique to move the selected text
true
if you have multiple custom dictionaries, you can specify which one word should use when checking spelling
true
from within word, you can search through various forms of reference info
true
while plagiarism is unethical, it is not considered an academic crime
false
you can use the ignore all button in the spelling and grammar dialog box
true