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