Unit Test Review E2020

11 September 2022
4.7 (114 reviews)
15 test answers

Unlock all answers in this set

Unlock answers (11)
question
A student is working in an Excel worksheet called "Blood Pressure Tracker1." What is the name of the highlighted cell area?
answer
WeekdayBloodPressure
question
A student wants to use the Advanced Filter dialog box to filter data and then copy it to a new worksheet. What information must be provided in the Advanced Filter box?
answer
the list range, the criteria range, and the copy location
question
Which scenario would best be resolved using precedent cell tracers?
answer
Leon opens an Excel spreadsheet and notices an error in the formula. The formula is very complex, and Leon cannot find the cells that are identifiers in the formula.
question
Ivan has four workbooks open titled "Winter," "Spring," "Summer," and "Fall." Ivan copies the total expenses formula from "Winter" to a cell called "Yearly Total" in the "Spring" workbook. Which steps did Ivan most likely follow?
answer
After copying the cell from the "Winter" workbook, Ivan used the View tab. He then selected Switch Window to change to the "Spring" workbook and then pasted the formula in the correct cell.
question
Marina collects and records data in an Excel spreadsheet. She uses the data to produce a line graph. Marina wants to change the graph so the minimum distance on the y-axis is 0. What should be done to make this change?
answer
Adjust the Minimum option to Fixed and change to 0.
question
Advanced Electronics has employees who use a company website to share work. By posting on the website, employees are able to track who works on a project and see any changes made. An employee named Elias creates an Excel file that he needs to share with his colleagues. Elias wants to track the changes made to the project. What is the best method that Elias can use to save and send this file?
answer
On the Save & Send tab, select Save to SharePoint, which will allow access to all registered users.
question
Jeanette wants to combine data from four workbooks into a new workbook that will consolidate her data. She can write a function that will combine the data, or she can use the Consolidate Data dialog box. What is an advantage of using the Consolidate Data dialog box?
answer
The data from each workbook can be seen in the workbook by clicking on the Collapse button.
question
What is an advantage of using Excel's built-in templates to create invoices?
answer
The setting and data heading are already made and the data just needs to be inserted.
question
A user wants to sort data in multiple columns. Which sequence of steps will sort the data?
answer
select a cell in the data rangeselect the Data tab select "Sort" in the Sort and Filter groupselect the column to be sortedselect an orderclick OK
question
What is an advantage of using 3-D range names?
answer
Cells in multiple worksheets can be given the same name.
question
What does the "+" sign in the screenshot indicate?
answer
the expand symbol in an outline
question
A company produces a template that employees will use as a monthly time sheet. The template is saved in a location that is available to all employees. What steps should be followed in order to save the template in an alternate location?
answer
select File β†’ select Options β†’ select Advanced β†’ scroll to General β†’ insert the location in the "At startup, open all files in" dialog box
question
What is a disadvantage of merging cells?
answer
Data functions in multiple cells may not be recognized.
question
When is the best time to use the add Paste Special function?
answer
when a single snapshot in time is wanted
question
Ivan inputs a phone number into cell A2 of an Excel workbook. He formats the cell using a phone number format: (555) 987-6543. Ivan copies cell A2 into a new workbook. What will be displayed in the new workbook, and why?
answer
555987654, because when a number is copied, the number, not the format, is copied.