Advanced Excel Quiz Questions And Answers

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By SPACECOMPUTER
S
SPACECOMPUTER
Community Contributor
Quizzes Created: 10 | Total Attempts: 49,136
Questions: 50 | Attempts: 6,952

SettingsSettingsSettings
Advanced Excel Quiz Questions And Answers - Quiz

Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your knowledge below.


Questions and Answers
  • 1. 

     _______ tab, in the Editing group, click Find & Select, and then click Go To.

    • A.

      Data

    • B.

      Home

    Correct Answer
    B. Home
    Explanation
    In order to access the Go To feature, you need to go to the Home tab. Within the Home tab, you will find the Editing group, where the Find & Select option is located. By clicking on Find & Select, a drop-down menu will appear, and from there you can select Go To. Therefore, the correct answer is Home.

    Rate this question:

  • 2. 

     On the _____tab, in the Font group,

    • A.

      Home

    • B.

      Data

    Correct Answer
    A. Home
    Explanation
    The correct answer is "Home" because the question is asking about the tab where the Font group is located. The Font group contains options for formatting text, such as changing the font type, size, and style. The Home tab is typically where you can find basic formatting options for text in programs like Microsoft Word and Excel.

    Rate this question:

  • 3. 

    On the ----------tab, in the Page Setup group, click Background.

    • A.

      Page layout

    • B.

      Home

    Correct Answer
    A. Page layout
    Explanation
    In the given question, the correct answer is "Page layout". This answer is based on the information provided in the question, which states that on the "----------tab, in the Page Setup group, click Background". Therefore, the answer "Page layout" is the appropriate option in this context.

    Rate this question:

  • 4. 

    On the ----------tab, in the Page Setup group, click Background.

    • A.

      1.       Customize Ribbon

    • B.

      2.       Page layout

    Correct Answer
    B. 2.       Page layout
    Explanation
    In order to access the Background option in the Page Setup group, the user needs to be on the Page layout tab. This tab contains various options related to the layout and formatting of the page, including the Background option. Therefore, the correct answer is Page layout.

    Rate this question:

  • 5. 

    Open a new, blank workbook

    • A.

      CTRL+N.

    • B.

      CTRL+s.

    Correct Answer
    A. CTRL+N.
    Explanation
    Pressing CTRL+N opens a new, blank workbook in most spreadsheet software programs. CTRL+s is the shortcut for saving the current file, not for opening a new workbook. Therefore, the correct answer is pressing CTRL+N.

    Rate this question:

  • 6. 

    On the ------------tab, in the Sparklines group, click the type of sparkline that you want to create

    • A.

      Insert

    • B.

      Data

    Correct Answer
    A. Insert
    Explanation
    The correct answer is "insert". In Microsoft Excel, to create a sparkline, you need to go to the "Insert" tab. Within the "Insert" tab, there is a group called "Sparklines" where you can find different types of sparklines that you can choose from. By clicking on the desired type of sparkline, you can create it in your worksheet.

    Rate this question:

  • 7. 

    On the------------ tab, in the Clipboard group, click Copy

    • A.

      Customize Ribbon

    • B.

      Home

    Correct Answer
    B. Home
    Explanation
    The correct answer is "Home" because the question is asking where to find the "Copy" function in the Clipboard group. The Clipboard group is located on the "Home" tab, so clicking on "Home" will allow you to access the Copy function.

    Rate this question:

  • 8. 

    Under SmartArt Tools, on the Format tab, in the _____ group, click the arrow next to Shape Outline.

    • A.

      1.     Shape Styles group,

    • B.

      2.       Data

    Correct Answer
    A. 1.     Shape Styles group,
    Explanation
    Under SmartArt Tools, on the Format tab, in the Shape Styles group, you can find various options to customize the appearance of the shape outline. By clicking the arrow next to Shape Outline, you can access additional settings such as changing the color, weight, and style of the outline. This allows you to enhance the visual appeal of your SmartArt graphic and make it more visually appealing and professional-looking.

    Rate this question:

  • 9. 

    If the Developer tab is not available, do the following to display it: File tab, - Options- ____________-  Developer -OK.

    • A.

      Customize Ribbon

    • B.

        Data

    Correct Answer
    A. Customize Ribbon
    Explanation
    To display the Developer tab, you need to go to the File tab, then select Options. In the Options menu, you will find the Customize Ribbon option. By selecting Customize Ribbon and clicking OK, the Developer tab will be displayed.

    Rate this question:

  • 10. 

      On the ________tab, in the Styles group,

    • A.

      home

    • B.

        Data

    Correct Answer
    A. home
    Explanation
    The correct answer is "home". This suggests that the Styles group can be found on the Home tab.

    Rate this question:

  • 11. 

     thesaurus in _______ menu

    • A.

      Data

    • B.

      Review

    Correct Answer
    B. Review
    Explanation
    The correct answer is "Review" because a thesaurus is a tool used to find synonyms and antonyms for words, and the "Review" menu often includes options for checking and editing the content of a document, which would include the use of a thesaurus.

    Rate this question:

  • 12. 

    Sub total _______menu

    • A.

        Data

    • B.

      Review

    Correct Answer
    A.   Data
  • 13. 

    Data validation from __________ menu

    • A.

      Data

    • B.

      Review

    Correct Answer
    A. Data
  • 14. 

    New coment from ______________ menu

    • A.

      Insert

    • B.

      Data

    Correct Answer
    A. Insert
    Explanation
    The correct answer is "Insert" because the given comment suggests that there is a new comment and the user wants to insert or add some data related to that comment. The "Insert" option is likely to allow the user to input or append the desired data into the comment section.

    Rate this question:

  • 15. 

    New coment from ______________ menu

    • A.

      Insert

    • B.

      Data

    Correct Answer
    A. Insert
    Explanation
    The given correct answer is "Insert". It is likely that the question is asking about a feature or option in a menu, and the correct answer is the action of inserting something. This could refer to inserting new comments or data into a system or document. Without more context, it is difficult to provide a more specific explanation.

    Rate this question:

  • 16. 

     What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

    • A.

      Elect both cells, and then drag the fill handle Fill handle over the range you want, for instance 18 more rows.

    • B.

      Select the range you want, including both cells, point to Fill on the Edit menu, and then click down.

    Correct Answer
    A. Elect both cells, and then drag the fill handle Fill handle over the range you want, for instance 18 more rows.
    Explanation
    To extend the numbers to a longer sequence, you can select both cells and drag the fill handle over the range you want. In this case, you would drag it for 18 more rows to include the numbers 1 through 20.

    Rate this question:

  • 17. 

    Which symbol must all formula begin with?

    • A.

      =

    • B.

      +

    Correct Answer
    A. =
    Explanation
    All formulas must begin with the "=" symbol. This symbol is used to indicate that the following characters are part of a formula and not just regular text. It is a convention in spreadsheet programs like Microsoft Excel and Google Sheets to use the "=" symbol at the start of a formula to differentiate it from other text entries. This allows the program to recognize and evaluate the formula correctly.

    Rate this question:

  • 18. 

    A typical worksheet has …. Number of columns

    • A.

      128

    • B.

      256

    Correct Answer
    B. 256
    Explanation
    A typical worksheet has 256 number of columns. This means that the worksheet can accommodate data in 256 different columns. The number of columns in a worksheet determines the horizontal space available for organizing and analyzing data. With 256 columns, users can input and manipulate a large amount of information in a structured manner.

    Rate this question:

  • 19. 

    The  Chart wizard term data categories refers to;

    • A.

      A chart plot area

    • B.

      A horizontal axis

    Correct Answer
    B. A horizontal axis
    Explanation
    The term "data categories" in the context of the Chart wizard refers to a horizontal axis. In a chart, the horizontal axis represents the categories or groups that the data is being plotted against. It is used to display and label the different categories or groups of data in the chart, allowing for easy comparison and analysis.

    Rate this question:

  • 20. 

    A worksheet range is a

    • A.

      A group of cells

    • B.

      A group of worksheets

    Correct Answer
    A. A group of cells
    Explanation
    A worksheet range refers to a group of cells within a worksheet. It allows for the selection and manipulation of multiple cells simultaneously, making it easier to perform calculations or formatting changes across a specific set of cells. By selecting a range of cells, you can apply functions, formulas, or formatting options to all the cells within that range, saving time and effort.

    Rate this question:

  • 21. 

    The auto calculate feature

    • A.

      Can only add values in a range of cells

    • B.

      Provides a quick way to view the result of an arithmetic operation on a range of cells

    • C.

      Option 3

    • D.

      Option 4

    Correct Answer
    B. Provides a quick way to view the result of an arithmetic operation on a range of cells
    Explanation
    The auto calculate feature in Excel allows users to quickly view the result of an arithmetic operation on a range of cells. This means that users do not have to manually input formulas or functions to perform calculations, as the auto calculate feature automatically updates and displays the result. This feature is particularly useful when working with large sets of data, as it provides a convenient and efficient way to obtain instant calculations without the need for complex formulas or manual input.

    Rate this question:

  • 22. 

    You can edit a cell by

    • A.

      Clicking the formula button

    • B.

      Double clicking the cell to edit it in-place

    • C.

      Option 3

    • D.

      Option 4

    Correct Answer
    B. Double clicking the cell to edit it in-place
    Explanation
    Double clicking a cell allows you to directly edit its contents without the need to go to the formula bar or any other location. This feature is convenient and time-saving as it provides a quick way to make changes to the data within a cell. By double clicking, the cell becomes active for editing, and you can easily modify its content.

    Rate this question:

  • 23. 

    Which elements of worksheet can be protected from accidental modification

    • A.

      Scenarios

    • B.

      All of above

    Correct Answer
    B. All of above
    Explanation
    All of the elements of a worksheet can be protected from accidental modification. This includes cells, formulas, charts, graphics, and any other content present on the worksheet. By protecting these elements, users can prevent any unintentional changes or deletions, ensuring the integrity and accuracy of the data and calculations in the worksheet.

    Rate this question:

  • 24. 

    Files created with Lotus 1-2-3 have an extension

    • A.

      123

    • B.

      WK1

    Correct Answer
    A. 123
    Explanation
    Files created with Lotus 1-2-3 have the extension "123". This means that when a file is saved or created using Lotus 1-2-3, it will have the file name followed by the extension ".123". This extension helps to identify and distinguish Lotus 1-2-3 files from other file types.

    Rate this question:

  • 25. 

    Comments can be added to cells using

    • A.

      Edit > Comments

    • B.

      Insert > Comments

    Correct Answer
    B. Insert > Comments
    Explanation
    The correct answer is "Insert > Comments" because this option allows users to add comments to cells in a spreadsheet. By selecting this option, users can easily provide additional information or explanations about specific data or calculations in the spreadsheet. This feature is useful for collaboration and communication purposes, as it allows multiple users to leave comments and discuss the content of the spreadsheet.

    Rate this question:

  • 26. 

    Which of the following is not a worksheet design criterion?

    • A.

      Description

    • B.

      Clarity

    Correct Answer
    A. Description
    Explanation
    A worksheet design criterion refers to the factors that are considered when creating a worksheet. These criteria help ensure that the worksheet is effective and user-friendly. In this case, "Description" is not a worksheet design criterion because it does not typically play a role in determining the layout, formatting, or organization of a worksheet. Description may be important for providing context or instructions within a worksheet, but it is not a fundamental design criterion like clarity, which focuses on ensuring that the information presented on the worksheet is clear and easy to understand.

    Rate this question:

  • 27. 

    Which of the following is the latest version of Excel

    • A.

      Excel ME

    • B.

      Excel XP

    Correct Answer
    B. Excel XP
    Explanation
    Excel XP is the latest version of Excel. It was released in 2001 as part of the Microsoft Office XP suite. This version introduced several new features and improvements compared to the previous versions. It included enhanced formatting options, improved data analysis tools, and better collaboration capabilities. Excel XP also had a more user-friendly interface and improved stability and performance. Overall, Excel XP was a significant upgrade from its predecessors and remained the latest version until the release of Excel 2003.

    Rate this question:

  • 28. 

    To copy cell contents using drag and drop press the

    • A.

      Ctrl key

    • B.

      Esc key

    Correct Answer
    B. Esc key
    Explanation
    The Esc key is used to cancel or escape from a current action or operation. In the context of copying cell contents using drag and drop, pressing the Esc key would cancel the drag and drop action, preventing the contents from being copied.

    Rate this question:

  • 29. 

    Which menu option can be sued to split windows into two

    • A.

      Window > split

    • B.

      View > split

    Correct Answer
    A. Window > split
    Explanation
    The correct answer is "Window > split". This menu option allows users to split windows into two, enabling them to view multiple documents or applications side by side. By selecting this option, users can easily organize their workspace and increase productivity by easily referencing information from different sources simultaneously.

    Rate this question:

  • 30. 

    Which of the following is not information you can specify using the solver?

    • A.

      Input cells

    • B.

      Constraints

    Correct Answer
    A. Input cells
    Explanation
    The solver in question refers to a tool used to solve optimization problems. In this context, the input cells are the variables or parameters that are used as inputs to the solver. These input cells can be specified and manipulated to find the optimal solution. Therefore, the correct answer is "Input cells" because they are indeed information that can be specified using the solver.

    Rate this question:

  • 31. 

     Excel probably considers the cell entry January 1, 2000 to be a

    • A.

      Label

    • B.

      Value

    Correct Answer
    B. Value
    Explanation
    Excel probably considers the cell entry January 1, 2000 to be a value because it is a specific date that can be used in calculations and formulas. In Excel, dates are stored as numeric values, with January 1, 1900 being represented by the value 1. Therefore, January 1, 2000 would have a numeric value greater than 1, making it a value rather than a label.

    Rate this question:

  • 32. 

    All worksheet formula

    • A.

      Return a formula result

    • B.

      Use the addition operator

    Correct Answer
    A. Return a formula result
    Explanation
    The answer "Return a formula result" is correct because when using a worksheet formula, the purpose is to calculate and return a result based on the given inputs and formula logic. The formula is used to perform calculations, manipulate data, or generate specific results within a worksheet. Therefore, the main objective of using a worksheet formula is to obtain a result based on the formula's calculations.

    Rate this question:

  • 33. 

    Which of the following is not a valid data type in excel

    • A.

      Number

    • B.

      Character

    Correct Answer
    B. Character
    Explanation
    The correct answer is "Character" because in Excel, the data types are typically categorized as numbers, dates, text, and Boolean values. "Character" is not a specific data type in Excel, as it falls under the broader category of "text".

    Rate this question:

  • 34. 

    Which area in an excel window allows entering values and formulas

    • A.

      Formula bar

    • B.

      Standard toolbar

    Correct Answer
    A. Formula bar
    Explanation
    The formula bar in an Excel window is the area where users can enter both values and formulas. It is located just below the ribbon and displays the content of the active cell. This is where users can input data or write formulas to perform calculations in Excel. The formula bar is a crucial tool for data entry and formula creation in Excel.

    Rate this question:

  • 35. 

    Which of the following is a popular DOS based spreadsheet package?

    • A.

      Excel

    • B.

      Lotus 1-2-3

    Correct Answer
    B. Lotus 1-2-3
    Explanation
    Lotus 1-2-3 is a popular DOS based spreadsheet package. It was one of the first spreadsheet software programs to gain widespread popularity in the 1980s. It offered features such as advanced calculations, graphing capabilities, and database management. Lotus 1-2-3 was widely used in business and finance sectors for data analysis and financial modeling. Although it has been largely replaced by modern spreadsheet software like Microsoft Excel, Lotus 1-2-3 played a significant role in the development of spreadsheet technology.

    Rate this question:

  • 36. 

    Which of the following is not a worksheet design criterion?

    • A.

      Description

    • B.

      Clarity    

    Correct Answer
    A. Description
    Explanation
    The given answer, "Description," is not a worksheet design criterion. Worksheet design criteria typically include factors such as clarity, organization, readability, and ease of use. Description, on the other hand, refers to providing information or details about something, which may not be directly related to the design of a worksheet. Therefore, it can be concluded that description is not a criterion for designing a worksheet.

    Rate this question:

  • 37. 

     What is an expression that tells how the numbers in a determined set of cells are to be calculated?

    • A.

       Formula

    • B.

      Field

    Correct Answer
    A.  Formula
    Explanation
    An expression that tells how the numbers in a determined set of cells are to be calculated is called a formula. A formula is a mathematical equation or operation that is used to perform calculations in a spreadsheet or any other system that uses cells to store data. It can include mathematical operators, functions, and cell references to perform complex calculations and generate results based on the values in the specified set of cells.

    Rate this question:

  • 38. 

     Excel is a

    • A.

       Word processor

    • B.

      A spreadsheet

    Correct Answer
    B. A spreadsheet
    Explanation
    Excel is a spreadsheet software that allows users to create, organize, and analyze data in a tabular format. It provides various features such as mathematical functions, charts, and graphs, which are specifically designed for data analysis and manipulation. Unlike a word processor, which is used for creating and editing text documents, Excel focuses on numerical data and calculations. Therefore, the correct answer is "A spreadsheet".

    Rate this question:

  • 39. 

     When you insert an Excel file into a Word document, the data are

    • A.

      Hyperlinked

    • B.

       Placed in a word table

    Correct Answer
    B.  Placed in a word table
    Explanation
    When you insert an Excel file into a Word document, the data is placed in a Word table. This means that the content of the Excel file is organized and displayed in a structured manner within a table in the Word document. This allows for easier viewing and manipulation of the data within the Word document itself.

    Rate this question:

  • 40. 

    How are data organized in a spreadsheet?

    • A.

       Rows and columns

    • B.

       Height and width

    Correct Answer
    A.  Rows and columns
    Explanation
    Data in a spreadsheet are organized in rows and columns. Rows are horizontal lines that contain data, while columns are vertical lines that hold specific types of information. This arrangement allows for a systematic organization and easy retrieval of data. Rows are typically used to represent individual records or entries, while columns represent different attributes or variables associated with those records. By organizing data in this way, it becomes easier to analyze and manipulate information in a spreadsheet.

    Rate this question:

  • 41. 

    When you use the fill effects in the format data series dialog box, you can not

    • A.

       rotate text on the chart

    • B.

       select a fore ground color

    Correct Answer
    A.  rotate text on the chart
    Explanation
    When using the fill effects in the format data series dialog box, you are unable to rotate text on the chart. This means that you cannot change the orientation or angle of the text within the chart. The fill effects options in the dialog box only allow for modifications to the background color, patterns, and gradients of the chart elements.

    Rate this question:

  • 42. 

      Which of the following is not a basic step in creating a worksheet?

    • A.

      Enter text and data

    • B.

       Copy the worksheet

    Correct Answer
    B.  Copy the worksheet
    Explanation
    Copying the worksheet is not a basic step in creating a worksheet. The basic steps in creating a worksheet include entering text and data, formatting the worksheet, and creating formulas or functions. Copying the worksheet is typically done after the worksheet has been created and is used when you need to duplicate the worksheet for a similar purpose or to make changes without affecting the original worksheet.

    Rate this question:

  • 43. 

     Hyperlinks cannot be

    • A.

       Pictures

    • B.

      All can be hyperlinks

    Correct Answer
    B. All can be hyperlinks
    Explanation
    This answer suggests that all types of content, including pictures, can be used as hyperlinks. In other words, hyperlinks are not limited to just text or specific types of content. This means that when creating a hyperlink, any type of content can be linked to another webpage or resource, allowing users to navigate through different types of content by clicking on them.

    Rate this question:

  • 44. 

    To drag a selected range of data to another worksheet in the same workbook, use the

    • A.

       Shift key

    • B.

       Ctrl key

    Correct Answer
    B.  Ctrl key
    Explanation
    To drag a selected range of data to another worksheet in the same workbook, you need to use the Ctrl key. Pressing the Ctrl key while dragging the selected range allows you to create a copy of the data in the destination worksheet without removing it from the original worksheet. This is useful when you want to duplicate or move data between worksheets without losing the original information. The Shift key, on the other hand, is not used for this specific action.

    Rate this question:

  • 45. 

     In a worksheet you can select

    • A.

       Columns

    • B.

      ROW

    • C.

      SHEET

    • D.

       a, b, and c

    Correct Answer
    B. ROW
    Explanation
    In a worksheet, you can select rows. This means that you can highlight or choose specific rows in order to perform certain actions such as formatting, deleting, or inserting data. Selecting rows allows you to manipulate data in a more organized and efficient manner.

    Rate this question:

  • 46. 

    What term refers to a specific set of values saved with the workbook?

    • A.

      Range

    • B.

       Scenario

    Correct Answer
    B.  Scenario
    Explanation
    A scenario in Excel refers to a specific set of values that are saved with the workbook. It allows users to create different versions of the same data by changing the values in the scenario. This feature is useful when analyzing different possibilities or what-if scenarios without altering the original data.

    Rate this question:

  • 47. 

    You can activate a cell by

    • A.

      A FINCTION IN OTHER

    • B.

      NESTED

    • C.

      SINGLE

    Correct Answer
    B. NESTED
  • 48. 

    Macros are “run” or executed from the ….. menu.

    • A.

       Tools

    • B.

       Data

    Correct Answer
    A.  Tools
    Explanation
    Macros are executed from the "Tools" menu.

    Rate this question:

  • 49. 

    What term describes a background that appears as a grainy, non smooth surface

    • A.

       gradient

    • B.

        pattern

    Correct Answer
    A.  gradient
    Explanation
    The term that describes a background that appears as a grainy, non-smooth surface is "pattern". A pattern can be created using various shapes, lines, or textures that repeat in a regular manner. In this case, the background has a grainy and non-smooth appearance, indicating the presence of a pattern rather than a gradient, which is a smooth transition between colors.

    Rate this question:

  • 50. 

    You can edit existing Excel data by pressing the

    • A.

       F1 key

    • B.

       F2 key

    Correct Answer
    B.  F2 key
    Explanation
    Pressing the F2 key allows you to edit existing Excel data. This key activates the cell's editing mode, allowing you to modify the contents of the cell directly.

    Rate this question:

Quiz Review Timeline +

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

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.