Microsoft Excel Spreadsheet Software Programs Quiz

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 AdrielEphraim
A
AdrielEphraim
Community Contributor
Quizzes Created: 1 | Total Attempts: 160
| Attempts: 160
SettingsSettings
Please wait...
  • 1/5 Questions

    You can rename worksheets by either double clicking or right clickingon the tab. When the tab is highlighted, you can retype the new name.

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


The purpose of this assessment is to help us determine proficiency levels in our company, and where to focus our efforts in upcoming training classes. Your individual results will be scored and used as a basis for your training needs.

Microsoft Excel Spreadsheet Software Programs Quiz - Quiz

Quiz Preview

  • 2. 

    The only formats you can choose for numbers in a chart are currency,fractions, or percentages.

    • True

    • False

    • Not Sure

    Correct Answer
    A. False
    Explanation
    The statement is false because there are more formats available for numbers in a chart than just currency, fractions, or percentages. Other formats include general number format, scientific notation, date and time format, and custom formats.

    Rate this question:

  • 3. 

    One way to enter data into a cell is by typing into the formula bar and clicking on the check mark button.

    • True

    • False

    • Not Sure

    Correct Answer
    A. True
    Explanation
    The statement is true because the formula bar in a spreadsheet program allows users to directly input data into a selected cell. By typing into the formula bar and clicking on the check mark button, the data is entered and the cell is updated with the typed information. This method is commonly used when users want to input specific values or formulas into cells instead of copying and pasting data from other sources.

    Rate this question:

  • 4. 

    The DEFAULT number of worksheets in an Excel Workbooks is ___?

    • There is no default. It has to be set each time Excel is opened.

    • 3

    • 255

    • 1

    • Not Sure

    Correct Answer
    A. 3
    Explanation
    The correct answer is 3 because there is no default number of worksheets in an Excel workbook. Each time Excel is opened, the user has to set the number of worksheets they want to have in the workbook.

    Rate this question:

  • 5. 

    If a cell has the contents, 25048.50 and has been formatted to acurrency format with no decimals places, which of the following willappear in the cell?

    • 25,048

    • 25,049.00

    • $25,048.50

    • $25,049

    • Not Sure

    Correct Answer
    A. $25,049
    Explanation
    The given cell contains the value 25048.50 and has been formatted to a currency format with no decimal places. In this format, the decimal part of the number is rounded up or down to the nearest whole number. Since the decimal part of 0.50 is greater than or equal to 0.5, it will be rounded up to 1. Therefore, the number will be rounded up to 25049.00. Additionally, since the cell is formatted as a currency, the number will be displayed with the currency symbol, which is $ in this case. Hence, the correct answer is $25,049.

    Rate this question:

Quiz Review Timeline (Updated): Dec 15, 2024 +

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

  • Current Version
  • Dec 15, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 16, 2010
    Quiz Created by
    AdrielEphraim
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.