Microsoft Excel Test
25 Questions
Cancel
-
+
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
Questions and Answers
- 1.
- A.
Cell
- B.
Labels
- C.
Spreadsheet
- 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: 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.
Spreadsheet
- D.
Formulas
- 16.
![]()
Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make? - 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?
Back to top
