MICROSOFT EXCEL QUIZ

Division symbol in spreadsheet.

• /

• +

• =

Multiplication symbol in Microsoft Excel

• &

• *

• ^

The numbers in Excel represent the...

• Rows

• Columns

• Cells

• Data

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

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

To sort names in a worksheet, we can use this button.

• 
• 
• 
• 

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

• Formula

• Formula Bar

• Cell Address

• Cell Grid

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

• Active Cell

• Formula

• Cell

• Cell address