Excel Study Guide

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

b.relative

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

b.three

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

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. .843

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

a. 0

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

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)

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

a.5 b.15 c.30 d.50

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

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

a.CTRL+HOME

Which of the following keys 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

Cell references 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

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

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

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 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 (:)

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. texts

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

What effect does the Accounting 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

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 ____ Auto Complete 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

You can use the ____ to 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

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

b.constant

What effect does the Comma Style format have on the selected cells? a.Converts decimals to commas within a cell b.Converts decimals to commas within merged cells c.Displays cell 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

Clicking the _________ box completes an entry. a. Cancel b. formula c. enter d. tab

c. enter

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

Excel automatically appends the ____ to 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 parentheses

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

c.CTRL

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 of the following Auto Fill Options menu options is the same as the Fill Series option? a.Fill Months b.Fill Without Formatting c.Fill Formatting Only d.Copy Cells

c.Fill Formatting Only

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

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

d. cell

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

d. paste

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

d.100

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

d.Auto Fill Options

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

____ 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

You use ____ to view an XPS file. a.Adobe Reader b.Backstage View c.Microsoft PowerView d.XPS Viewer

d.XPS Viewer

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