6054+ MCQ Questions in english

Home
MCQ GK

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

6054+ MCQ Questions in english हिन्दी

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

A. Enter

B. Ctrl + Shift + Enter

C. Alt + Enter

D. Shift + Space

6053. 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

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

A. Ctrl + A

B. Ctrl + Shift + A

C. Shift + A

D. Alt + A

6051. 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

6050. Insert new row in shortcut key:

A. Ctrl + R

B. Ctrl + Shift + "+"

C. Shift + F11

D. Alt + R

6049. 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

6048. 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

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

A. COLUMN()

B. ROW()

C. INDEX()

D. MATCH()

6046. 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

6045. 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

6044. 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

6043. 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.

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

A. Find & Replace

B. Sorting

C. Conditional Formatting

D. Data Validation

6041. 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.

6040. 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

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

A. ExcelPowerPoint

B. Excel PowerPoint

C. Excel-PowerPoint

D. Error

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

A. Micr

B. soft

C. cro

D. sof

6037. 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

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

A. CONCATENATE()

B. JOIN()

C. MERGE()

D. COMBINE()

6035. 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

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

A. Ctrl + N

B. Ctrl + O

C. Ctrl + W

D. Shift + N

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

A. #NAME?

B. #VALUE!

C. #REF!

D. #NULL!

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

A. 1

B. 3

C. 10

D. 0

6031. What does Ctrl + Z do in Excel?

A. Undo last action

B. Redo last action

C. Zoom in

D. Clear contents

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

A. 1,048,576

B. 65,536

C. 104,857

D. Unlimited

6029. 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

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

A. Goal Seek

B. Scenario Manager

C. Data Table

D. Forecast Sheet

6027. 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 6054 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