Excel Quiz

A cell is a

• vertical space that goes up and down

• horizontal space going across

• grid made of intersection of columns and rows

• area where columns and rows intersect

Long text can be broken down into many lines within a cell, you can do this by?

• Justify

• Wrap text

• Conditional formatting

• All are incorrect.

In a worksheet you can select

• The entire worksheet

• Rows

• Columns

• All of the above

A spreadsheet is a

• horizontal space going across

• grid made of columns and rows

• area where columns and rows intersect

• verticle space that goes up and down

How are columns designated?

• Triangles

• Numbers

• Circles

• Letters

How do you tell one cell from another?

• by its address

• by numbers

• By letters

• None of these

In EXCEL, you can sum a large range of data by simply selecting a tool button called

• Auto Fill

• Auto correct

• Auto Sum

• Auto Format

In order to perform a calculation in a spreadsheet, we need to use a?

• variable

• formula

• table

• none are correct

If A1= 30, A2 = 20,I want to multiply these two cells and show output in C6. Which formula should I use?

• Write in cell C6, = Multiply A1:A2

• Write in cell C6, =30*20

• Write in cell C6, Mutiply A1 to A2

• Write in cell C6, =A1*A2

Which of the following formulas is not entered correctly?

• =10+50

• =B7*B1

• =B7+14

• 10+50