1.
What is the intersection of a column and a row on a worksheet called ?
Correct Answer
D. Cell
Explanation
The intersection of a column and a row on a worksheet is called a cell. A cell is the smallest unit of a worksheet and is identified by its unique address, which is a combination of the column letter and the row number. Cells are used to store and display data in a spreadsheet, and they can contain various types of information such as text, numbers, formulas, and formatting.
2.
Which of these data types is not in MS.excel?
Correct Answer
C. 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.
3.
In MS Excel, which menu does have Sort option
Correct Answer
D. 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.
4.
Which of these charts does not exist in MS Excel?
Correct Answer
D. 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.
5.
Which sign display when Formula Error in MS Excel
Correct Answer
D. #
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.
6.
Functions in MS Excel must begin with ___
Correct Answer
B. 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.
7.
What type of chart is useful for showing trends or changes over time ?.
Correct Answer
C. 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.
8.
The process of arrenging the items of a column in some sequence or order is known as :
Correct Answer
C. 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.
9.
The ____ feature of MS Excel quickly completes a series of data
Correct Answer
B. 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.
10.
What type of chart is useful for comparing parts of a whole ?
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.
11.
How many sheets are there, by default, when we create a new Excel file ?
Correct Answer
B. 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.
12.
In Excel, which one denoted a range from B1 through E5.
Correct Answer
B. 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.
13.
What type of chart will you use to compare performance of sales of two products ?
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.
14.
A features that displays only the data in column (s) according to specified criteria
Correct Answer
C. 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.
15.
On an excel sheet the active cell in indicated by ?
Correct Answer
B. 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.
16.
In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
Correct Answer
D.
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.
17.
The default style for new data keyed in a new workbook is ?
Correct Answer
B. 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.
18.
In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
Correct Answer
D. 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.
19.
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu
Correct Answer
C. 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.
20.
In MS-Excel 3-D reference in a formula
Correct Answer
C. 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.