Microsoft Excel Test

25 Questions  I  By Shane.clay on February 22, 2009
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

  

Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  A ________________ consists of a grid made from columns and rows?
A.
B.
C.
D.
2.  What is not a basic part of a spreadsheet?
A.
B.
C.
D.
3.  Which of the following data can be put inside a cell?
A.
B.
C.
4.  In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
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.
B.
C.
D.
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.
B.
12.  True or False: Constants are entires that do not have a specified value
A.
B.
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.
B.
C.
D.
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


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz