Excel Scavenger Hunt

Give one reason using a computer is better than paper and pencil.

computers can check your spelling and help you arrange information easier

What is a spreadsheet

electronic document in which data is arranged

What 3 types of data can be entered in a spreadsheet?

labels, values, formulas

What does the average function find?

return the average (arithmetic mean) of the arguements

What will the MAX function find

the max function is a built in function in excel that is catergorized as a satistical function. it can be used asa worksheet function , the max function can be entered as part of a formula in a cell of a worksheet

How are formulas created

using functions

What are constants used for?

values that rarely change

How can you change the column width?

1. select the cloumn or columns that you want to change 2. on the home tab, in the cells group, click format 3. under cell size, click autofit collumn width

What 3 types of data can be entered in a spreadsheet?

=

What formula would you create to find the average of Cells A1, A2, and A4?

= average(A1,A2,A4)

What is the formula to find the sum of cells A1, A2, and A3?

=sum(a1:a3)

What Basic Mathematics rule do the functions follow?

PEMDAS

How should you name a cell

Select the cell, range of cells, or nonadjacent selections that you want to name. Click the Name box at the left end of the formula bar. Name box. Type the name that you want to use to refer to your selection. Names can be up to 255 characters in length. Press ENTER.

What type of data may be found in a cell

labels, values, formulas

What function will show the smallest value in the selected range of cells?

min