NEW
Font size
WorksheetsQwertyuo
Total questions: 29
Worksheet time: 15mins
Excel. Binary file format (BIFF12) in Excel
xls
*.xltx
*.xlsb
*.xlsx
MS Excel. What kind of data found in a spreadsheet
Data, words, numbers
Numbers, data, words
Equations, data, numbers
Numbers, formulas, labels
Excel. To merge the cells which tab do you use from the format, cells menu
Font tab
Merge tab
Alignment tab
Number tab
MS Excel. Where a row and a column meet, what do you call that
A box
A cell
A table
A block
MS Excel. In an excel sheet the active cell is indicated by
A simple border
A dotted border
A dark wide border
A blinking border
MS Access. How do you rearrange the date in ascending or descending order
Data, table
Data, filter
Data, sort
Data, subtotals
MS Access. Connected fields can have
one file, but different type of data
two files, but different type of data
different names and different type of data
different names, but identical type of data
!MS Access. «Create» tab allows to
execute an auto format
break the table, query and a report
create new table, form, report, query, macro and module
create the page, the form, a template, report, a query, a slide and the database
MS Access. Changing the structure of a table
table mode
design mode
creation of a new table
open the table and change the name of fields
MS Access. Special objects for input and viewing of data in the table
reports
modules
forms
macros
*!MS Access. For copying the records it’s necessary to select and execute comand
home - font - copy
create - reports - copy
home – data collection - insert
home - clipboard - copy
MS Access. The type of a field is set in
pages
tables
reports
design View
MS Access. This object represents formatted printouts of data in a database
form
query
filter
report
Which of the following is not a valid data type in MS Access
memo
yes/No
picture
currency
MS Access. Records are sorted by increase
12, 144, 245, 53, 94
$10, $25, $35, $50
Lily, Rose, Carnation, Aster
Folder, Directory, Container
MS Access. Logical operator «not»is used to select
coincident files
coincident queries
coincident values
in coincident values
MS Access. Logical operator «not Т» is used for select
words which contain letter «Т»
words which don’t contain letter «Т»
words which begin from letter «Т»
words which do not begin from letter «Т»
MS Access. Logical operator «С asterics» is used for selec
words which contain letter «С»
words which don’t contain letter «С»
words which begin from letter «С»
words which don’t begin from letter «С»
MS Access. Logical operator «[B-C]» is used for select
words which contain letter «D»
words which don?t contain letter «В»
words which begin from letters «В», «С», «D»
words which end with letters «В», «С», «D»
The appropriate data type to store time in MS Access
time
time only
Time/date
date/time
!MS Access. Database properties are also known as
Keywords
Metadata
Database objects
Database certificates
MS Access. A table is represented as a collection of rows and columns called a
Metadata
Clientsheet
Datasheet
Reportsheet
Access. If your criterion for filtering is that the value in a particular field matches or does not match a certain value, use
Autofilter
Filter by Form
Filter by Selection
Advanced Filter/Sort
MS Access. A form typically has ____ sections
1
3
2
5
Access. View which allows you to make changes to the form, but does not show the actual form
Form view
Table view
Layout view
Design view
MS Access. The arrange tab button called ____ opens the object's property sheet to set its properties
Object
Scroll Tab
Property Sheet
Control Padding
!MS Access. ____ are the details about a file
Database views
Database sheets
Database properties
Database certificates
MS Access. Database design refers to the arrangement of data into:
Lists
Forms
Reports
Tables and fields
MS Power Point. The ____ slide transition gently uncovers one slide to reveal the next
Wipes
Push and Cover
Entities and labels
Fades and Dissolves
