mc - spreadsheet

7/28/2019 Mc - Spreadsheet

1/3

Spreadsheet

Multiple Choice

Identify the choice that best completes the statement or answers the question.1. Text entered into a spreadsheet is aligned towards

the left by default. These entries are called

a. values

b. labels

c. formulae

d. functions

2. Which of the following formatting features is

unique to numbers in spreadsheets?

a. Bold

b. Custom

c. Italicsd. Indent

3. To centre the title rows of a spreadsheet across the

columns

a. centre align the title rows

b. centre align the title columns

c. merge and centre title rowsd. merge and centre title columns

4. Formulae in a spreadsheet involve

a. cell addresses, values and labelsb. cell addresses, values and mathematical

operators

c. cell addresses and labels

d. cell addresses and values

5. The term used to describe text in a spreadsheet that

is aligned towards the left by default is

a. value formulae

b. headings

c. labels

d. values

6. Which of the following is the default justificationof numbers in spreadsheets?

a. Left

b. Full

c. Centred

d. Right

7. When a cell from a spreadsheet is absolute

referenced,

a. its value becomes constant

b. its cell address becomes constant

c. its label becomes constant

d. its cell value changes automatically

8. Spreadsheet formulae use

a. values, labels or cell addressesb. values, mathematical operators, cell addresses

c. labels or cell addresses

d. values or cell addresses

9. Which of the following is NOT involved in

extraction or filtering of records in spreadsheets?

a. Value range

b. Criteria range

c. List range

d. Copy to range

10. What type of chart is NOT suitable for representing

data over two years as shown in the table below?

Country 2009 2010A 300 600

B 500 800

C 500 600

a. Line chart

b. Column chart

c. Bar chart

d. Pie chart

11. Which of the following is NOT associated with the

filtering or extraction of records in a spreadsheet?

a. Copy to range

b. List rangec. Criteria range

d. Value range

12. The function that produces the position of a number

or item in a sorted list is


2/3

a. Sum

b. Vlookup

c. Rank

d. Count


3/3

Spreadsheet

Answer Section

MULTIPLE CHOICE

1. ANS: B PTS: 1 NOT: CSEC Specimen 20082. ANS: B PTS: 1 NOT: CSEC Specimen 2008

3. ANS: C PTS: 1 NOT: CSEC Specimen 2008

4. ANS: B PTS: 1 NOT: CSEC Specimen 2008

5. ANS: C PTS: 1 NOT: CSEC June 2010

6. ANS: D PTS: 1 NOT: CSEC June 2010

7. ANS: B PTS: 1 NOT: CSEC June 2010

8. ANS: B PTS: 1 NOT: CSEC June 2010

9. ANS: A PTS: 1 NOT: CSEC June 2010



12. ANS: C PTS: 1 NOT: CSEC June 2011

mc - spreadsheet

Documents