1) Within a database which data type should be used if keying in a phone number? a) Numbers b) Date/Time c) Short Text 2) When sorting information into descending order which way would it go? a) A-Z b) Z-A 3) Chronological order means... a) Numbers from highest to lowest b) Z to A c) From the earliest date and time to the most recent. 4) 20% of £12,000 is a) £240 b) £1,200 c) £2,400 d) £6,000 5) Within a database a primary key is... a) A unique identifier  b) The order of the records c) Date of birth 6) Within a database salary should be shown in which format or data type? a) Date/Time b) Short Text c) Currency  d) Pounds e) Number 7) What is the AVERAGE of the follow numbers, 5, 8, 2, 9, 1. a) 1 b) 5 c) 3 d) 9 8) What of the following would I use in a database query if I was looking for 8 or higher? a) >8 b) <8 c) >=8 d) <=8 9) Which tool would you use within a database to create a query? a) Query Wizard b) Query Design c) Query Library d) Table 10) Which tool would you use within a database to create a form? a) Form Wizard b) Form Design c) Form Library  d) Table 11) Which tool would you use within a database to create a report? a) Report Wizard b) Report Design c) Report Library  d) Table 12) Each column in a database table is known as a  a) Record b) Field 13) Each row in a database table is known as a  a) Record b) Field 14) Within a spreadsheet =Count will calculate the... a) Number of cells b) Number of cells containing data c) Add all numbers together d) Rows 15) VAT stands for a) Value added tax b) View from top c) View after total 16) Within excel =SUM is used when adding.. a) Two numbers b) More than two numbers c) More than five numbers d) More than three numbers 17) Keying *day within the criteria of a query would return all records that a) end in the letters day, i.e. Friday b) start with the letters day, i.e. Daytime c) only those that have *day in them d) all records containing day 18) What is the difference between COUNT and COUNTA functions in spreadsheets? a) COUNT counts both numbers and text, COUNTA counts numbers only.=12*3 b) COUNT counts numbers only, COUNTA counts both numbers and text. c) Both count numbers only. d) Both count numbers and text. 19) Which of the following represents an absolute cell reference in Excel? a) $B5$ b) $B$5 c) B$5$ d) $B5 20) You want a formula that shows "Pass" if a score in cell B2 is greater than or equal to 50, otherwise it shows "Fail." a) =IF(B2$50, "Pass", "Fail") b) =IF(B2>=50, "Pass", "Fail") c) =IF(B2<50, "Fail", "Pass") d) =IF(B2=50, "Pass", "Fail")

N5 Admin - DB & SS

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?