Excel Training Exam 58 Questions with Verified Answers
What are filter views? - CORRECT ANSWER A tool that allows you to customize and save certain
... [Show More] filters
When sorting A-Z on a column that includes the numbers 1-20, what number will be at the top? - CORRECT ANSWER 1
How do you apply filters? - CORRECT ANSWER Select the filter button, then use the filter dropdowns on each column to filter your data
If you want to add 3 cells together, what function should you use to do so? - CORRECT ANSWER Sum()
What will the following logical statement evaluate to?
IF(7>5, "apple", "banana") - CORRECT ANSWER apple
What function should you use when you're unsure of the specific location of the data you want to replace. - CORRECT ANSWER Substitute
To create a chart, what menu do you go to? - CORRECT ANSWER Insert menu
What type of chart is useful to see how lots of different data points are related? - CORRECT ANSWER Scatterplots
When would you want to use HLOOKUP? - CORRECT ANSWER When you want to find a specific piece of data in a spreadsheet that's organized horizontally
When would you want to use VLOOKUP? - CORRECT ANSWER When you want to find a specific piece of data in a spreadsheet that's organize vertically
VLOOKUP and HLOOKUP can be used interchangeably - CORRECT ANSWER False
Which of the below is a valid XML tag? - CORRECT ANSWER //span
When should you use ImportXML instead of ImportHTML? - CORRECT ANSWER When you want to pull any kind of data from a page, but it doesn't have a table or list structure
When should you use ImportHTML instead of ImportXML? - CORRECT ANSWER When the data you want is clearly formatted in a table or a list
As long as you know a little bit of X, you can use Google Scripts to interact with any spreadsheet or other Google product (Calendar, Gmail, etc.) - CORRECT ANSWER Javascript
The X section is simply a collection of Google Scripts that others have written and used. - CORRECT ANSWER Add-ons
Excel X and spreadsheet scripts can be used to automate repetitive tasks and functions in spreadsheets - CORRECT ANSWER macros
Excel uses the visual basic language to write Macros, while X uses Java script - CORRECT ANSWER Google spreadsheets
There is a button on the ribbon, and you are interested in learning more about its functionality. How can you access "Tell me more"? - CORRECT ANSWER Hover over the button, then click "Tell me more" at the bottom of the information displayed.
You are working in your company's "2018 Sales" Workbook with each column widened and a color graph. When you add a worksheet "2018 Profit," how will the new worksheet appear? - CORRECT ANSWER with the same formatting as "2018 Sales" before you made any changes
What does it mean that the right mouse button is "context-sensitive"? - CORRECT ANSWER The menu items available will differ depending on the context of what you are right-clicking .
You would like to add some frequently used buttons to the Quick Access Toolbar. How can you do this? - CORRECT ANSWER Right-click the button on the ribbon and select Add.
You are working in the most recent version of Excel provided by your company. Why would you use the "Save as type" pulldown menu? - CORRECT ANSWER You are saving the file for someone with an older version of Excel.
As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will Excel take with this? - CORRECT ANSWER Excel will display it as 6/31/2019 but left-justified and as only a set of numbers and dashes, and not an actual date.
You are entering Sales data for each month in 2018. How can you quickly enter all 12 months in columns? - CORRECT ANSWER Type in January, point to the lower right-hand corner of the cell, hold down the left mouse button, and drag across the next eleven rows.
You have numerical data across 12 rows and 4 columns. When you highlight this range of cells, and then press Average under AutoSum in the Formula ribbon, which outcome occurs? - CORRECT ANSWER The averages will display in the column at the end of each row and below the bottom row of each column.
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? - CORRECT ANSWER on the first empty cell to the right of the last cell containing a value
One of the number cells in your worksheet shows as ###. What does this mean? - CORRECT ANSWER The content in the cell is wider than the cell width.
You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products? - CORRECT ANSWER by typing =d5-d6
How can you quickly add a border around a set of cells covering 3 rows and 12 columns? - CORRECT ANSWER Use Draw Border under Border on the ribbon under Home.
Your worksheet includes data for your company's IT department. How can you use Find & Select to quickly capitalize the many instances of IT appearing in the worksheet? - CORRECT ANSWER Use the "Match entire cell contents" option under Replace.
How would you most efficiently test a layout adjustment before printing on paper? - CORRECT ANSWER Use Print Preview as a trial and error.
Which primary function does the Excel Ideas feature serve? - CORRECT ANSWER You can explore charting variations for your data sets.
You created a bar chart with the bars for the products and the colors for the salesperson. If you click Switch Row Column, what will happen?
You are correct!
The bars will change to salespeople, and the colors will change to products. - CORRECT ANSWER The bars will change to salespeople, and the colors will change to products.
What is the first step in creating a chart with Excel Office 365?
You are correct!
Highlight the data you want to show in the chart. - CORRECT ANSWER Highlight the data you want to show in the chart.
Before you create a chart in Excel, how would you have the chart appear?
You are correct!
Remove any totals next to your data. - CORRECT ANSWER Remove any totals next to your data.
How can you remove a split other than by clicking the Split button under View?
You are correct!
by double-clicking the split line - CORRECT ANSWER by double-clicking the split line
you can _____ multiple sheets at the same time by _____ them first.
You are correct!
edit; grouping - CORRECT ANSWER edit; grouping
If you accidentally delete a sheet that you wanted to keep, which action should you take?
You are correct!
Retrieve the sheet from a saved version of the file. - CORRECT ANSWER Retrieve the sheet from a saved version of the file.
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 are correct!
You will either have to click Refresh on the Analyze ribbon or click Alt+F5. - CORRECT ANSWER You will either have to click Refresh on the Analyze ribbon or click Alt+F5.
You would like to filter your large worksheet down to only sales from January. Which action must you take before using the Filter feature?
You are correct!
Make sure your date has no empty rows or columns. - CORRECT ANSWER Make sure your date has no empty rows or columns.
If you have a worksheet containing data you do not want to be sorted, what must you do before sorting?
You are correct!
Delineate the data you do not want to be sorted. - CORRECT ANSWER Delineate the data you do not want to be sorted.
How can you access Track Changes in Microsoft Excel Office 365?
You are correct!
Track Changes is located under the Customize Quick Access Toolbar. - CORRECT ANSWER Track Changes is located under the Customize Quick Access Toolbar.
Which action will edit locked cells in a protected worksheet?
You are correct!
Enter the password to turn off the protection. - CORRECT ANSWER Enter the password to turn off the protection.
Why would you set up a workbook to be shared if you are the only one using the workbook? - CORRECT ANSWER You can track changes
You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list? - CORRECT ANSWER Regions
Which shortcut can you use to rename a worksheet? - CORRECT ANSWER Double-click the sheet tab, and then type the new name.
To freeze rows 1 and 2, and columns 1, 2, and 3, which cell should you highlight before selecting Freeze Panes? - CORRECT ANSWER row 3, column 4
Which type of chart is preferable when you are dealing with a timeframe? - CORRECT ANSWER line chart
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? - CORRECT ANSWER Print the first page.
Which two keys are commonly used to move or insert data? - CORRECT ANSWER Ctrl and Shift
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? - CORRECT ANSWER Check for data you have previously hidden.
What is a good rule-of-thumb for using color backgrounds in a worksheet? - CORRECT ANSWER Use a light-color fill.
Where can you access the format cell's Dialog Box launcher? - CORRECT ANSWER from the arrow to the right on Font on the ribbon
You created a formula in cell C8. When you copy the formula into cell D8, which action are you taking? - CORRECT ANSWER You are changing the content in the formula to the content in cell D8.
Which shortcuts can you use for Undo and Redo? - CORRECT ANSWER Ctrl+Z for Undo and Ctrl+Y for Redo
What is the best practice for entering dates and times in Excel? - CORRECT ANSWER Use slashes for dates and colons for time.
Although it is not a term Excel uses, how do most people think of Excel? - CORRECT ANSWER as a spreadsheet [Show Less]