PakQuizHub

Microsoft Excel Mcqs

Free 30+ Microsoft Excel Mcqs for PPSC, FPSC, NTS, and Pakistan government job tests. Practise below with answers and explanations.

30 MCQs available← Back to Microsoft Excel Mcqs

30 questions in this list. Select an option to practice, or open a question for the full page with explanation.

Microsoft Excel Mcqs — MCQs for Pakistan government job tests

About this subject

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.

Correct options are highlighted when revealed.

1.How many predefined margin settings are available by default in MS Excel?

2.Which feature allows you to divide the text in a single column into multiple columns in a spreadsheet?

3.Which feature in MS Excel enables you to assign custom names to cells or ranges in formulas without relying on selection?

4.In MS Word, the "Justify" alignment adjusts text to align evenly on both the left and right margins. How does the "Justify" alignment function in MS Excel?

5.Which keyboard shortcut allows you to jump directly to the last row in an Excel worksheet?

6.In MS Excel 2016, what is the label of the final column in a worksheet?

7.In Microsoft Excel, given a list of sales figures in column A, which formula will accurately return the second largest distinct value from that list?

8.In Microsoft Excel, which function is used to eliminate extra spaces from a text string, leaving only single spaces between words?

9.What is the primary purpose of the VLOOKUP function in Excel?

10.What is the highest zoom level available in Microsoft Excel?

11.What is the default file name assigned by MS Excel when you create a new workbook?

12.Which elements can you selectively paste by using the Paste Special feature?

13.Where can you configure a page border in Microsoft Excel?

14.Where does Excel show the address of the active cell?

15.What is the label of the very first cell in an Excel worksheet?

16.What does an Excel workbook primarily consist of?

17.Which shortcut key combination in Microsoft Excel inserts the current time into a cell?

18.What is the term for retrieving data from a cell that is on another worksheet?

19.What happens to the data when you insert an Excel file into a Word document with the source file connection maintained?

20.The 'greater than' symbol (>) represents which type of operation?

More on PakQuizHub