Excel General

Question 1

Columns

Answer 1

hold up a house so vertical

Question 2

File

Answer 2

= workbook

Question 3

Accessibility Tab

Answer 3

Can help you SHINE.

Question 4

Workbooks have

Answer 4

work-sheets within them

Question 5

All worksheets have

Answer 5

same # rows & columns

Question 6

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”?

Answer 6

Hover over the button, then click Tell me more at the bottom of the information displayed.

Question 7

When would you use Excel for a task?

Answer 7

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.

Question 8

What is the difference between a workbook and worksheet?

Answer 8

A workbook is the file and a worksheet is the individual tab within the workbook.

Question 9

NumberS should be right-aligned

Answer 9

unless serial/part #s

Question 10

Which action CANNOT be reversed using the Undo command?

Answer 10

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.

Question 11

what is most likely the reason the work order and status columns are left-aligned while the cost column is right-aligned?

Answer 11

By default, cells with alpha characters are left-aligned and while numeric characters are right-aligned.

Question 12

How can you use Find and Select to quickly capitalize the many instances of “IT” appearing in the worksheet?

Answer 12

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.

Question 13

How would you quickly find who is assigned a specific badge number?

Answer 13

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.

Question 14

You want to move the ID COLUMN before the employee name. What is the fastest way to move this data?

Answer 14

Click B to highlight the column then hold the Shift key down and drag the column in front of the Employee column.

Question 15

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

Answer 15

=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

Question 16

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

Answer 16

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

Question 17

The AutoSum function always looks up and then left

Answer 17

Ctrl + “O” for Open

Question 18

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?

Answer 18

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.

Question 19

Ctrl + “W” for CLOSE

Answer 19

strange but control & “w” = close

Question 20

You can _____ multiple sheets at the same time by _____ them first.

Answer 20

edit; grouping
Correct:
Grouping is useful for simultaneously making the same edits to multiple sheets.

Question 21

If you accidentally delete a sheet that you wanted to keep, which action should you take?

Answer 21

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.

Question 22

What must you do before sorting if you have a worksheet containing data you do not want to be sorted?

Answer 22

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.

Question 23

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?

Answer 23

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.

Question 24

Sharing =

Answer 24

Co Authoring a file (share thru OneDrive for example)

Question 25

Which type of chart is preferable when you are dealing with a timeframe

Answer 25

Line