Excel Unit 1 Test

Which of the following groups on the Home tab contains the commands to insert,

delete and format cell width and height?

• Numbers

• Styles

• Cells

Karl wants to change the page orientation of the printed worksheet. Which group

on the Page Layout tab contains the command to complete this action?

• Themes

• Sheet Options

• Page Setup

All formulas must begin with which of the following symbols?

• =

• +

• *

Which of the following groups on the Formulas tab contains the ability to turn on

Formula view?

• Function Library

• Formula Auditing

• Calculations

Which of the following adds the values in cells A1 through A10?

• =SUM(A1:A10)

• SUM(A1:A10)

• +SUM(A1!A10)

Alex wants to find the lowest value in a range of cells. Which of the following

functions should he use?

• =MIN( )

• =MAX( )

• =AVERAGE( )

Alex wants to find the highest value in a range of cells. Which of the following

functions should he use?

• =MEDIAN( )

• =MAX( )

• =MIN( )

If you wanted to find the average of a range of numbers, what formula would you use?

• =AVERAGE( )

• =SUM( )

• AVERAGE( )

What does the image show below?

• Active Cell

• A Formula

• A Row

Which of the following is displayed in the image?

• Auto Complete

• Auto Fill

• Flash Fill