MIS Final Exam Excel

which of the following arguments is not in an IF function: a. logical test b. value if true c. value if true false d. value if false

d. value if true false

The person or persons requesting the worksheet should supply their requirements in a _____ document a. blank b. test issues c. requirements d. certified

C. Requirements

cell reference in a formula are called___. a. assumptions b. comments c. numbers d. content

a. assumptions

the date you change a file is an example of a(n) ___ property. a. automatically updated b. baseline c. standard d. indexed

a. automatically updated

a pie chart with one or more slices offset is referred to as a(n) ___ pie chart. a. exploded b. outer c. offset d. rasterized

a. exploded

a ____ reference is an adjusted cell reference in a copied and pasted formula. a. revised b. relative c. recycled d. retained

b. relative

______ is/are used to place worksheet, column, and row titles on a worksheet. a. color b. text c. links d. tabs

b. text

clicking the ____ box completes an entry. a. cancel b. formula c. enter d. tab

c. enter

Which of the following is the Ribbon path to the Cell Styles button? a. (HOME tab | Styles Group) b. (STYLES tab | Home group) c. HOME tab | Format group) d. (FORMAT tab | Styles group)

a. (HOME tab | Styles group)

which of the following is the path to the Zoom Button? a. (VIEW tab | Zoom group) b. (HOME tab | Zoom group) c. (INSERT tab | Zoom group) d. ( ZOOM tab | View group)

a. (VIEW tab | Zoom group)

when you decrease the row heigh to ___, the row is hidden. a. 0 b. 1 c. 2 d. 3

a. 0

if you do not assign a format to a cell or cells in a column, the column width will remain ___ characters. a. 8.43 b. 7.52 c. 11.65 d. 9.43

a. 8.43

which of the following Option buttons gives options for filling cells following a fill operation? a. Auto Fill Options b. AutoCorrect Options c. Insert Options d. Paste Options

a. Auto Fill Options

you can press the ____ keys to open the Format Cells dialog box. a. CTRL+1 b. CTRL+2 c. CTRL+3 d. CTRL+4

a. CTRL+1

pressing the ____ keyboard shortcut key(s) selects cell A1. a. CTRL+HOME b. CTRL+END c. HOME d. END

a. CTRL+HOME

the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is the ___ key. a. ENTER b. ALT c. CTRL d. SHIFT

a. ENTER

Which of the following Auto Fill Options menu options is the same as the Fill Series option? a. Fill Months b. Fill without formating c. Fill Formatting Only d. Copy cells

a. Fill Months

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. a. Goal b. formula c. Option d. Function

a. Goal

which of the following key moves the insertion point to the beginning of data in a cell? a. HOME b. ENTER c. INSERT d. TAB

a. HOME

which of the following keys toggles between Insert mode and Overtype mode? a. INSERT b. ENTER c. TAB d. ALT

a. INSERT

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

a. RIGHT ARROW

the adjusted cell reference in a copied and pasted formula are called ____ cell references. a. related b. relative c. pasted d. alternative

a. related

The Increase Indent button indents the contents of a cell to the right by___ space each time you click it. a. two b. three c. four d. five

a. two

the path to the Format Painter button is_____. a. (Home tab | Number group) b. (HOME tab | Clipboard group) c. (HOME tab | Painting group) d. (HOME tab | Font group)

b. (HOME tab | Clipboard group)

how many chart types does Excel offer? a. 5 b. 15 c. 30 d. 50

b. 15

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

b. AutoCorrect

you can click the ____ button to undo an automatic correction. a. auto fill options b. autocorrect options c. paste options d. trace error

b. AutoCorrect Options

you can apply the Bold font style by pressing the ____ keyboard shortcut keys. a. ALT+B b. CTRL+B c. SHIFT+B d. TAB+B

b. CTRL+B

the Copy button copies the contents and format of the source area to the office___, a temporary storage area in the computer's memory a. Ribbon b. Clipboard c. Folder d. File

b. Clipboard

what effect does the Account Number Format have on the selected cells? a. converts alphabetic characters to numbers b. displays cell contents with two decimal places that align vertically c. performs tax calculations d. copies the numbers of one cell to another

