Excel Assessment - 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 Management
M
Management
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,293
| Attempts: 1,296
SettingsSettings
Please wait...
  • 1/8 Questions

    C4:D11 is an example of a            .

    • Formula
    • Range
    • Column
    • Cell
Please wait...
Excel Quizzes & Trivia
About This Quiz

This assessment will be used to measure your knowledge of Excel.


Quiz Preview

  • 2. 

    What symbol is missing in the beginning of this formula?       SUM(B2:B11)

    • ;

    • *

    • =

    • /

    • //

    Correct Answer
    A. =
    Explanation
    The symbol that is missing in the beginning of the formula is the equals sign (=). The equals sign is used in formulas to indicate that a calculation or function is being performed. In this case, the formula is SUM(B2:B11), which calculates the sum of the values in cells B2 to B11.

    Rate this question:

  • 3. 

    There are multiple ways to insert a hyperlink into a cell.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because in most spreadsheet programs, such as Microsoft Excel or Google Sheets, you can insert a hyperlink into a cell by selecting the cell, right-clicking on it, and choosing the "Insert Hyperlink" option. Alternatively, you can use the keyboard shortcut Ctrl+K to open the hyperlink dialog box and enter the desired link. This allows users to easily add clickable links to their spreadsheet cells, which can be useful for referencing external websites, documents, or other resources.

    Rate this question:

  • 4. 

    Data can be sorted by ____________ ? (Please check all answers that apply)

    • Font type

    • Value

    • Cell Color

    • Alphabetically

    • All of the above

    Correct Answer(s)
    A. Value
    A. Cell Color
    A. Alphabetically
    Explanation
    Data can be sorted by value, cell color, and alphabetically. Sorting by value means arranging the data in ascending or descending order based on the numerical values. Sorting by cell color involves arranging the data based on the color of the cells, which can be useful for categorizing or highlighting specific data. Sorting alphabetically means arranging the data in alphabetical order based on the text or characters. Therefore, all of the given options are correct for sorting data.

    Rate this question:

  • 5. 

    The two orientation styles of a page layout are landscape and             .

    Correct Answer(s)
    Portrait
    Explanation
    The two orientation styles of a page layout are landscape and portrait. Landscape refers to a layout where the width of the page is greater than its height, while portrait refers to a layout where the height of the page is greater than its width. These two styles offer different options for displaying and arranging content, allowing for flexibility in design and presentation.

    Rate this question:

  • 6. 

    If you need a total of C1:D2, which of the following would you use? (Check all answers that apply)

    • Sum(C1:D2)

    • Total(C1:D2)

    • C1+D2

    • C1+C2+D1+D2

    Correct Answer(s)
    A. Sum(C1:D2)
    A. C1+C2+D1+D2
    Explanation
    To calculate the total of the range C1:D2, you can use the formula Sum(C1:D2). This formula will add up all the values within the range and give you the sum. Additionally, you can also use the formula C1+C2+D1+D2 to manually add up the individual values in the range. Both of these methods will give you the total of the range C1:D2.

    Rate this question:

  • 7. 

    Select the best description(s) for applying a macro to a sheet.

    • Insert -> Sheet Options -> Insert Macro

    • View -> Record Macro -> Stop Recording

    • Developer -> Design Mode -> Run Macro -> Stop Macro

    • Developer -> Record Macro -> Stop Recording

    • Both B and D

    Correct Answer
    A. Both B and D
    Explanation
    Both options B and D are correct because they both involve recording a macro. In option B, the user goes to the View tab, selects Record Macro, and then stops recording. In option D, the user goes to the Developer tab, selects Record Macro, and then stops recording. Both options involve the process of recording a macro, which allows the user to automate a series of actions in Excel.

    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
  • Mar 14, 2012
    Quiz Created by
    Management
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.