What error code is returned by an MS Excel cell formula if a required lookup value cannot be matched or found inside a VLOOKUP search block? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In Excel, which chart type is used to show the relationship between two variables?
Correct Answer: Option B
Explanation:
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In MS PowerPoint, which option is used to change the order of slides?
Correct Answer: Option C
Explanation:
Slide Sorter View is specifically for rearranging slides, but you can also drag in Normal View or Outline. However, Slide Sorter is the primary view for reordering.
Slide Sorter View is specifically for rearranging slides, but you can also drag in Normal View or Outline. However, Slide Sorter is the primary view for reordering.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In MS Access, to add a new record in a table, you can use:
Correct Answer: Option B
Explanation:
You can add records via Datasheet view or via an INSERT query.
You can add records via Datasheet view or via an INSERT query.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!