Excel Test By T. Batool A.Rahim
25 Questions
| Total Attempts: 84
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 ________________ consists of a grid made from columns and rows?
- A.
Cell
- B.
Labels
- C.
Spreadsheet
- D.
Formulas
- 2.Which of the following data can be put inside a cell?
- A.
Row
- B.
Column
- C.
Constant
- 3.In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
- 4.In a spreadsheet, the __________ is defined as the vertical space that is going across the window.
- 5.___________ are used to designate each row's location.
- 6.In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.
- A.
Labels
- B.
Cell
- C.
Formulas
- D.
Numbers
- 7.
Name this cell: - 8.
In the spreadsheet below, provide an example of a label?
- 9.True or False: Labels do not have a value associated with them
- A.
True
- B.
False
- 10.True or False: Constants are entires that do not have a specified value
- A.
True
- B.
False
- 11.
In the spreadsheet below, provide an example of a constant:
- 12.All formulas must begin with what?
- 13.____________ are entires that have equations that calculates the value to display. n
- A.
Labels
- B.
Constants
- C.
Spreadsheet
- D.
Formulas
- 14.
Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?
- 15.The ___________ function takes all of the values in each of the specified cells and totals their values
- 16.The _________ function adds all of the indicated cells together and divides by the total number of cells.
- 17.What is the symbol for multiplication?
- 18.What is the symbol for division?
- 19.What is the symbol for addition?
- 20.What is the symbol for subtraction?
- 21.What is not a basic part of a spreadsheet?
- A.
Formula
- B.
Cell
- C.
Row
- D.
Column
- 22._____________ are used to designate each column's location.
- 23.The two most widely used charts are the:
- 24.Name the three basic parts of a spreadsheet?
- 25.In a spreadsheet, each cell may have three types of data in them: Name all three
Questions: 22 | Attempts: 7472 | Last updated: Mar 22, 2022
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...
Questions: 10 | Attempts: 4495 | Last updated: Mar 22, 2022
-
Sample QuestionHow do you spell check an Excel worksheet?
A Data Analyst is skilled enough to translate numbers into comprehensible words and meanings of business data, sales and logistics. He collects the data and information and uses it to promote a company or help it make a...
Questions: 10 | Attempts: 3581 | Last updated: Mar 22, 2022
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?
Back to top