Spreadsheet Review

Spreadsheet Review: Review the following @@ PowerPoints @@ in the Spreadsheet folder and fill in the blanks or answer the questions.

Look at the Review for Test Spreadsheet Vocabulary PowerPoint to fill in the blanks.

Descending order- is ____________ to __________ sort order or 100 to 1 order.

Relative cell referencing- _____________ formulas and automatically ____________ to correct cell range.  

In contrast, an __________________ cell reference does not change when its formula is copied and pasted to other cells.

Which symbol is used for absolute cell references? ______________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___Go to Types of Charts PowerPoint and look on slide 3 to fill in the blanks.

_____________________Chart- comparisons

Stacked Bar Chart - charts each group’s ________________________________to the whole.

Line Charts show ________________________ or changes in data over time.

XY Scatter Charts are used to indicate the __________________________ of  two or more sets of data.

Pie Charts answers the question “What is the ________________________of each part to the whole?”

Exploded Pie Chart is an ___________________________ pie chart.

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___Look at the 4.01 Advanced Functions document to answer the questions and fill in blanks.

Which function allows the computer to insert dates according to your instructions? ___________

 

VLOOKUP- Looks for a value in the ___________________________ column of a table, and then gives you a value in the ________________________row from the column specified.

 

Which function counts the number of cells within a range when given specific conditions?

To create a list: Type and highlight the __________________ you want to use. Next you will ________________________ the list in the name box (beside the ____________________Bar) then ___________________________ the cell that you want the drop-down list to appear in. Then do to _____________, Validation, Allow: List, and then source: ____(the name of your list)

 

Which function helps you control the kind of info that is entered into a worksheet? A drop-down list would be an example because you could only choose information that was entered into the list.   ___________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

___Look at the Excel if statements explained PowerPoint

Write the IF statement for IF A2 is equal to “Feline”, write “Cat” in B2, otherwise, write “Amphibian”
___________________________________________________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Play the SCATTER GAMES on the quizlet sites 
____SCATTER http://quizlet.com/4256873/spreadsheet-vocabulary-flash-cards/
____SCATTER http://quizlet.com/5002039/spreadsheet-terms-flash-cards/
____SCATTER http://quizlet.com/834955/cai-401-ss-components-flash-cards/
____Get 100% _http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg3.htm 
____SCATTER http://quizlet.com/3972846/ms-wrights-bct-obj-5-flash-cards/
_____ Hangman game get 22 out of 25 correct  http://www.quia.com/hm/174125.html  
____SCATTER http://quizlet.com/10716938/cai-obj-401-business-spreadsheets-flash-cards/
___ match words to definitions http://www.quia.com/mc/1799176.html?AP_rand=23603320 

___ match words to definitions for the link below
_http://www.quia.com/mc/2016566.html?AP_rand=1926551694 

___ You can use notes. You must get 100% for the link below. http://www.quia.com/quiz/2055803.html?AP_rand=1395669365 

___WIN a million dollars http://www.quia.com/rr/363962.html