Excel General Flashcards
Columns
hold up a house so vertical
File
= workbook
Accessibility Tab
Can help you SHINE.
Workbooks have
work-sheets within them
All worksheets have
same # rows & columns
You are using a button on the ribbon, and you are interested in learning more about its functionality. How can you access “Tell me more”?
Hover over the button, then click Tell me more at the bottom of the information displayed.
When would you use Excel for a task?
NO-when creating a presentation to give to a team
NO-when writing an instruction guide for a team
NO-when writing an article about a new product
YES-when creating a list of employees with their ID numbers
Correct
Excel is commonly used for creating and maintaining lists.
What is the difference between a workbook and worksheet?
A workbook is the file and a worksheet is the individual tab within the workbook.
NumberS should be right-aligned
unless serial/part #s
Which action CANNOT be reversed using the Undo command?
deleting a tab in the workbook
Correct
The Undo feature does not apply to modifying tabs in the workbook, which includes deleting and renaming the tab.
what is most likely the reason the work order and status columns are left-aligned while the cost column is right-aligned?
By default, cells with alpha characters are left-aligned and while numeric characters are right-aligned.
How can you use Find and Select to quickly capitalize the many instances of “IT” appearing in the worksheet?
Use the “Match entire cell contents” option under Replace.
Correct:
This will capitalize every instance of “it” in cells in which lowercase “it” is the only content.
How would you quickly find who is assigned a specific badge number?
Use the Find tool, enter the badge number, and check the box next to Match Case AND Match Entire Cell Contents.
Correct
The badge numbers are alphanumeric and also consist of capital and lowercase letters. With a large number of badges in the worksheet, it is best to use BOTH the Match Case AND the Match Entire Cell Contents to have only one result.
You want to move the ID COLUMN before the employee name. What is the fastest way to move this data?
Click B to highlight the column then hold the Shift key down and drag the column in front of the Employee column.
you want to use the XLOOKUP function to find the employee whose number appears in cell I2. Using the data in columns A and B, what formula is needed
=XLOOKUP(I2,B:B,A:A)
The XLOOKUP formula will search for the ID in I2 in column B and will return the name in column A
You have numerical data in A1 to D12. You want to show an average for each column and each row. What’s the most efficient solution
Select cells A1 to E13. Then select Formula > AutoSum > Average
This will show averages per row in column E, and averages per column in row 13. As a bonus, you’ll get the average of the entire dataset in cell E13
The AutoSum function always looks up and then left
Ctrl + “O” for Open
You want to view how your worksheet will print and make edits to the worksheet in this mode. What is the easiest way to accomplish this?
Click Page layout on the bottom of the page in the status bar.
Correct:
The Page Layout option in the status bar allows you to view how the worksheet will print and make edits.
Ctrl + “W” for CLOSE
strange but control & “w” = close
You can _____ multiple sheets at the same time by _____ them first.
edit; grouping
Correct:
Grouping is useful for simultaneously making the same edits to multiple sheets.
If you accidentally delete a sheet that you wanted to keep, which action should you take?
Retrieve the sheet from a saved version of the file.
Correct: This is the only way you can retrieve the sheet. Do not save the file before you do this or you will lose the deletions.
What must you do before sorting if you have a worksheet containing data you do not want to be sorted?
Delineate the data you do not want to be sorted. Correct:
Insert at least one empty column or a couple of empty rows between the data you want to be sorted and the data you do not wish to be sorted.
An Excel workbook tracks the sales data for a company. A pivot table is in the adjacent tab and provides a high-level view of the sales by department. The sales numbers are updated in the workbook, but the pivot table is not reflecting these changes. What is most likely causing this problem?
ou need to refresh the pivot table to include the updated data.
Correct: Anytime the raw data is updated, the pivot table must be refreshed to update the information in the table.
Sharing =
Co Authoring a file (share thru OneDrive for example)
Which type of chart is preferable when you are dealing with a timeframe
Line
