Microsoft Excel Graded Project Quiz 2
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
212
Subject
Industrial Engineering
Date
Nov 24, 2024
Type
docx
Pages
4
Uploaded by KidCaribouPerson358
Microsoft Excel Graded Project Quiz 2
Question 1
5 / 5 points
You have a spreadsheet with data in rows 4 through 10 in columns B, C, E, and F. How would you select the data to create a chart?
Click the
Select All
button in the upper-left corner of the spreadsheet.
Drag to select B4 through F10.
Drag to select B4 through C10. Hold down the
Ctrl
key and drag to select E4 through F10.
Drag to select B4 through C10. Hold down the
Shift
key and drag to select E4 through F10.
Hide question 1 feedback
Correct
To select non-contiguous cells in Excel, drag to select your first range of cells. Then hold down the
Ctrl
key while you drag to select the additional cell ranges.
Question 2
5 / 5 points
You entered an Excel function to perform a mathematical calculation on several columns of numbers in your spreadsheet. The cell where the function resides displays
#####
. What is the reason for this?
The column is too narrow to display the formula's resulting value.
There's an error in the data the formula is pulling from the columns.
There's an error in the formula that you entered.
The format of the cell isn't set to display a numeric value.
Hide question 2 feedback
Correct
When Excel displays
#####
in a cell, it means one of two things:
1.
The column isn't wide enough to display the information in the cell.
2.
There's a negative date or time in the cell.
Question 3
5 / 5 points
The title of your worksheet is 2020 Budget. You've created a pie chart to show the budget category percentages, but the chart title reads a generic "Chart Title." How do you change it to match the worksheet title of 2020 Budget?
Click on and then select the text
Chart Title
in the chart and type
2020 Budget.
Select the
Chart Title
text box and delete it. Insert the Excel TEXT function and
link it to a cell in the worksheet with the text 2020 Budget in it.
Click on and then select the text
Chart Title
in the chart and link to the worksheet name.
Delete and recreate your chart, making sure you include a header row with the title 2020 Budget in it.
Hide question 3 feedback
Correct
A text box contains the title of the chart. It's editable just like any other text box.
Question 4
5 / 5 points
You created a budget in Excel. You would like to quickly see how each budget category compares to the others to make up the total. What is the best way to accomplish this?
Sorting the category totals low to high or high to low
The @SUM function to generate category totals automatically
A formula calculating category percentages
A pie chart
Hide question 4 feedback
Correct
A pie chart is a graphical representation of data where the entire circle equals the whole and the individual sections are graphically represented as sections showing their proportion of the whole.
Question 5
5 / 5 points
A colleague gives you a spreadsheet containing the personnel records of all department employees. Employees are added to a row at the bottom of the spreadsheet as they're hired. As a result, you have to scan the entire spreadsheet to find the information for employees. What is the best way to resolve this problem?
Apply a filter to display just the employee data you want to work with.
Apply a data sort to your copy of the spreadsheet, so that employees are in alphabetical order by name.
Search for each employee's data you want to work with.
Request that the colleague restructure the spreadsheet so that employees are added in alphabetical order instead of by hire date.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Hide question 5 feedback
Correct
The Sort feature in Excel allows you to change the view of your data, rearranging it into a specified order. For example, text can be sorted alphabetically or reverse alphabetically, and numbers can be sorted in ascending or descending numeric order.