Excel Test One
a reference that refers to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column.
mixed cell reference
The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point by percentage, rather than value, and assign all the percentages below that point to the second plot.
percentage value
B1 is an example of a(n) ____ reference.
relative
a cell address without the $ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns. By default, all references in Excel are relative.
relative cell reference
small world-sized charts or graphics that are embedded within the words, numbers, and images they represent
sparklines
The ____ function adds a list of values and/or cell ranges.
sum
Each function has its own ____, which specifies the function name and order of the arguments.
syntax
In the formula =(1+2)/3<>10, Excel evaluates ____ first.
1+2
what can be found in the data tab?
Pivot Tables, What If anaylsis
In the formula =B2=C2, the second equal sign is interpreted as ____.
a rational operator
$B$1 is an example of a(n) ____ reference.
absolute
one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook. It's indicated by a dollar sign in the column or row coordinate
absolute cell reference
The >, >=, <, and <= operators also work with text, where a greater value is one that appears later in the ____.
alphabet
what can be found in the home tab?
basic functions such as font, font size, bold, italicize, underline, types of formatting, merge and center, wraptext, conditional format, auto sum
compares values across categories in a vertical orientation
column chart
what can be found in the insert tab?
creating all tables, inserting images, text boxes, word art
Stacked charts do a good job of illustrating the ____ effects of data in categories.
cumulative
The purpose of formatting is to make a chart ____.
easier for the viewer to understand
A function is always structured beginning with the function address and an opening parenthesis mark.
false
To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing.
false
TorF: Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller segments of a pie chart into a separate smaller chart.
false
TorF: Excel provides unconditional formatting tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.
false
TorF: In a line chart, values are indicated by the filled areas below the lines.
false
TorF: The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.
false
TorF: The Accounting Number Style displays values with commas and two decimal places, but no dollar signs.
false
TorF: The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.
false
TorF: You must make changes to the content of data labels using buttons in the Format Data Labels task pane.
false
With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.
high-low-close
What can be found in the formula tab?
insert funtion, logical, financial, data and time, other functions
The error message ###### means that there is ____.
insufficient width in the cell to display data, or negative date/time
displays trends over time or by category
line chart
The result of the formula =OR(I3:I21>90), where cell I5 is 92, is ____.
true
TorF: Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.
true
TorF: If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter the following formula: =3>5.
true
TorF: Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.
true
TorF: Relational operators can be used to evaluate dates.
true
TorF: The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.
true
TorF: The function inputs are referred to as arguments.
true
TorF: The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.
true
The ____ is the vertical axis where data values are plotted.
y-axis
