NEW
Font size
WorksheetsIntro to Spreadsheets
Total questions: 15
Worksheet time: 8mins
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
Name the image.
Cell Reference
Name Box
Formula Bar
Standard Toolbar
