Show
Home Subjects Expert solutions Create Log in Sign up Upgrade to remove ads Only ₩37,125/year
Terms in this set (39)What is the best practice to switch the columns and rows in a range? Cut the range, then use the Paste Special option called Transpose In the formula, =1+(2-3)+5/6-6^2, what will excel evaluate second? 6^2 What should you do if there are columns you need, but do not want to display? Hide the columns you do not want to display, then unhide them when finished. A range is specified by its _______. top left and bottom right cells What is true about an input area? It is used when certain values are used repeatedly throughout the worksheet. What does it mean when you see ##### in a cell? you column is not wide enough Which of the following is not a way to widen a column? Click on the column label and drag it to the right Where can you find more alignment options? format cells dialog box Which of the following is not a valid number format? $-1,000.00 Which keyboard shortcut toggles through the types of reference options? F4 What type of cell reference should be used when a value remains constant? Absolute If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference? absolute What punctuation is used to separate the two cell references in a range? Colon (:)
Where does Excel automatically display statistics like count, average, and sum when a range of values is selected? status bar Which of the following is not an argument associated with the IF function? Value if neither true nor false Which excel function changes the value to desired number of decimal places? Round What describes a function's purpose? name If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the text and blank cells, which function would you use? COUNT What error will you get if you type a function name incorrectly? #NAME? What chart type can display two different chart types at the same time? Combo What is not true about an effective chart? It always contains more than one series In a bar chart, which axis displays the categories? vertical The plot area is surrounded by how many axes? 2 What is a disadvantage of a stacked column chart? segments do not start at the same point what is not found on the chart elements list? chart type Which chart type is not listed in the All Charts window? sparkline What should you not select when selecting data for a chart? worksheet titles Where does the primary axis display on a combo chart? left side Which of following is not a chart element? Chart foreground Which of the following is not a freeze option? Freeze section Using the data bars conditional formatting, how is the highest value represented? By the longest bar By default, what is the first table on a worksheet named? table 1 How does excel indicate that a column has been selected in a structured reference? a colored border appears around that column which wildcard character only replaces one character with one other character? question mark ? What is not true about creating a data table? for efficiency, make sure your data table does not exceed 256 rows where does excel display the total row table? Below the last row in the table Which of the following is not a conditional formatting option? table format By how many levels will excel allow you to sort? 64 If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in excel? Conditional formatting Students also viewedExcel Chapter 1-2 Questions129 terms Hono21 Quiz 1 Csi 1200200 terms dcnjsdjvvdsn3 Excel Chapter 333 terms xeniade Excel Ch319 terms lit1212 Other sets by this creatorMKTG 3320 Exam 250 terms Hannahscheaffer1 MKTG 3320 exam 169 terms Hannahscheaffer1 MKTG 3320 exam 156 terms Hannahscheaffer1 FINC 3320 Exam 1 Ch. 0-439 terms Hannahscheaffer1 Other Quizlet setsunit 6: narratology38 terms heretolearnye MIP 1 begreper romantikken28 terms Eileen_Engebretsen MSE 2001 Chapter 9 and previous exams64 terms ImTurnerTheLearner Lesson 2: Why Public Speaking Matters10 terms quizlette7927625 What action changes the actual number of decimal places in Excel?The Increase Decimal and Decrease Decimal commands allow you to control how many decimal places are displayed in a cell. These commands don't change the value of the cell; instead, they display the value to a set number of decimal places.
Which button instructs Excel to display additional decimal places in a cell?On the Home tab, in the Number group, click the icon next to Number to display the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Percentage. In the Decimal places box, enter the number of decimal places that you want to display.
Which function would you use if you wanted to count the number of values but ignore cells that are below a certain value?Use the COUNTA function function to count only cells in a range that contain values. When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you.
What keyboard shortcut will automatically update any formulas using today () or now ()?The time and date displayed by the formula will automatically update when any of the following things happen: Any cell in the worksheet is changed. A new number or formula is entered in any cell. F9 is pressed.
|