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

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?