What is a data series?

a row or column of numbers that are plotted in a chart

What gives you the sequence in which items should be calculated in an equation?

Order of Operations or Order of Precedence

How do you select ranges that are not adjacent?

Select a range/hold down Ctrl key/select other range

What is a data point?

single value in a cell that is plotted in a chart or graph

What three buttons are located to the top right of a chart to help format it?

Chart elements/chart styles/chart filters

studbud

Excel Chapter 3 - More Formulas and Charts

12 termsStudBud Administration43 plays

More formulas and charts

Flashcards12 cardsFPractice quizPHost liveL

Questions 12

Answers

1
Graphical presentation of spreadsheet data
Footer
Textbox
Chart
Picture
2
A formula such as =F5/$F$10 calculates what?
Value after increase
Percent of increase
Percent of discount
Percent of total
3
Displays the value after a projected increase percentage has been applied
Percent of increase
Value after increase
Percent of total
Value after discount
4
What is a data series?
labels for a data point
a row or column of numbers that are plotted in a chart
an arrow pointing to a particular range
single value in a cell that is plotted in a chart or graph.
5
Displays how much (the percentage] something has increased.
Percent of decrease
Percent of increase
Value after increase
Percent of total
6
What gives you the sequence in which items should be calculated in an equation?
Aunt Sally's Order
Order of Operations or Order of Precedence
Mathematical Order
Operational Sequence
7
A formula such as =B16*(100%+B12) calculates what?
Percent of increase
Value after increase
Percent of total
Percent of discount
8
How do you select ranges that are not adjacent?
Select a range/hold down Space Bar/select other range
Select a range/hold down Alt key/select other range
Select a range/hold down Shift key/select other range
Select a range/hold down Ctrl key/select other range
9
What is a data point?
labels for a data series
an arrow pointing to a particular cell
row or column of numbers that are plotted in a chart
single value in a cell that is plotted in a chart or graph
10
How many licks does it take to get to the center of a tootsie roll pop?
4
the world may never know
2
1
11
What three buttons are located to the top right of a chart to help format it?
Font/Line/Word Art
Chart elements/chart styles/chart filters
Chart Elements/Sparklines/SmartArt
Design/Format/Layout
12
A formula such as =(C5-B5)/B5 calculates what?
Percent of increase
Percent of discount
Percent of total
Value after increase

Excel Chapter 3 - More Formulas and Charts Flashcards | StudBud