How Much Do You Know About Excel?

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Felicyaa
F
Felicyaa
Community Contributor
Quizzes Created: 1 | Total Attempts: 882
| Attempts: 883
SettingsSettings
Please wait...
  • 1/12 Questions

    If you have cells selected, it is possible to see the sum of the cells in the status bar.

    • True
    • False
Please wait...
About This Quiz

Test your Excel skills with our interactive quiz! Discover your proficiency in using shortcuts for formulas, chart creation, data handling, and more. Perfect for enhancing your efficiency and mastery in one of the most essential business tools.

How Much Do You Know About Excel? - Quiz

Quiz Preview

  • 2. 

    Ctrl + 0 Hides the selected column.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 3. 

    What Function key will repeat the last step you did on the current area?

    Correct Answer
    F4
    Explanation
    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:

  • 4. 

    How do you select the column of the cell you are in ?

    • Alt + C

    • Alt + R

    • Ctrl + Spacebar

    • Shift + S

    Correct Answer
    A. Ctrl + Spacebar
    Explanation
    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:

  • 5. 

    What series of keys do you use to see all of your forumlas in a worksheet at once?

    • Ctrl+ a

    • Shift+F3

    • Alt+F8

    • Ctrl+~

    Correct Answer
    A. 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:

  • 6. 

    What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?

    • F11

    • F5

    • F7

    • F4

    Correct Answer
    A. F4
    Explanation
    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:

  • 7. 

    If you have a file with filtered data and just want to copy selected visible fields, what would you do before pasting?

    • Ctrl+G, Special and Select Visible cells only

    • F5, Special and Select Visible cells only

    • A or B

    • None of the above

    Correct Answer
    A. A or B
    Explanation
    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:

  • 8. 

    What 2 Keys do you to get a a second line in a cell?

    Correct Answer
    Alt + Enter
    Explanation
    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:

  • 9. 

    What key Stroke(s) create an excel chart from selected data?

    • F10

    • F11

    • Shift+F10

    • Alt+C

    Correct Answer
    A. F11
    Explanation
    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:

  • 10. 

    What is the shortcut to add current date in a cell?

    • Ctrl +

    • Ctrl + D

    • Ctrl + :

    • Ctrl + ;

    Correct Answer
    A. Ctrl + ;
    Explanation
    The shortcut to add the current date in a cell is Ctrl + ;.

    Rate this question:

  • 11. 

    How do you copy the cell above without using copy paste or drag and drop?

    • Ctrl + C + P

    • Ctrl + '

    • Alt + P

    • None of the above

    Correct Answer
    A. 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:

  • 12. 

    What Feature in excel allows you to seperate data in one cell into multiple cells?

    Correct Answer
    Data-Text to Columns
    Explanation
    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 (Updated): Mar 17, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 01, 2012
    Quiz Created by
    Felicyaa
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.