Show Home Subjects Expert solutions Create Log in Sign up Upgrade to remove ads Only ₩37,125/year
Terms in this set (71)Ctrl 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? Hiding 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. Function A ____ is a named operation that replaces the action of an arithmetic expression. =COUNTA(B1:B20) 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? Column You need to add another product to your inventory worksheet which shows product names in row A. Which of the following should you add? 11 The default worksheet text is _____ -point Calbri. AutoSum button 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? Hidden You receive a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is ____. (25+10)*50 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? Name Box 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? Replace 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? Font A ____ refers to a collection of characters with similar, specific changes. Print area 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? Conditional formatting To format a range so that all values are greater than $500 appear in red, which of following can you use? Cell formatting 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? Zero The percent style formats numbers as percentages with _____ decimal places by default.
Color 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 ______. Home 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 ______. Format Painter To copy a cell's formatting to another cell, which of the following can you use? Font 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? Sum 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? =MONTH(DATE(2016,7,0)) 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? AVERAGE Which of the following functions would you use to calculate the arithmetic mean of a price list? MIN Function To have Excel enter the lowest price from a range of prices, which of the following would you use? =DATE(1998,1,12) Which is the correct formula to insert the date January 12, 1998 into a cell? $A$5 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? =IF(B2>=60,"Pass","Fail") 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? =ROUND(AVERAGE(C3:C50),0) 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? MAX 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. Fill handle 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? What-IF Analysis 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? =ROUND(A5,2) 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? IF 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? Axis title A(n) _____ is descriptive text that appears next to a chart's horizontal or vertical axis. Waterfall 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? Data Bar 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? Trendline
Which of the following elements can you add to a chart to display a line representing the general direction in a data series? Treemap A _____ chart displays each category of data in a rectangle and smaller rectangles within them for subcategories. Scatter Which of the following chart types show how two numeric data series are related to each other? Sunburst A(n) _____ chart organizes hierarchies of data in a series of concentric rings and is appropriate for showing groups within categories of information. Data bars If you see a cells with blue fills varying lengths representing the values, the cells most likely have _____ applied to them. Pie Chart To which of the following chart types can you not add axis titles? Outside End 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? Waterfall A _____ chart tracks the addition and subtraction of values within a sum. Line sparklines 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? Students also viewedBIA 320 Exam One124 terms Sydneymik1 Info systems midterm30 terms
mike_perlamuter Excel 336 terms happysan Excel Review36 terms AvengingAngel113 Sets found in the same folderExcel Review36 terms AvengingAngel113 Excel module 1, 2, 3126 terms Liz-S BUIS 260 Final55 terms DonnJr Getting Started with Excel29 terms kade2078Teacher Other Quizlet setsCriminology - Final Exam12 terms mikellbcozad RM Exam 244 terms mhakopia insurance57 terms vannahyou 11. Evolution260 terms satmaster20 Why would you use now () in a formula quizlet?The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
Which of the following functions inserts the total of a range Excel?The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Which of the following is true about entering a function using the Insert function dialog box?Which of the following is true about entering a function using the Insert Function dialog box? You can select a function you've recently used.
Which of the following can you use to copy the formula to an adjacent cell?Fill formulas into adjacent cells
You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left.
|
Which of the following can you use to insert a formula using a function quizlet?
Urheberrechte © © 2024 nguoilontuoi Inc.
