How Much Do You Know About Excel?
(312).jpg "How Much Do You Know About Excel? - Quiz")
Excel Tips
Questions and Answers
- 1.
What series of keys do you use to see all of your forumlas in a worksheet at once?
- A.
Ctrl+ a
- B.
Shift+F3
- C.
Alt+F8
- D.
Ctrl+~
Correct Answer
D. Ctrl+~Explanation
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.Rate this question:
-
- 2.
What key Stroke(s) create an excel chart from selected data?
- A.
F10
- B.
F11
- C.
Shift+F10
- D.
Alt+C
Correct Answer
B. F11Explanation
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.Rate this question:
-
- 3.
If you have a file with filtered data and just want to copy selected visible fields, what would you do before pasting?
- A.
Ctrl+G, Special and Select Visible cells only
- B.
F5, Special and Select Visible cells only
- C.
A or B
- D.
None of the above
Correct Answer
C. A or BExplanation
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.Rate this question:
-
- 4.
What is the shortcut to add current date in a cell?
- A.
Ctrl +
- B.
Ctrl + D
- C.
Ctrl + :
- D.
Ctrl + ;
Correct Answer
D. Ctrl + ;Explanation
The shortcut to add the current date in a cell is Ctrl + ;.Rate this question:
-
- 5.
What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?
- A.
F11
- B.
F5
- C.
F7
- D.
F4
Correct Answer
D. F4Explanation
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.Rate this question:
-
- 6.
What Function key will repeat the last step you did on the current area?
Correct Answer
F4Explanation
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.Rate this question:
- 7.
If you have cells selected, it is possible to see the sum of the cells in the status bar.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 8.
How do you copy the cell above without using copy paste or drag and drop?
- A.
Ctrl + C + P
- B.
Ctrl + '
- C.
Alt + P
- D.
None of the above
Correct Answer
B. Ctrl + 'Explanation
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.Rate this question:
-
- 9.
How do you select the column of the cell you are in ?
- A.
Alt + C
- B.
Alt + R
- C.
Ctrl + Spacebar
- D.
Shift + S
Correct Answer
C. Ctrl + SpacebarExplanation
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.Rate this question:
-
- 10.
What 2 Keys do you to get a a second line in a cell?
Correct Answer
Alt + EnterExplanation
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.Rate this question:
- 11.
Ctrl + 0 Hides the selected column.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 12.
What Feature in excel allows you to seperate data in one cell into multiple cells?
Correct Answer
Data-Text to ColumnsExplanation
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.Rate this question:
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 17, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 01, 2012Quiz Created by
Felicyaa
Back to top