MCQ Of Microsoft Excel Set-1st

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 Gupta_gourav763
G
Gupta_gourav763
Community Contributor
Quizzes Created: 2 | Total Attempts: 2,403
| Attempts: 769
SettingsSettings
Please wait...
  • 1/10 Questions

    Worksheet can be renamed by

    • Adding ? symbol at the end of filename while saving workbook
    • Click on Worksheet tab by Holding CTRL Key and type new name
    • Double Click on the Worksheet tab and type new name
    • Worksheet cannot renamed
Please wait...
About This Quiz

This Quiz is just as similar to IBPS and other banking exams so that it would be easy to give the exams likewise. .

Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    IBPS-1-1. Which of the following is correct syntax in Excel?  

    • A. =IF(LogicalTest, TrueResult, FalseResult)

    • B. =IF(LogicalTest, (TrueResult, FalseResult))

    • C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

    • D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

    Correct Answer
    A. A. =IF(LogicalTest, TrueResult, FalseResult)
    Explanation
    The correct syntax in Excel is A. =IF(LogicalTest, TrueResult, FalseResult). This formula is used to perform a logical test and return different results based on whether the test is true or false. The LogicalTest is the condition that is being evaluated, TrueResult is the value or expression that is returned if the condition is true, and FalseResult is the value or expression that is returned if the condition is false.

    Rate this question:

  • 3. 

    How to fit long texts in a single cell with multiple lines?

    • Start typing in the cell and press the Enter key to start another line

    • Use the Wrap Text option in the Format -> Alignment menu

    • Use the Shrink to Fit option in the Format -> Cells -> Alignment menu

    • All of above

    Correct Answer
    A. Use the Wrap Text option in the Format -> Alignment menu
    Explanation
    To fit long texts in a single cell with multiple lines, the correct answer is to use the Wrap Text option in the Format -> Alignment menu. This option allows the text to wrap within the cell, automatically adjusting the height of the cell to accommodate the text. By selecting this option, the text will be displayed in multiple lines within the cell, making it easier to read and fit within the available space.

    Rate this question:

  • 4. 

    If the cell B1 contains the formula = $A$1, which of the following statements is true

    • There is a relative reference to cell A1

    • There is an absolute reference to cell A1

    • Further changes in value of A1 will not affect the value of B1

    • Further changes in value of B1 will affect the value of A1

    Correct Answer
    A. There is an absolute reference to cell A1
    Explanation
    The formula in cell B1 contains an absolute reference to cell A1. This means that the value in cell B1 will always refer to the value in cell A1, regardless of any changes made to the value in cell A1. Any further changes in the value of A1 will not affect the value of B1.

    Rate this question:

  • 5. 

    IBPS-1-2. Which of the following is correct?

    • A. =POWER(2^3)

    • B. =POWER(2,3)

    • C. =POWER(2#3)

    • D. =POWER(2*3)

    Correct Answer
    A. B. =POWER(2,3)
    Explanation
    The correct answer is B. =POWER(2,3). This is because the POWER function in Excel is used to calculate the result of a number raised to a specified power. In this case, the number 2 is raised to the power of 3, resulting in 8. The syntax for the POWER function is =POWER(number, power). Therefore, the correct format for raising 2 to the power of 3 is =POWER(2,3).

    Rate this question:

  • 6. 

    Selecting the Rows 5 & 6 then choose Insert->Row. What will happen?

    • A. 2 Rows will be inserted after Row 4

    • B. 2 Rows will be inserted after Row 5

    • C. 2 Rows will be inserted after Row 6

    • D. 2 Rows will be inserted after Row 7

    Correct Answer
    A. A. 2 Rows will be inserted after Row 4
    Explanation
    Selecting Rows 5 & 6 and choosing Insert->Row will insert 2 rows after Row 4. This means that the existing Row 5 and Row 6 will shift down, and the new rows will be added after Row 4.

    Rate this question:

  • 7. 

    If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?

    • A. =A1 + “@” + B1

    • B. =A1 # “@” # B1

    • C. =A1 & “@” & B1

    • D. =A1 $ “@” $ B1

    Correct Answer
    A. C. =A1 & “@” & B1
    Explanation
    The correct answer is C. =A1 & “@” & B1. This function uses the ampersand (&) operator to concatenate the values in cell A1, the "@" symbol, and the values in cell B1, resulting in the desired output "MCQ@Questions" in cell C1.

    Rate this question:

  • 8. 

    If 4/6 entered in a cell without applying any formats, Excel will treat this as

    • Fraction

    • Number

    • Text

    • Date

    Correct Answer
    A. Date
  • 9. 

    If particular workbook have to open each time Excel started, where that workbook should be placed?

    • AUTOEXEC Folder

    • AUTOSTART Folder

    • EXCELSTART Folder

    • XLSTART Folder

    Correct Answer
    A. XLSTART Folder
    Explanation
    The correct answer is XLSTART Folder. The XLSTART folder is a special folder in Excel that contains workbooks that are automatically opened when Excel starts. Placing the workbook in the XLSTART folder ensures that it will be opened every time Excel is launched. This is useful for workbooks that need to be accessed frequently or serve as templates for new workbooks.

    Rate this question:

  • 10. 

    What is the shortcut key to hide entire row?

    • CTRL + H

    • CTRL + R

    • CTRL + 9

    • CTRL + -

    Correct Answer
    A. CTRL + 9
    Explanation
    Pressing CTRL + 9 is the shortcut key to hide an entire row in Excel. This shortcut allows users to quickly hide a row without having to go through the menu options.

    Rate this question:

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

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 06, 2013
    Quiz Created by
    Gupta_gourav763
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.