EDOA101 Chapter 3 - Topic 9 ~ 12

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

• &

• =

• #

• *

A pie graph is a visual representation which of the following?

• Values change over time.

• Comparison of a piece of data to the whole group.

• A categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

In a spreadsheet formula which symbol is used to multiply? 

• +
• -
• *
• x

Which of these would multiply the numbers from A3 to A6

• *(A3:A6)

• =Multiplay(A3:A6)

• =A3*A4*A5*A6

• =Sum(a3*a6)

If I want to add up a range of cells A1 through A25, which formula would I use?

• =Sum(A1:A25)

• =Sum(A1+A25)

• (A1+A25)

• +(A1+A25)

In Excel, what do all formula begin with?

• !
• -
• +
• =

What are we doing in the example below?

• Filtering the Type column by number.

• Filtering the Type column to show only Laptops and Projectors.

• Filtering the Type column to show everything except Laptops and Projectors.

• Filtering the Type column by date.

What is being adjusted in this diagram?

• Cell A1
• Font Size
• Alginment
• Spacing

Which of the following will add in Excel header?

• Date

• Address

• Phone number

• Company logo

How to freeze panes?

• Insert > Pictures > Freeze Panes

• Review > Freeze Panes > Freeze Panes

• View > Freeze Panes > Freeze Panes

• Help > Where's Freeze Panes?