Spreadsheet Questions

Spreadsheets: An Overview
1.Which statements are true concerning password-protecting spreadsheets?

Passwords reduce the risk of data being viewed by an unauthorised individual
Passwords eliminate the risk of data being altered by an unauthorised person
Passwords should be written down to prevent them from being forgotten
A) I only
B) I and II only
C) I and III only
D) I, II and III
2.Which of the following statements is false?
A) Spreadsheets can be used to produce management accounts.
B) Spreadsheets are well suited to word processing tasks.
C) Spreadsheets can be used for budgeting and forecasting.
D) Spreadsheets make the calculation and manipulation of data easier and quicker.
3.Which of the following tasks is not suited to a spreadsheet?
A) Analysing a company’s sales by product
B) Producing a basic cashflow forecast
C) Producing an accountancy procedures manual
D) Checking a depreciation calculation
4. Which type of chart would be best used to show the relative size of component
elements of a total?
A) Scatter diagram
B) Bar chart
C) Pie chart
D) Line graph
Spreadsheets skills 1
1. The following spreadsheet calculates raw material's monthly and quarterly costs. A
formula has been entered in cell C4, and then the fill command is used to copy the formula
into C5 to C6.
A B C D
1 Material cost per kg (£) 25.00
3 Usage per month (kg) Cost (£)
4 Jan 345 8,625.00
5 Feb 240 6,000.00
6 March 680 17,000.00
7 Total 1265 31,625.00
Using the fill command, which formula entered in C4 will produce the correct
formulae in C5 and C6?
A) =B1*B4
B) =$B1*$B4
C) =$B$1*B4
D) =B$1*B$4
2. The spreadsheet below records the monthly unit sales from April to September.
A B C
1 Sales (units)
2 April 12,000
3 May 12,350
4 June 10,670
5 July 13,890
6 August 13,780
7 September 12,750
8 Total 75,440
9 Monthly average 12,573
Which statements are true?
(1) The command to total the cells B2 to B7 is expressed as =add(B2:B7)
(2) The calculation in cell B9 is suited to using a spreadsheet function.
A. 1 only
B. 2 only
C. 1 and 2
D. Neither
3. Two statements about spreadsheets follow.
1. $A$4 is an absolute cell reference.
2. A formula cannot be copied if it contains an absolute cell reference.
Is each statement true or false?
A. Statement 1 is true, Statement 2 is false
B. Both statements are true
C. Statement 1 is false, Statement 2 is true
D. Both statements are false
4.Which action could be achieved using the AutoFill feature?
A. Fit spreadsheet contents to a single page
B. Copy a cell comment to adjacent cells
C. Extend a sequential series of data
D. Automatically apply a filter to a set of data
5. What is the correct formula for adding the values in cells B12 and C13 and multiplying
the result by the value in cell C25?
A. =B12+C13/C25
B. =B12+C13*C25
C. =(B12+C13)/C25
D. =(B12+C13)*C25
6. Hannah is working on a spreadsheet containing the total sales value for the year 20X7 in cell
D70. Hannah has been instructed to calculate the 20X8 forecast sales figure, in cell F70, by
adding 7.5% to the 20X7 total sales figure.
Which formula would calculate the correct figure?

A. =D70*1.75
B. =D70/1.075
C. =D70*1.075
D. =D70/1.75
7. Two statements about relative cell references in spreadsheets follow.
1. $D$9 is an example of a relative cell reference.
2. A relative cell reference in a formula changes when the formula is copied to
another location.
8. The sales achieved by each of the 20 sales representatives in a company have been entered
into column C of a spreadsheet, occupying cells C1 to C20. An appropriate formula has been
entered into cell C21 to calculate total sales.
Which formula can be used to calculate average sales per representative?

A. =C21/20
B. =AVERAGE(C21)
C. =C21*0.05/20
D. =SUM(C1:C20)
Spreadsheets skills 2
1. A spreadsheet has been created to hold the following data fields:
Product code
Product name
Location in warehouse
Cost per unit
Number of units in warehouse
Date of last sale
Total Value
Which data manipulation function would be most beneficial to a management
accountant when deciding whether to cease holding certain product types?
A. Filter on value > $1000
B. Sort on total value in descending order
C. Sort by date of last sale in ascending order
D. Filter on the number of units in the warehouse >150
2. Adam is working on a spreadsheet containing figures ranging from a thousand dollars to
twenty thousand dollars. Adam is considering how best to format the summarised figures to
present to the company’s Board of Directors.
Which format would be most appropriate?

A. $1000.00
B. $1,000.00
C. $1,000
D. $1000
3. Which column header has formatting that has not been applied consistently
throughout the column?
date ref Item $ Bal $
01-Mar-09 XX1 10.56 10.56

