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
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
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 Question
What add-in program serves as the data analyzing tool in Excel?