Microsoft Excel Practice Questions Part I
MCQ QuestionsWhat is the shortcut key to select the entire column in Excel?
A. Shift + Spacebar
B. Ctrl + Spacebar
C. Alt + Spacebar
D. None of the above
Answer: B
Which of the following is a function in Excel?
A. Sum
B. Subtotal
C. Average
D. All of the above
Answer: D
Which of the following is not a valid data type in Excel?
A. Date
B. Text
C. Boolean
D. Timezone
Answer: D
What is the shortcut key to save a workbook in Excel?
A. Ctrl + S
B. Ctrl + X
C. Ctrl + C
D. Ctrl + V
Answer: A
Which of the following chart types is used to display trends over time?
A. Pie chart
B. Line chart
C. Bar chart
D. Scatter chart
Answer: B
What is the shortcut key to open the Format Cells dialog box in Excel?
A. Ctrl + 1
B. Ctrl + 2
C. Ctrl + 3
D. Ctrl + 4
Answer: A
What is the default font size in Excel?
A. 8
B. 10
C. 11
D. 14
Answer: C
Which of the following is not a valid Excel function category?
A. Logical
B. Statistical
C. Mathematical
D. Textual
Answer: D
What is the shortcut key to delete a cell in Excel?
A. Ctrl + D
B. Ctrl + X
C. Ctrl + Y
D. Ctrl + Z
Answer: B
Which of the following is used to protect a worksheet in Excel?
A. Password
B. Range
C. Cell
D. All of the above
Answer: A
Which of the following is not a valid cell reference in Excel?
A. A1
B. B2
C. C3.1
D. D4
Answer: C
What is the shortcut key to select the entire worksheet in Excel?
A. Ctrl + A
B. Ctrl + Shift + A
C. Ctrl + Alt + A
D. None of the above
Answer: A
What is the maximum number of characters that can be entered in a single cell in Excel?
A. 256
B. 1024
C. 16384
D. Unlimited
Answer: A
Which of the following is used to add comments to cells in Excel?
A. Insert Comment
B. Add Note
C. Attach Comment
D. None of the above
Answer: A
What is the shortcut key to open the Go To dialog box in Excel?
A. Ctrl + G
B. Ctrl + F
C. Ctrl + H
D. Ctrl + E
Answer: A
Which of the following is not a valid chart type in Excel?
A. Radar chart
B. Waterfall chart
C. Thermometer chart
D. Pyramid chart
Answer: C
What is the shortcut key to insert a new worksheet in Excel?
A. Shift + F11
B. Ctrl + Shift + W
C. Ctrl + Shift + S
D. Ctrl + Shift + B
Answer: A
Which of the following is used to calculate the sum of a range of cells in Excel?
A. Sum function
B. Average function
C. Count function
D. None of the above
Answer: A
Which of the following is used to calculate the average of a range of cells in Excel?
A. Sum function
B. Average function
C. Count function
D. None of the above
Answer: B
What is the shortcut key to paste a copied cell in Excel?
A. Ctrl + V
B. Ctrl + X
C. Ctrl + C
D. Ctrl + P
Answer: A
Which of the following is used to apply conditional formatting to cells in Excel?
A. Format Cells dialog box
B. Conditional Formatting dialog box
C. Insert Function dialog box
D. None of the above
Answer: B
What is the shortcut key to autofill a series of cells in Excel?
A. Ctrl + D
B. Ctrl + R
C. Ctrl + E
D. Ctrl + T
Answer: A
Which of the following is used to change the orientation of text in a cell in Excel?
A. Alignment dialog box
B. Format Cells dialog box
C. Font dialog box
D. None of the above
Answer: A
What is the shortcut key to insert a new row in Excel?
A. Ctrl + Shift + R
B. Ctrl + Shift + I
C. Ctrl + Shift + N
D. Ctrl + Shift + A
Answer: A
Which of the following is used to create a chart in Excel?
A. Insert Chart
B. Chart Wizard
C. Chart Builder
D. None of the above
Answer: A
What is the shortcut key to open the Find and Replace dialog box in Excel?
A. Ctrl + F
B. Ctrl + H
C. Ctrl + G
D. Ctrl + R
Answer: B
Which of the following is used to freeze rows or columns in Excel?
A. Freeze Panes
B. Lock Cells
C. Protect Sheet
D. None of the above
Answer: A
What is the shortcut key to open the Sort dialog box in Excel?
A. Alt + A
B. Alt + D
C. Alt + S
D. Alt + F
Answer: B
Which of the following is not a valid type of data validation in Excel?
A. Whole number
B. Decimal number
C. Text length
D. Custom formula
Answer: C
What is the shortcut key to open the Filter dialog box in Excel?
A. Ctrl + Alt + F
B. Ctrl + Shift + F
C. Ctrl + F
D. Ctrl + L
Answer: D
Structure Questions
What is the shortcut key to select the entire column in Excel? A. Shift + Spacebar B. Ctrl + Spacebar C. Alt + Spacebar D. None of the above Answer: B
Which of the following is a function in Excel? A. Sum B. Subtotal C. Average D. All of the above Answer: D
Which of the following is not a valid data type in Excel? A. Date B. Text C. Boolean D. Timezone Answer: D
What is the shortcut key to save a workbook in Excel? A. Ctrl + S B. Ctrl + X C. Ctrl + C D. Ctrl + V Answer: A
Which of the following chart types is used to display trends over time? A. Pie chart B. Line chart C. Bar chart D. Scatter chart Answer: B
What is the shortcut key to open the Format Cells dialog box in Excel? A. Ctrl + 1 B. Ctrl + 2 C. Ctrl + 3 D. Ctrl + 4 Answer: A
What is the default font size in Excel? A. 8 B. 10 C. 11 D. 14 Answer: C
Which of the following is not a valid Excel function category? A. Logical B. Statistical C. Mathematical D. Textual Answer: D
What is the shortcut key to delete a cell in Excel? A. Ctrl + D B. Ctrl + X C. Ctrl + Y D. Ctrl + Z Answer: B
Which of the following is used to protect a worksheet in Excel? A. Password B. Range C. Cell D. All of the above Answer: A
Which of the following is not a valid cell reference in Excel? A. A1 B. B2 C. C3.1 D. D4 Answer: C
What is the shortcut key to select the entire worksheet in Excel? A. Ctrl + A B. Ctrl + Shift + A C. Ctrl + Alt + A D. None of the above Answer: A
What is the maximum number of characters that can be entered in a single cell in Excel? A. 256 B. 1024 C. 16384 D. Unlimited Answer: A
Which of the following is used to add comments to cells in Excel? A. Insert Comment B. Add Note C. Attach Comment D. None of the above Answer: A
What is the shortcut key to open the Go To dialog box in Excel? A. Ctrl + G B. Ctrl + F C. Ctrl + H D. Ctrl + E Answer: A
Which of the following is not a valid chart type in Excel? A. Radar chart B. Waterfall chart C. Thermometer chart D. Pyramid chart Answer: C
What is the shortcut key to insert a new worksheet in Excel? A. Shift + F11 B. Ctrl + Shift + W C. Ctrl + Shift + S D. Ctrl + Shift + B Answer: A
Which of the following is used to calculate the sum of a range of cells in Excel? A. Sum function B. Average function C. Count function D. None of the above Answer: A
Which of the following is used to calculate the average of a range of cells in Excel?
A. Sum function B. Average function C. Count function D. None of the above Answer: B
What is the shortcut key to paste a copied cell in Excel? A. Ctrl + V B. Ctrl + X C. Ctrl + C D. Ctrl + P Answer: A
Which of the following is used to apply conditional formatting to cells in Excel? A. Format Cells dialog box B. Conditional Formatting dialog box C. Insert Function dialog box D. None of the above Answer: B
What is the shortcut key to autofill a series of cells in Excel? A. Ctrl + D B. Ctrl + R C. Ctrl + E D. Ctrl + T Answer: A
Which of the following is used to change the orientation of text in a cell in Excel? A. Alignment dialog box B. Format Cells dialog box C. Font dialog box D. None of the above Answer: A
What is the shortcut key to insert a new row in Excel? A. Ctrl + Shift + R B. Ctrl + Shift + I C. Ctrl + Shift + N D. Ctrl + Shift + A Answer: A
Which of the following is used to create a chart in Excel? A. Insert Chart B. Chart Wizard C. Chart Builder D. None of the above Answer: A
What is the shortcut key to open the Find and Replace dialog box in Excel? A. Ctrl + F B. Ctrl + H C. Ctrl + G D. Ctrl + R Answer: B
Which of the following is used to freeze rows or columns in Excel? A. Freeze Panes B. Lock Cells C. Protect Sheet D. None of the above Answer: A
What is the shortcut key to open the Sort dialog box in Excel? A. Alt + A B. Alt + D C. Alt + S D. Alt + F Answer: B
Which of the following is not a valid type of data validation in Excel? A. Whole number B. Decimal number C. Text length D. Custom formula Answer: C
What is the shortcut key to open the Filter dialog box in Excel? A. Ctrl + Alt + F B. Ctrl + Shift + F C. Ctrl + F D. Ctrl + L Answer: D
What is a cell in Excel? A: A cell is a single unit on a worksheet, identified by a unique cell reference (such as A1 or B7), where data can be entered, stored and manipulated.
How do you enter a formula in Excel? A: To enter a formula in Excel, start with an equals sign (=) followed by the formula you want to use. For example, to add two numbers, type =A1+B1 and press Enter.
What is the purpose of the fill handle in Excel? A: The fill handle is used to copy formulas or values to adjacent cells in a worksheet. You can drag the fill handle to fill a series of cells with a pattern.
What is a range in Excel? A: A range is a group of adjacent cells in a worksheet, identified by the cell addresses of the top-left and bottom-right cells in the range (such as A1:B5).
What is the purpose of a worksheet tab in Excel? A: The worksheet tab is used to switch between different worksheets in a workbook.
What is the purpose of the Home tab in Excel? A: The Home tab provides access to frequently used formatting and editing commands in Excel.
What is the purpose of the Page Layout tab in Excel? A: The Page Layout tab is used to customize the appearance of the worksheet when it is printed.
What is the purpose of the Formulas tab in Excel? A: The Formulas tab provides access to functions, auditing tools, and formula calculation options in Excel.
What is a function in Excel? A: A function is a built-in formula that performs a specific calculation in Excel. Examples include SUM, AVERAGE, and IF.
What is a chart in Excel? A: A chart is a visual representation of data in Excel, used to help users understand trends and patterns in the data.
What is conditional formatting in Excel? A: Conditional formatting is a feature in Excel that allows users to highlight cells based on certain criteria, such as color coding cells with values above or below a certain threshold.
What is a pivot table in Excel? A: A pivot table is a tool in Excel used to summarize and analyze large amounts of data in a flexible and interactive way.
What is a filter in Excel? A: A filter is a tool in Excel used to display only the data that meets certain criteria, and hide the rest.
What is a sparkline in Excel? A: A sparkline is a small, simple chart displayed within a single cell in Excel, used to show trends in data over time or across categories.
What is the purpose of the status bar in Excel? A: The status bar displays information about the current cell selection, including the sum, average, and count of selected cells.
What is the purpose of the quick access toolbar in Excel? A: The quick access toolbar provides easy access to frequently used commands in Excel, such as Save, Undo, and Redo.
What is the purpose of the formula bar in Excel? A: The formula bar displays the contents of the currently selected cell, including any formulas or data.
What is a named range in Excel? A: A named range is a group of cells in a worksheet that has been given a name, making it easier to refer to in formulas and functions.
What is the purpose of the freeze panes feature in Excel? A: The freeze panes feature in Excel allows users to keep specific rows or columns visible while scrolling through a large worksheet.
What is the purpose of the AutoFill featurein Excel?
A: The AutoFill feature in Excel is used to quickly fill a series of cells with data, such as dates, numbers, or text. You can use the fill handle to drag and fill the cells automatically based on a pattern.
Posts
0 Comments