Intro to Spreadsheets

1. A spreadsheet package is an application package

which

• enables you to organize data as tables and perform operations on that data using functions and

  formulae.

• enables you to produce professional

  documents

• enables the production of presentations to assist teaching and

  lectures

• keeps tables of records of entities in an

  organisation

which of the following is NOT a purpose of spreadsheets

• to create simple tabulations such as invoices and price

  lists

• to hold accounting and financial

  data

• to perform advanced text

  processing

• to capture, display and manipulate numeric

  data

The intersection of a row and a column is called:

• data

• a cell

• a

  field

• an equation

When you are typing a formula into a cell the first thing that must be entered is

• $

• &

• =

• #

Labels are used in a spreadsheet to:

• give the computer

  instructions

• give information about the data being

  displayed

• set up formulae

  complete

  calculations

• complete

  calculations

the cell labelled F5 refers to

• row F, column

  5

• column F, row

  5

• a

  function

• function key F5

B5:D9 is best described as

• a row

• a cell

• a

  column

• a range

The text "Total Amount" in a cell is best described as points: 1

• a value

• a label

• a

  function

• a formula

9. Which built in Excel function is used to add all the values in a range

• COUNT

• MAX

• AVERAGE

• SUM

What's the name of the Cell that is highlighted?

• 3B

• B2

• C3

• B3