Spreadsheets: Working With Columns & Rows Quiz #5

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Havroncl21
H
Havroncl21
Community Contributor
Quizzes Created: 9 | Total Attempts: 3,816
Questions: 12 | Attempts: 127

SettingsSettingsSettings
Working Quizzes & Trivia

Spreadsheets: Working with Columns & Rows Quiz #5 from Atomic Learning


Questions and Answers
  • 1. 

    You can select a column or a row by using your?

    • A.

      Mouse

    • B.

      Keyboard

    • C.

      All of the above

    Correct Answer
    C. All of the above
    Explanation
    You can select a column or a row by using your mouse or keyboard. Both the mouse and keyboard can be used to navigate and select columns or rows in a document or spreadsheet. The mouse allows for easy clicking and dragging to select multiple cells in a row or column, while the keyboard provides shortcuts and commands such as using the arrow keys to move between cells and holding down the Shift key to select multiple cells. Therefore, both the mouse and keyboard can be used to select a column or a row.

    Rate this question:

  • 2. 

    You can select a cell, a column or a row in Excel.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In Excel, you have the flexibility to select either a cell, a column, or a row. This allows you to perform various operations on the selected element, such as formatting, editing, or applying functions. Selecting a cell enables you to work on a specific location within the spreadsheet. Selecting a column allows you to manipulate the entire column, while selecting a row gives you control over the entire row. Therefore, it is true that you can select a cell, a column, or a row in Excel.

    Rate this question:

  • 3. 

    The control key allows you to select nonadjacent rows or columns.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The control key is a modifier key that, when pressed along with another key, allows for special functionality. In the context of selecting rows or columns, holding down the control key enables the user to select multiple rows or columns that are not adjacent to each other. By selecting nonadjacent rows or columns, users can perform various actions on them simultaneously, such as deleting, copying, or formatting. Therefore, the statement that the control key allows you to select nonadjacent rows or columns is true.

    Rate this question:

  • 4. 

    IF you see ##### in a cell what should you do?

    • A.

      Shrink the cell

    • B.

      Widen the cell

    Correct Answer
    B. Widen the cell
    Explanation
    If you see ##### in a cell, it means that the content in the cell is too wide to fit within the column width. To display the full content, you need to widen the cell by adjusting the column width. This will ensure that all the text or data in the cell is visible and not truncated.

    Rate this question:

  • 5. 

    There is only 1 way to change the column width.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement "There is only 1 way to change the column width" is false. In most software applications, there are multiple ways to change the column width. For example, in spreadsheet programs like Microsoft Excel, you can change the column width by manually dragging the column boundary, using the "Format" menu, or by using keyboard shortcuts. Therefore, the given statement is incorrect.

    Rate this question:

  • 6. 

    You are able to change the height of a column by

    • A.

      Clicking the format command in the HOME tab

    • B.

      Clicking and dragging the cell to the appropriate heigth

    • C.

      Hitting enter till it is big enough

    Correct Answer(s)
    A. Clicking the format command in the HOME tab
    B. Clicking and dragging the cell to the appropriate heigth
    Explanation
    To change the height of a column in Excel, you can click on the format command in the HOME tab. This will allow you to access the formatting options, including adjusting the height of the column. Another way to change the height is by clicking and dragging the cell to the appropriate height. This allows you to manually adjust the size of the column based on your preference.

    Rate this question:

  • 7. 

    By default, the height of a cell is?

    • A.

      15

    • B.

      18

    • C.

      22

    • D.

      100

    Correct Answer
    B. 18
    Explanation
    The default height of a cell is 18.

    Rate this question:

  • 8. 

    You are able to hide columns and rows in an Excel spreadsheet.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In Excel, you have the ability to hide columns and rows in a spreadsheet. This feature allows you to temporarily remove certain columns or rows from view without deleting the data. It can be useful when you want to focus on specific data or simplify the view of your spreadsheet. By hiding columns and rows, you can effectively organize and present your data in a more concise and visually appealing manner.

    Rate this question:

  • 9. 

    A column is always inserted to the _________ of the selected column.

    • A.

      Right

    • B.

      Left

    Correct Answer
    B. Left
    Explanation
    A column is always inserted to the left of the selected column.

    Rate this question:

  • 10. 

    By default a row is inserted ____________ the selected row.

    • A.

      Above

    • B.

      Below

    Correct Answer
    A. Above
    Explanation
    When a row is inserted, it is typically inserted above the currently selected row. This means that the new row will be positioned right above the row that was selected before the insertion.

    Rate this question:

  • 11. 

    In the delete tab under the home tab you are able to?

    • A.

      Delete cells

    • B.

      Delete Rows

    • C.

      Delete Columns

    • D.

      All of the Above

    Correct Answer
    D. All of the Above
    Explanation
    In the delete tab under the home tab, you are able to delete cells, delete rows, and delete columns. This means that you can remove individual cells, entire rows, or entire columns from your spreadsheet. The "All of the Above" option accurately describes the available options for deletion in this tab.

    Rate this question:

  • 12. 

    You are not able to insert cells.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The given statement states that you are not able to insert cells. Since this statement is false, it means that you are able to insert cells. Hence, the correct answer is False.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.