Study sets, textbooks, questions
Upgrade to remove ads
Excel, EXAM 3
Terms in this set (71)
To select nonadjacent cells or ranges on a worksheet you can press and hold _______ while selecting each one.
a button appears near the selected cells with options for pasting formulas and values.
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet.
A ____ is a named operation that replaces the action of an arithmetic expression.
A student is given the task of counting the number of non blank cells in the range of cells B1 to B20. Which of the following forumulas should he use to do so?
It follows the order of operations.
In a complex formula, how does Excel determine which calculation to perform first?
You need to add another product to your inventory worksheet which shows product names in row A. Which of the following should you add?
The default worksheet text is _____ -point Calbri.
Which of the following inserts a function into a cell?
Rename the worksheet
After inserting a new worksheet, what should you do to identify the purpose of the worksheet?
You receive a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is ____.
Which of the following formulas adds 25 and 10, then multiplies the result by 50?
You can move cells using the drag-and-drop feature.
Which of the following is true about moving cell contents?
Excel changes the cell references in the copied formula to reflect the new location of the formula.
When you copy a formula from cell A10 to B10, what happens to the cell references in the formula?
The ____ displays the cell reference of an active cell.
You can add a border to the left, top, right, or bottom edge of a cell or range.
Which of the following is true about adding cell borders?
If you want to change all occurrences of "Radio" and "TV" in a worksheet you can use the _____ command.
Highlight Cells Rules
Which of the following conditional formatting commands can you use to highlight the top 10 values in a range of cells?
Edit the conditional formatting rule
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?
A ____ refers to a collection of characters with similar, specific changes.
If you want to print only part of a worksheet you can set a _____.
Click the footer section on the right and type your name.
While working in Page Layout View, how can you enter your name so it appears in the lower right corner of the printout?
To format a range so that all values are greater than $500 appear in red, which of following can you use?
You can use the Find and Replace dialog box to find and replace _____.
Merge and Center button
To combine multiple cells into one combined cell, which of the following do you use?
The percent style formats numbers as percentages with _____ decimal places by default.
To help you easily identify sheets in a workbook, you can add _____ to the sheet cells.
A font syle
When you underline cell content, you are using _____.
Quick Analysis Tool
You can create conditional cell formats using either the home tab or the ______.
To apply a cell style, you would use the Cell styles command on the _____ tab.
Paste the same format multiple times.
You double-click the Format Painter button when you want to ____.
Page Layout View
You can edit a worksheet footer in ______.
To copy a cell's formatting to another cell, which of the following can you use?
To change the color of cell content, you use the _____ color list arrow.
Highlight Cells Rules
To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?
Kathy wants to add the numbers entered in a range of selected cells. Which tab will she click on the menu that appears after clicking on totals in the Quick Analysis option?
#N/A error value
If the VLOOKUP function cannot find a match in the lookup table, what does it return?
If it needs an absolute cell reference.
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?
Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?
Click the AutoFill Options button and then click Fill Without Formatting.
When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. Which can she do to prevent the formatting change?
Which of the following functions would you use to calculate the arithmetic mean of a price list?
To have Excel enter the lowest price from a range of prices, which of the following would you use?
Which is the correct formula to insert the date January 12, 1998 into a cell?
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
Insert Function Dialog Box
Which of the following Excel tools displays the syntax for a selected function?
The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert a cell C2 to check whether the student passed or failed?
Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?
In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours.
You have selected a cell with a formula. Which of the following can you use to copy the formula to an adjacent cell?
Number of the column containing the return value.
What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)?
Absolute cell reference
In the formula =B6*$B$2, which of the following describes $B$2?
Aldo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal seek command?
Cell A contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?
Which of the following is a type of logical function?
AutoFill Options button
Which of the following let's you extend any data pattern involving dates, times, numbers, or text?
A(n) _____ is descriptive text that appears next to a chart's horizontal or vertical axis.
Which type of chart would show increases in the value of a stock find in green, decreases in gray, and the initial and final values in red?
Increase the font size
Which of the following can you do to make a chart title stand out on a chart?
Change the color of the data series.
Which can you do to make data series easier to distinguish from one another?
Scale of the sparkline axis
What can you change to coordinate sparklines with other charts and graphic objects on a worksheet?
What type of conditional formatting rule would you create to add a horizontal bar to a cell background where the length of the bar reflects the value in the cell?
Which of the following elements can you add to a chart to display a line representing the general direction in a data series?
A _____ chart displays each category of data in a rectangle and smaller rectangles within them for subcategories.
Which of the following chart types show how two numeric data series are related to each other?
A(n) _____ chart organizes hierarchies of data in a series of concentric rings and is appropriate for showing groups within categories of information.
If you see a cells with blue fills varying lengths representing the values, the cells most likely have _____ applied to them.
To which of the following chart types can you not add axis titles?
Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appear outside of the pie chart but close to each slice. Which label Position option should she select for the data labels?
A _____ chart tracks the addition and subtraction of values within a sum.
Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the range A3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of each row in column N to track the monthly sales for each product. What can she insert in the range N3:N7?
Select Data Source dialog box
Which of the following dialog boxes do you use to remove a data series from a chart?
Sets found in the same folder
Excel module 1, 2, 3
BUIS 260 Final
Other Quizlet sets
Practice Exam 2
Intro to Crim- Final
ENV SCI Chap 9- Exam 2