Microsoft Offie Excel Units A,B,C,D & E

in excel, the electronic spreadsheet you work work in is called a ______
A) tablet
B) databook
C) numericsheet
D) worksheet

in excel, a worksheet is contained in a file is called
A) workbook
B) workpad
C) notebook
D) datapad

you can use the 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

all excel formulas begin with the ____
A) +
B) *
C) =
D) slash

Excel recognizes any entry as a value if it is a number or it begins with _____
A) +
B) =
C) $
D) all of the above

you can use the _____ key(s) on the keyboard to navigate a worksheet
A) [Ctrl]
B) zoom
C) arrow
D) [enter]

to move one screen to the left press _____
A) [Ctrl][Home]
B) [Atl][Page Up]
C) [Ctrl][Page Left]
D) [Alt][Page Down]

to quickly jump to the last cell in a worksheet press ____
A) [Alt][Page Down]
B) [Shift Down]
C) [Page Down]
D) [Ctrl][End]

the Undo button allows you to reverse up to ____ previous actions, one at a time
A) 1
B) 10
C) 100
D) 1,000

Possible paper orientations for printing a worksheet are landscapes and _____
A) preview
B) portrait
C) normal
D) page break

In the formula =(G15-G14)*$M$3/4, which mathematical operation if performed first?
A) $M$3/4
B) (G15-G14)*$M$3
C) (G15-G14)
D) (G15-G140)/4

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

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) that data remains in its original function
D) the data is moved to another location and removed from its original location

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

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

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

which formula contains a mixed cell reference?
A) =(A6=A7)*.20
B) =($A$6+A7)*.20
C) =($A$6+$A$7)*.20
D) =($A6+$A$7)*.20

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

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

t0 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

Excel templates make a creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template
A) formulas
B) formatting
C) labels
D) data

the file extension .xltx indicates what type of Excel file?
A) excel template
B) excel workbook
C) excel worksheet
D) excel formulas only worksheet

the default file extension for an Excel 2013 workbook is ____
A) .xltx
B) .xslx
C) .xlsx
D) .xlts

the ____ of a cell determines how the labels and values look.
A) value
B) formula
C) label
D) format

the default Accounting number format adds dollar signs and ____ decimal places to the data
A) one
B) two
C) three
D) four

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 ____ group on the HOME tab, and the clock a style in the gallery.
A) Alignment
B) Styles
C) Cells
D) Editing

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

you can apply font styles and alignment options using the ____ tab of the Ribbon
A) INSERT
B) HOME
C) PAGE LAYOUT
D) VIEW

You can apply font styles and alignment options using the _____ dialog box
A) format cells
B) insert
C) conditional formatting
D) autocorrect

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

the format painter button is found in the _____ group on the HOME tab of the Ribbon.
A) Alignment
B) Styles
C) Clipboard
D) Font

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 common on a shortcut menu
D) All of the above

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

____ shows you how a fill color will look before you apply it
A) Sneak Peek
B) Live Preview
C) Quick Look
D) Advance Look

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

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

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

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, clocking the Insert list arrow in the Cells group on the HOME tab, then clicking Insert Sheet.
A) [Esc]
B) [Shift]
C) [F4]
D) [Alt]

the spelling button is found in the proofing group on the _____ tab on the Ribbon.
A) HOME
B) PAGE LAYOUT
C) REVIEW
D) 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

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.
A) line
B) area
C) column
D) pie

To show how individual volume changes over time in relation to total volume, us a(n) ______
A) area chart
B) bar chart
C) column chart
D) line chart

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

a combination chart can add a(n) ____ axis to chart related data
A) combo
B) secondary
C) tertiary
D) clustered

In a pipe chart, slices that are pulled away are said to be ____
A) identified
B) exploded
C) opened
D) extracted

a common example of a text delimiter is ____
A) ,
B) =
C) +
D) (

the CONCATENATE function joints two or more ___ into one.
A) strings
B) formulas
C) cells
D) function

which excel function averages cells in a range based on a specific condition?
A) AVERAGEIF
B) AVERAGE
C) COUNTIF
D) SUMIF

which button do you click on the Function Library group to select SUMIf from the list of functions?
A) statistical
B) Math & Trig
C) Math Functions
D) Trig & Calculus

Which error code will display if a formula contains a text error?
A) #NA
B) #NUM!
C) #NAME?
D) #####

Which error code will display if a value in a formula is not available?
A) #NAME?
B) #VAL
C) #NONE
D) #NA

which error code will display if a number is used invalidly in a cell?
A) #NUM!
B) #VAL
C) #VALUE!
D) #NAME?

when used in formulas, names become ____ cell references by default.
A) absolute
B) relative
C) linked
D) unlinked

which of the following is not a valid named range?
A) Alaska59
B) New quote
C) salary
D) Top_Sales

a condition that can be answered with a true or false response is called a(n) ____
A) logical test
B) what-if analysis
C) True_False condition
D) IF analysis