In Excel, which function rounds a number down to the nearest integer? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In MS Word, what does the 'Format Painter' tool copy?
Correct Answer: Option A
Explanation:
Format Painter copies only visual formatting settings (fonts, colorations, spacing) from a source selection and applies them to a target.
Format Painter copies only visual formatting settings (fonts, colorations, spacing) from a source selection and applies them to a target.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In MS PowerPoint, which feature can be used to copy all standard formatting, animations, colors, and styling from one object and apply it to another?
Correct Answer: Option B
Explanation:
The Format Painter tool copies style formatting from one item (text, shapes, backgrounds) and applies it directly to another target item.
The Format Painter tool copies style formatting from one item (text, shapes, backgrounds) and applies it directly to another target item.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In Excel, which function is used to calculate the average of a set of numbers but ignores zero values?
Correct Answer: Option D
Explanation:
AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.
AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!