# Microsoft Excel Test

25 Questions

During this quiz/test, each student will be able to: § Be introduced to Microsoft Excel § Be able to describe what a spreadsheet is § Describe a spreadsheet (cells, rows, and columns) § Describe types of data in spreadsheets (labels, constants, and formulas) § Creating and understanding formulas

• 1.
• A.

Cell

• B.

Labels

• C.

• D.

Formulas

• 2.
What is not a basic part of a spreadsheet?
• A.

Formula

• B.

Cell

• C.

Row

• D.

Column

• 3.
Which of the following data can be put inside a cell?
• A.

Row

• B.

Column

• C.

Constant

• 4.
In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
• 5.
In a spreadsheet, the __________ is defined as the vertical space that is going across the window.
• 6.
_____________ are used to designate each column's location.
• 7.
___________ are used to designate each row's location.
• 8.
In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.
• A.

Labels

• B.

Cell

• C.

Formulas

• D.

Numbers

• 9.
Name this cell:
• 10.
In the spreadsheet below, provide an example of a label?
• 11.
True or False: Labels do not have a value associated with them
• A.

• 12.
True or False: Constants are entires that do not have a specified value
• A.

True

• B.

False

• 13.
In the spreadsheet below, provide an example of a constant:
• 14.
All formulas must begin with what?
• 15.
____________  are entires that have equations that calculates the value to display. n
• A.

Labels

• B.

Constants

• C.

• D.

Formulas

• 16.
• 17.
The ___________ function takes all of the values in each of the specified cells and totals their values
• 18.
The _________ function adds all of the indicated cells together and divides by the total number of cells.
• 19.
The two most widely used charts are the:
• 20.
Name the three basic parts of a spreadsheet?
• 21.
In a spreadsheet, each cell may have three types of data in them: Name all three
• 22.
What is the symbol for multiplication?
• 23.
What is the symbol for division?
• 24.
What is the symbol for addition?
• 25.
What is the symbol for subtraction?
Related Quizzes
Featured Quizzes
Related Topics