Avid exam review

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

A - (HOME tab | Styles groups)

When you decrease the row height to ____, the row is hidden. a. 0 c. 2 b. 1 d. 3

A - 0

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

A - 2

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

A - 8.43

33. Which of the following calculations multiplies 23 by 0.01? a. =23% c. 23+.01 b. 23 d. =24-.01

A - =23%

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

A - Automatically updated

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

A - CTRL + HOME

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. a. ENTER c. CTRL b. ALT d. SHIFT

A - ENTER

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

A - Exploded

A ____ is text and graphics that print at the bottom of every page. a. footer c. margin b. toe d. stopper

A - Footer

A ____ is a prewritten formula that is built into Excel. a. function c. task b. feature d. calculation

A - Function

A ____ is text and graphics that print at the top of each page. a. header c. margin b. topper d. crown

A - Header

Which of the following keys move the insertion point to the beginning of the cell? a. HOME b. ENTEr c. INSERTION d. TAB

A - Home

The ____ function is useful when you want to assign a value to a cell based on a logical test. a. IF c. AND b. NOW d. OR

A - IF

Combining two or more selected cells into one cell is called ____ cells. a. merging c. combining b. mixing d. spanning

A - Merging

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 ___ button allows you to erase recent cell entries a. undo b. cell style c. bold d. Increase Decimal

A - Undo

The default view in Excel is called ____ view. a. Normal c. Basic b. Standard D. values

A - normal

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

A - semi-colon (;)

An excel __ allows data to be summarized and charted easily. A- worksheet C- document B- workflow D- presentation

A - worksheet

T or F:With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

False

T or F: Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

False (freezing)

T or F: When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

True

T or F: With Excel in Edit mode, you can edit cell contents directly in the cell.

True

T or F: You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

True

T or F:A character with a point size of 10 is about 10/72 of one inch in height.

True

T OR F: A requirements document includes a needs statement, source of date , summary of calculations, and any other special requirements.

True

T or F : Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

True

T or F: A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

True

T or F: A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

True

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

True

T or F: Excel has more than 400 functions that perform just about every type of calculation you can imagine.

True

T or F: Moving from left to right, the first calculation in the order of operations is negation (-).

True

T or F: The <= comparison operator means less than or equal to.

True

T or F: The AVERAGE function requires that the argument be included within parentheses following the function name.

True

T or F: The AutoCorrect feature can automatically capitalize the first letter in the names of days.

True

T or F: The Insert Options button lists formatting options.

True

T or F: The equal sign (=) precedes a formula

True

T or F: The most common error when entering a formula is to reference the wrong cell in the formula.

True

T or F: To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

True

T or F: An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

false

T or F:Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

True

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

True

T or F: A thin red border indicates the active cell

False

T or F: Excel can display characters in only three font colors: black, red, and blue.

False

T or F: Live preview is available on a touch screen.

False

T or F: The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

False

T or F: The arithmetic operator, ^, directs Excel to perform the division operation

False

T or F: The range automatically selected by Excel is always correct.

False

T or F: The underline format underlines the entire cell, not just the characters in the cell.

False

T or F: When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

False

T or F: When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

False

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

False

T or F: You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

False

T or F: You cannot format an entire column at once.

False

T or F: You should press the SPACEBAR to clear a cell.

False

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

B - 15

35. When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. a. 40 c. 48 b. 26 d. 13

B - 26

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. a. Comma style format c. Percent style format b. Accounting number format d. Currency style format

B - Accounting number format

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 - Auto correct

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

B - CTRL + B

Press __ to select the entire worksheet. a. F1 b. CTRL + A ALT + A d. F4

B - CTRL _ A

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. a. scheme c. theme b. gallery d. style

C - Theme

What effect does the Accounting Number Format have on the selected cells? a. Converts alphabetic characters to numbers c. Performs tax calculations b. Displays cell contents with two decimal places that align vertically d. Copies the numbers of one cell to another

B - Displays cell contents with two decimal places that aligns vertically.

Using the mouse to move or copy cells is called ____. a. drop and drag c. drag and copy b. drag and drop d. drag and paste

B - Drag and drop

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign. a. Function c. Equal b. Formula d. Calculate

B - Formula

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

B - Insert

____ view allows you to create or modify a worksheet while viewing how it will look in printed format. a. Normal c. Page Break Preview b. Page Layout d. Full Screen

B - Page layout

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

B - Right parenthesis

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. a. section c. special b. sparkline d. sparkle

B - Sparkline

____ is/are used to place worksheet, column, and row titles on a worksheet. a. Color c. Links b. Text d. Tabs

B - Text

The first step in creating an effective worksheet is to make sure you ____. a. apply font formatting c. insert a chart b. understand what is required d. enter the data

B - Understand what is required

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 c. Folder b. Clipboard d. File

B - clipboard

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

B - colon (:)

34. When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. a. placement c. positioning b. operations d. selections

B - operations

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

B - relative

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

B- ESC

Which of the following formulas contains an absolute cell reference? a. =$B4 c. =$B$4 b. =B$4 d. =B4

C - $B$4

41. 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. a. DIVSUM c. AVERAGE b. RANGEAVG d. MAX

C - AVERAGE

Charts can either be embedded in a worksheet or placed in a separate ____. a. worksheet c. chart sheet b. dialog box d. range

C - Chart sheet

What effect does the Comma Style format have on the selected cells? a. Converts decimals to commas within a cell c. Displays cell contents with two decimal places and commas as thousands separators b. Converts decimals to commas within merged cells d. Allows for substitution of selected characters

C - Displays contents with two decimal places and commas as thousand separators.

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

C - END

Clicking the ____ box completes an entry. a. Cancel b. Formula c. Enter d. Tab

C - Enter

36. Which of the following happens when you enter the formula =G15 into a cell? a. Excel recalculates all formulas in the worksheet c. Excel assigns the value in cell G15 to the active cell b. Excel assigns the sum of the values in the previous 15 cells to the active cell d. Nothing; =G15 is an invalid formula

C - Excel assigns the value in cell G15 to the active cell

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. a. save c. format b. print d. clear

C - Format

39. The ____ function displays the highest value in a range. a. MIN c. MAX b. SUM d. AVERAGE

C - MAX

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

D - 100

Which comparison operator means "not equal to"? a. <= c. < b. > d. <>

D - <>

32. All of the following are valid Excel arithmetic operators EXCEPT ____. a. ^ c. % b. * d. >

D - >

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 c. AutoFunction b. AutoComplete d. AutoCalculate

D - Autocalculate

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. Formatting Options b. Replace Options d. Auto Fill Options

D - Autofill options

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

D - Cell

You should use a ____ chart to compare values side by side, broken down by category. a. Column c. Line b. Bar d. Clustered Column

D - Clustered Column

The range of cells receiving the content of copied cells is called the ____. a. receiver cell c. receiving range b. final cell d. destination area

D - Destination area

40. The ____ function determines the lowest number in a range. a. LOW c. LEAST b. BASE d. MIN

D - MIN

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

D - Paste

____ properties are associated with all Microsoft Office files and include author, title, and subject. a. Automatic c. Replacement b. Hidden d. Standard

D - Standard

The ____ button lists error-checking options following the assignment of an invalid formula to a cell. a. Find Error c. Fix Error b. Explain Error d. Trace Error

D - Trace Error

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

D - two or four

T or F: The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

true