Excel Lesson 2-creating A Workbook

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 Nmays
N
Nmays
Community Contributor
Quizzes Created: 3 | Total Attempts: 1,471
Questions: 20 | Attempts: 893

SettingsSettingsSettings
Excel Lesson 2-creating A Workbook - Quiz

This quiz concerns Excel Lesson 2-Creating a workbook.


Questions and Answers
  • 1. 

    Labels are aligned at the ________ edge of the cell.

    • A.

      Left

    • B.

      Right

    • C.

      Top

    • D.

      Bottom

    Correct Answer
    A. Left
    Explanation
    Labels are aligned at the left edge of the cell.

    Rate this question:

  • 2. 

    You can complete a cell entry by pressing

    • A.

      Enter

    • B.

      Tab

    • C.

      Shift+tab

    • D.

      An arrow key

    • E.

      Another cell

    Correct Answer(s)
    A. Enter
    B. Tab
    C. Shift+tab
    D. An arrow key
    E. Another cell
    Explanation
    To complete a cell entry in a spreadsheet, you can use the following methods: pressing the enter key, pressing the tab key, pressing shift+tab to move to the previous cell, using an arrow key to navigate to another cell, or simply selecting another cell. Each of these actions allows you to finalize the input in the current cell and move on to the next one or perform a different action.

    Rate this question:

  • 3. 

    The default font keyed in a new work book is.

    • A.

      12 pt. Times New Romans

    • B.

      10 pt. Arial

    • C.

      12 pt. Bradley Hand ITC

    • D.

      10 pt. Times New Roman

    Correct Answer
    B. 10 pt. Arial
    Explanation
    The default font in a new workbook is 10 pt. Arial.

    Rate this question:

  • 4. 

    True or False.  If you choose a larger font size, the height of the row is automatically made taller.

    Correct Answer
    true
    Explanation
    When you choose a larger font size, the height of the row is automatically adjusted to accommodate the larger text. This is because the height of a row is determined by the tallest element within it, which in this case would be the larger text. Therefore, selecting a larger font size will result in a taller row to ensure that the text is fully visible and properly displayed.

    Rate this question:

  • 5. 

    Which button allows you to copy cell formats from one cell to another?

    • A.

      Enter

    • B.

      Autofit

    • C.

      Format painter

    • D.

      Esc

    Correct Answer
    C. Format painter
    Explanation
    The format painter button allows you to copy cell formats from one cell to another. This feature is useful when you want to apply the same formatting, such as font style, color, and borders, to multiple cells without manually adjusting each one. By selecting the format painter button and then clicking on the cell or range of cells you want to apply the formatting to, you can quickly and easily copy the formatting from one cell to another.

    Rate this question:

  • 6. 

    A_______ is a group of cells that form a retangle on the screen.

    • A.

      Label

    • B.

      Workbook

    • C.

      Worksheet

    • D.

      Column

    • E.

      Range

    Correct Answer
    E. Range
    Explanation
    A range is a group of cells that form a rectangle on the screen. It can include multiple rows and columns, and is often used to perform calculations or apply formatting to a specific set of cells.

    Rate this question:

  • 7. 

    How do you know a range is active?

    • A.

      It is highlighted on the screen.

    • B.

      It has a marquee around it.

    • C.

      The data changes to Bold to let me know it's active

    • D.

      I'm psychic & I just Know!!

    Correct Answer
    A. It is highlighted on the screen.
    Explanation
    The correct answer is "It is highlighted on the screen." When a range is active, it is visually distinguished from other ranges on the screen by being highlighted. This visual cue helps the user identify which range they are currently working with and prevents confusion when navigating through different ranges in a document or spreadsheet.

    Rate this question:

  • 8. 

    True or False.  A range has an address called an range address.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A range in a computer program or spreadsheet refers to a group of cells. Each range has a specific address called a range address, which is used to identify and refer to that particular range of cells. Therefore, the statement is true.

    Rate this question:

  • 9. 

    An example of a  range address.

    • A.

      A1:B3

    • B.

      A1;B3

    • C.

      A1-B3

    • D.

      A1=B3

    • E.

      A1*B3

    Correct Answer
    A. A1:B3
    Explanation
    The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The letter "A" refers to the column and the number "1" refers to the row of the first cell in the range. The colon ":" is used to indicate a range. The letter "B" refers to the column and the number "3" refers to the row of the last cell in the range. Therefore, A1:B3 represents a range of cells from A1 to B3.

    Rate this question:

  • 10. 

    When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________.

    • A.

      Cell selecter

    • B.

      Cell cross

    • C.

      Selection pointer

    • D.

      Range selecter

    Correct Answer
    C. Selection pointer
    Explanation
    When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a selection pointer. This pointer helps you visually identify the range of cells you are selecting and indicates the starting point of your selection.

    Rate this question:

  • 11. 

    If labels spill onto the column to it's right & the column on the right is not empty you need to ________________.

    • A.

      Resize the column

    • B.

      Complete your calculations by hand, excel is too hard to learn.

    • C.

      Select the column to delete it, you didn't need it anyway.

    • D.

      Leave it the way it is.

    • E.

      Widen it so the label is not cut off.

    Correct Answer(s)
    A. Resize the column
    E. Widen it so the label is not cut off.
    Explanation
    If labels spill onto the column to its right and the column on the right is not empty, you need to resize the column or widen it so that the label is not cut off.

    Rate this question:

  • 12. 

    A__________ is a single point of color on the screen.

    • A.

      Pixel

    • B.

      Cell

    • C.

      Border

    • D.

      Margin

    Correct Answer
    A. Pixel
    Explanation
    A pixel is a single point of color on the screen. It is the smallest unit of measurement in a digital image or display. Pixels combine together to form images and are responsible for creating the visuals we see on screens. Each pixel represents a specific color and when millions of pixels are combined, they create a complete image. Therefore, a pixel is the correct answer as it accurately describes a single point of color on the screen.

    Rate this question:

  • 13. 

    A value is always _____________ aligned in the cells & is included in calculations.

    • A.

      Left

    • B.

      Centered

    • C.

      Justified

    • D.

      Right

    Correct Answer
    D. Right
    Explanation
    Values in cells are typically aligned to the right. When a value is aligned to the right, it means that it is positioned towards the right side of the cell. This alignment is commonly used for numerical data, as it allows for easier reading and comparison of values. Additionally, when values are aligned to the right, they are included in calculations such as summing or averaging the values in a range of cells.

    Rate this question:

  • 14. 

    This button allows you to incorporate the currency format to data.

    • A.

      .

    • B.

      %

    • C.

      =

    • D.

      -

    • E.

      $

    Correct Answer
    E. $
    Explanation
    This answer suggests that the button mentioned in the question allows the user to incorporate the currency format to data. The symbol "$" is commonly used to represent currency, so selecting this button would likely apply the dollar currency format to the data.

    Rate this question:

  • 15. 

    When you key the date, excel applies a standard format that shows:

    • A.

      2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.

    • B.

      Excel leaves it exactly the way I type it!

    • C.

      The formula to change the date.

    Correct Answer
    A. 2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.
    Explanation
    When you key the date in Excel, it applies a standard format that shows 2 digits for the month, 2 digits for the day, and either 2 or 4 digits for the year. This means that if you type a date like "01/05/2022", Excel will display it as "01/05/22" or "01/05/2022" depending on the format applied. Excel does not automatically change the date or apply any formula to it, it simply displays it according to the standard format.

    Rate this question:

  • 16. 

    What does the function Sum do?

    • A.

      Adds the values in the range & then divides by the number of cells in the range.

    • B.

      Determines the largest value in a range.

    • C.

      Multiplies the values in a range.

    • D.

      Adds the values in the cell

    Correct Answer
    D. Adds the values in the cell
    Explanation
    Sum-Adds the values in the cell
    Average-adds the values in the range & then divides by the number of cells in the range
    Max-Determins the largest value in a range.

    Rate this question:

  • 17. 

    You can check results of your calculations by using:

    • A.

      Auto fit

    • B.

      Auto replace

    • C.

      Auto correct

    • D.

      Auto calculate

    Correct Answer
    D. Auto calculate
    Explanation
    The given correct answer is "Auto calculate" because it suggests that you can verify the accuracy of your calculations by using an automatic calculation feature. This feature allows you to perform calculations in a spreadsheet or software program, ensuring that the results are correct without manual calculation.

    Rate this question:

  • 18. 

    A_________ is a built in mathematical formula included in excel.

    • A.

      Cell

    • B.

      Formula

    • C.

      Range

    • D.

      Range address

    • E.

      Function

    Correct Answer
    E. Function
    Explanation
    A function is a built-in mathematical formula included in Excel that allows users to perform calculations, manipulate data, and automate tasks. Functions can be used to perform a wide range of operations, such as summing numbers, finding averages, counting cells, and more. They are predefined formulas that can be easily applied to cells or ranges in Excel to perform specific calculations or operations.

    Rate this question:

  • 19. 

    A________ is a series of instructions that performs a calculation & displays an answer.

    • A.

      Function

    • B.

      Formula

    • C.

      Range

    • D.

      Cell

    Correct Answer
    B. Formula
    Explanation
    A formula is a series of instructions that performs a calculation and displays an answer. It is used in spreadsheets or programming to automate calculations and generate results based on given inputs. Formulas can include mathematical operators, functions, and references to cells or ranges of data. When a formula is executed, it performs the specified calculations and displays the resulting value.

    Rate this question:

  • 20. 

    Formula's always start with:

    • A.

      =

    • B.

      -

    • C.

      *

    • D.

      +

    • E.

      /

    Correct Answer
    A. =
    Explanation
    The correct answer is =. This is because in most mathematical equations or formulas, the equal sign (=) is used to indicate that the expression on the left side is equal to the expression on the right side. It is the symbol that represents equality in mathematics.

    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 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 30, 2009
    Quiz Created by
    Nmays
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.