Quiz 3 SEC A

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 Gshivani554
G
Gshivani554
Community Contributor
Quizzes Created: 2 | Total Attempts: 304
| Attempts: 147
SettingsSettings
Please wait...
  • 1/20 Questions

    What is the intersection of a column and a row on a worksheet called ?

    • Column
    • Value
    • Address
    • Cell
Please wait...
About This Quiz

This quiz titled 'QUIZ 3 SEC A' assesses knowledge on MS Excel, covering basics like cell definitions, data types, menu options, error signs, and functions.

Quiz 3 SEC A - Quiz

Quiz Preview

  • 2. 

    Functions in MS Excel must begin with ___

    • An () sign

    • An Equal Sign

    • A Plus Sign

    • A > Sign

    Correct Answer
    A. An Equal Sign
    Explanation
    Functions in MS Excel must begin with an equal sign because the equal sign is used to indicate that a formula or function is being entered. By starting with an equal sign, Excel recognizes that the following characters are part of a formula rather than regular text. This allows Excel to calculate the result based on the specified function or formula.

    Rate this question:

  • 3. 

    Which of these data types is not in MS.excel?

    • Number

    • Currency

    • Label

    • Date/Time

    Correct Answer
    A. Label
    Explanation
    The data type "Label" is not found in MS Excel. MS Excel offers various data types for organizing and analyzing data, such as Number, Currency, and Date/Time. However, there is no specific data type called "Label" in MS Excel.

    Rate this question:

  • 4. 

    In Excel, which one denoted a range from B1 through E5.

    • B1 - E5

    • B1:E5

    • B1 to E5

    • B1$E5

    Correct Answer
    A. B1:E5
    Explanation
    The correct answer is B1:E5 because in Excel, a range is denoted by specifying the starting cell followed by a colon and then the ending cell. In this case, B1 is the starting cell and E5 is the ending cell, so the range is B1:E5.

    Rate this question:

  • 5. 

    What type of chart is useful for comparing parts of a whole ?

    • Pie Chart

    • Column Chart

    • Line Chart

    • Dot Graph

    Correct Answer
    A. Pie Chart
    Explanation
    A pie chart is useful for comparing parts of a whole because it visually represents the proportions of different categories or components in relation to the whole. The chart is divided into slices, with each slice representing a specific category or component. The size of each slice corresponds to the proportion or percentage it represents in relation to the total. This allows for easy comparison and understanding of the relative sizes or percentages of the different parts of the whole.

    Rate this question:

  • 6. 

    How many sheets are there, by default, when we create a new Excel file ?

    • 1

    • 3

    • 5

    • 10

    Correct Answer
    A. 3
    Explanation
    When we create a new Excel file, there are typically three sheets that are created by default. These sheets are named Sheet1, Sheet2, and Sheet3. These sheets can be used to organize and store different sets of data within the same Excel file.

    Rate this question:

  • 7. 

    A features that displays only the data in column (s) according to specified criteria

    • Formula

    • Sorting

    • Filtering

    • Pivot

    Correct Answer
    A. Filtering
    Explanation
    Filtering is a feature that displays only the data in column(s) according to specified criteria. It allows users to narrow down the data set and view only the information that meets certain conditions. By applying filters, users can easily identify and analyze specific data subsets, making it a useful tool for data analysis and exploration.

    Rate this question:

  • 8. 

      In MS-Excel 3-D reference in a formula

    • Cannot be modified

    • Only appears on summary worksheets

    • Spans worksheets

    Correct Answer
    A. Spans worksheets
    Explanation
    A 3-D reference in MS-Excel is a reference that spans multiple worksheets. It allows you to perform calculations or retrieve data from multiple worksheets at once. Unlike regular cell references, a 3-D reference cannot be modified or changed. It is useful when you want to consolidate data from multiple worksheets or perform calculations across multiple sheets.

    Rate this question:

  • 9. 

    Which sign display when Formula Error in MS Excel

    • $

    • *

    • \

    • #

    Correct Answer
    A. #
    Explanation
    In MS Excel, the "#" sign is displayed when there is a formula error. This error can occur when there is a problem with the formula syntax, such as using incorrect operators or not closing brackets properly. When the formula error is detected, Excel displays the "#" sign to indicate that there is an issue with the formula. The user can then investigate and correct the error to ensure accurate calculations.

    Rate this question:

  • 10. 

    On an excel sheet the active cell in indicated by ? ​​​​

    • A dotted border

    • A dark wide border

    • A blinking border

    • 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 helps the user easily identify which cell they are currently working on or selecting. The dark wide border stands out from the other cells and provides a visual cue to the user.

    Rate this question:

  • 11. 

    The default style for new data keyed in a new workbook is ? ​​​​​

    • Comma

    • Normal

    • Currency

    • Percent

    Correct Answer
    A. Normal
    Explanation
    The default style for new data keyed in a new workbook is "Normal". This means that any data entered will have the default formatting, such as regular font, no special number formatting, and no currency or percent symbols.

    Rate this question:

  • 12. 

    What type of chart will you use to compare performance of sales of two products ?

    • Column Chart

    • Line Chart

    • Pie Chart

    • Both A and B

    Correct Answer
    A. Column Chart
    Explanation
    A column chart would be the best choice to compare the performance of sales of two products. This type of chart uses vertical columns to represent different categories or groups, making it easy to compare the sales figures of the two products side by side. The height of each column corresponds to the sales value, allowing for a clear visual comparison of the performance. A line chart, on the other hand, would be more suitable for showing trends over time, while a pie chart is used to represent proportions or percentages. "Both A and B" is not a valid answer as it is not clear what A and B refer to.

    Rate this question:

  • 13. 

    In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu

    • Edit

    • Format

    • Tools

    • All of the above

    Correct Answer
    A. Tools
    Explanation
    To protect a worksheet in MS-Excel, you can choose "Protection" and then select "Protect Sheet" from the "Tools" menu. This option allows you to secure the worksheet by preventing users from making any changes to the data or formatting. By selecting this option, you can restrict access to the worksheet and ensure the integrity of the information it contains.

    Rate this question:

  • 14. 

    The ____ feature of MS Excel quickly completes a series of data

    • Auto Complete

    • Auto Fill

    • Fill Handle

    • Sorting

    Correct Answer
    A. Auto Fill
    Explanation
    The Auto Fill feature of MS Excel quickly completes a series of data by automatically filling in values based on a pattern or existing data. It saves time and effort by predicting the desired sequence and filling it in for the user. This feature is particularly useful when working with repetitive data such as dates, numbers, or text.

    Rate this question:

  • 15. 

    What type of chart is useful for showing trends or changes over time ?.

    • Pie Chart

    • Column Chart

    • Line Chart

    • Dot Graph

    Correct Answer
    A. Line Chart
    Explanation
    A line chart is the most suitable type of chart for showing trends or changes over time. It uses a series of data points connected by lines to represent the progression of a variable over a specific period. This allows for a clear visualization of how the data changes over time and makes it easy to identify patterns or trends. Unlike a pie chart or column chart, a line chart focuses specifically on the relationship between the data points and their chronological order, making it ideal for tracking changes over time. A dot graph is not a commonly used chart type for showing trends or changes over time.

    Rate this question:

  • 16. 

    In MS Excel, which menu does have Sort option

    • Edit

    • Format

    • Tool

    • Data

    Correct Answer
    A. Data
    Explanation
    The correct answer is Data because the Sort option is typically found under the Data menu in MS Excel. This option allows users to organize and arrange data in ascending or descending order based on specific criteria such as numbers, dates, or alphabetical order. By selecting the Data menu, users can easily access the Sort option and apply sorting functionality to their spreadsheet.

    Rate this question:

  • 17. 

    In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore

    • A. You can automatically apply formatting to a data series

    • B. You can change the position of a data marker and that automatically changes the data point value in the worksheet

    • C. You can change a data point value and automatically that is drawn in  the chart

    • D. Both (b) & (c)

    Correct Answer
    A. D. Both (b) & (c)
    Explanation
    The correct answer is D. Both (b) & (c). This is because in MS-Excel, data markers on a chart are linked to data points in a worksheet. This means that if you change the position of a data marker, it will automatically change the data point value in the worksheet (option b). Similarly, if you change a data point value, it will automatically be drawn in the chart (option c). Therefore, both options b and c are correct.

    Rate this question:

  • 18. 

    The process of arrenging the items of a column in some sequence or order is known as :

    • Arranging

    • Autofill

    • Sorting

    • Filtering

    Correct Answer
    A. Sorting
    Explanation
    Sorting is the correct answer because it refers to the process of arranging the items in a column in a specific sequence or order. This can be done in ascending or descending order based on certain criteria, such as alphabetical order, numerical order, or chronological order. Sorting allows for better organization and easier access to the data, making it a fundamental operation in data management and analysis.

    Rate this question:

  • 19. 

    In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013

    • Workday

    • Date

    • Networkday

    • Weekday

    Correct Answer
    A. Weekday
    Explanation
    The Weekday function in MS-Excel calculates the number of weekdays between two dates. In this case, it will calculate the number of weekdays between 6/9/2013 and 8/12/2013. This function excludes weekends (Saturday and Sunday) from the calculation, so it will give the number of workdays (Monday to Friday) between the two dates.

    Rate this question:

  • 20. 

    Which of these charts does not exist in MS Excel?

    • Scatter

    • Line

    • Doughnut

    • Graph

    Correct Answer
    A. Graph
    Explanation
    The correct answer is "Graph" because "Graph" is not a type of chart that exists in MS Excel. MS Excel does have other types of charts such as Scatter, Line, and Doughnut, but "Graph" is not one of them.

    Rate this question:

Quiz Review Timeline (Updated): Feb 5, 2023 +

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

  • Current Version
  • Feb 05, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 31, 2019
    Quiz Created by
    Gshivani554
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.