Can You Pass This Microsoft Excel Exam 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 Arunavaguha416
A
Arunavaguha416
Community Contributor
Quizzes Created: 1 | Total Attempts: 555
| Attempts: 555
SettingsSettings
Please wait...
  • 1/15 Questions

    WHAT IS SHORTCUT FOR COPY ?

    • CTRL+C
    • CTRL
    • COPY
    • PASTE
Please wait...
About This Quiz

This quiz tests your proficiency in Microsoft Excel, covering basic functions like cell addressing, shortcuts, formula initiation, syntax correctness, and cell interaction. It's designed to evaluate essential skills for effective spreadsheet management.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    HOW TO START ANY FORMULA IN A CELL ?

    • /

    • *

    • +

    • =

    Correct Answer
    A. =
    Explanation
    To start any formula in a cell, you need to use the "=" sign. This signifies to the spreadsheet software that you are entering a formula and not just typing in regular text. By using the "=" sign, you are instructing the software to perform calculations or functions based on the formula you input after the "=" sign.

    Rate this question:

  • 3. 

    A EXCEL SHEET CONTAINS ?

    • ROW

    • COLUMN

    • ROW AND COLUMN

    • LINES

    Correct Answer
    A. ROW AND COLUMN
    Explanation
    An Excel sheet contains both rows and columns. Rows are horizontal lines that run across the sheet, while columns are vertical lines that run down the sheet. Rows are identified by numbers, while columns are identified by letters. The intersection of a row and a column is called a cell, and each cell can hold data such as text, numbers, or formulas. Therefore, an Excel sheet consists of both rows and columns to organize and store data effectively.

    Rate this question:

  • 4. 

    CAN WE ADD PICTURE IN A EXCEL SHEET ?

    • YES

    • NO

    Correct Answer
    A. YES
    Explanation
    Pictures can be added to an Excel sheet by using the "Insert" tab and selecting the "Picture" option. This allows users to insert images from their computer or from online sources into their Excel spreadsheet. Adding pictures can be useful for visualizing data or adding additional context to the information in the sheet.

    Rate this question:

  • 5. 

    AN EXAMPLE OF  CELL ADDRESS .. 

    • 23G

    • 11

    • A11

    • A

    Correct Answer
    A. A11
    Explanation
    The given answer "A11" is an example of a cell address in a spreadsheet. In spreadsheets, cell addresses are used to identify and locate specific cells. In this case, "A11" represents a cell in column A and row 11. The letter "A" represents the column, and the number "11" represents the row. By using cell addresses, users can easily reference and manipulate data within a spreadsheet.

    Rate this question:

  • 6. 

    EVERY CELL MUST HAVE A ADDRESS ..

    • TRUE

    • FALSE

    Correct Answer
    A. TRUE
    Explanation
    Every cell in a system or structure must have an address in order to be identified and located. This is essential for efficient organization and communication within the system. Without addresses, it would be difficult to refer to specific cells and track information accurately. Therefore, it is true that every cell must have an address.

    Rate this question:

  • 7. 

    CTRL + X COMMAND IS USED FOR ?

    • CUT

    • COPY

    • PASTE

    Correct Answer
    A. CUT
    Explanation
    CTRL + X command is used for cutting text or selected content from a document or file. This means that the selected content is removed from its original location and stored in the clipboard. It can then be pasted elsewhere using the CTRL + V command. This command is commonly used to move or transfer content within a document or between different documents or applications.

    Rate this question:

  • 8. 

    WHICH SYNTAX IS CORRECT ?

    • =(A1-B1)

    • (A1-B1)

    • A1

    Correct Answer
    A. =(A1-B1)
    Explanation
    The correct syntax is =(A1-B1). This formula subtracts the value in cell B1 from the value in cell A1. The equal sign at the beginning indicates that it is a formula, and the parentheses are used to group the subtraction operation.

    Rate this question:

  • 9. 

    CTRL + Z IS USED FOR ?

    • REDO

    • COPY

    • UNDO

    • PASTE

    Correct Answer
    A. UNDO
    Explanation
    The correct answer is UNDO because CTRL + Z is a keyboard shortcut commonly used to undo the previous action in many computer programs. This command allows users to reverse their last action and restore the document or file to its previous state. It is a convenient feature that helps users correct mistakes or revert changes they no longer want.

    Rate this question:

  • 10. 

    TABLE OPTION CAN BE FOUND ON ...

    • HOME

    • INSERT

    • FORMULAS

    • VIEW

    Correct Answer
    A. INSERT
    Explanation
    The correct answer is INSERT because the "Table" option is usually found in the "Insert" tab of various software applications, such as Microsoft Word or Excel. This tab contains various options for inserting different types of objects, including tables. Therefore, the correct option for finding the "Table" option is INSERT.

    Rate this question:

  • 11. 

    On an excel sheet the active cell in indicated by ?

    • A dark wide border

    • WITH A DOT

    • COLOR OF THE CELL IS CHANGED

    • By italic text

    Correct Answer
    A. A dark wide border
    Explanation
    The active cell on an Excel sheet is indicated by a dark wide border. This border helps the user easily identify which cell they are currently working on. It stands out from the rest of the cells and provides a visual cue. This is a common feature in spreadsheet software to assist users in navigating and editing their data efficiently.

    Rate this question:

  • 12. 

    Which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

    • IF

    • OR

    • AND

    • NOT

    Correct Answer
    A. IF
    Explanation
    The IF function is a logical function that evaluates a condition and returns "TRUE" or "FALSE" based on the result. It allows us to perform different actions based on whether the condition is true or false. Therefore, the IF function is the correct answer as it shows the word "TRUE" or "FALSE" as a result.

    Rate this question:

  • 13. 

    PRODUCT FUNCTION IS USED FOR ?

    • MULTIPLICATION

    • DIVISION

    • ADDITION

    • NOTHING

    Correct Answer
    A. MULTIPLICATION
    Explanation
    The product function is used for multiplication. It is a mathematical operation that combines two or more numbers to find their total value when they are multiplied together. The product function can be used to calculate the result of multiplying any given numbers, making it a useful tool in mathematical calculations and problem-solving.

    Rate this question:

  • 14. 

    If you press ___, the cell accepts your typing as its contents ?

    • SHIFT+ENTER

    • ENTER

    • CTRL

    • CTRL+ENTER

    Correct Answer
    A. ENTER
    Explanation
    When you press "ENTER," the cell in question accepts your typing as its contents. This is because "ENTER" is the key that is typically used to confirm and finalize any input or changes made in a cell. By pressing "ENTER," you are indicating to the spreadsheet software that you have finished entering data or making edits, and it should accept and store the information you have inputted.

    Rate this question:

  • 15. 

    What is Microsoft Excel?

    • Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.

    • IT IS USED FOR VARIOUS CALCULATION

    • ANY OF THE ABOVE

    Correct Answer
    A. ANY OF THE ABOVE
    Explanation
    Microsoft Excel is a widely used electronic worksheet developed by Microsoft. It is primarily used for organizing, storing, and manipulating data. However, it is also extensively used for various calculations, making it a versatile tool for professionals in various fields. Therefore, the correct answer is "Any of the above," as Microsoft Excel can be used for organizing, storing, manipulating data, and performing calculations.

    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
  • Sep 09, 2015
    Quiz Created by
    Arunavaguha416
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.