05-Mar-09 XX2 1235.0 1,245.56
16-Mar-09 XX3 1,776.90 3,022.46
A. Date column
B. Ref column
C. Item $ column
D. Bal $ column
4. Joe enters a product code, 10467, into a cell. Joe wants the spreadsheet to treat the code as
text rather than value.
When entering the code, what character should Joe precede the code with?
A. A dollar sign $
B. An apostrophe ‘
C. An equals sign =
D. An exclamation mark !
Presenting information Using spreadsheets
1. The following error message is shown #DIV/0!
Which statement describes the error that has occurred?
A. The formula referenced a blank cell
B. The formula attempted to divide by zero
C. There is an erroneous cell reference in the formula
D. There is an error in the formula name.
2. A spreadsheet user wishes to print a section of their spreadsheet. A print area has already
been defined, but this excludes some of the data which needs to be printed.
Which actions could be used to print the required area?

1. Selecting the ‘Quick Print’ option
2. Selecting a range and specifying to print that range
3. Setting a new print area and then selecting ‘Quick Print’
A. 1 and 2
B. 2 and 3
C. 1 and 3
D. 1, 2 and 3
3. Ali is working on a large spreadsheet. Ali wants the titles entered in rows A to C to remain
visible on the screen when he scrolls down the worksheet.
What spreadsheet feature would enable the titles to remain visible when users
scroll down the worksheet?
A. Freeze Panes
B. Wrap Text
C. Zoom
D. Switch Windows
4. Alex wishes to enter a cell comment in cell D17.
Which is the correct command sequence that enables Alex to enter a cell
comment in cell D17?
A. Function key F5, D17, OK, Double click, Insert comment
B. Function key F7, D17, OK, Right-click, Insert comment
C. Function key F5, D17, OK, Right-click, Insert comment
D. Function key F7, D17, OK, Double click, Insert comment
Spreadsheets: Role, Design and Limitations
1. Which task would a spreadsheet be LEAST appropriate for?
A. Producing a chart
B. ‘What-if’ analysis
C. Report writing
D. Producing a budget
2. Which statements are possible limitations of a spreadsheet model?
1. Spreadsheet models may be too simplistic.
2. The contents of unprotected cells may be accidentally overwritten or deleted.
3. Incorrect use of relative and absolute references in copied formulae
A. 1 and 2
B. 1 and 3
C. 2 and 3
D. 1, 2 and 3
3. A wages spreadsheet has been created to calculate monthly gross wages for each staff
member and the company’s total. It consists of rates of pay and hours worked for each
employee.
What is LEAST LIKELY to be an advantage of this spreadsheet?

A. Rates of pay can be changed to see the effect on gross wages
B. The spreadsheet model can be used each month
C. The spreadsheet will prevent employees from being assigned an incorrect pay
rate
D. Formulae can be used to update calculations when data is changed
automatically
4. When considering the design of a spreadsheet, what is LEAST likely to be relevant?
A. The number of cells required
B. The most appropriate formatting
C. How to ensure a consistent layout
D. How best to organise individual worksheets
5. Which task is BEST suited to spreadsheet software?
A. Recording staff details
B. Analysing expenses against target figures
C. Producing lists of product details
D. Listing customer feedback
6. Which design weaknesses listed below are present in this spreadsheet?
date units of stock $ ref
kg
01-Mar-09 250.09 1,789 AH1
02-Mar-09 67 9.55 AH1
14-Mar-09 53.2 7 AH1
25-Mar-09 76.998 10.7765 AH1

I.There is an unnecessary empty column
II.The number values are not formatted consistently
III.The format used to display dates is confusing
IV.The alignment of the ‘kg’ heading is inconsistent with the kg values
A) I & II only
B) II & III only
C) II & III & IV only
D) I, II and IV only
7. Two statements about spreadsheets follow.
1. Spreadsheet software is an example of an accountancy software package.
2. Spreadsheets are general-purpose software suited to some management
accountancy tasks.

Spreadsheet Questions

Uploaded by

Copyright:

Available Formats

Spreadsheet Questions

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Spreadsheet Questions

Uploaded by

Copyright:

Available Formats

Spreadsheets: An Overview

1.Which statements are true concerning password-protecting spreadsheets?

1 Material cost per kg (£) 25.00

3 Usage per month (kg) Cost (£)

4 Jan 345 8,625.00

5 Feb 240 6,000.00

6 March 680 17,000.00

7 Total 1265 31,625.00

Which formula would calculate the correct figure?

Which formula can be used to calculate average sales per representative?

Which format would be most appropriate?

01-Mar-09 XX1 10.56 10.56

Which actions could be used to print the required area?

What is LEAST LIKELY to be an advantage of this spreadsheet?

01-Mar-09 250.09 1,789 AH1

02-Mar-09 67 9.55 AH1

14-Mar-09 53.2 7 AH1

25-Mar-09 76.998 10.7765 AH1

You might also like