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
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: - ProProfs]( "Name this cell:")
Name this cell: - 10.
![In the spreadsheet below, provide an example of a label? - ProProfs]( "In the spreadsheet below, provide an example of a label?")
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: - ProProfs]( "In the spreadsheet below, provide an example of a constant:")
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.
Spreadsheet
- 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? - ProProfs]( "Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?")
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?
Back to top