What is the shortcut key sequence used to open the 'Find and Replace' dialog box with the 'Replace' tab directly active in MS Word? MCQ with Answer and Explanation
Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column?
Explanation:
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.
Which chart type in MS Excel tracks distinct coordinates across two separate numeric axes ($X$ and $Y$) to evaluate correlation patterns between two variable data structures?
Explanation:
A Scatter (XY) chart plots numeric values along horizontal ($X$) and vertical ($Y$) axes to visually expose mathematical relationships or scientific data correlations.
No comments yet. Be the first to start the discussion!