Microsoft Excel Basics

Microsoft Excel is what kind of software?

• Word Processing Software

• Spreadsheet Software

• Database Software

• Presentation Software

An Excel file format extension is

• doc

• xls

• txt

• mp3

The numbers in Excel represent the...

• Rows

• Columns

• Cells

• Data

When creating a chart in Excel, what is the first thing you need to do?

• Select the data to be graphed.

• Select the Insert Tab

• Choose a chart from the ribbon

• Double click the active cell

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

• &

• =

• #

• *

What function adds all of the numbers in a range of cells?

• Calculate

• Compute

• Sum

• Max

To sort data in Excel, go to the __________ ribbon.

• Home

• Data

• Insert

• View

What does the mouse look like in a spreadsheet?

• Arrow

• Pointer

• Two headed arrow

• Selection cross

If I want to find an average of cells A1 through A25, which formula would I use?

• =average(A1:A25)

• =avg(A1:A25)

• =average(A1-A25)

• =avg(A1-A25)

Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 

• =(A1+A2+A3)/4
• A1+A2+A3/4
• =A1+A2+A3^4
• (A1+A2) + A3/4