25 Multiple Choice Questions on Microsoft Excel
Basic Questions
-
What is the default file extension of an Excel workbook?a) .docxb) .xlsxc) .pptxd) .xlsm
- Answer: b) .xlsx
-
Which shortcut key is used to save a workbook in Excel?a) Ctrl + Sb) Ctrl + Pc) Ctrl + Xd) Ctrl + V
- Answer: a) Ctrl + S
-
What is the intersection of a row and a column called?a) Boxb) Cellc) Tabled) Grid
- Answer: b) Cell
-
Which symbol is used to start a formula in Excel?a) #b) @c) =d) &
- Answer: c) =
-
What does the SUM function do in Excel?a) Counts the number of cellsb) Finds the highest valuec) Adds a range of numbersd) Finds the lowest value
- Answer: c) Adds a range of numbers
Formulas and Functions
-
Which of the following is NOT a function in Excel?a) AVERAGEb) COUNTc) SUMd) COMBINE
- Answer: d) COMBINE
-
Which function is used to find the largest number in a range?a) MAXb) MINc) AVERAGEd) LARGE
- Answer: a) MAX
-
Which function is used to count the number of numeric values in a range?a) COUNTAb) COUNTc) SUMd) COUNTIF
- Answer: b) COUNT
-
What does the IF function do?a) Formats textb) Adds numbersc) Performs a logical testd) Converts numbers into text
- Answer: c) Performs a logical test
-
What will =ROUND(25.678,2) return?a) 25.6b) 25.68c) 25.67d) 25.7
- Answer: b) 25.68
Formatting and Editing
- Which shortcut key is used to bold text in Excel?a) Ctrl + Bb) Ctrl + Uc) Ctrl + Id) Ctrl + Shift + B
- Answer: a) Ctrl + B
- What feature allows you to apply a format to multiple cells based on a condition?a) Data Validationb) Conditional Formattingc) AutoFilld) Data Filter
- Answer: b) Conditional Formatting
- Which tab in the ribbon contains the Merge & Center button?a) Homeb) Insertc) Viewd) Data
- Answer: a) Home
- How can you remove all formatting from a cell?a) Press Deleteb) Use Clear Formatsc) Use Find and Replaced) Use AutoFill
- Answer: b) Use Clear Formats
- Which option is used to change the background color of a cell?a) Font Colorb) Fill Colorc) Conditional Formattingd) Borders
- Answer: b) Fill Color
Data Management and Analysis
- Which feature allows you to quickly fill a series of cells with data or a pattern?a) AutoFormatb) AutoFillc) Data Validationd) Sorting
- Answer: b) AutoFill
- What does the Filter feature do?a) Sorts datab) Highlights duplicatesc) Hides non-matching rowsd) Merges cells
- Answer: c) Hides non-matching rows
- Which tool is used to summarize and analyze data in Excel?a) Pivot Tableb) AutoSumc) VLOOKUPd) COUNTIF
- Answer: a) Pivot Table
- Which function is used to search for a value in a column and return a value from another column?a) VLOOKUPb) HLOOKUPc) INDEXd) MATCH
- Answer: a) VLOOKUP
- Which function helps in finding the position of a value within a range?a) FINDb) SEARCHc) MATCHd) INDEX
- Answer: c) MATCH
Shortcuts and Special Features
- Which shortcut is used to insert a new worksheet in Excel?a) Ctrl + Nb) Shift + F11c) Alt + Shift + Nd) Ctrl + Shift + N
- Answer: b) Shift + F11
- Which key is used to edit a selected cell?a) F2b) F4c) Enterd) Esc
- Answer: a) F2
- What happens when you press Ctrl + Z in Excel?a) Redo the last actionb) Undo the last actionc) Save the filed) Copy the text
- Answer: b) Undo the last action
- Which key combination is used to apply or remove filters?a) Ctrl + Shift + Lb) Ctrl + Lc) Alt + F4d) Ctrl + Alt + L
- Answer: a) Ctrl + Shift + L
- Which of the following is NOT a valid Excel data type?a) Textb) Numberc) Formulad) Paragraph
- Answer: d) Paragraph
No comments:
Post a Comment