MS Excel Page 3 - Pak Mcqs Point

MS Excel Important Mcqs

41- What programming language is used for writing Excel Macros ?

A. Python

B. Visual Basic for Applications (VBA)

C. JAVA

D. SQL

View Answer

Answer : B. Visual Basic for Applications (VBA)

Description

42- Where can you enable Macros in Excel ?

A. Data → Enable Macros

B. Home → View Macros

C. Insert → Macro

D. File → Options → Trust Center

View Answer

Answer : D. File → Options → Trust Center

Description

43- What does the Record Macro feature do ?

A. Automates repetitive tasks

B. Records mouse movements

C. Creates pivot tables

D. Encrypts worksheets

View Answer

Answer : A. Automates repetitive tasks

Description

44- How can you run a recorded Macro ?

A. Data → Macro Manager

B. View → Run Macro

C. Developer → Macros → Run

D. Insert → Macro → Execute

View Answer

Answer : C. Developer → Macros → Run

Description

45- Which feature allows users to import data from external sources like SQL or CSV ?

A. Solver

B. VLOOKUP

C. Text to Columns

D. Get & Transform (Power Query)

View Answer

Answer : D. Get & Transform (Power Query)

Description

46- What function retrieves data from another Excel workbook ?

A. VLOOKUP

B. INDIRECT

C. HYPERLINK

D. INDEX

View Answer

Answer : B. INDIRECT

Description

47- Which of the following database functions in Excel retrieves a single record that meets a condition ?

A. DGET

B. DSUM

C. DAVERAGE

D. DCOUNT

View Answer

Answer : A. DGET

Description

48- What is the purpose of Power Pivot ?

A. To create relational data models

B. To apply conditional formatting

C. To filter worksheets

D. To format cells

View Answer

Answer : A. To create relational data models

Description

49- What does the Remove Duplicates function do ?

A. Merges similar values

B. Hides duplicate values

C. Deletes all duplicate records in a dataset

D. Creates a backup of duplicate data

View Answer

Answer : C. Deletes all duplicate records in a dataset

Description

50- What is the main purpose of the FILTER function in Excel ?

A. To sort data

B. To apply conditional formatting

C. To remove duplicates

D. To return a filtered subset of data based on criteria

View Answer

Answer : D. To return a filtered subset of data based on criteria

Description

51- What is the shortcut to open Format Cells dialog box ?

A. Ctrl + Shift + F

B. Ctrl + 1

C. Alt + F1

D. Ctrl + F2

View Answer

Answer : B. Ctrl + 1

Description

52- Which shortcut key is used to insert the current date in Excel ?

A. Alt + D

B. Ctrl + ;

C. F5

D. Shift + Ctrl + D

View Answer

Answer : B. Ctrl + ;

Description

53- How can you quickly jump to a specific cell in Excel ?

A. Shift + F3

B. Alt + S

C. Ctrl + J

D. Ctrl + G

View Answer

Answer : D. Ctrl + G

Description

54- Which shortcut is used to apply AutoSum ?

A. Alt + =

B. Ctrl + +

C. Ctrl + A

D. Shift + S

View Answer

Answer : A. Alt + =

Description

55- What does Ctrl + Shift + L do in Excel ?

A. Switches between sheets

B. Launches the Solver add-in

C. Toggles AutoFilter on and off

D. Locks a worksheet

View Answer

Answer : C. Toggles AutoFilter on and off

Description

56- Which function calculates the present value of an investment ?

A. FV

B. PV

C. NPV

D. PMT

View Answer

Answer : B. PV

Description

57- What does the PMT function calculate ?

A. Loan balance

B. Net present value

C. Interest rate

D. Loan payment per period

View Answer

Answer : D. Loan payment per period

Description

58- Which function is used to calculate compound interest ?

A. IRR

B. PV

C. FV

D. RATE

View Answer

Answer : C. FV

Description

59- What does the IRR function return ?

A. Interest paid on a loan

B. Internal Rate of Return for cash flows

C. Present value of investments

D. Future value of investments

View Answer

Answer : B. Internal Rate of Return for cash flows

Description