b. Displays cell contents with two decimal places that align vertically

to erase an entire entry in a cell and then reenter the data from the beginning, press the ___ key. a. ALT b. ESC c. CTRL d. TAB

b. ESC

the ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled. a. Copy Cells b. Fill Formatting Only c. Fill Without Formatting d. none of the above

b. Fill Formatting Only

the ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign. a. function b. formula c. equal d. calculate

b. Formula

the ____ Option button lists formatting options following an insertion of cells, rows, or columns. a. AutoCorrect b. Insert c. Auto Fill d. Paste

b. Insert

When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899. a. SYSDATE b. NOW c. DATETIME d. CURRENT

b. NOW

to print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery. a. Print Active Sheets b. Print Selection c. Print Entire Workbook d. none of the above

b. Print Selection

following the insertion of a row, the Insert Options button lets you select all of the following options except: a. Format Same As Above b. Undo Formatting c. Format Same As Below d. Clear Formatting

b. Undo Formatting

you can enter the correct range in a function by typing the beginning and ending cell reference separated by a _______. a. semi-colon (;) b. colon (:) c. period (.) d. none of the above

b. colon (:)

when you set up a worksheet, you should use cell references in formula whenever possible, rather than ___ values. a. logical b. constant c. consistent d. calculated

b. constant

using the mouse to move or copy cells is called____. a. drop and drag b. drag and drop c. drag and copy d. drag and paste

b. drag and drop

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. a. position b. orientation c. slope d. incline

b. orientation

you can use the ___ the check which cells are referenced in the formula assigned to the active cell. a. formula finder b. range finder c. calculation finder d. function finder

b. range finder

which of the following keys moves the insertion point to the end of data in a cell? a. HOME b. DELETE c. END d. BACKSPACE

c. END

Which the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle? a. Quarter1 b. Qtr1 c. Qtr2 d. Quarter4

c. Qtr2

what effects does the Comma Style format have on the selected cells? a. converts decimals to commas within a cell b. converts decimals commas within merged cells c. displays cells contents with two decimal places and commas as thousands separators d. allows for substitution of selected characters

c. displays cell contents with two decimal places and commas as thousands separators

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 b. other c. nested d. duplicate

c. nested

Excel automatically appends the ___ the complete the AVERAGE function when you click the Enter box or press the ENTER key. a. left parenthesis b. right bracket c. right parenthesis d. left bracket

c. right parenthesis

if formulas located in other cell reference cells in a deleted row or column, Excel does not adjust these cell reference but instead displays the ___ error message. a. #NULL! b. #DIV/0 c. #N/A d. #REF!

d. #REF!

which of the following is a method of entering functions? a. the Name box area in the formula bar b. the Sum menu c. the Insert Function box in the formula bar d. all of the above

d. All of the above

the ___ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. a. autoformat b. autocomplete c. autofunction d. autocalculate

d. AutoCalculate

you should use a ___ chart to compare values side by side, broken by category. a. Column b. bar c. line d. Clustered Column

d. Clustered Column

to open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____. a. button b. check box c. option button d. Dialog Box Launcher

d. Dialog Box Launcher

you use ____ to view an XPS file. a. adobe reader b. backstage view c. microsoft powerview d. XPS viewer

d. XPS viewer

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 c. replace options c. formatting options d. auto fill options

d. auto fill options

To enter data in a cell, you must first select the _____ a. row b. worksheet c. column d. cell

d. cell

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

d. indirect

the range of cells receiving copied content is called the ____ area. a. fill b. range c. location d. paste

d. paste

____ text often provides a strong visual appeal. a. launched b. tiny c. logical d. rotated

d. rotated

___ properties are associated with all Microsoft Office files and include author, title, and subject. a. automatic b. hidden c. replacement d. standard

d. standard

the ___ button lists error-checking options following the assignment of an invalid formula to a cell. a. find error b. explain error c. fix error d. trace error

d. trace error

when working with a large worksheet, you can split the window into ___ panes. a. three or four b. four or five c. two or six d. two or four

d. two or four

excel remembers the last ____ actions you have completed. a. 25 b. 50 c. 75 d. 100

d.100