Excel Quiz 2

What is a cell?

• a period during which a retailer sells goods at reduced prices
• the smallest structural and functional unit of an organism
• a small room in which a prisoner is locked up
• an intersection of a row and column

Each cell has its own name or _______________based on its column and row. 

• formula address
• email address
• mailing address
• cell address

What happens when you delete the entire cell? 

• The cells below it will shift to fill in the gaps and replace the deleted cells.
• The cells above it will shift to fill in the gaps and replace the deleted cells.
• The cells left of it will shift to fill in the gaps and replace the deleted cells.
• The cells right of it will shift to fill in the gaps and replace the deleted cells.
  

What does the AutoFit feature allow you to do?

• set the column's width to the default of 12 pts
• set a column's width to fit its content automatically
• set all of the columns' widths to the same amount
• set all of the columns' widths to the default of 12 pts
  

If I want to insert a row between rows 6 and 7, which row do I select before using the Insert command?

• 6 and 7
• 7
• 6
• neither

If I want to insert a column between columns A and B, which column do I select before using the Insert command?

• B
• A
• A and B
• neither

What do number formats do? 

• They tell Excel what type of font to use.
• They tell Excel exactly what type of data you are using.
• They tell Excel what language to use.
• They tell Excel what color font to use.

What is the default number format for all data if Excel isn't able to guess which type you want to use? 

• Decimal
• General
• Percentage
• Data

If you choose Currency format, what does Excel do to the numbers in the cells? Check all that apply.

• displays 2 decimal places
• Adds a %
• displays 1 decimal place
• Adds a $

Where can you see the actual value of a cell? 

• name box
• format menu
• in the cell
• formula bar