66 MS Excel MCQ Questions in english

Home
Subjects
MS Excel

Subjectwise MCQ

English Hindi General Knowledge Mathematics History Geography Science Reasoning Economics Accounts Business Computer Government Scheme 1st CM List Biology Invention Environment Science Polity Sports GK JavaScript C And C++HTML and CSS MS Word MS Excel MS PowerPoint Bootstrap Python PHP MySQL

Select Subject

Statewise Prepration

Andaman Nicobar Andhra Pradesh Arunchal Pradesh Assam Bihar Chandigarh Chhatisgarh Dadra & Nagar Haveli and Daman & Diu Delhi Goa Gujarat Haryana Himachal Pradesh Jammu & Kashmir Jharkhand Karnatka Kerala Laddakh Lakshadweep Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Odisha Pondicherry Punjab Rajasthan Sikkim Tamil Nadu Telangana Tripura Uttar Pradesh Uttarakhand West Bengal

Select State

Govt. Examwise MCQ

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer CTET UTET

Select Examination

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer CTET UTET

66 MS Excel MCQ Questions in english हिन्दी

Microsoft produced Microsoft Excel, a spreadsheet, for Windows, macOS, Android, and iOS. It has calculating or computing capabilities, graphing tools, pivot tables, and the Visual Basic for Applications macro programming language. The Microsoft Office program package includes Excel.

66. Which key is used to enter an array formula?

A. Enter

B. Ctrl + Shift + Enter

C. Alt + Enter

D. Shift + Space

65. What does Ctrl + H does in Excel?

A. It opens Find & Replace

B. It inserts a hyperlink

C. It highlights the selected text

D. It hides the selected row

64. Which of the following key combinations will select the entire worksheet?

A. Ctrl + A

B. Ctrl + Shift + A

C. Shift + A

D. Alt + A

63. What happens when you press Ctrl + D in Excel?

A. Deletes the row

B. Fills data down from above cell

C. Creates a duplicate file

D. Opens Format Cells dialog

62. Insert new row in shortcut key:

A. Ctrl + R

B. Ctrl + Shift + "+"

C. Shift + F11

D. Alt + R

61. If A1 has "Excel" and B1 has "PowerPoint", what will =MATCH("Word",A1:B1,0) return?

A. #N/A

B. 1

C. 3

D. Word

60. What does the CHOOSE() function do?

A. Selects a value from a list on the base of an index number

B. Finds the largest value

C. Sorts the data

D. Returns the first occurrence of a value

59. Which function can return the row number of a reference?

A. COLUMN()

B. ROW()

C. INDEX()

D. MATCH()

58. What is the primary advantage of using INDEX-MATCH over VLOOKUP?

A. Can search both vertically and horizontally

B. Only works for numbers

C. Only searches to match exactly

D. Slower than VLOOKUP

57. In VLOOKUP, what does the third argument (column index) define?

A. The column number to return data from

B. The row number to return data from

C. The search value

D. The range of lookup table

56. Which among the following is not an option for Conditional Formatting?

A. Highlight Cells Rules

B. Top/Bottom Rules

C. Data Bars

D. Password Protection

55. What occurs if you double-click the fill handle of a selected cell?

A. Copies the value to all the cells.

B. Expands selection to the last filled row.

C. Fill the range down according to the pattern.

D. Deletes the contents.

54. Which feature highlights the cells based on certain conditions?

A. Find & Replace

B. Sorting

C. Conditional Formatting

D. Data Validation

53. What is the action performed by Ctrl+ Shift + "~" in Excel?

A. Apply percentage format

B. Apply general number format

C. Apply currency format

D. Remove formatting.

52. Which also restricts the kind of data that will be entered into a cell?

A. Data Validation

B. Conditional Formatting

C. Filter

D. Data Analysis

51. If A1 = "Excel" and B1 = "PowerPoint", then the formula =A1&" "&B1 will return:

A. ExcelPowerPoint

B. Excel PowerPoint

C. Excel-PowerPoint

D. Error

50. What will be the output =RIGHT("Microsoft", 4) return?

A. Micr

B. soft

C. cro

D. sof

49. What will =IF(AND(A1>10, B1<5), "Yes", "No") return if A1=12 and B1=3?

A. Yes

B. No

C. Error

D. FALSE

48. Which function is used to join two or more text values into one?

A. CONCATENATE()

B. JOIN()

C. MERGE()

D. COMBINE()

47. What will =TEXT(TODAY(),"DD-MMM-YYYY") return if today is 18th Feb 2025?

A. 18/02/2025

B. 18-02-25

C. 18-Feb-2025

D. 02/18/2025

46. What is the shortcut to create a new workbook?

A. Ctrl + N

B. Ctrl + O

C. Ctrl + W

D. Shift + N

45. Which error appears if a formula refers to an invalid cell?

A. #NAME?

B. #VALUE!

C. #REF!

D. #NULL!

44. What will =MOD(10,3) return?

A. 1

B. 3

C. 10

D. 0

43. What does Ctrl + Z do in Excel?

A. Undo last action

B. Redo last action

C. Zoom in

D. Clear contents

42. What is the maximum number of rows in an Excel worksheet?

A. 1,048,576

B. 65,536

C. 104,857

D. Unlimited

41. Which Excel tool is used to find an unknown value by modifying another cell?

A. Solver

B. Goal Seek

C. Scenario Manager

D. Conditional Formatting

40. Which analysis tool aids in predicting future outcomes based on data trends?

A. Goal Seek

B. Scenario Manager

C. Data Table

D. Forecast Sheet

39. In a Pivot Table, what does the Values field refer to?

A. Rows

B. Columns

C. Data calculations

D. Filters

« Previous
Next »

Showing 1 to 28 of 66 results

Latest Jobs

AIIMS Non Faculty Group A, B & C Recruitment 202 ...

Apr 14, 2024

High Court of Kerala Recruitment

Last Date: Apr 26

Recruitment In Staff Selection Commission

Last Date: Apr 18

SSC

Deputy Collector Recruitment In Tamil Nadu Publi ...

Last Date: Apr 27

TNPSC

Kurnool District Court Jobs Notification for the ...

Last Date: Apr 11

Latest Blogs