Excel Advanced Questions By Akshay Magre

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 Pavan86
P
Pavan86
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,839
| Attempts: 365
SettingsSettings
Please wait...
  • 1/20 Questions

    Can we hide a sheet????

    • True
    • False
Please wait...
About This Quiz

This Set of Questions are for Target Audience already aware of Basic Excel Concepts.

Questions : 20
Time Limit : 40 mins
Pass Criteria : 60 %

Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

    • B1:G10

    • B1-G10

    • B1;G10

    • B1&G10

    Correct Answer
    A. B1:G10
    Explanation
    The correct answer is B1:G10 because it represents a range of cells starting from B1 and extending to column G and down to row 10. The colon (:) is used to indicate a range of cells in Excel.

    Rate this question:

  • 3. 

    To add two cells (A1 and A2) together you use the following formula

    • =A1+A2

    • =Add(A1+A2)

    • =together(A1:A2)

    • A1 plus A2

    Correct Answer
    A. =A1+A2
    Explanation
    The correct answer is =A1+A2 because it is the correct formula to add the values in cells A1 and A2 together. The plus sign (+) is used to indicate addition in Excel formulas, so =A1+A2 means adding the value in cell A1 to the value in cell A2.

    Rate this question:

  • 4. 

    Excel uses the …. Function when creating a data table

    • Average

    • Count

    • Sum

    • Table

    Correct Answer
    A. Table
    Explanation
    Excel uses the "Table" function when creating a data table. This function allows users to organize and analyze data in a structured format. By converting a range of data into a table, users can easily sort, filter, and perform calculations on the data. Tables also provide automatic formatting and dynamic range expansion, making it a convenient tool for data analysis in Excel.

    Rate this question:

  • 5. 

    What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

    • Spreadsheet program

    • Database program

    • Word processor program

    • Desktop publisher program

    Correct Answer
    A. Spreadsheet program
    Explanation
    A computer program that organizes data in rows and columns of cells is called a spreadsheet program. This type of program is commonly used to keep track of financial information, such as recording the money earned from mowing lawns over the summer.

    Rate this question:

  • 6. 

     How do you change column width to fit the contents?

    • Single-click the boundary to the left to 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 above

    Correct Answer
    A. Double click the boundary to the right of the column heading
    Explanation
    Double clicking the boundary to the right of the column heading will automatically adjust the column width to fit the contents.

    Rate this question:

  • 7. 

    Which of the following is correct Syntax in excel?

    • =IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)

    • =IF(LOGICAL TEST,FALSE RESULT,TRUE RESULT)

    • =IF(LOGICAL TEST,TRUE RESULT)(LOGICAL TEST, FALSE RESULT)

    • ALL OF THE ABOVE

    Correct Answer
    A. =IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)
    Explanation
    The correct syntax in Excel is "=IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)". This formula is used to perform a logical test and return different values based on the result of the test. The logical test is placed in the first argument, the value to be returned if the test is true is placed in the second argument, and the value to be returned if the test is false is placed in the third argument.

    Rate this question:

  • 8. 

    The LEN function does what?

    • Compares the content in two cells

    • Counts the numbers of characters in a cell

    • Deletes extra space in text

    • All of above

    Correct Answer
    A. Counts the numbers of characters in a cell
    Explanation
    The LEN function is used to count the number of characters in a cell. It returns the total count of characters including letters, numbers, symbols, and spaces. It is commonly used in Excel to determine the length of a text string or to check if a cell contains a certain number of characters.

    Rate this question:

  • 9. 

    A value used in a formula that does not change is called a

    • Cell address

    • Constant

    • Function

    • Range

    Correct Answer
    A. Constant
    Explanation
    A constant is a value used in a formula that does not change. It remains fixed throughout the calculation process. Unlike variables, constants do not vary or fluctuate. They provide a fixed value for the formula to use in calculations. In this context, a cell address, function, or range does not accurately describe a value that does not change. Therefore, the correct answer is constant.

    Rate this question:

  • 10. 

    To move to previous sheet we need to use shortcut

    • CTRL + A

    • CTRL + PGUP

    • CTRL + PGDOWN

    • CTRL + HOME

    Correct Answer
    A. CTRL + PGUP
    Explanation
    To move to the previous sheet in a spreadsheet, the correct shortcut is CTRL + PGUP. This combination of keys allows the user to navigate to the sheet that comes before the current one.

    Rate this question:

  • 11. 

     What chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

    • Category axis

    • Data marker

    • Data point

    • Gridline

    Correct Answer
    A. Gridline
    Explanation
    A gridline is a horizontal or vertical line that extends across the plot area of a chart. It helps to make the chart easier to read and follow the values by providing a visual reference. Gridlines are often used in combination with axis labels to create a clear and organized chart.

    Rate this question:

  • 12. 

    You can copy data or formulas

    • With the copy, paste and cut commands

    • With commands on a shortcut

    • With buttons on the Qucik access toolbar

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    The correct answer is "All of the above" because all the options mentioned (copy, paste, cut commands; commands on a shortcut; buttons on the Quick access toolbar) allow you to copy data or formulas in Excel. These options provide different ways to perform the same action, giving users flexibility and convenience in their workflow.

    Rate this question:

  • 13. 

    Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

    • Use Ctrl to select all three cells, then click the paste button on the standard toolbar

    • Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

    • Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

    • All of above

    Correct Answer
    A. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
    Explanation
    The correct answer is to click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to. This option allows you to quickly copy the formatting from a selected cell to two other cells on the same worksheet by using the format painter tool. By double-clicking the format painter, you can copy the formatting to multiple cells without having to click the format painter again for each cell.

    Rate this question:

  • 14. 

    Weight refers to

    • The print density of characters

    • The height of the printed character

    • Upright or slanted shape

    • The design and appearance of characters

    Correct Answer
    A. The print density of characters
    Explanation
    Weight refers to the print density of characters. It refers to how dark or light the characters appear on the printed page. A higher weight indicates a darker, more solid print, while a lower weight indicates a lighter, more transparent print. The weight of characters can affect readability and the overall visual impact of the printed material.

    Rate this question:

  • 15. 

    Late for your investors meeting? How can you quickly apply professional formatting to your sales forecast worksheet?

    • Apply special attributes using Format Painter

    • Apply an Auto Format Style

    • Apply a selected background color

    • All of above

    Correct Answer
    A. Apply an Auto Format Style
    Explanation
    Applying an Auto Format Style allows you to quickly and easily apply professional formatting to your sales forecast worksheet. This feature automatically applies a pre-designed format to your data, saving you time and effort in manually formatting the worksheet. It ensures consistency and a professional look throughout the document.

    Rate this question:

  • 16. 

    You can use drag and drop to embed excel worksheet data in a word document

    • By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

    • By dragging a range of excel data to the Word button on the taskbar while pressing Shift key

    • By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

    • A and c

    Correct Answer
    A. A and c
    Explanation
    You can use drag and drop to embed excel worksheet data in a word document by either dragging a range of excel data to the Word button on the taskbar while pressing the Ctrl key or by displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key.

    Rate this question:

  • 17. 

    Using the F11 shortcut key to create a chart on chart sheet creates

    • A default chart

    • A 2-dimensional column chart

    • A 2-dimensional bar chart

    • A 3-dimensional line chart

    Correct Answer
    A. A 2-dimensional column chart
    Explanation
    Using the F11 shortcut key to create a chart on a chart sheet in Excel creates a 2-dimensional column chart. This means that the chart will display data in columns, with one axis representing the categories and the other axis representing the values. The chart will be in 2D, meaning it will not have any depth or perspective. This is the default chart type that is created when using the F11 shortcut key.

    Rate this question:

  • 18. 

    You can group noncontiguous worksheets with

    • The group button on the standard toolbar

    • The shift key and the mouse

    • The ctrl key and mouse

    • The alt+enter key

    Correct Answer
    A. The ctrl key and mouse
    Explanation
    You can group noncontiguous worksheets by holding down the ctrl key on your keyboard and selecting the desired worksheets with your mouse. This allows you to perform actions, such as formatting or entering data, on multiple worksheets at once.

    Rate this question:

  • 19. 

    Which of the following is a correct order of precedence in a formula calculation?

    • Multiplication and division, exponential positive and negative value

    • Multiplication and division, positive and negative values, addition and subtraction

    • Addition and subtraction, positive and negative values, exponentiation

    • None of above

    Correct Answer
    A. None of above
    Explanation
    The given options do not provide a correct order of precedence in a formula calculation. The correct order of precedence is typically parentheses, exponentiation, multiplication and division (from left to right), and addition and subtraction (from left to right). Therefore, the correct answer is "None of above" as none of the options provide the correct order of precedence.

    Rate this question:

  • 20. 

     which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

    • Workday

    • Date

    • Networkdays

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    The correct answer is "All of the above" because all three functions (workday, date, and networkdays) can be used to calculate the number of workdays between two dates. Each function has its own syntax and parameters, but they all serve the same purpose of counting the number of workdays. Therefore, any of these functions can be used to calculate the number of workdays between 6/9/2004 and 8/12/2004.

    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
  • Apr 18, 2013
    Quiz Created by
    Pavan86
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.