A. Save the file
B. Open a new worksheet
C. Create a chart
D. Refresh data
Submitted by: Areesha Khan
Microsoft Excel Mcqs
Microsoft Excel Mcqs for Preparation. Ms Excel Mcqs are very important Mcqs in Computer section.its very important to know the basic Knowledge of computer.Most of the test conductors like FPSC, NTS, KPPSC, PPSC SPSC and others, are adding computer knowledge MCQs in their test patron.
A. Text in Columns
B. Text in Rows
C. Text in selection
D. None
Submitted by: Aon Ali Gopang
A. Ctrl + Space
B. Shift + Ctrl +Enter
C. Ctrl + Down Arrow
D. Ctrl + =
Submitted by: Aon Ali Gopang
A. XFD
B. ZZZ
C. ZXF
D. ZAZ
Submitted by: Aon Ali Gopang
A. =LARGE(A:A, 2)
B. =LARGE(UNIQUE(A:A), 2)
C. =INDEX(SORT(UNIQUE(A:A), , -1), 2)
D. =SMALL(UNIQUE(A:A), 2)
Submitted by: Malik Sanwal
A. TRIM
B. SUBSTITUTE
C. CLEAN
D. REPT
Submitted by: Malik Sanwal
A. VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.
B. VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.
C. VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.
D. VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.
Submitted by: Aziz Ur Rehman
A. Insert Tab
B. Page layout
C. View Tab
D. Home Tab
Submitted by: Farhan Rana
A. Length
B. Counter
C. Count
D. None of These
Submitted by: Rashid Mehmood
A. To permanently delete rows or columns
B. To format the appearance of cells
C. To temporarily hide certain data based on specific criteria
D. To create a chart
