Computer Applications- Microsoft Excel: Microsoft Excel 2007 Basics

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 Ntorok
N
Ntorok
Community Contributor
Quizzes Created: 9 | Total Attempts: 3,319
| Attempts: 600
SettingsSettings
Please wait...
  • 1/15 Questions

    A ______ is a line of boxes going up and down.

    • Row
    • Column
    • Formula String
    • SpreadSheet
Please wait...
About This Quiz

Explore the fundamentals of Microsoft Excel 2007, including interface navigation with the Office Button, understanding cells, rows, and columns, and data entry techniques. This quiz is designed to assess basic proficiency and enhance user familiarity with Excel 2007.

Computer Applications- Microsoft Excel: Microsoft Excel 2007 Basics - Quiz

Quiz Preview

  • 2. 

    What do we call the boxes on a spreadsheet?

    • Formula bars

    • Grids

    • Home Boxes

    • Cells

    Correct Answer
    A. Cells
    Explanation
    Cells are the correct term for the boxes on a spreadsheet. In a spreadsheet, data is organized into a grid of rows and columns. Each individual box within this grid is called a cell. Cells can contain various types of data, such as numbers, text, or formulas, and they are used to store and manipulate data in a spreadsheet.

    Rate this question:

  • 3. 

    A _______ is a line of boxes going from left to right.

    • Row

    • Column

    • Formula String

    • SpreadSheet

    Correct Answer
    A. Row
    Explanation
    A row is a horizontal line of boxes in a table or spreadsheet that goes from left to right. It is used to organize and display data in a structured manner. Each box in a row typically represents a cell and contains information or data. By arranging data in rows, it becomes easier to compare and analyze information across different categories or variables.

    Rate this question:

  • 4. 

    All of the following are proper descriptions of arithmatic operators except:

    • "+" adds values

    • "-" subtracts values

    • "*" multiplies values

    • "/" Squares values

    Correct Answer
    A. "/" Squares values
    Explanation
    The correct answer is "/" Squares values. This is because the "/" operator is used for division, not for squaring values. The squaring of values is typically done using the exponentiation operator, which is not mentioned in the given options.

    Rate this question:

  • 5. 

    Which of the following formulas could you use to add several cells together?

    • =A1*B1*C1

    • A1+B1+C1=D1

    • =A1+B1+C1

    • A1*B1*C1

    Correct Answer
    A. =A1+B1+C1
    Explanation
    The correct answer is "=A1+B1+C1". This formula allows you to add the values in cells A1, B1, and C1 together. By using the plus sign (+) between the cell references, you can perform the addition operation in Excel.

    Rate this question:

  • 6. 

    What is the proper method for entering data into a cell?

    • Type the information you want in the formula bar and hit the Tab button

    • Select the cell by clicking on it, hit shift, and type the information you want in the cell

    • Select a cell by clicking on it, type the information you want in it, and press enter

    • Click on a cell, hit the Insert button, hit the enter button, and type the information you want in the cell.

    Correct Answer
    A. Select a cell by clicking on it, type the information you want in it, and press enter
    Explanation
    To enter data into a cell, the proper method is to select the cell by clicking on it, type the information you want in it, and then press enter. This is the standard process for inputting data in a cell in most spreadsheet applications.

    Rate this question:

  • 7. 

    Which of the following formulas could you use to find the Maximum value in the cell range?

    • =(MAX)

    • *MAX()

    • =MAX()

    • =MAX/MAX

    Correct Answer
    A. =MAX()
    Explanation
    The correct answer is "=MAX()". This formula is used to find the maximum value in a cell range. By using this formula, Excel will calculate and return the highest value within the specified range of cells.

    Rate this question:

  • 8. 

    In Microsoft Excel 2007, Where can you find the open, save, and print commands?

    • Home Ribbon

    • Office Button

    • Workbook Layout Button

    • Page Layout Button

    Correct Answer
    A. Office Button
    Explanation
    In Microsoft Excel 2007, the open, save, and print commands can be found in the Office Button. The Office Button is located in the top left corner of the Excel window and is represented by the Microsoft Office logo. When clicked, it opens a menu with various options, including the ability to open, save, and print Excel files.

    Rate this question:

  • 9. 

    Which of the following formulas could you use to average a range of cells?

    • =AVERAGE()

    • =(AVERAGE)

    • /(AVERAGE)

    • =AVERAGE(SUM/SUM)

    Correct Answer
    A. =AVERAGE()
    Explanation
    The correct answer is =AVERAGE(). This formula calculates the average value of a range of cells. By using the AVERAGE function, you can easily find the mean value of a set of numbers.

    Rate this question:

  • 10. 

    How would you format a column of cells so that it is in currency form?

    • Select the data or cell range that you want formatted, click Format on the shortcut menu, select Format Cells, and select currency from the category box.

    • Select the data or cell range that you want formatted, click Format Painter, select Format Cells, and then add money signs in the boxes.

    • Select the data or cell range that you want formatted, click View on the shortcut menu, select Page layout, and select currency from the category box.

    • None of the above

    Correct Answer
    A. Select the data or cell range that you want formatted, click Format on the shortcut menu, select Format Cells, and select currency from the category box.
    Explanation
    To format a column of cells in currency form, you need to select the data or cell range that you want formatted. Then, right-click on the selection and click on "Format" in the shortcut menu. From there, select "Format Cells" and choose the "currency" option from the category box. This will apply the currency format to the selected cells or range, displaying the values with the appropriate currency symbol and decimal places.

    Rate this question:

  • 11. 

    Which of the following formulas could you use to find the Minimum value in the cell range?

    • =(MIN)

    • /(MIN)

    • MIN()

    • =MIN()

    Correct Answer
    A. =MIN()
    Explanation
    The correct answer is =MIN(). This formula is used to find the minimum value in a cell range. By using the MIN function and providing the cell range as an argument, it will return the smallest value within that range.

    Rate this question:

  • 12. 

    What is a formula?

    • A complex calculation that Microsoft will do when formating your spreadsheet

    • It is a type of design formatting used in Math and Science

    • A way to speed up the inputing of data in a Word Document

    • A combination of numbers, operators, and cell references

    Correct Answer
    A. A combination of numbers, operators, and cell references
    Explanation
    A formula is a combination of numbers, operators, and cell references. In spreadsheets, formulas are used to perform calculations and manipulate data. By using operators such as addition, subtraction, multiplication, and division, along with cell references that point to specific cells containing data, formulas can perform complex calculations and generate results automatically. This allows for efficient data analysis and manipulation in spreadsheets.

    Rate this question:

  • 13. 

    Which of the following formulas could you use to add a range of cells together?

    • SUM()

    • =(SUM)

    • =+SUM()

    • =SUM()

    Correct Answer
    A. =SUM()
    Explanation
    The correct answer is =SUM(). This formula is used to add a range of cells together in Excel. By entering =SUM() followed by the range of cells you want to add, you can quickly calculate the total sum of those cells.

    Rate this question:

  • 14. 

    What does the Formula Bar do?

    • Gives the commands of subtraction or addition to a column

    • Allows the user to type in questions and get answers from the help file

    • Displays the contents of the currently selected cell

    • None of the above

    Correct Answer
    A. Displays the contents of the currently selected cell
    Explanation
    The Formula Bar is a feature in spreadsheet software that displays the contents of the currently selected cell. It allows users to view and edit the data or formulas in a cell. This feature is particularly useful when working with large datasets or complex calculations, as it provides a clear and organized view of the cell's content.

    Rate this question:

  • 15. 

    How do you sort data?

    • Select data, click on page layout, select cells, choose method of sorting

    • Select data, click on data tab, select sort, and choose method of sorting

    • Select data, click on view tab, select data tab, choose sort method

    • Click on data tab, select sort and choose method of sorting

    Correct Answer
    A. Select data, click on data tab, select sort, and choose method of sorting
    Explanation
    The correct answer is "Select data, click on data tab, select sort, and choose method of sorting". This answer explains the correct sequence of steps to sort data. It states that the data should be selected first, then the data tab should be clicked on, followed by selecting the sort option. Finally, the method of sorting should be chosen.

    Rate this question:

Quiz Review Timeline (Updated): Apr 18, 2023 +

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

  • Current Version
  • Apr 18, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 02, 2012
    Quiz Created by
    Ntorok
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.