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:
Â Which option can be used to create a new slide show with the current slides but presented in a different order?
B. Custom Slide show
C. Slide Show Setup
D. Slide Show View
Ans:â€“ B ,
A Ring, refers to a record chain, the last of which refers to the first record, in the chain, is called a/an
Options: executes first the job that last entered the queue, executes first the job that first entered the queue, execute first the job that has been in the queue the longest, executes first the job with the least processor needs
Options: the lock is obtained only after the transaction has processed., the lock is obtained before the transaction has processed., the lock never needs to be obtained., transactions that are best suited are those with a lot of activity.
. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Options: a. 5
d. Not enough information to tell
Options: A) The name of companies that made computers
B) The name of product a company gives to identify its product in market
C) A name of class to indicate all similar products from different companies
D) All of above
. How do you rearrange the data in ascending or descending order?
Options: Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals
Ans: â€“ A
A WATS arrangement
Options: is always less expensive than flat-rate service, is less expensive than flat-rate service only when the number of calls is large and the duration of each is short, is less expensive than flat-rate service only when the number of calls is small and the duration of each is long, is never less expensive than flat-rate service
Options: A sequence is an object that generates a sequential series of unique numbers., Sequences are most often used to provide values for surrogate keys., NextVal and CurrVal are both sequence methods., Sequences guarantee valid surrogate key values.
The necessary conditions needed before deadlock can occur?
Options: Â No Mutual Exclusion, Hold and wait, Preemption, Circular Wait
B. Â Mutual Exclusion, No Hold and wait, Preemption, Circular Wait
C. Â Mutual Exclusion, Hold and wait, No Preemption, Circular Wait
D. Â Mutual Exclusion, Hold and wait, Preemption, No Circular Wait
Ans:– C ,
Shortcut key to insert a hyperlink in a slide
A.Â Ctrl + H
B.Â Ctrl + K
C.Â Hyperlinks canâ€™t be inserted in slides
D.Â None of the above