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 “form control”?
A button, spinner, scroll bar, checkbox, etc.
This is advanced stuff!
Most people never use form controls!!!
What is a
power user?
A “power user” is someone who knows how to use
advanced features of a software program
such as macros, customizing the ribbon, or using form controls
what is an
increment?
“increment” means “the amount of change”
What is the series of numbers:
minimum: 1
maximum: 10
increment: 1
1,2,3,4,5,6,7,8,9,10
minimum: 1
maximum: 10
increment: 1
what is teh series of numbers?
minimum: 0
maximum: 25
increment: 5
0,5,10,15,20,25
minimum: 0
maximum: 25
increment: 5
How can you get this series of numbers?
1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990, 2000
1900,1910,1920,1930,1940,1950,1960,1970,1980,1990,2000
minimum: 1900
maximum: 2000
increment: 10
What is
“fill in the values”?
type the numbers where they belong
what is a legend
it is part of a graph
that explains what the colors mean
