Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options: Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row., Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column., Three rows have the values Brown, NULL, and Blue in the same column., One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
. How do you change column width to fit the contents?
Options: a. Single-click the boundary to the left to the column heading b. Double click the boundary to the right of the column heading c. Press Alt and single click anywhere in the column d. All of above
. 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)
Mostly which of the following device is used to carry user files?
Options: Floppy Disk
B. Hard Disk Â Â
Ans:– A ,
Which of the following function will return a value of 8?
Options: ROUNDUP(8.4999, 0)
B. ROUNDDOWN(8.4999, 0)
C. ROUND(8.4999, 0)
D. Only B and C
Ans:– D ,
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 macro processor and input to the assembler, more flexibility is available to the programmer in which he/she may use all the features of the assembler in conjunction with macros, All of the above
Options: A) Computers are 100% accurate but it can suffer from GIGO
B) Computers are reliable because they use electronic component which have very low failure rate
C) Computer is never tired and does not suffer from boredom
D) All of above