10234+ MCQ Questions in english

Home
MCQ GK

Subjectwise MCQ

English Hindi General Knowledge Mathematics History Geography Science Reasoning Economics Accounts Business Computer Government Scheme Statewise first 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 Uttarakhand Fair

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

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

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

6026. Which of the following functions can be utilized within a Pivot Table to determine a column sum?

A. COUNT()

B. AVERAGE()

C. SUM()

D. IF()

6025. The main purpose of a Pivot Table is:

A. To Sort Data

B. To Summarize Data

C. To Format Data

D. To Enter Data

6024. What is the result of =LEN("Hello World")?

A. 10

B. 11

C. 12

D. Error

6023. Which function is used to remove extra spaces from text?

A. CLEAN()

B. TRIM()

C. SUBSTITUTE()

D. FIND()

6022. What will the formula =LEFT("Excel", 2) return?

A. Ex

B. Exc

C. El

D. Error

6021. Which function finds data both horizontally and vertically?

A. VLOOKUP

B. HLOOKUP

C. INDEX-MATCH

D. CONCATENATE

6020. What does VLOOKUP stand for?

A. Vertical Lookup

B. Value Lookup

C. Virtual Lookup

D. Variable Lookup

6019. Which of the following chart types does not exist in Excel?

A. Histogram

B. Waterfall Chart

C. Radar Chart

D. Sunburst Chart

6018. Which of the following can be used to remove duplicate values in a dataset?

A. Remove Duplicates option

B. Find & Replace

C. Data Validation

D. Pivot Table

6017. What does the Sort feature in Excel allow you to do?

A. Arrange data in ascending or descending order

B. Remove duplicates

C. Find and replace data

D. Apply conditional formatting

6016. Which chart is best suited to display trends over time?

A. Bar Chart

B. Pie Chart

C. Line Chart

D. Doughnut Chart

6015. What is the shortcut key to apply a filter to a dataset?

A. Ctrl + F

B. Alt + D + F + F

C. Ctrl + Shift + L

D. Ctrl + L

6014. What is the shortcut key to apply bold formatting?

A. Ctrl + B

B. Ctrl + I

C. Ctrl + U

D. Alt + B

6013. Which Excel feature is used to combine and center the content of selected cells?

A. Merge & Center

B. Wrap Text

C. Conditional Formatting

D. Data Validation

6012. What does Ctrl + 1 do in Excel?

A. Opens the Format Cells dialog box

B. Opens a new workbook

C. Inserts a new sheet

D. Deletes a row

6011. What is the default file extension of Excel 2016?

A. .xls

B. .xlsx

C. .docx

D. .csv

6010. Which shortcut key is used to insert a new worksheet?

A. Shift + F11

B. Ctrl + N

C. Ctrl + W

D. Alt + Shift + N

6009. The function used to count the number of numerical values in a range is:

A. COUNT()

B. COUNTA()

C. COUNTIF()

D. COUNTBLANK()

6008. If A1=8, what will the formula =IF(A1>10, "Pass", "Fail") return?

A. Pass

B. Fail

C. Error

D. True

6007. The function =ROUND(15.678,2) returns:

A. 15.67

B. 15.68

C. 16

D. 15.7

« Previous
Next »

Showing 4201 to 4228 of 10234 results

Latest Jobs

UP Home Guard Recruitment 2025 – Apply Online

Jul 07, 2025

Career

Manipur University Recruitment 2025 For Guest Fa ...