Excel 2016

If you want to compare parts to the whole, which type of graph/chart would work the best?

• Pie

• Bar

• Column

• Line

Which of these will you find on the AutoSum dropdown menu?

• All of them

• MUL

• DIV

• SUM

Which of the following is considered a range in Excel?

• 9B:30C

• A1:B8

• A1, C22, D14

• They are all ranges

Clicking this icon after selecting the range, will result in all selected cells merging into one larger cell.

• Merge and Center

• Center

• Wrap Text

• FlashFill

Which of the following is the Name Box?

• A

• B

• C

• D

Which of the following is a row?

• A

• B

• C

• D

Which of the following is a column?

• A

• B

• C

• D

What is the address of this cell?

• B3

• 3B

• AB3

• None of them is correct

Where do your formulas appear when you type them in a worksheet?

• Name Box

• Formula Bar

• Search Box

• Function Bar

Which one of these icons will increase decimal places?

• A

• B

• C

• D