1) A cell range. a) A2 b) A2:M10 c) =average(5K:12K) d) A2,M10 2) A block of code that is used to perform a single, related action. a) Variable b) Constant c) Function d) Parameter 3) Raw facts and figures. a) field b) information c) data d) query 4) Counts the number of cells in range R5 to R50 that contain numeric values. a) =count(R5:R50) b) =count(R5,R50) c) count(R5toR50) d) count(R5:R50) 5) The function =if(B3<1000,"Low", "High") returns a) "Low" if B3 = 1000 b) "High" if B3 = 1000 c) "Low" if B3 = 1999 d) "High" if B3 = 999 6) A computer application that is used to organise data that can then be stored, processed and accessed electronically. a) Spreadsheet b) Word Processing c) Graphics d) Database 7) A value that is unique for every record in a database and can be used to identify a record. a) primary key b) field c) foreign key d) field length 8) A primary key from one table that appears in another table to establish a link between two entities. a) primary key b) table c) foreign key d) query 9) An automatic check to reduce the chance of errors being made when data is entered into a computer system. a) query b) criteria c) SQL d) data validation 10) Specialised language for accessing data in relational databases. a) criteria b) validation c) SQL d) table

Managing Data

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?