Excel Exam

Which chart type do you use to compare distinct objects over time using horizontal bars? a. area b. bar c. column d. line

bar

Cells and ranges in a worksheet can be formatted ____. a. only before data is entered b. only after data is entered c. before or after data is entered d. at the same time data is entered

before or after data is entered

The default border color around a chart title is ____. a. red b. green c. black d. blue

blue

You can change, or ____, the contents of an active cell at any time. a. recover b. navigate c. edit d. calculate

edit

A chart that is inserted directly in the current worksheet is called a(n) ____ chart. a. inner b. embedded c. sub d. interactive

embedded

In a worksheet, the ____ is called the formula prefix. a. minus sign (-) b. plus sign (+) c. pound sign (#) d. equal sign (=)

equal sign (=)

In a pie chart, slices that are pulled away are said to be ____. a. identified b. exploded c. opened d. extracted

exploded

A(n) ____ is a built-in formula that uses arguments to calculate information. a. label b. function c. template d. indicator

function

In Excel, MAX and AVERAGE are examples of ____. a. functions b. arguments c. lists d. buttons

functions

The x-axis and y-axis are, respectively, the ____. a. horizontal and vertical axes b. data series and gridlines c. tick markers and data series d. vertical and horizontal axes

horizontal and vertical axes

Which of the following is NOT a Paste list arrow option? a. pasting values only b. pasting values with number formatting c. pasting cell selectors d. pasting formulas only

pasting cell selectors

Possible paper orientations for printing a worksheet are landscape and ____. a. preview b. portrait c. normal d. page break

portrait

Which chart type is the best candidate for spotting trends and extrapolating information based on research data? a. pie b. area c. scatter d. hi-low

scatter

The default Accounting number format adds dollar signs and ____ decimal places to the data. a. one b. two c. three d. four

two

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion? a. Cell references are not affected b. The user must insert new cell references c. The user is prompted to enter new cell references d. Cell references are automatically adjusted

Cell references are automatically adjusted

You can change a column chart to a clustered bar chart using the ____ dialog box. a. New Chart Type b. Chart Category c. Adjust Type d. Change Chart Type

Change Chart Type

The file extension .xltx indicates what type of Excel file? a. Excel template b. Excel workbook c. Excel worksheet d. Excel formulas only worksheet

Excel template

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon. a. HOME b. PAGE LAYOUT c. REVIEW d. DATA

HOME

To insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click Insert Cells. a. HOME b. CELLS c. INSERT d. TOOLS

HOME

You can apply font styles and alignment options using the ____ tab of the Ribbon. a. INSERT b. HOME c. PAGE LAYOUT d. VIEW

HOME

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon. a. HOME b. DATA c. PAGE LAYOUT d. REVIEW

HOME

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon. a. HOME b. DATA c. PAGE LAYOUT d. REVIEW

PAGE LAYOUT

In the formula =ROUND(D4:F4,0), what does the zero indicate? a.The number of decimal places in the rounded number b. The number of times the formula should be repeated c. A null value d. The value for cell F4

The number of decimal places in the rounded number

____ marks indicate the scale of measure for each value on the y-axis. a. Datapoint b. Tick c. Axis d. Legend

Tick

The default file extension for an Excel 2013 workbook is ____. a. .xltx b. .xslx c. .xlsx d. .xlts

.xlsx

The Excel operator for division is ____. a. / b. \ c. % d. ^

/

Which of the following is a complex formula? a. =SUM(B4:B8) b. =(B4/B8)*10 c. =AVERAGE(C6:D6) d. =MIN(D5:D7)

=(B4/B8)*10

f cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the? a. =A1/A2 b. =10/2 c. 5 d. =5

5

All functions begin with the formula prefix ____. a. @ (at symbol) b. = (equals sign) c. # (number symbol) d. + (plus sign)

= (equals sign)

Which formula contains a mixed cell reference? a. =(A6+A7)*0.20 b. =($A$6+A7)*0.20 c. =($A$6+$A$7)*0.20 d. =($A6+$A$7)*0.20

=($A6+$A$7)*0.20

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address. a. % b. & c. $ d. @

$

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first? a. $M$3/4 b. (G15-G14)*$M$3 c. (G15-G14) d. (G15-G14)/4

(G15-G14)

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet? a. =A1^A2 b. 20 c. 10^2 d. 100

100

The Undo button allows you to reverse up to ____ previous actions, one at a time. a. 1 b. 10 c. 100 d. 1,000

100

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs? a. =C12+(C13*F4) b. =(C12+C13)*F4 c. =$C12+$C13*F4 d. =C12*F4+C13

=(C12+C13)*F4

Excel recognizes an entry as a value if it is a number or it begins with ____. a. + b. = c. $ d. All of the above

All of the above

Excel templates include which of these common documents? a. budgets b. balance sheets c. time cards d. All of the above

All of the above

The COUNTA function is used to count the number of cells in a range that contain which type of data? a. numbers b. dates c. formulas d. All of the above

All of the above

____ operators perform mathematical calculations such as adding and subtracting. a. Text concatenation b. Reference c. Arithmetic d. Comparison

Arithmetic

Double-clicking the column line to the right of a column activates the ____ feature for the column. a.AutoCorrect b. Format c.AutoFit d.Format as Table

AutoFit

In the formula =D1+C1/F3, which calculation will be performed first? a. C1/F3 b. D1+C1 c. D1/F3 d. D1+F3

C1/F3

The Format Painter button is found in the ____ group on the HOME tab of the Ribbon. a. Alignment b. Styles c. Clipboard d. Font

Clipboard

____ formatting is automatically updated if you change data in the worksheet. a. Conditional b. Spatial c. Dynamic d. Data

Conditional

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections. a. Options b. Effects c. Tools d. Shadow Format

Effects

You can add a text box using the CHART TOOLS ____ tab. a. DESIGN b. LAYOUT c. FORMAT d. TEXT

FORMAT

You can apply font styles and alignment options using the ____ dialog box. a. Format Cells b. Insert c. Conditional Formatting d. AutoCorrect

Format Cells

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box. a. Page Setup b. AutoCorrect c. Insert d. Format Cells

Format Cells

Which tab and group will allow the insertion of rows and columns in a worksheet? a. HOME tab, Styles group b. PAGE LAYOUT tab, Page Format group c. HOME tab, Cells group d. PAGE LAYOUT tab, Cells group

HOME tab, Cells group

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive. a. Find Images b. Insert Pictures c. Add Clip Art d. Add Images

Insert Pictures

The default format for cells that meet a condition with conditional formatting is ____. a. Dark Blue Fill with Light Red Text b. Light Red Fill with Dark Red Text c. Light Blue Fill with Dark Blue Text d. Dark Red Fill with Light Red Text

Light Red Fill with Dark Red Text

____ shows you how a fill color will look before you apply it. a. Sneak Peek b. Live Preview c. Quick Look d. Advance Look

Live Preview

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon. a. HOME b. PAGE LAYOUT c. REVIEW d. DATA

REVIEW

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon. a. HOME b. REVIEW c. INSERT d. VIEW

REVIEW

To format a cell or range, first you select it, and then you apply the formatting using the ____, the Mini toolbar, or a keyboard shortcut. a. Name box b. formula box c. Ribbon d. Sheet tabs

Ribbon

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____. a. Rules Options dialog box b. Rules template c. Rules Wizard d. Rules Manager

Rules Manager

The ____ option helps fit the data on a single page without making changes to individual margins. a. Scale to Fit b. Paginate c. Page Break View d. Squeeze

Scale to Fit

____ below the worksheet grid let you switch from sheet to sheet in a workbook. a. Cell pointers b. Mode indicators c. Scroll bars d. Sheet tabs

Sheet tabs

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid. a. SmartArt b. WordArt c. ClipArt d. 3-DArt

SmartArt

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the HOME tab, and then click a style in the gallery. a. Alignment b. Styles c. Cells d. Editing

Styles

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut? a. The user sees a "clipboard full" message b. The clipboard automatically deletes all items and starts over with the new item c. The clipboard prompts the user to delete items d. The clipboard automatically deletes the oldest item on the clipboard

The clipboard automatically deletes the oldest item on the clipboard

When cells are copied using Excel's copy function, what happens to the data in the copied cells? a. The data is permanently deleted from the copied cells b. The data is temporarily deleted from the copied cells c. The data remains in its original location d. The data is moved to another location and removed from its original location

The data remains in its original location

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet. a. Preview b. Zoom c. Orientation d. Layout

Zoom

To move one screen to the left press ____. a. [Ctrl][Home] b. [Alt][Page Up] c. [Ctrl][Page Left] d. [Alt][Page Down]

[Alt][Page Up]

To quickly jump to the last cell in a worksheet press ____. a. [Alt][Page Down] b. [Shift][Down] c. [Page Down] d. [Ctrl][End]

[Ctrl][End]

To quickly jump to the first cell in a worksheet press ____. a. [Alt][Page Up] b. [Shift][Home] c. [Page Up] d. [Ctrl][Home]

[Ctrl][Home]

Which keyboard shortcut turns on Edit mode? a. [F1] b. [F2] c. [F4] d. [F8]

[F2]

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula? a. [F1] b. [F4] c. [F10] d. [F12]

[F4]

You can add multiple worksheets to a workbook by clicking the HOME tab on the Ribbon, pressing and holding ____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clicking the Insert list arrow in the Cells group on the HOME tab, then clicking Insert Sheet. a. [Esc] b. [Shift] c. [F4] d. [Alt]

[Shift]

The Excel operator for exponent is ____. a. / b. \ c. % d. ^

^

Which type of cell reference preserves the exact cell address in a formula? a. absolute b. mixed c. relative d. All of the above

absolute

You can change the ____ of labels and values in cells to be left, right, or center. a. font b. font size c. cell style d. alignment

alignment

To show how individual volume changes over time in relation to total volume, use a(n) ____. a. area chart b. bar chart c. column chart d. line chart

area chart

You can use the ____ key(s) on the keyboard to navigate a worksheet. a. [Ctrl] b. Zoom c. arrow d. [Enter]

arrow

A ____ is an individual media file, such as art, sound, animation, or a movie. a. point b. cell style c. clip d. template

clip

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default. a. line b. area c. column d. pie

column

###### in a cell means that the ____. a. formula contains an error b. value contains an error c. label has a spelling error d. column is too narrow to display the value completely

column is too narrow to display the value completely

An example of a(n) ____ chart is a column chart with a line chart. a. nested b. combination c. complex d. exploded

combination

A pie chart ____. a. compares distinct, unrelated objects over time using a horizontal format b. compares trends over even time intervals c. compares trends over uneven time or measurement intervals d. compares sizes of pieces as part of a whole

compares sizes of pieces as part of a whole

A scatter chart ____. a. compares distinct, unrelated objects over time using a horizontal format b. compares trends over even time intervals c. compares trends over uneven time or measurement intervals d. combines a column and line chart to compare data requiring different scales of measure

compares trends over uneven time or measurement intervals

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes. a. represent values graphically b. organize data c. create what-if data scenarios d. perform calculations

create what-if data scenarios

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template. a. formulas b. formatting c. labels d. data

data

Which of the following will NOT be affected or rearranged by choosing a new layout on the CHART TOOLS DESIGN tab? a. data b. legend c. titles d. gridlines

data

Each value in a cell selected for a chart is called a ____. a. data marker b. tick mark c. data point d. data series

data point

A collection of related data points is called a ____. a. data marker b. tick mark c. data point d. data series

data series

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel. a. SUM function b. redo c. fill handle d. copy/paste

fill handle

The ____ size is the physical size of the text. a. style b. format c. serif d. font

font

The ____ of a cell determines how the labels and values look. a. value b. formula c. label d. format

format

You can edit the contents of the active cell by ____. a. pressing the [Enter] key and starting to type b. pressing the [Home] key and starting to type c. just starting to type d. pressing the [Ctrl] key and the [Home] key and starting to type

just starting to type

A(n) ____ is an entry in a cell that contains text such as "2013 Sales" or "Travel Expenses." a. value b. label c. formula d. argument

label

Text annotations are ____ that you can add to further describe the data in your chart. a. arrows b. titles c. labels d. notes

labels

A(n) ____ identifies each data series in a chart, generally with a different color. a. axis b. data point c. data marker d. legend

legend

Which of the following is not an option that the Data Labels can produce? a. series name b. category name c. value of the data point d. legend name

legend name

Which chart type is the best candidate for emphasizing sales trends over a period of 6 months? a. line b. pie c. area d. scatter

line

Which two charts compare trends over time intervals? a. bar and pie b. pie and area c. area and line d. line and scatter

line and scatter

Which method of entering a function requires the user to know the name and initial characters of a function? a. manually typing the function b. using the Insert Function button c. using the Sum button d. using the Sum list arrow

manually typing the function

An Excel user should use a relative cell reference when it is important to ____. a. preserve the relationship to the formula location b. never change the formula c. preserve the exact cell address in a formula d. memorize the formula

preserve the relationship to the formula location

A small, ____ triangle appears in the upper-right corner of a cell containing a comment. a. red b. blue c. green d. yellow

red

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary. a. mixed b. absolute c. relative d. parameter

relative

You can use ____ to move around in a document that is too large to fit on the screen at once. a. cell pointers b. mode indicators c. scroll bars d. sheet tabs

scroll bars

A combination chart can add a(n) ____ axis to chart related data. a. combo b. secondary c. tertiary d. clustered

secondary

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data. a. database b. spreadsheet c. dataform d. project

spreadsheet

Cell ____ are predesigned combinations of formats. a. resolutions b. dimensions c. alignments d. styles

styles

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet. a. styles b. Formats c. Fonts d. Clip arts

styles

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click. a. text annotations b. gridlines c. markers d. styles

styles

You can use predesigned, formatted files called ____ to create new worksheets quickly. a. formatsheets b. layouts c. templates d. screens

templates

Which of the following removes only the contents of a selected row or column? a. the Delete button b. the [Delete] key c. the Delete command on a shortcut menu d. All of the above

the [Delete] key

You can ____ the chart title text to select it. a. click b. double-click c. triple-click d. right-click

triple-click

Functions can be entered for formulas using all of the following methods except ____. a. the Insert Function dialog box b. the AutoSum button c. typing the function d. typing the function argument

typing the function argument

In Excel, a worksheet is contained in a file called a ____. a. workbook b. workpad c. notebook d. datapad

workbook

In Excel, the electronic spreadsheet you work in is called a ____. a. tablet b. databook c. numericsheet d. worksheet

worksheet

On a chart created in Excel, the horizontal axis is also called the ____. a. x-axis b. y-axis c. data marker d. legend

x-axis

On a chart created in Excel, the vertical axis is also called the ____. a. x-axis b. y-axis c. data marker d. legend

y-axis