How Much Do You Know About Excel?

When cells are selected in a spreadsheet program, such as Microsoft Excel, the sum of those cells can be seen in the status bar. The status bar is located at the bottom of the program window and provides information about the selected cells, including their sum. This feature is useful for quickly calculating the total value of a group of cells without having to manually input a formula or use a separate calculator. Therefore, the statement that it is possible to see the sum of the cells in the status bar when cells are selected is true.

Ctrl + 0 is a keyboard shortcut that is commonly used in spreadsheet software such as Microsoft Excel. When this shortcut is pressed, it hides the selected column in the spreadsheet. Therefore, the statement "Ctrl + 0 hides the selected column" is true.

Pressing the F4 key will repeat the last step performed on the current area. This can be useful when you need to repeat a specific action multiple times without having to manually perform it again. By pressing F4, you can save time and effort by quickly applying the same action to the desired area.

To select the column of the cell you are in, you can use the shortcut Ctrl + Spacebar. This shortcut selects the entire column that the active cell is in, making it easy to perform actions or formatting specifically on that column.

Pressing Ctrl+~ is the correct series of keys to see all of your formulas in a worksheet at once. This key combination toggles between displaying the formulas and the values in the cells.

Pressing the F4 function key will convert the selected cell reference to an absolute reference. Absolute references do not change when copied or filled to other cells, making them useful when you want to keep a specific cell reference constant in a formula.

Before pasting the selected visible fields from a filtered data file, you would need to either press Ctrl+G, go to the Special option, and select "Select Visible cells only" (option A), or press F5, go to the Special option, and select "Select Visible cells only" (option B). This ensures that only the visible cells are copied and pasted, excluding any hidden or filtered data.

To create a second line in a cell, you can use the shortcut keys Alt + Enter. This combination allows you to insert a line break within a cell, enabling you to enter text on a new line without moving to the next cell.

Pressing F11 in Excel creates an Excel chart from selected data. This shortcut key allows users to quickly generate a chart without having to go through the chart creation process manually. By selecting the data and pressing F11, Excel automatically creates a default chart using the selected data range. This shortcut is a convenient way to visualize data and present it in a graphical format.

The shortcut to add the current date in a cell is Ctrl + ;.

Pressing Ctrl + ' is the correct answer because it is the shortcut key to copy the content from the cell above without using copy paste or drag and drop. This shortcut allows the user to quickly duplicate the value or formula in the cell above to the current cell.

The feature in Excel that allows you to separate data in one cell into multiple cells is called "Text to Columns." This feature is useful when you have data in a single cell that needs to be split into different columns based on a delimiter, such as a comma or a space. By using the Text to Columns feature, you can easily divide the data into separate cells, making it easier to analyze and manipulate the information.