Excel Exam 2022
27.) What is the best practice for entering dates and times in Excel
Use slashes for dates and colons for time.
2.) You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year. What is the best way to create the list
Use the Filter option to filter by full time employees and use the Numbers filter to select greater than $45,000.
19.) To use AutoSum with a row of four values, where must your cursor be to have the sum appear in the row if you have not highlighted the cells
on the first empty cell to the right of the last cell containing a value
25.) Which two keys are commonly used to move or insert data
Ctrl and Shift
13.) Which shortcut can you use to rename a worksheet
Double-click the sheet tab, and then type the new name.
7.) Although it is not a term Excel uses, how do most people think of Excel
as a spreadsheet
22.) You would like to filter your large worksheet down to only sales from January. Which action must you take before using the Filter feature
Make sure your date has no empty rows or columns.
10.) You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list
Regions
17.) To freeze rows 1 and 2, and columns 1, 2, and 3, which cell should you highlight before selecting Freeze Panes
row 3, column 4
16.) Which type of chart is preferable when you are dealing with a timeframe
line chart
20.)What is a good rule-of-thumb for using color backgrounds in a worksheet
Use a light-color fill.
1.) Which shortcuts can you use for Undo and Redo
Ctrl+Z for Undo and Ctrl+Y for Redo
23.) You created a formula in cell C8. When you copy the formula into cell D8, which action are you taking
You are changing the content in the formula to the content in cell D8.
6.)Why would you set up a workbook to be shared if you are the only one using the workbook
You can track changes.
3.) What statement is accurate in regards to sharing workbooks
You must add the feature to the Quick Access Toolbar.
24.) As you are working with a pivot table, you decide to change some of your source data. How will the pivot table recognize the change
You will either have to click Refresh on the Analyze ribbon or click Alt+F5.
4.) You manage the worksheet shown below that contains a list of employees and a list of building numbers. The employee list is 1500 rows of data. What is the easiest way to sort the employee list without affecting the building number list
Add a blank column between columns B and C, click in cell A2, and select Sort.
18.)You have a workbook with multiple worksheets and want an exact copy of one of the worksheets. How can you duplicate this sheet within the same workbook
Click in the tab name of the worksheet, hold the Ctrl key, and drag the worksheet.
11.) While it might be considered "old-school," which action should you take if you are unsure how a page will print, even after looking at Page Break Preview
Print the first page.
14.) You hide three worksheets in a workbook and need to unhide them. How can you accomplish this
Right-click any visible sheet, then select which worksheet you want to Unhide.
15.) The worksheet below has the split feature active as shown by the vertical line between columns B and C. Which cell was selected when split was chosen by the user
C1
9.) What does it mean that the right mouse button is "context-sensitive"
The menu items available will differ depending on the context of what you are right-clicking.
5.) How can you access Track Changes in Microsoft Excel Office 365
Track Changes is located under the Customize Quick Access Toolbar.
8.) How does tracking changes relate to sharing a workbook in Excel
You must share the workbook to track changes.
26.) You resurrected an old worksheet. It appears to contain most of the information that you need, but not all of it. Which step should you take next
Check for data you have previously hidden.
12.) You are creating a chart using the data shown below. What is the best chart type and style to use in order to make the upward sales trend most obvious
Create a line chart and make the chart more narrow than the default.
21.) Where can you access the format cell's Dialog Box launcher
from the arrow to the right of Font on the ribbon