Which shortcut key is used to select all content in an Excel worksheet?
The shortcut key to select all content in an Excel worksheet is CTRL+A.
What is the function of the shortcut key CTRL+B in Excel?
The shortcut key CTRL+B is used to apply bold formatting to text in Excel.
How do you copy selected cells in Excel using a shortcut key?
To copy selected cells in Excel, you use the shortcut key CTRL+C.
Which shortcut key combination is used to fill down in Excel?
The shortcut key combination used to fill down in Excel is CTRL+D.
To find content within a worksheet, which shortcut should be used?
To find content within a worksheet, you should use the shortcut CTRL+F.
What does the shortcut CTRL+G accomplish in Excel?
The shortcut CTRL+G is used to open the Go To dialog in Excel.
Which shortcut key is used for replacing text or values in Excel?
The shortcut key used for replacing text or values in Excel is CTRL+H.
To italicize text in an Excel cell, which shortcut key should be used?
To italicize text in an Excel cell, you should use the shortcut key CTRL+I.
What is the shortcut key for inserting a hyperlink in Excel?
The shortcut key for inserting a hyperlink in Excel is CTRL+K.
To open a new workbook in Excel, which shortcut would you use?
To open a new workbook in Excel, you would use the shortcut CTRL+N.
Which shortcut key opens an existing workbook in Excel?
The shortcut key to open an existing workbook in Excel is CTRL+O.
What is the shortcut for printing a worksheet in Excel?
The shortcut for printing a worksheet in Excel is CTRL+P.
Which shortcut key fills cells to the right in Excel?
The shortcut key to fill cells to the right in Excel is CTRL+R.
To save an Excel workbook, which shortcut should be used?
To save an Excel workbook, you should use the shortcut CTRL+S.
What is the shortcut for underlining text in an Excel cell?
The shortcut for underlining text in an Excel cell is CTRL+U.
Which shortcut key pastes copied content in Excel?
The shortcut key to paste copied content in Excel is CTRL+V.
To close an open workbook, which shortcut is used?
To close an open workbook, you use the shortcut CTRL+W.
What is the shortcut key for cutting selected content in Excel?
The shortcut key for cutting selected content in Excel is CTRL+X.
Which shortcut key repeats the last action performed in Excel?
The shortcut key to repeat the last action performed in Excel is CTRL+Y.
What is the function of the shortcut CTRL+Z in Excel?
The function of the shortcut CTRL+Z in Excel is to undo the last action.
Which function key provides help in Excel?
The function key that provides help in Excel is F1.
To edit the active cell, which function key should you use?
To edit the active cell, you should use the function key F2.
Which function key pastes a defined name in Excel?
The function key that pastes a defined name in Excel is F3.
What is the function of the F4 key in Excel?
The function of the F4 key in Excel is to repeat the last action.
What is the shortcut key to create a new worksheet?
The shortcut key to create a new worksheet is Shift + F11.
What is the shortcut key to move to the next worksheet?
The shortcut key to move to the next worksheet is Ctrl + Page Down.
What is the shortcut key to move to the previous worksheet?
The shortcut key to move to the previous worksheet is Ctrl + Page Up.
What is the shortcut key to move to the beginning of the worksheet?
The shortcut key to move to the beginning of the worksheet is Ctrl + Home.
What is the shortcut key to move to the end of the worksheet?
The shortcut key to move to the end of the worksheet is Ctrl + End.
What is MS Excel used for?
MS Excel is used for spreadsheet calculations.
What is the file extension for an Excel workbook?
The file extension for an Excel workbook is .xls.
In Excel, a row is identified by:
In Excel, a row is identified by numbers.
In Excel, a column is identified by:
In Excel, a column is identified by letters.
What symbol is used to start a formula in Excel?
The symbol used to start a formula in Excel is =.
What function is used to add numbers in Excel?
The function used to add numbers in Excel is SUM.
Which feature allows you to fill cells with repetitive or sequential data?
The feature that allows you to fill cells with repetitive or sequential data is AutoFill.
How do you start a new line within a cell?
To start a new line within a cell, you use Alt + Enter.
What is the intersection of a row and a column called?
The intersection of a row and a column is called a cell.
Which function is used to find the largest number in a range?
The function used to find the largest number in a range is MAX.
What is a group of cells called?
A group of cells is called a range.
How do you activate the edit mode in a cell?
To activate the edit mode in a cell, you double-click the cell.
What is the default file extension for Excel 2007 and later versions?
The default file extension for Excel 2007 and later versions is .xlsx.
Which function counts the number of cells with numeric data?
The function that counts the number of cells with numeric data is COUNT.
How do you combine text from two or more cells into one cell?
To combine text from two or more cells into one cell, you use Concatenate.
Which chart type is best for showing trends over time?
The chart type best for showing trends over time is a line chart.
How do you apply a filter to data in Excel?
To apply a filter to data in Excel, you use Data > Filter.
Which key is used to navigate to the next cell in a row?
The key used to navigate to the next cell in a row is Tab.
What function is used to return the current date and time?
The function used to return the current date and time is NOW.
How do you freeze the top row of your worksheet?
To freeze the top row of your worksheet, you use View > Freeze Panes > Freeze First Row.
How can you quickly sum a row or column of numbers?
To quickly sum a row or column of numbers, you use the AutoSum button.
Which function returns the smallest number in a range?
The function that returns the smallest number in a range is MIN.
What is the name of the box that shows the content of the active cell?
The name of the box that shows the content of the active cell is the Formula Bar.