Quiz 3 SEC A
-
What is the intersection of a column and a row on a worksheet called ?
-
Column
-
Value
-
Address
-
Cell
-
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 Preview
- 2.
Functions in MS Excel must begin with ___
-
An () sign
-
An Equal Sign
-
A Plus Sign
-
A > Sign
Correct Answer
A. An Equal SignExplanation
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. LabelExplanation
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:E5Explanation
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 ChartExplanation
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. 3Explanation
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. FilteringExplanation
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 worksheetsExplanation
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 borderExplanation
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. NormalExplanation
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 ChartExplanation
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. ToolsExplanation
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 FillExplanation
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 ChartExplanation
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. DataExplanation
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. SortingExplanation
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. WeekdayExplanation
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. GraphExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 31, 2019Quiz Created by
Gshivani554