1.
Why is Excel a useful program?
Correct Answer
E. B, C and D
Explanation
Excel is a useful program because it helps keep data organized, performs calculations, and easily creates graphs and charts from data. This allows users to efficiently manage and analyze large amounts of information, making it a valuable tool for various tasks such as budgeting, data analysis, and creating visual representations of data.
2.
If you want to make a chart, how would you get to the chart-making wizard?
Correct Answer
A. Click on the drop down menu "Insert" and select "Chart."
Explanation
To access the chart-making wizard, you need to click on the drop-down menu labeled "Insert" and then choose the option "Chart." This menu allows you to access various tools and features related to inserting different elements into your document, including charts. By selecting the "Chart" option, you can access the chart-making wizard, which will guide you through the process of creating and customizing your chart.
3.
True or False: Excel can calculate averages and sums.
Correct Answer
A. True
Explanation
Excel is a powerful spreadsheet program that can perform various calculations, including averaging and summing. It has built-in functions such as AVERAGE and SUM that allow users to easily calculate the average and sum of a range of numbers. These functions can be applied to both individual cells and entire columns or rows, making it convenient for data analysis and mathematical operations. Therefore, it is correct to say that Excel can calculate averages and sums.
4.
How many different types of charts can you make in Excel?
Correct Answer
D. Many!!
Explanation
The correct answer is "Many!!" because Excel offers a wide range of chart types, including but not limited to column charts, bar graphs, pie charts, line charts, scatter plots, area charts, and more. Users can choose from various chart options based on their data and visualization needs, making the number of possible chart types in Excel quite extensive.
5.
If you want to add a number of cells together, what is the formula you use?
Correct Answer
B. =sum(cells)
Explanation
The formula used to add a number of cells together is =sum(cells). This formula calculates the sum of the values in the specified range of cells.
6.
When might you use Excel in the future?
Correct Answer(s)
A. When organizing data in one of your classes for example in (science) class
B. When making grapHs in one of your classes for example in (math) class
D. A and B.
Explanation
The correct answer is A and B. You might use Excel in the future when organizing data in one of your classes, such as in a science class. Excel can help you organize and analyze data effectively. Additionally, you might use Excel when making graphs in one of your classes, such as in a math class. Excel provides tools for creating accurate and visually appealing graphs. Therefore, using Excel for organizing data and making graphs in various classes would be beneficial.
7.
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 basic unit of a worksheet and is identified by a unique address, which is the combination of the column letter and the row number. Cells are used to store data, formulas, and formatting in a spreadsheet.
8.
What type of chart is useful for comparing values over categories?
Correct Answer
B. Column Chart
Explanation
A column chart is useful for comparing values over categories because it displays data in vertical columns, with each column representing a different category. The height of each column represents the value being compared, making it easy to visually compare values between categories. This type of chart is particularly effective when there are multiple categories and the emphasis is on comparing the magnitude or size of each category's value.
9.
A feature 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 they want to see by applying specific conditions or criteria. By applying filters, users can easily sort through a large dataset and view only the relevant information. This feature is commonly used in spreadsheet programs and databases to quickly analyze and extract specific data based on user-defined criteria.
10.
Statistical calculations and preparation of tables and graphs can be done using
Correct Answer
B. Excel
Explanation
Excel is the correct answer because it is a powerful spreadsheet software that allows users to perform statistical calculations, create tables, and generate graphs easily. It offers various functions and formulas specifically designed for statistical analysis, making it a preferred tool for data manipulation and representation. Adobe Photoshop is primarily used for image editing, Notepad is a basic text editor, and Power Point is a presentation software, none of which are specifically designed for statistical calculations and data analysis.