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 हिन्दी

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

6006. The formula correct for calculating the average of A1:A10 is:

A. =MEAN(A1:A10)

B. =AVERAGE(A1:A10)

C. =SUM(A1:A10)/10

D. both b and c

6005. Which function is used to find the highest number in a range?

A. MAX()

B. MIN()

C. LARGE()

D. HIGHEST()

6004. What is the shortcut key for double line spacing?

A. Ctrl + 1

B. Ctrl + 2

C. Ctrl + 3

D. Ctrl + 5

6003. Which of the following is default File Extension for Word Template?

A. .dot

B. .dotx

C. .docx

D. .txt

6002. Which key combination will insert a Non-Breaking Space?

A. Ctrl + Space

B. Alt + Space

C. Ctrl + Shift + Space

D. Shift + Space

6001. Which shortcut key would be used to insert a soft hyphen?

A. Ctrl + -

B. Ctrl + Shift + -

C. Alt + Shift + -

D. Ctrl + Shift + Space

6000. Which is a valid document view option?

A. Draft

B. Print Layout

C. Outline

D. All of the above

5999. What function will give you an option to insert a caption for a figure in Ms Word?

A. Insert → Caption

B. References → Insert Caption

C. Layout → Caption

D. Home → Caption

« Previous
Next »

Showing 29 to 56 of 6054 results

Latest Jobs

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

Apr 13, 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