Standard Grade Computing Gpp1

Front 1

What does the term 'replication' mean in a
spreadsheet?

Back 1

Replication means to copy a cell contents to
another cell

Hint 1

to do with a copy

Front 2

Name two ways that a cell in a spreadsheet
can be formatted

Back 2

Alignment - centre/left right and Number of
decimal places

Hint 2

the way a cell looks

Front 3

What is the name of the feature that prevents
a cell from being altered?

Back 3

Cell protection will 'lock' a cell from change

Hint 3

the cell is locked

Front 4

What function would you use in a spreadsheet
to get the highest number from cell B3 to B7

Back 4

The 'maximum' function would be used and
the formula would be = max(b3:b7)

Hint 4

highest number is the clue

Front 5

Explain the difference between absolute
replication and relative replication

Back 5

Absolute replication is an identical copy of
the original formula. Relative replication
means the rows and column reference
change

Hint 5

one is the same and the other has changes

Front 6

Name two graphic tools used when drawing a
house

Back 6

A line tool and a rectangle tool can be used
when drawing a house

Hint 6

think of any object or shape in a simple house

Front 7

Name a drawing tool use to draw a car

Back 7

Rectangle tool and circle tool (wheels) can be
used to draw a car.

Hint 7

think of a simple drawing of a car. What shapes are ther?

Front 8

If a graphic does not fit on a page what can be
done to correct the problem?

Back 8

Scale the graphic so it is smaller and it will
fit on the page.

Hint 8

making it smaller is not the correct technical term

Front 9

A graphic of an arrow is pointing South. How
can you make it point North?

Back 9

Select the graphic and rotate it 180 degrees.
This will point the arrow in the opposite
direction.

Hint 9

you need to select it first then.....

Front 10

How can you get a graphic which has been
draw by hand into the computer?

Back 10

Scan the graphic using a scanner. This will
get the image into the computer

Hint 10

use a device connected to the computer

Front 11

If there is a graphic of a class photo what can
you do to isolate your image from the rest of
the group?

Back 11

Crop the graphic to remove your image from
the group

Hint 11

not cut it out ....something else

Front 12

When drawing a graphic explain the meaning
of a 'tool attribute'

Back 12

A tool attribute is the settings of a drawing
tool e.g. a line can be thick or thin, red or
blue. Colour and thickness are attributes

Hint 12

what you can do to a shape drawn by a tool

Front 13

What is a 'standard paragraph?'

Back 13

A standard paragraph is a paragraph which
has been saved and can be inserted into a
document

Hint 13

a paragraph that you may use again and again so....

Front 14

What feature of a word processor can be used
to replace the name "Albert" with "Harry"
throughout a document in one operation?

Back 14

Search and Replace would be used to search
for all occurrences of "Albert" and replace
with "Harry"

Hint 14

look for it and make the change...(not the right wording!)

Front 15

Why are some words highlighted as spelling
errors in a word processor when they are
correct?

Back 15

The words are not in the computer's
dictionary e.g. people's names and place
names

Hint 15

Why do you not knpow how to spell words? Same idea for the computer.