In PowerPoint, to apply the same transition to all slides, click: MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In Excel, which function is used to return the smallest value that meets a condition?
Correct Answer: Option C
Explanation:
MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.
MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In MS Excel, what is the value returned if you run the formula =FLOOR.MATH(18.9, 5)?
Correct Answer: Option D
Explanation:
The FLOOR.MATH function rounds a specified number downward to the nearest integer multiple of significance. The nearest multiple of 5 below 18.9 is 15.
The FLOOR.MATH function rounds a specified number downward to the nearest integer multiple of significance. The nearest multiple of 5 below 18.9 is 15.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In MS Access, which of the following is NOT a field data type?
Correct Answer: Option C
Explanation:
Lookup is not a data type; it's a field property (using Lookup Wizard). Data types include Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated.
Lookup is not a data type; it's a field property (using Lookup Wizard). Data types include Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!