Microsoft Excel Examination

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 PRST_GY
P
PRST_GY
Community Contributor
Quizzes Created: 1 | Total Attempts: 553
| Attempts: 553
SettingsSettings
Please wait...
  • 1/30 Questions

    Is it possible to insert an image from a file into an Excel spreadsheet ?

    • Yes
    • No
Please wait...
About This Quiz

This is a 30-minute exam (approximately 1 minute per item) which assesses your knowledge in using Microsoft Excel. You may open an Excel Workbook to help you answer some of the questions on this exam. Goodluck!

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    The Excel IF function checks to see if a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the Excel IF function is indeed used to check whether a certain condition is true or false. If the condition is true, the function will execute one set of instructions, and if the condition is false, it will execute a different set of instructions. Therefore, the statement "The Excel IF function checks to see if a certain condition is true or false" is true.

    Rate this question:

  • 3. 

    A range has an address called an range address.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A range in this context refers to a group or collection of cells in a spreadsheet. Each range is assigned a unique address, known as a range address, which helps to identify and locate the specific range within the spreadsheet. Therefore, the statement that a range has an address called a range address is true.

    Rate this question:

  • 4. 

    There are three worksheets with every new workbook. You can change that automatic number if you want to. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Every new workbook in Excel comes with three default worksheets. However, if desired, the user has the ability to change the automatic number of worksheets. Therefore, the statement is true.

    Rate this question:

  • 5. 

    An example of a  range address.

    • A1;B3

    • A1-B3

    • A1:B3

    • A1*B3

    • A1&B3

    Correct Answer
    A. A1:B3
    Explanation
    The correct answer is A1:B3 because it represents a range of cells in a spreadsheet, starting from cell A1 and ending at cell B3. The colon (:) is used to indicate the range between the starting and ending cells.

    Rate this question:

  • 6. 

    ###### means: 

    • You've entered a number wrong.

    • You've misspelled something.

    • The cell is not wide enough.

    • All of the above

    • None of the above

    Correct Answer
    A. The cell is not wide enough.
    Explanation
    The correct answer is "The cell is not wide enough" because the use of "######" in a cell is a formatting feature in Excel that indicates the cell is not wide enough to display the entire content of the cell. When a cell contains a long number or text, Excel will display "######" to indicate that the content is too wide for the cell. This can be resolved by widening the cell or adjusting the column width to accommodate the content.

    Rate this question:

  • 7. 

    The formula = ((A2+B5)*5% is valid

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The given formula is not valid because it is missing a closing parenthesis. The correct formula should be = ((A2+B5)*5%).

    Rate this question:

  • 8. 

     It is possible to print multiple sheets or tabs in Microsoft Excel, all at the same time.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In Microsoft Excel, it is indeed possible to print multiple sheets or tabs at the same time. This can be done by selecting the sheets or tabs that need to be printed, and then choosing the print option. This feature is helpful when there is a need to print multiple sheets or tabs together, saving time and effort.

    Rate this question:

  • 9. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    If you choose a larger font size, the height of the row is automatically made taller. This statement is true because when you increase the font size, the text takes up more space vertically, which in turn increases the height of the row to accommodate the larger text.

    Rate this question:

  • 10. 

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

    • Enter

    • Autofit

    • Format Painter

    • Esc

    Correct Answer
    A. 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 border, to multiple cells without manually adjusting each one. Simply select the cell with the desired format, click on the Format Painter button, and then click on the cell(s) where you want to apply the same format.

    Rate this question:

  • 11. 

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

    • Count

    • Average

    • Sum

    • None of the above

    Correct Answer
    A. Sum
    Explanation
    The formula that can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is the "Sum" formula. This formula is specifically designed to add up numerical values and exclude non-numeric values from the calculation. By using the "Sum" formula, you can easily calculate the total sum of a range of cells without having to manually filter out non-numeric values.

    Rate this question:

  • 12. 

    A fast way to add up this column of numbers is to click in the cell below the numbers and then:

    • Click Subtotals on the Data menu

    • View the sum in the formula bar.

    • Click the AutoSum button on the Standard toolbar, then press ENTER.

    • All of the above

    • None of the above

    Correct Answer
    A. Click the AutoSum button on the Standard toolbar, then press ENTER.
    Explanation
    The correct answer is "Click the AutoSum button on the Standard toolbar, then press ENTER." This is the fastest way to add up the column of numbers. By clicking the AutoSum button, Excel automatically selects the range of cells above the active cell and inserts the SUM function in the formula bar. Pressing ENTER then calculates and displays the sum in the active cell. The other options mentioned in the question are not the fastest methods for adding up the column of numbers.

    Rate this question:

  • 13. 

    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?

    Correct Answer
    =AVERAGE(A1:A5)
    =(A1+A2+A3+A4+A5)/5
    =average(a1:a5)
    =(a1+a2+a3+a4+a5)/5
    Explanation
    The correct answer is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5. Both formulas will give the average of the values in cells A1 to A5. The AVERAGE function calculates the average directly, while the second formula manually adds up the values and divides by the count of values (in this case, 5). The third and fourth options are the same as the first two, just written in lowercase.

    Rate this question:

  • 14. 

    How do you change column width to fit the contents?

    • Single-click the boundary to the left of the column heading.

    • Double-click the boundary to the right of the column heading.

    • Press ALT and single-click anywhere in the column.

    • All of the above

    • None of the above

    Correct Answer
    A. Double-click the boundary to the right of the column heading.
    Explanation
    To change the column width to fit the contents in Excel, you can double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to accommodate the widest content within it. Single-clicking the boundary to the left of the column heading or pressing ALT and single-clicking anywhere in the column will not achieve the desired result. Therefore, the correct answer is to double-click the boundary to the right of the column heading.

    Rate this question:

  • 15. 

    A Formula and a function are the same thing.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    False. A formula and a function in Excel are not the same thing.
    A formula is an expression that you create inside a cell. It can be as simple or as complex as you need it to be, and it performs calculations or tasks you set up. Formulas must start with an equal sign when inserted into a cell. For example, =1+2 and =A1+D3 are formulas.
    A function, on the other hand, is a predefined formula already available in Excel. Functions allow you to make calculations, formatting, and similar tasks without needing to know operators or programming languages. For example, =SUM(A1:A10) is a function.
    So, while a cell in Excel can only have one formula, the formula itself can consist of multiple functions.

    Rate this question:

  • 16. 

    To add a new row, click a cell in the row immediately above where you want the new row.  

    • True

    • False

    Correct Answer
    A. False
    Explanation
    To add a new row in a table, you need to click a cell in the row immediately below where you want the new row. Therefore, the statement "To add a new row, click a cell in the row immediately above where you want the new row" is false.

    Rate this question:

  • 17. 

    Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy...

    • Click the Paste button on the Standard toolbar.

    • Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

    • Click the arrow on the Paste button on the Standard toolbar, then click Values.

    • All of the above

    • None of the above

    Correct Answer
    A. Click the arrow on the Paste button on the Standard toolbar, then click Values.
    Explanation
    To paste only the result of a formula without the underlying formula itself, you would first copy the cell with the formula. Then, you would place the insertion point in the cell where you want to paste the result. Finally, you would click the arrow on the Paste button on the Standard toolbar and select "Values" from the options. This will paste only the calculated value of the formula into the destination cell, without including the formula itself.

    Rate this question:

  • 18. 

    Labels are aligned at the ________ edge of the cell.

    • Left

    • Right

    • Top

    • Bottom

    • None of the above

    Correct Answer
    A. Left
    Explanation
    Labels are aligned at the left edge of the cell. This means that the labels are positioned on the left side of the cell, ensuring that they are aligned with the left border of the cell.

    Rate this question:

  • 19. 

    You can complete a cell entry by pressing

    • Enter

    • Tab

    • Shift+tab

    • An arrow key

    • Another cell

    • All of the above

    • None of the above

    Correct Answer
    A. All of the above
    Explanation
    You can complete a cell entry by pressing Enter, Tab, shift+tab, an arrow key, or another cell. These are all valid ways to finish inputting data into a cell in a spreadsheet or data entry program.

    Rate this question:

  • 20. 

    How do you know a range is active?

    • It is highlighted on the screen.

    • It has a marquee around it.

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

    • I'm psychic & I just Know!!

    • All of the above except "I'm psychic & I just Know!!"

    • None of the above

    Correct Answer
    A. It is highlighted on the screen.
    Explanation
    The correct answer is "It is highlighted on the screen." This means that when a range is active, it will be visually distinguished from other elements on the screen, such as by being highlighted or having a different color or shading. This visual cue helps the user identify which range is currently active and allows them to interact with it accordingly.

    Rate this question:

  • 21. 

    The default font keyed in a new work book is -

    • Verdana

    • Calibri 

    • Ariel 

    • Times New Roman

    • None of the above

    Correct Answer
    A. Calibri 
    Explanation
    The default font in a new workbook in Microsoft Excel is Calibri at size 11. 

    Rate this question:

  • 22. 

    For tips and warnings in “Defining Names”, we can use spaces or special characters in the names.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    In "Defining Names", it is not recommended to use spaces or special characters in the names. This is because spaces and special characters can cause errors or confusion in the program. It is best to use alphanumeric characters and underscores (_) in the names to ensure clarity and avoid any potential issues.

    Rate this question:

  • 23. 

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

    • Label

    • Workbook

    • Worksheet

    • Column

    • Range

    • None of the above

    Correct Answer
    A. Range
    Explanation
    A range is a group of cells that form a rectangle on the screen. It can include multiple rows and columns, allowing for the selection and manipulation of a specific area of a spreadsheet. Ranges are commonly used for performing calculations, formatting data, and applying formulas or functions to a specific set of cells.

    Rate this question:

  • 24. 

    The following formula show “Fair”, “Good” or “Excellent” depending on the value of A1 but there is an error in the logic. What value produces an incorrect result?                                   =IF(A1<500,”Fair”,IF(AND(A1>500,A1<1500),”Good”,”Excellent”))

    • A value of 0 will display “Good”

    • A value of 500 will display “Excellent”

    • A value of 1500 will display “Fair”

    • A value of -500 will display “Excellent”

    • None of the above

    Correct Answer
    A. A value of 500 will display “Excellent”
    Explanation
    The correct answer is that a value of 500 will display "Excellent". This is because the logic in the formula is incorrect. The first condition checks if A1 is less than 500, and if true, it displays "Fair". The second condition checks if A1 is greater than 500 and less than 1500, and if true, it displays "Good". However, if A1 is exactly 500, it does not meet the first condition but also does not meet the second condition, so it falls into the default else case and displays "Excellent". This is an error in the logic of the formula.

    Rate this question:

  • 25. 

    Which key do you press to group two or more nonadjacent worksheets? 

    • CTRL

    • SHIFT

    • ALT

    • ENTER

    • None of the above

    Correct Answer
    A. SHIFT
    Explanation
    To group two or more nonadjacent worksheets, you would press the SHIFT key. Pressing the SHIFT key allows you to select multiple worksheets that are not next to each other in the worksheet tab bar. This feature is useful when you want to perform an action, such as formatting or entering data, on multiple worksheets simultaneously.

    Rate this question:

  • 26. 

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

    • Cell selector

    • Cell cross

    • Selection Pointer

    • Range Selector

    • None of the above

    Correct Answer
    A. 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 indicate the range of cells you want to select or manipulate.

    Rate this question:

  • 27. 

    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. ...

    • True

    • False

    Correct Answer
    A. False
    Explanation
    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down CTRL, and then drag the selected sheet along the row of sheet tabs. The statement in the question is incorrect as it mentions holding down SHIFT instead of CTRL.

    Rate this question:

  • 28. 

    We can create range names by simply defining names in Excel. Provide the path on how to define names using Microsoft Excel: Kindly separate your answers with either > or , (no extra spaces please). Example: a>b>c or a,b,c

    Correct Answer
    Insert>Name>Define
    Insert,Name,Define
  • 29. 

    #VALUE! means: 

    • An empty cell

    • Wrong formula

    • Has one or more space characters

    • None of the above

    Correct Answer
    A. Has one or more space characters
    Explanation
    The value #VALUE! indicates that a cell contains one or more space characters. This means that the cell appears empty, but it actually contains spaces.

    Rate this question:

  • 30. 

    Outlining data in an Excel spreadsheet will organize the sheet and make it easier to view. Provide the path on how to create an outline using Microsoft Excel. Kindly separate your answers with either > or , (no extra spaces please). Example: a>b>c or a,b,c

    Correct Answer
    Data > Group and outline > Group
    Data>Group and outline>Group
    Data,Group and outline,Group

Quiz Review Timeline (Updated): Nov 9, 2023 +

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

  • Current Version
  • Nov 09, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 30, 2012
    Quiz Created by
    PRST_GY
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.