Multiple Choice - Practical

1.

1 point

In a database table I have a field called Price. I want to calculate a new field called Vat, which is equal to the price multiplied by 0.175. How would I type this?

vat = price * 0.175

vat: price * 0.175

vat: [price] * 0.175

vat = [price] * 0.175

2.

1 point

In Access a primary key refers to

a field that uniquely identifies a record

a unique set of fields

a record that is unique

a set of unique records

3.

1 point

In Access reports, grouping is a way to

place similar tables together

display each record separately

place similar records together

place all records in one group

4.

1 point

If the formula =C3+ B3 is copied from cell D3 to D4, the formula is changed to

=C4 + B4

=D3 +B4

=C3 + B3

=$C$3 + $B$3

5.

1 point

In Word Processing, an efficient way to move the 3rd paragraph to place it after 5th paragraph is

cut, copy and paste

copy, cut and paster

cut and paste

copy and paste

6.

1 point

Microsoft Excel allows you to enter

numbers only

text only

neither text nor numbers

text and numbers

7.

1 point

Text at the top of every page in a document is known as

headnote

footer

heading

header

8.

1 point

Which datatype would be best for storing a telephone number in a database?

date/time

autonumber

number

text

9.

1 point

In Excel

= A4 + B6

is an example of a

formula

chart

range

function

10.

1 point

I Word, an endnote appears at

the bottom of the entire document

the top of the document

the bottom of each page

the bottom of each paragraph

11.

1 point

In Excel, how would I find the average of B3 to B9?

=average(B3:B9)

average = (B3:B9)

=ave(B3:B9)

=average B3B9

12.

1 point

Which function in Excel returns the largest value of a set of numbers?

count

max

min

sum

13.

1 point

The use of the $ in formulae in Excel is an example of

absolute referencing

currency formatting

automatic recalculation

relative referencing

14.

1 point

Which of the following IS NOT a formatting feature for numbers in Excel

currency

all caps

comma

percentage

15.

1 point

Presentation software such as PowerPoint allows the user to

1. track changes
2. design tables
3. enhance public speaking
4. develop graphs to report on sales data

2, 3 and 4

none

1 and 2 only

1, 2, 3 and 4