Excel Competency Practice Test | updated

Excel Competency Practice Test | updated b - ABC is a: a.Cell reference b.Column designation c.Range reference d.Row name b - The fastest way to highlight top 10 values in a range is by: a) Adding a pie chart next to the data. b) Applying conditional formatting. c) Quickly selecting the values and changing the border colors by hand. d) This will always be a lengthy process, especially if you have a large dataset d - Excel has _______ rows: a.2,000 b.16,384 c.33,000 d.1,048,576 d - What does it mean when Excel displays ### in a cell that is supposed to have a numerical value? a.It is a pattern it wants you to reproduce b.It is an error message c.It is not a prime number d.The column is too narrow to display the value a - What is the shortcut/key combination to print work? a.CTRL+P b.CTRL+S c.CTRL+U d.CTRL+V b - Returns the number of cell locations in a range that contain a text or numeric character. a.COUNT b.COUNTA c.COUNTIF d.COUNTAS - In VLOOKUP, "lookup_value" is: array of matches that are available based on your lookup value. column that includes the information that we are looking up. range that contains the values you want returned by the function. piece of data you know and are trying to match with something you don't know. True - T/F: When you create a table, if your data does not contain column headers, Excel adds headers with default names d - In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns. A. index B. glossary C. list D. range b - Nima wants to create a hyperlink to a location in her current workbook. She clicks the Hyperlink button in the Links group on the Insert tab. What option should she select from the Link to list? A. Existing File B. Place in This Document C. Create New Document D. E-mail Address d - Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. A. controls B. groups C. tabs D. ranges True - T/F: If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the worksheets in the group b - A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks. A. internal B. external C. import D. export b - ____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet. A. Hiding B. Freezing C. Showing D. Sealing True - T/F: If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1 True - T/F: Excel can summarize data in a range of data by inserting subtotals b - Every ____ consists of an object that contains a button for each unique value in that field. A. piece B. slicer C. section D. part a - You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet one of the criteria. A. Or B. Both C. And D. Either c - You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria. A. Or B. Both C. And D. Either b - A data ____ table describes the fields you plan to maintain in a table. A.structure B. definition C. map D. linked c - What are the three arguments of an "IF" function? a.Logical Test, Vfib, Bell curve Test b.Value_if_True, Logical Test, Beta Test c.Value_if_True, Logical Test, Value_if_false d.Value_if_false, Value_if_true, alpha test a - How many data series are used to create a pie chart? a.1 b.2 c.3 d.4