EXCEL Basics
Looking GOOD!
Charts
Math
Misc.
100
____________ is a spreadsheet, graphing software that can perform math functions.
What is EXCEL.
100
Changing the appearance of a table or spreadsheet is called _______________.
What is Formatting.
100
A chart is a visual representation of the ________.
What is data.
100
The math formulas used in EXCEL are called ___________.
What are Functions.
100
The ________ command can automatically change the order of of our data, either acending (A-Z) or descending (Z-A).
What is Sort command.
200
One box in an EXCEL table or spreadsheet is called this.
What is a cell.
200
____________ are a visual representation of the data and help use to understand the data.
What are graphs or charts.
200
If we want out graph or chart to look the way we want it to, we must select _______________.
What is the Correct Data.
200
We used an automatic funtion command to quickly add up our data called _____________.
What is AutoSum.
200
EXCEL can be used to create useful documents that allow us to input data and see immediate output of useful information. (True or False)
What is True.
300
_________ go ACROSS the page, not up and down.
What are ROWS.
300
The frame of a table or spreadsheet is called a __________.
What is a border.
300
Charts and graphs can use different colors to show different data item. (True or False)
What is True. This makes it easier to read and understand.
300
The funtion we used to add the sum of all numbers and divide by the number of numbers is called __________.
What is Average.
300
______________ is small picture or drawings, that can be placed into EXCEL to help the viewer know what our data is about.
What is Clip Art.
400
_____________ go up and down a page, not across.
What are Columns.
400
We set up the _______________ command to help us format our data automatically.
What is the Auto Format command.
400
Charts and graphs can only be placed in the upper left-hand corner of a page. (True or False)
What is False. The can be placed anywhere on the page.
400
By using the Black Crosshair feature in EXCEL, we can copy a funtion from one cell to the next and have it automatically adjust the cell range. (True or False)
What is True. This makes inserting funtions MUCH faster and easier.
400
Clip art can be place _______________ within the speardsheet.
What is Anywhere.
500
A ____________ or ____________ is a tool for organizing information into rows, columns, and cells.
What are Table or Spreadsheet.
500
When we set up our Auto Format command, we placed it into _________ ________ Toolbar.
What is Quick Access.
500
The listing of what data is represented by each color is shown with little color boxes in the ____________.
What is the Legend.
500
The most powerful feature of EXCEL is that it can use __________ in the table data.
What is MATH.
500
EXCEL, like WORD and PowerPoint, is designed to help us __________________, or tell the viewer something.
What is Communicate.