Options: It automatically completes abbreviated words
B. It completes text entries that match an existing entry in the same column
C. It completes text and numeric entries that match an existing entry in the same column
D. It completes text entries that match an existing entry in the same worksheet
Ans:– B ,
More MS-Excel Related questions:
The advantage(s) of incorporating the macro processor into pass 1 is(are):
Options: many functions do not have to be implemented twice., Functions are combined and it is not necessary to create intermediate files as output from the macros processor and input to the assembler., more flexibility is available to the programmer in that he may use all the features of the assembler in conjunction with macros., all of the above
Options: a feature of data processing systems that allows for the study of data as processed from step to step; and auditor can then trace all transactions that affect an account., a data item that characterizes an object, two or more data items handled as a unit, All of the above
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
. Which of the following is correct syntax in Excel?
Options: a. =IF(LogicalTest, TrueResult, FalseResult)
b. =IF(LogicalTest, (TrueResult, FalseResult))
c. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
d. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)
Options: a program that places programs into memory and prepares them for execution., a program that automate the translation of assembly language into machine language., a program that accepts a program written in a high level language and produces an object program., is a program that appears to execute a source program as if it were machine language.