Microsoft Excel 100 MCQ for PEO exam
Which of the following is a spreadsheet software developed by Microsoft?
a) Word
b) Excel
c) PowerPoint
d) Access
Answer: b) Excel
What is the extension of an Excel workbook file?
a) .xlsx
b) .docx
c) .pptx
d) .pdf
Answer: a) .xlsx
Which ribbon tab in Excel is used for formatting cells?
a) Home
b) Insert
c) Page Layout
d) Formulas
Answer: a) Home
What is the keyboard shortcut to select an entire column in Excel?
a) Ctrl+C
b) Ctrl+V
c) Ctrl+A
d) Ctrl+Spacebar
Answer: d) Ctrl+Spacebar
Which function in Excel is used to add up a range of cells?
a) AVERAGE
b) MAX
c) SUM
d) COUNT
Answer: c) SUM
What is the maximum number of rows in Excel 2019 and Excel for Microsoft 365?
a) 65,536
b) 1,048,576
c) 256
d) 16,384
Answer: b) 1,048,576
Which symbol is used to start a formula in Excel?
a) +
b) -
c) *
d) =
Answer: d) =
What is the keyboard shortcut to save an Excel workbook?
a) Ctrl+S
b) Ctrl+P
c) Ctrl+X
d) Ctrl+C
Answer: a) Ctrl+S
Which function in Excel is used to find the highest value in a range of cells?
a) AVERAGE
b) MAX
c) SUM
d) COUNT
Answer: b) MAX
What is the keyboard shortcut to insert a new row in Excel?
a) Ctrl+R
b) Ctrl+Shift+R
c) Ctrl+I
d) Ctrl+Shift+Plus
Answer: d) Ctrl+Shift+Plus
Which ribbon tab in Excel is used for inserting charts?
a) Home
b) Insert
c) Page Layout
d) Formulas
Answer: b) Insert
What is the function of the AutoSum button in Excel?
a) It automatically applies a sum formula to selected cells
b) It automatically calculates the average of selected cells
c) It automatically applies formatting to selected cells
d) It automatically sorts selected cells in ascending order
Answer: a) It automatically applies a sum formula to selected cells
Which function in Excel is used to count the number of cells that contain numeric values in a range?
a) AVERAGE
b) MAX
c) SUM
d) COUNT
Answer: d) COUNT
What is the keyboard shortcut to cut selected cells in Excel?
a) Ctrl+C
b) Ctrl+V
c) Ctrl+X
d) Ctrl+Z
Answer: c) Ctrl+X
Which ribbon tab in Excel is used for changing the page orientation and margins?
a) Home
b) Insert
c) Page Layout
d) Formulas
Answer: c) Page Layout
Which function in Excel is used to find the average value in a range of cells?
a) AVERAGE
b) MAX
c) SUM
d) COUNT
Answer: a) AVERAGE
What is the keyboard shortcut to paste copied cells in Excel?
a) Ctrl+V
b) Ctrl+C
c) Ctrl+X
d) Ctrl+Z
Answer: a) Ctrl+V
What is the purpose of freezing panes in Excel?
a) To lock specific cells so they cannot be edited
b) To split the worksheet window into multiple panes
c) To hide rows or columns in the worksheet
d) To apply conditional formatting to cells
Answer: b) To split the worksheet window into multiple panes
Which ribbon tab in Excel is used for adding formulas and functions?
a) Home
b) Insert
c) Formulas
d) Data
Answer: c) Formulas
What is the function of the AutoFill feature in Excel?
a) To automatically copy the content of a cell to adjacent cells
b) To automatically apply conditional formatting to cells
c) To automatically sort cells in ascending order
d) To automatically delete selected cells
Answer: a) To automatically copy the content of a cell to adjacent cells
What is the keyboard shortcut to open the Format Cells dialog box in Excel?
a) Ctrl+1
b) Ctrl+2
c) Ctrl+3
d) Ctrl+4
Answer: a) Ctrl+1
Which function in Excel is used to find the minimum value in a range of cells?
a) AVERAGE
b) MAX
c) MIN
d) COUNT
Answer: c) MIN
What is the keyboard shortcut to delete selected cells in Excel?
a) Ctrl+D
b) Ctrl+H
c) Ctrl+K
d) Ctrl+-
Answer: d) Ctrl+-
Which ribbon tab in Excel is used for sorting and filtering data?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the CONCATENATE function in Excel?
a) It adds up a range of cells
b) It finds the average of a range of cells
c) It combines the contents of multiple cells into one cell
d) It counts the number of cells in a range
Answer: c) It combines the contents of multiple cells into one cell
What is the keyboard shortcut to insert the current date in Excel?
a) Ctrl+D
b) Ctrl+;
c) Ctrl+:
d) Ctrl+.
Answer: b) Ctrl+;
Which function in Excel is used to calculate the square root of a number?
a) SQRT
b) POWER
c) ROUND
d) ABS
Answer: a) SQRT
What is the keyboard shortcut to format cells as currency in Excel?
a) Ctrl+Shift+$
b) Ctrl+Shift+%
c) Ctrl+Shift+&
d) Ctrl+Shift+#
Answer: a) Ctrl+Shift+$
Which ribbon tab in Excel is used for reviewing and editing the contents of a workbook?
a) Home
b) Insert
c) Data
d) Review
Answer: d) Review
What is the function of the VLOOKUP function in Excel?
a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
b) It counts the number of cells in a range that meet a specific condition.
c) It calculates the sum of a range of cells.
d) It finds the average of a range of cells.
Answer: a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
What is the keyboard shortcut to insert a new worksheet in Excel?
a) Ctrl+W
b) Ctrl+N
c) Ctrl+Shift+N
d) Ctrl+Shift+Plus
Answer: c) Ctrl+Shift+N
Which function in Excel is used to calculate the absolute value of a number?
a) SQRT
b) POWER
c) ROUND
d) ABS
Answer: d) ABS
What is the keyboard shortcut to insert the current time in Excel?
a) Ctrl+D
b) Ctrl+;
c) Ctrl+:
d) Ctrl+.
Answer: c) Ctrl+:
Which ribbon tab in Excel is used for sharing and protecting workbooks?
a) Home
b) Insert
c) Data
d) Review
Answer: d) Review
What is the function of the IF function in Excel?
a) It adds up a range of cells
b) It performs a logical test and returns different values based on the result
c) It calculates the average of a range of cells
d) It counts the number of cells in a range
Answer: b) It performs a logical test and returns different values based on the result
What is the keyboard shortcut to insert a new column in Excel?
a) Ctrl+R
b) Ctrl+Shift+R
c) Ctrl+I
d) Ctrl+Shift+Plus
Answer: c) Ctrl+I
Which ribbon tab in Excel is used for creating and modifying formulas?
a) Home
b) Insert
c) Formulas
d) Data
Answer: c) Formulas
What is the function of the COUNTIF function in Excel?
a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
b) It counts the number of cells in a range that meet a specific condition.
c) It calculates the sum of a range of cells.
d) It finds the average of a range of cells.
Answer: b) It counts the number of cells in a range that meet a specific condition.
What is the keyboard shortcut to undo the last action in Excel?
a) Ctrl+Z
b) Ctrl+Y
c) Ctrl+C
d) Ctrl+V
Answer: a) Ctrl+Z
Which ribbon tab in Excel is used for creating and modifying tables?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the CONCAT function in Excel?
a) It adds up a range of cells
b) It finds the average of a range of cells
c) It combines the contents of multiple cells into one cell, separated by a specified delimiter
d) It counts the number of cells in a range
Answer: c) It combines the contents of multiple cells into one cell, separated by a specified delimiter
What is the keyboard shortcut to select an entire row in Excel?
a) Ctrl+C
b) Ctrl+V
c) Ctrl+A
d) Shift+Spacebar
Answer: d) Shift+Spacebar
Which ribbon tab in Excel is used for performing data analysis and what-if analysis?
a) Home
b) Insert
c) Data
d) Formulas
Answer: d) Formulas
What is the function of the COUNT function in Excel?
a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
b) It counts the number of cells in a range that meet a specific condition.
c) It calculates the sum of a range of cells.
d) It finds the average of a range of cells.
Answer: b) It counts the number of cells in a range that meet a specific condition.
What is the keyboard shortcut to select the entire worksheet in Excel?
a) Ctrl+A
b) Ctrl+T
c) Ctrl+E
d) Ctrl+W
Answer: a) Ctrl+A
Which ribbon tab in Excel is used for creating and formatting charts?
a) Home
b) Insert
c) Page Layout
d) Formulas
Answer: b) Insert
What is the function of the IFERROR function in Excel?
a) It performs a logical test and returns different values based on the result
b) It calculates the average of a range of cells
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It handles errors and returns a specific value if an error occurs
Answer: d) It handles errors and returns a specific value if an error occurs
What is the keyboard shortcut to insert a line break within a cell in Excel?
a) Ctrl+Enter
b) Alt+Enter
c) Shift+Enter
d) Enter
Answer: b) Alt+Enter
Which ribbon tab in Excel is used for defining and applying conditional formatting?
a) Home
b) Insert
c) Page Layout
d) Review
Answer: a) Home
What is the function of the PMT function in Excel?
a) It calculates the present value of an investment
b) It calculates the future value of an investment
c) It calculates the payment amount for a loan or investment
d) It calculates the number of periods required to reach a specific value
Answer: c) It calculates the payment amount for a loan or investment
What is the keyboard shortcut to insert a hyperlink in Excel?
a) Ctrl+H
b) Ctrl+K
c) Ctrl+L
d) Ctrl+M
Answer: b) Ctrl+K
Which ribbon tab in Excel is used for protecting and sharing workbooks?
a) Home
b) Insert
c) Review
d) Data
Answer: c) Review
What is the function of the ROUND function in Excel?
a) It calculates the sum of a range of cells.
b) It calculates the average of a range of cells.
c) It rounds a number to a specified number of decimal places.
d) It counts the number of cells in a range.
Answer: c) It rounds a number to a specified number of decimal places.
What is the keyboard shortcut to apply bold formatting to selected cells in Excel?
a) Ctrl+B
b) Ctrl+I
c) Ctrl+U
d) Ctrl+Shift+B
Answer: a) Ctrl+B
Which ribbon tab in Excel is used for importing and exporting data?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the VLOOKUP function in Excel?
a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
b) It counts the number of cells in a range that meet a specific condition.
c) It calculates the sum of a range of cells.
d) It finds the average of a range of cells.
Answer: a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
What is the keyboard shortcut to apply italics formatting to selected cells in Excel?
a) Ctrl+B
b) Ctrl+I
c) Ctrl+U
d) Ctrl+Shift+I
Answer: b) Ctrl+I
Which ribbon tab in Excel is used for creating and modifying pivot tables?
a) Home
b) Insert
c) Data
d) Formulas
Answer: c) Data
What is the function of the COUNTA function in Excel?
a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
b) It counts the number of cells in a range that meet a specific condition.
c) It calculates the sum of a range of cells.
d) It counts the number of cells in a range that are not empty.
Answer: d) It counts the number of cells in a range that are not empty.
What is the keyboard shortcut to apply underline formatting to selected cells in Excel?
a) Ctrl+B
b) Ctrl+I
c) Ctrl+U
d) Ctrl+Shift+U
Answer: c) Ctrl+U
Which ribbon tab in Excel is used for creating and modifying data validation rules?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the NOW function in Excel?
a) It calculates the current date and time.
b) It calculates the average of a range of cells.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: a) It calculates the current date and time.
What is the keyboard shortcut to apply strikethrough formatting to selected cells in Excel?
a) Ctrl+B
b) Ctrl+I
c) Ctrl+U
d) Ctrl+5
Answer: d) Ctrl+5
Which ribbon tab in Excel is used for customizing the appearance of the worksheet?
a) Home
b) Insert
c) Page Layout
d) Review
Answer: c) Page Layout
What is the function of the RAND function in Excel?
a) It calculates the current date and time.
b) It generates a random number between 0 and 1.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: b) It generates a random number between 0 and 1.
What is the keyboard shortcut to format cells as percentage in Excel?
a) Ctrl+Shift+%
b) Ctrl+Shift+$
c) Ctrl+Shift+&
d) Ctrl+Shift+#
Answer: a) Ctrl+Shift+%
Which ribbon tab in Excel is used for customizing the formulas and calculations in the worksheet?
a) Home
b) Insert
c) Formulas
d) Data
Answer: c) Formulas
What is the function of the SUMIF function in Excel?
a) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
b) It counts the number of cells in a range that meet a specific condition.
c) It calculates the sum of a range of cells that meet a specific condition.
d) It finds the average of a range of cells.
Answer: c) It calculates the sum of a range of cells that meet a specific condition.
What is the keyboard shortcut to open the Find and Replace dialog box in Excel?
a) Ctrl+F
b) Ctrl+H
c) Ctrl+R
d) Ctrl+Shift+F
Answer: b) Ctrl+H
Which ribbon tab in Excel is used for customizing the page setup and printing options?
a) Home
b) Insert
c) Page Layout
d) Review
Answer: c) Page Layout
What is the function of the SUBTOTAL function in Excel?
a) It calculates the current date and time.
b) It calculates the average of a range of cells.
c) It performs a specified mathematical operation on a range of cells.
d) It counts the number of cells in a range.
Answer: c) It performs a specified mathematical operation on a range of cells.
What is the keyboard shortcut to insert a new row in Excel?
a) Ctrl+R
b) Ctrl+Shift+R
c) Ctrl+I
d) Ctrl+Shift+Plus
Answer: d) Ctrl+Shift+Plus
Which ribbon tab in Excel is used for customizing the view and zoom level of the worksheet?
a) Home
b) Insert
c) View
d) Review
Answer: c) View
What is the function of the IFNA function in Excel?
a) It performs a logical test and returns different values based on the result.
b) It calculates the average of a range of cells.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It handles #N/A errors and returns a specific value if the result is #N/A.
Answer: d) It handles #N/A errors and returns a specific value if the result is #N/A.
What is the keyboard shortcut to save a workbook in Excel?
a) Ctrl+S
b) Ctrl+O
c) Ctrl+C
d) Ctrl+V
Answer: a) Ctrl+S
Which ribbon tab in Excel is used for customizing the conditional formatting rules?
a) Home
b) Insert
c) Data
d) Review
Answer: a) Home
What is the function of the NETWORKDAYS function in Excel?
a) It calculates the number of working days between two dates.
b) It calculates the current date and time.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: a) It calculates the number of working days between two dates.
What is the keyboard shortcut to format cells as currency in Excel?
a) Ctrl+Shift+%
b) Ctrl+Shift+$
c) Ctrl+Shift+&
d) Ctrl+Shift+#
Answer: b) Ctrl+Shift+$
Which ribbon tab in Excel is used for customizing the data connections and external data sources?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the CONCATENATE function in Excel?
a) It combines the contents of multiple cells into one cell, separated by a specified delimiter.
b) It calculates the average of a range of cells.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: a) It combines the contents of multiple cells into one cell, separated by a specified delimiter.
What is the keyboard shortcut to insert a new worksheet in Excel?
a) Ctrl+W
b) Ctrl+N
c) Ctrl+Shift+N
d) Ctrl+Shift+Plus
Answer: c) Ctrl+Shift+N
Which ribbon tab in Excel is used for customizing the data sorting and filtering options?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the MID function in Excel?
a) It calculates the current date and time.
b) It returns a specific number of characters from the middle of a text string.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: b) It returns a specific number of characters from the middle of a text string.
What is the keyboard shortcut to insert the current date in Excel?
a) Ctrl+D
b) Ctrl+;
c) Ctrl+:
d) Ctrl+.
Answer: b) Ctrl+;
Which ribbon tab in Excel is used for customizing the data validation rules?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the MAX function in Excel?
a) It calculates the current date and time.
b) It calculates the average of a range of cells.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: d) It finds the maximum value in a range of cells.
What is the keyboard shortcut to insert the current time in Excel?
a) Ctrl+D
b) Ctrl+;
c) Ctrl+:
d) Ctrl+.
Answer: c) Ctrl+:
Which ribbon tab in Excel is used for customizing the data analysis and what-if analysis tools?
a) Home
b) Insert
c) Data
d) Formulas
Answer: d) Formulas
What is the function of the LEN function in Excel?
a) It calculates the current date and time.
b) It calculates the average of a range of cells.
c) It returns the length of a text string.
d) It finds the maximum value in a range of cells.
Answer: c) It returns the length of a text string.
What is the keyboard shortcut to undo the last action in Excel?
a) Ctrl+Z
b) Ctrl+Y
c) Ctrl+X
d) Ctrl+C
Answer: a) Ctrl+Z
Which ribbon tab in Excel is used for customizing the data validation input messages and error alerts?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the AVERAGE function in Excel?
a) It calculates the current date and time.
b) It calculates the average of a range of cells.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: b) It calculates the average of a range of cells.
What is the keyboard shortcut to cut selected cells in Excel?
a) Ctrl+X
b) Ctrl+C
c) Ctrl+V
d) Ctrl+Z
Answer: a) Ctrl+X
Which ribbon tab in Excel is used for customizing the data formatting options?
a) Home
b) Insert
c) Page Layout
d) Review
Answer: a) Home
What is the function of the TRIM function in Excel?
a) It calculates the current date and time.
b) It calculates the average of a range of cells.
c) It removes leading and trailing spaces from a text string.
d) It finds the maximum value in a range of cells.
Answer: c) It removes leading and trailing spaces from a text string.
What is the keyboard shortcut to copy selected cells in Excel?
a) Ctrl+X
b) Ctrl+C
c) Ctrl+V
d) Ctrl+Z
Answer: b) Ctrl+C
Which ribbon tab in Excel is used for customizing the data grouping and outlining options?
a) Home
b) Insert
c) Data
d) Review
Answer: c) Data
What is the function of the CONCAT function in Excel?
a) It calculates the current date and time.
b) It combines the contents of multiple cells into one cell, without any delimiter.
c) It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
d) It finds the maximum value in a range of cells.
Answer: b) It combines the contents of multiple cells into one cell, without any delimiter.
What is the keyboard shortcut to paste copied cells in Excel?
a) Ctrl+X
b) Ctrl+C
c) Ctrl+V
d) Ctrl+Z
Answer: c) Ctrl+V
Which ribbon tab in Excel is used for customizing the data charting and graphing options?
a) Home
b) Insert
c) Charts
d) Review
Answer: c) Charts
Thank you for attempting all 100 MCQ on Microsoft Excel for various competative exams.
0 Comments