Microsoft Excel - Level 1

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 Priya1412
P
Priya1412
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,112
| Attempts: 2,123
SettingsSettings
Please wait...
  • 1/10 Questions

    What are you trying to achieve by using the following symbol %?

    • Create a total?
    • Deduct from equation?
    • Total up the sum?
    • Calculate a percentage?
Please wait...
About This Quiz

If you feel confident with using MS Excel at Level 1 - Try the quiz and test your knowledge. If not, please return to the tutorials for further support.

Microsoft Excel - Level 1 - Quiz

Quiz Preview

  • 2. 

    Which option would you select to alter the formatting properties in a cell?

    • Format Cells

    • Pick from List

    • Insert

    • Clear contents

    Correct Answer
    A. Format Cells
    Explanation
    To alter the formatting properties in a cell, you would select "Format Cells" option. This option allows you to modify various formatting aspects such as font style, size, color, borders, alignment, and more. It provides a comprehensive range of formatting options to customize the appearance of the cell according to your preferences or the requirements of the data being displayed.

    Rate this question:

  • 3. 

    What is the correct equation you would insert in the cell to solve the following:  2 is what percent of 8?

    • (1/8)-100

    • (2/8)*100

    • (3/12)*100

    • (2*8)/100

    Correct Answer
    A. (2/8)*100
    Explanation
    2 divided by 8 reduces to 1 divided by 4, or one fourth which is 25%

    Rate this question:

  • 4. 

    Determine what percentage 6 is of 24 by using the following equation 6/24*100?

    • 30%

    • 24%

    • 25%

    • 6%

    Correct Answer
    A. 25%
    Explanation
    The equation given, 6/24*100, calculates the percentage of 6 in relation to 24. By dividing 6 by 24 and then multiplying by 100, we get the result of 25. This means that 6 is 25% of 24.

    Rate this question:

  • 5. 

    Which formula can add all the numeric values in a range of cells, ignoring those that are not numeric, and place the result in a different cell?

    • Count

    • Average

    • Sum

    Correct Answer
    A. Sum
    Explanation
    The formula that can add all the numeric values in a range of cells, ignoring those that are not numeric, and place the result in a different cell is the "Sum" formula. This formula calculates the total sum of all the numeric values within a specified range of cells and disregards any non-numeric values.

    Rate this question:

  • 6. 

    To select a column the easiest method is to...?

    • Double click any cell in the column

    • Drag from the top cell in the column to the last cell in the column

    • Click the column heading

    • Click the column label

    Correct Answer
    A. Click the column heading
    Explanation
    To select a column, the easiest method is to click the column heading. This is because the column heading represents the entire column and clicking on it automatically selects the entire column. This method is quicker and more efficient compared to the other options provided. Double-clicking any cell in the column may only select that specific cell, dragging from the top cell to the last cell may be time-consuming, and clicking the column label may not necessarily select the entire column. Therefore, clicking the column heading is the most straightforward and effective way to select a column.

    Rate this question:

  • 7. 

    Which of the following things can be entered in a cell?

    • Numbers

    • Words

    • Equations, Formulas or Functions

    • Fill Colour

    Correct Answer(s)
    A. Numbers
    A. Words
    A. Equations, Formulas or Functions
    A. Fill Colour
    Explanation
    In a cell, various types of data can be entered including numbers, words, equations, formulas or functions, and fill color. Numbers can be entered to perform calculations or represent numerical values. Words can be entered as labels, titles, or any other textual information. Equations, formulas, or functions can be entered to perform complex calculations or manipulate data. Fill color can be entered to change the background color of a cell for visual differentiation or formatting purposes.

    Rate this question:

  • 8. 

    If you press _____, the cell accepts your typing as its contents but the focus stays in the cell

    • ENTER

    • CTRL + ENTER

    • TAB

    • INSERT

    Correct Answer
    A. CTRL + ENTER
    Explanation
    Pressing CTRL + ENTER allows the user to enter the content into the cell, but the focus remains in the same cell. This means that after typing the content, the user can continue editing or formatting the cell without having to navigate away from it.

    Rate this question:

  • 9. 

    Which do you press to enter the current time in a cell?

    • CTRL+SHIFT+: (colon)

    • CTRL+; (semicolon)

    • CTRL+F10

    Correct Answer
    A. CTRL+; (semicolon)
    Explanation
    To enter the current time in a cell, you would press CTRL+; (semicolon). This keyboard shortcut allows you to quickly insert the current time into a selected cell in Microsoft Excel.

    Rate this question:

  • 10. 

    Which Excel feature can summarise the data in a large table?

    • Data Validation

    • Conditonal Formatting

    • Autoformat

    • Pivot Table

    Correct Answer
    A. Autoformat
    Explanation
    Autoformat is not the correct answer for this question. Autoformat is a feature in Excel that allows users to quickly apply a predefined format to a selected range of cells. It does not have the capability to summarize data in a large table. The correct answer for summarizing data in a large table would be Pivot Table. Pivot Tables allow users to analyze and summarize large amounts of data by creating customized tables, charts, and reports based on the data.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 04, 2010
    Quiz Created by
    Priya1412
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.