# Microsoft Excel Test

24 Questions | Total Attempts: 12962  Settings  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

Related Topics
• 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.
• 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: Constants are entires that do not have a specified value
• A.

True

• B.

False

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

Labels

• B.

Constants

• C.

• D.

Formulas

• 15.
Provide the formula for the following spreadsheet: If you work for 23 hours and make \$5.36 an hour, how much do you make?
• 16.
The ___________ function takes all of the values in each of the specified cells and totals their values
• 17.
The _________ function adds all of the indicated cells together and divides by the total number of cells.
• 18.
The two most widely used charts are the:
• 19.
Name the three basic parts of a spreadsheet?
• 20.
In a spreadsheet, each cell may have three types of data in them: Name all three
• 21.
What is the symbol for multiplication?
• 22.
What is the symbol for division?
• 23.
What is the symbol for addition?
• 24.
What is the symbol for subtraction?