Excel Exam
column is too narrow to display the value completely
###### 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
clip
A ____ is an individual media file, such as art, sound, animation, or a movie. a. point b. cell style c. clip d. template
embedded
A chart that is inserted directly in the current worksheet is called a(n) ____ chart. a. inner b. embedded c. sub d. interactive
data series
A collection of related data points is called a ____. a. data marker b. tick mark c. data point d. data series
compares sizes of pieces as part of a whole
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 trends over uneven time or measurement intervals
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
red
A small, ____ triangle appears in the upper-right corner of a cell containing a comment. a. red b. blue c. green d. yellow
PAGE LAYOUT
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
relative
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
column
A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default. a. line b. area c. column d. pie
legend
A(n) ____ identifies each data series in a chart, generally with a different color. a. axis b. data point c. data marker d. legend
function
A(n) ____ is a built-in formula that uses arguments to calculate information. a. label b. function c. template d. indicator
label
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
= (equals sign)
All functions begin with the formula prefix ____. a. @ (at symbol) b. = (equals sign) c. # (number symbol) d. + (plus sign)
preserve the relationship to the formula location
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
spreadsheet
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
styles
Cell ____ are predesigned combinations of formats. a. resolutions b. dimensions c. alignments d. styles
before or after data is entered
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
AutoFit
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
data point
Each value in a cell selected for a chart is called a ____. a. data marker b. tick mark c. data point d. data series
All of the above
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
data
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
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
typing the function argument
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
=(C12+C13)*F4
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
100
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
Rules Manager
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
functions
In Excel, MAX and AVERAGE are examples of ____. a. functions b. arguments c. lists d. buttons
workbook
In Excel, a worksheet is contained in a file called a ____. a. workbook b. workpad c. notebook d. datapad
worksheet
In Excel, the electronic spreadsheet you work in is called a ____. a. tablet b. databook c. numericsheet d. worksheet
equal sign (=)
In a worksheet, the ____ is called the formula prefix. a. minus sign (-) b. plus sign (+) c. pound sign (#) d. equal sign (=)
Insert Pictures
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
(G15-G14)
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
C1/F3
In the formula =D1+C1/F3, which calculation will be performed first? a. C1/F3 b. D1+C1 c. D1/F3 d. D1+F3
The number of decimal places in the rounded number
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
x-axis
On a chart created in Excel, the horizontal axis is also called the ____. a. x-axis b. y-axis c. data marker d. legend
y-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
The clipboard automatically deletes the oldest item on the clipboard
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
portrait
Possible paper orientations for printing a worksheet are landscape and ____. a. preview b. portrait c. normal d. page break
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
/
The Excel operator for division is ____. a. / b. \ c. % d. ^
^
The Excel operator for exponent is ____. a. / b. \ c. % d. ^
HOME
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
Clipboard
The Format Painter button is found in the ____ group on the HOME tab of the Ribbon. a. Alignment b. Styles c. Clipboard d. Font
REVIEW
The Spelling button is found in the Proofing group on the ____ tab on the Ribbon. a. HOME b. PAGE LAYOUT c. REVIEW d. DATA
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
format
The ____ of a cell determines how the labels and values look. a. value b. formula c. label d. format
Scale to Fit
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
font
The ____ size is the physical size of the text. a. style b. format c. serif d. font
two
The default Accounting number format adds dollar signs and ____ decimal places to the data. a. one b. two c. three d. four
.xlsx
The default file extension for an Excel 2013 workbook is ____. a. .xltx b. .xslx c. .xlsx d. .xlts
Light Red Fill with Dark Red Text
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
Excel template
The file extension .xltx indicates what type of Excel file? a. Excel template b. Excel workbook c. Excel worksheet d. Excel formulas only worksheet
horizontal and vertical axes
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
Styles
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
fill handle
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
Ribbon
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
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
[Alt][Page Up]
To move one screen to the left press ____. a. [Ctrl][Home] b. [Alt][Page Up] c. [Ctrl][Page Left] d. [Alt][Page Down]
[Ctrl][Home]
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][End]
To quickly jump to the last cell in a worksheet press ____. a. [Alt][Page Down] b. [Shift][Down] c. [Page Down] d. [Ctrl][End]
area chart
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
The data remains in its original location
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
Cell references are automatically adjusted
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
bar
Which chart type do you use to compare distinct objects over time using horizontal bars? a. area b. bar c. column d. line
line
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
scatter
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
=($A6+$A$7)*0.20
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
[F4]
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]
[F2]
Which keyboard shortcut turns on Edit mode? a. [F1] b. [F2] c. [F4] d. [F8]
manually typing the function
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
pasting cell selectors
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
=(B4/B8)*10
Which of the following is a complex formula? a. =SUM(B4:B8) b. =(B4/B8)*10 c. =AVERAGE(C6:D6) d. =MIN(D5:D7)
the [Delete] key
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
HOME tab, Cells group
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
line and scatter
Which two charts compare trends over time intervals? a. bar and pie b. pie and area c. area and line d. line and scatter
absolute
Which type of cell reference preserves the exact cell address in a formula? a. absolute b. mixed c. relative d. All of the above
triple-click
You can ____ the chart title text to select it. a. click b. double-click c. triple-click d. right-click
[Shift]
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]
Format Cells
You can apply font styles and alignment options using the ____ dialog box. a. Format Cells b. Insert c. Conditional Formatting d. AutoCorrect
HOME
You can apply font styles and alignment options using the ____ tab of the Ribbon. a. INSERT b. HOME c. PAGE LAYOUT d. VIEW
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
alignment
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
edit
You can change, or ____, the contents of an active cell at any time. a. recover b. navigate c. edit d. calculate
$
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. @
just starting to type
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
scroll bars
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
create what-if data scenarios
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
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
templates
You can use predesigned, formatted files called ____ to create new worksheets quickly. a. formatsheets b. layouts c. templates d. screens
arrow
You can use the ____ key(s) on the keyboard to navigate a worksheet. a. [Ctrl] b. Zoom c. arrow d. [Enter]
Zoom
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
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
Sheet tabs
____ 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
Conditional
____ formatting is automatically updated if you change data in the worksheet. a. Conditional b. Spatial c. Dynamic d. Data
Tick
____ marks indicate the scale of measure for each value on the y-axis. a. Datapoint b. Tick c. Axis d. Legend
Arithmetic
____ operators perform mathematical calculations such as adding and subtracting. a. Text concatenation b. Reference c. Arithmetic d. Comparison
Live Preview
____ shows you how a fill color will look before you apply it. a. Sneak Peek b. Live Preview c. Quick Look d. Advance Look
5
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
