McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Centre | Lecturer Centre | Info Centre | HOME

Appendices
Mini-case Solutions
Extra Datasets
Buy the Book
Excel Spreadsheets
Exercise Solutions
Self-test Questions
Additional Exercises

Jacket
Quantitative Methods for Business & Management
Frank Dewhurst, UMIST, UK
Quantitative Methods and what this book is all about

Self-test Questions



1

Quantitative Methods is important for business and management because many of the underlying disciplines involve the use of scientific method.
A)TRUE
B)FALSE
2

Scientific Method involves
A)Lots of mathematical calculations
B)Proving with certainty what will happen
C)Using data in a systematic way to draw conclusions
D)Only using numbers
E)None of the above
3

A model is always
A)A mathematical construct
B)A simplification of reality
C)A replication of reality
D)A and B
E)A and C
4

Spreadsheets are designed to facilitate calculations in quantitative methods.
A)TRUE
B)FALSE
5

Spreadsheets are computer programmes which
A)Consist of cells in which numbers and formulae can be entered
B)Consist of cells in which text can be entered
C)Provide an electronic form of a card index box
D)A and B
E)None of the above
6

The programme Microsoft Excel is a spreadsheet.
A)TRUE
B)FALSE
7

Which of the following ways will not open the programme Excel on your computer (assuming that it is ‘loaded’ onto your computer)?
A)Double clicking the Excel short-cut icon on the desktop
B)Turning the computer power off and then on again
C)Use the Start button and select open office document and then double click blank workbook
D)Use the Start button and select programs, Microsoft office, Microsoft Excel
E)All of the above
8

In Excel, data is stored in a worksheet.
A)TRUE
B)FALSE
9

In Excel, a workbook is
A)Defined as 100 cells entity
B)Defined as 1000 cells
C)A collection of worksheets which are saved as a single entity
D)A collection of rows and columns of cells in a worksheet
E)None of the above
10

In Excel, the data, formula or text is entered in the name box as you type.
A)TRUE
B)FALSE
11

Editing a cell is undertaken by pointing at the cell, changing the text in the formula bar and then by:
A)Clicking on the green tick
B)Clicking on the red cross
C)Pressing the enter key
D)A or C
E)B or C
12

Copy and paste is useful
A)Only for copying numbers from one cell to another
B)Only for copying formulas from one cell to another
C)To copy the contents of one cell to one or more other cells
D)To move the contents of one cell to another
E)To make the contents of the cell appear in italic font
13

If you want to move the contents of one cell to another you should use:
A)Copy and paste
B)Cut and paste
C)Delete
D)Highlight the cell that you want to move and click the red cross
E)Highlight the cell you want to move and click the green tick
14

To format a cell you must:
A)Select the cell(s) by highlighting it/them and then click on the green tick
B)Select the cell(s) by highlighting it/them and press the F2 button
C)Select the cell(s) by highlighting it/them and then click on the red cross
D)Select the cell(s) by highlighting it/them and then choose the relevant format action.
E)Any of the above
15

Microsoft Excel always has available a number of additional data analysis tools which are useful for quantitative methods.
A)TRUE
B)FALSE






Copyright2003 A McGraw-Hill Online Learning Centre
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Education Europe is one of the many fine businesses of The McGraw-Hill Companies.