Microsoft Excel MCQs

By: Prof. Dr. Fazal Rehman | Last updated: August 1, 2024

Microsoft Excel Basic Skills MCQs

1. Excel Interface MCQs
   • Ribbon and toolbar – Excel MCQs
   • Worksheets and workbooks – Excel MCQs
   • Cells, rows, and columns – Excel MCQs
2. Data Entry and Formatting – Excel MCQs
   • Entering and editing data – Excel MCQs
   • Formatting cells (number, text, date)- Excel MCQs
   • Conditional formatting- Excel MCQs
3. Basic Formulas and Functions- Excel MCQs
   • Basic arithmetic operations (SUM, SUBTRACT, MULTIPLY, DIVIDE) – Excel MCQs
   • Common functions (SUM, AVERAGE, MIN, MAX, COUNT) – Excel MCQs
   • Relative and absolute cell references – Excel MCQs
4. Data Management – Excel MCQs
   • Sorting and filtering data – Excel MCQs
   • Using tables – Excel MCQs
   • Data validation – Excel MCQs

Intermediate Skills

5. Advanced Formulas and Functions – Excel MCQs
   • Logical functions (IF, AND, OR, NOT) – Excel MCQs
   • Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH) – Excel MCQs
   • Text functions (LEFT, RIGHT, MID, CONCATENATE) – Excel MCQs
6. Charts and Graphs – Excel MCQs
   • Creating different types of charts (bar, line, pie, etc.) – Excel MCQs
   • Formatting and customizing charts – Excel MCQs
   • Using sparklines – Excel MCQs
7. Data Analysis Tools – Excel MCQs
   • PivotTables – Excel MCQs
   • PivotCharts – Excel MCQs
   • Data analysis tools (Goal Seek, Solver) – Excel MCQs
8. Data Visualization – Excel MCQs
   • Conditional formatting for data visualization – Excel MCQs
   • Creating dashboards – Excel MCQs
   • Using slicers and timelines with PivotTables – Excel MCQs

Advanced Skills – Excel MCQs

9. Advanced Data Management – Excel MCQs
   • Importing and exporting data – Excel MCQs
   • Using Power Query for data transformation – Excel MCQs
   • Consolidating data from multiple sources – Excel MCQs
10. Advanced Functions – Excel MCQs
    • Array formulas – Excel MCQs
    • Advanced statistical functions – Excel MCQs
    • Financial functions – Excel MCQs
11. Macros and VBA – Excel MCQs
    • Recording and running macros – Excel MCQs
    • Basic VBA programming – Excel MCQs
    • Automating tasks with VBA – Excel MCQs
12. Collaboration and Security – Excel MCQs
    • Sharing and protecting workbooks – Excel MCQs
    • Tracking changes and comments – Excel MCQs
    • Using Excel with other Office applications – Excel MCQs

Additional Tips

13. Keyboard Shortcuts – Excel MCQs
    • Common shortcuts for efficiency – Excel MCQs
    • Customizing the Quick Access Toolbar – Excel MCQs
14. Excel Best Practices
    • Organizing and structuring your workbooks – Excel MCQs
    • Documenting your formulas and data – Excel MCQs
    • Regularly saving and backing up your work – Excel MCQs

1. Which of the following key is used for help in Ms Excel?
(a) F5
(b) F7
(c) F3
(d) F1
(e) None of these

2. Which of the following keys are used to Open tab in Ms Excel?
(a) Ctrl+u
(b) Ctrl+p
(c) Ctrl+p
(d) Ctrl+g
(e) Ctrl+o

3. Which of the following key is used to “Goto” tab in Ms Excel?
(a) F9
(b) F7

(c) F6
(d) F2
(e) F5

4. Which of the following keys are used to save data in Ms Excel?
(a) Ctrl+s
(b) Ctrl+p
(c) Ctrl+o
(d) Ctrl+p
(e) none of these

5. Which of the following key is used to edit in Ms Excel?
(a) F1
(b) F6
(c) F3
(d) F2
(e) none of these

6. Which of the following key is used to Repeat

last action in Ms Excel?
(a) F9
(b) F4
(c) F5
(d) F9
(e) none of these

7. Which of the following key underline the text in Ms Excel?
(a) Ctrl+o
(b) Ctrl+p
(c) Ctrl+u
(d) Ctrl+s
(e) none of these

8. Which of the following key copy the text in Ms Excel:
(a) Ctrl+u
(b) Ctrl+c
(c) Ctrl+o
(d) Ctrl+v
(e) none of these

9. Which of the following key close the workbook in Ms Excel?
(a) Ctrl+w
(b) Ctrl+v
(c) Ctrl+c
(d) Ctrl+k
(e) none of these

10. Which of the following cut the text in Ms Excel?
(a) Ctrl+k
(b) Ctrl+v
(c) Ctrl+w
(d) Ctrl+x
(e) none of these

Read More 

1. Microsoft Word MCQs

2. Microsoft Excel MCQs

3. Microsoft Office shortcut keys

4. Microsoft access Solved MCQ’s

5. MS Access MCQs

6. Microsoft PowerPoint MCQs

7. Microsoft Word MCQs

8. Microsoft Windows and Office MCQs

9. Microsoft Windows MCQs

10. Basic MS Office MCQs

MS Excel mcqs pdf  | MS Excel mcqs with answers  | Microsoft Excel mcqs pdf free download  | MS Excel mcqs for fpsc  | MS Excel mcqs download.

MCQs collection of solved and repeated MCQs with answers for the preparation of competitive exams, admission test and job of PPSC, FPSC, UPSC, AP, APPSC, APSC, BPSC, PSC, GOA, GPSC, HPSC, HP, JKPSC, JPSC, KPSC, KERALAPSC, MPPSC, MPSC, MPSCMANIPUR, MPSC, NPSC, OPSC, RPSC, SPSCSKM, TNPSC, TSPSC, TPSC, UPPSC, UKPSC, SPSC, KPPSC, BPSC, AJKPSC ALPSC, NPSC, LPSC, SCPSC, DPSC, DCPSC, PSC, UPSC, WVPSC, PSCW, and WPSC.