Excel Modules 1 - 6 Review (DONE)

To find the largest value in a cell range, use the MIN function.

• True

• False

Answer explanation

You would use the MAX function.

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

• True

• False

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

• The formula =B6+B7+B8+B9+B10.

  
  

• The formula =TOTAL(B6-B10)

  
  

• The formula =SUM(B6:B10)

  
  

• The formula +SUM(B6-B10)

  
  

Cedric wants to print one page of worksheet data on two pages. Which of the following can he do?

• Insert a page break

  
  

• Add print titles

  
  

• Freeze the top row

  
  

• Change the zoom

  
  

To have Excel enter the lowest price from a range of prices, which of the following would you use?

• MAX function

  
  

• COUNT function

  
  

• MIN function

  
  

• COUNTA function

  
  

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

• Page Layout view

  
  

• Normal view

  
  

• Web Preview

  
  

• Backstage view

  
  

Which of the following is the temporary storage area that holds selections you copy or cut?

• Clipboard

• Backstage

• Name box

• Worksheet window

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

• Alignment

• Fonts

• Color

• Styles

To move a worksheet, you can drag its sheet tab to the left or right.

• True

• False

Jack wants to show sparklines with symbols for positive and negative values. He should insert Win/Loss sparklines.

• True

• False