Chapter 4 ✅

Question 1

what does a spreadsheet contain and why

Answer 1

worksheets - used to present and manipulate data

Question 2

to allow applications to perform +-= and re +-= auto

what are spreadsheets designed for

Answer 2

to allow applications to perform calculations and recalculations automatically

Question 3

column (t) and row refrences (5)

what does a cell contain

Answer 3

a cell has a column reference (a letter) and a row reference (a number)

Question 4

T,N,D,F or refrence to another c

what ways can cells store data

Answer 4

text, number, date, formula or a reference to another cell

Question 5

Guys Named Cillian Don’t Tip People

what can spreadsheet data be formatted as

Answer 5

general, number, currency, date, time and percentages

Question 6

allows user to control C and A

what does cell formatting allow

Answer 6

allows a user to control the contents and appearance of a cell

e.g. aligning text, changing the font, adding a border or adding background color

Question 7

what does conditional formatting allow

Answer 7

allows a specified format to be applied to a cell or a group of cells