more vocabulary Flashcards
what is
auto-complete?
WHAT: you program offers you choices when you type
WHERE: functions in Excel, searches in google
change the axis scale
- right-click on the axis
- on the pop-up menu, choose “format axis”
- change the maximum on the SIDEBAR and hit enter
what is
“chronological”?
in order of time
(from earliest to latest)
what is another word for “number crunching”?
“data analysis”
what is a “daily average”
or “weekly average”
average by days
average by weeks
What is a sidebar?
a bar with options or information
that appears on the
SIDE of the screen (or page)
scroll bar
vertical bar on the side of the screen
you DRAG the scroll bar
in order to bring the page up and down
what is a slider?
it is a range that you can drag
how can you round a number?
=ROUND($99.99, 0)
FIRST NUMBER: the number to round
SECOND NUMBER: how many decimal places
what are
NESTED parentheses
parentheses inside parentheses
( ( ) )
=roundup(sum(a1:a10), 0)
what is a
developer?
someone who writes computer programs
or web pages
what does the “developer tab” do?
it lets you insert buttons, scroll bars, and list boxes on your spreadsheet
how do you get the developer tab
- go to the file menu and choose “options”
- choose “customize ribbon”
- click the checkbox for the “developer” tab
what is
“default”?
or
“by default”?
“default” means the ordinary state, without any changes
for example:
default text is not bold or underlined
text color is black by default
what does it mean to
customize the ribbon?
change the tabs or buttons on the ribbon
This is advanced stuff!!!
Most people never customize the ribbon
what is a legend
it is part of a graph
that explains what the colors mean
