50 एक्सेल ओने लाइनर Questions Answer
What is the maximum number of rows in an Excel 2019 worksheet?
Answer: 1,048,576
What is the maximum number of columns in an Excel 2019 worksheet?
Answer: 16,384
What is the file extension for an Excel workbook?
Answer: .xlsx
Which ribbon tab in Excel 2019 allows you to insert charts?
Answer: Insert
Which keyboard shortcut is used to select the entire worksheet in Excel?
Answer: Ctrl + A
What is the keyboard shortcut to undo the last action in Excel?
Answer: Ctrl + Z
Which function is used to calculate the sum of a range of cells in Excel?
Answer: SUM
Which function is used to calculate the average value of a range of cells in Excel?
Answer: AVERAGE
Which keyboard shortcut is used to save an Excel workbook?
Answer: Ctrl + S
Which ribbon tab in Excel 2019 allows you to change the font size and style?
Answer: Home
Which ribbon tab in Excel 2019 allows you to change the column width and row height?
Answer: Home
What is the keyboard shortcut to open the Go To dialog box in Excel?
Answer: Ctrl + G
What is the keyboard shortcut to insert a new worksheet in Excel?
Answer: Shift + F11
Which function is used to find the maximum value in a range of cells in Excel?
Answer: MAX
Which function is used to find the minimum value in a range of cells in Excel?
Answer: MIN
What is the keyboard shortcut to switch between open workbooks in Excel?
Answer: Ctrl + Tab
Which ribbon tab in Excel 2019 allows you to change the cell color and border?
Answer: Home
Which ribbon tab in Excel 2019 allows you to format numbers and dates?
Answer: Home
What is the keyboard shortcut to copy a cell in Excel?
Answer: Ctrl + C
What is the keyboard shortcut to paste a copied cell in Excel?
Answer: Ctrl + V
Which function is used to count the number of cells in a range that contain a number in Excel?
Answer: COUNT
Which function is used to count the number of cells in a range that are not empty in Excel?
Answer: COUNTA
Which ribbon tab in Excel 2019 allows you to insert functions?
Answer: Formulas
What is the keyboard shortcut to open the Format Cells dialog box in Excel?
Answer: Ctrl + 1
Which function is used to concatenate two or more text strings in Excel?
Answer: CONCATENATE
What is the keyboard shortcut to insert the current date in Excel?
Answer: Ctrl + ;
What is the keyboard shortcut to insert the current time in Excel?
Answer: Ctrl + Shift + ;
Which function is used to calculate the square root of a number in Excel?
Answer: SQRT
Which ribbon tab in Excel 2019 allows you to protect a worksheet?
Answer: Review
What is the keyboard shortcut to select the entire column in Excel?
Answer: Ctrl + Spacebar
Which ribbon tab in Excel 2019 allows you to sort data?
Answer: Data
Which function is used to round a number to a specified number of digits in Excel?
Answer: ROUND
Which keyboard shortcut is used to create a chart in Excel?
Answer: F11
What is the keyboard shortcut to find and replace data in Excel?
Answer: Ctrl + H
Which function is used to calculate the average of the largest and smallest values in a range of cells in Excel?
Answer: AVERAGEIF
Which function is used to calculate the standard deviation of a range of cells in Excel?
Answer: STDEV
Which ribbon tab in Excel 2019 allows you to filter data?
Answer: Data
What is the keyboard shortcut to select a non-contiguous range of cells in Excel?
Answer: Ctrl + Click
Which keyboard shortcut is used to move to the next worksheet in Excel?
Answer: Ctrl + Page Down
Which function is used to calculate the compound interest rate in Excel?
Answer: FV
What is the keyboard shortcut to insert a hyperlink in Excel?
Answer: Ctrl + K
Which ribbon tab in Excel 2019 allows you to insert shapes and pictures?
Answer: Insert
Which function is used to calculate the number of days between two dates in Excel?
Answer: DATEDIF
What is the keyboard shortcut to insert a new comment in Excel?
Answer: Shift + F2
Which function is used to calculate the sum of a range of cells that meet a specified condition in Excel?
Answer: SUMIF
Which function is used to calculate the product of a range of cells in Excel?
Answer: PRODUCT
What is the keyboard shortcut to zoom in and out in Excel?
Answer: Ctrl + Scroll Wheel
Which ribbon tab in Excel 2019 allows you to protect a workbook?
Answer: Review
Which function is used to calculate the future value of an investment in Excel?
Answer: FV