1.How many rows are there on a worksheet in Microsoft Excel 2003?

a 45635
b 65536
c 256
d 64356

2. Data can be arranged in ascending and descending order by using

a Sort command from the file menu
b Sort command from toolbar
c Sort command from the data menu
d Sort command from the table menu

3. A red triangle in the top right corner of a cell indicates

a An unprotected formula
b Number is stored as text
c The formula refers to an empty cell
d There is a comment attached to the cell

4. To select multiple cells that are non contiguous you would click them while holding down the

a CTRL key
b ALT key
c Shift key
d CTRL + Shift keys

5.Freezing panes in excel refers to

a Isolating cell so the can not be seen
b Hiding a range o f data permanently
c Locking a section of a worksheet so that it is always visible
d Hiding specific worksheets

6. A named range is

a A range of cells defined by given name
b A range of cells that contain the same text data
c A name for associated formulas
d A range of extracted names

7. If you required more then two conditions to be analysed in a list, you would use which filter

a Multi-Filter
b Auto filter
c Advanced filter
d Advantage filter

8. A formula in excel is

a A formula is a way for you to make calculations based upon data
b A recipe for associating information
c A set of properties
d Numbers and symbols

9. Excel should be primarily used for

a Data storage
b Data and text storage
c Data analysis
d Data extraction

10. In excel a macro is

a A large set of data
b A data dump
c Script that performs an action
d A macromedia file

Your Test Result is %