EXCEL 5

The intersection of a column and a row is called a _______.

• cell

• chart

• sum

• worksheet

2.     A group of cells is called a ______.

• cell cluster

• cell range

• chart

•       multicell

3.   What is the purpose of the SUM function in Excel?

•       To add up the values in a range of cells.

•   To find the average of the values in a range of cells.

• To multiply the values in a range of cells.

• To sort the values in a range of cells.

4.     How do you use the SUM function to add up a range of cells in Excel?

• =SUM(range of cells)     

• =TOTAL(range of cells)

• =AVERAGE(range of cells)

• =ADD(range of cells)

What is one tool we can use to ensure our text fits in the cell?

• conditional formatting tool       

• Squeeze text tool            

•     Create table tool

•   Wrap text tool

   What is the formula to multiply two cells in Excel?

• A1+B

• =A1*B1     

• A1/B1

• a.      A1-B1

What are some key features of Excel that make it useful for data analysis?

• cooking, gardening, knitting, woodworking

• math problems, history essays, language translation

• sorting, filtering, pivot tables, data visualization

• word processing, graphic design, video editing, email management

  What do we use excel for?

• making presentations     

• sorting and analyzing data

• writing a letter

• talking to friends

9.     Which of the following will divide cell A1 by B1?

• B1/A1

• A1/B1

• =A1/B1

• =B1/A1

 

10.   An Excel spreadsheet is primarily used for calculating which of the following options

• data

• finances

• numbers

• all of the above