Transcription of Microsoft Excel Test 2010 Chapters 1 3 (Part #1) Computer ...
1 Microsoft Excel Test 2010 Chapters 1 3 (Part #1) Computer Application I -1301 Student Name: _____ I agree to work independent and without help or assisting my fellow students. If I am caught cheating, I will accept the punishment decided by Professor Sims which includes but not limited to, a 0 on the test for both parties. _____. Student s Signature 1. An Excel document is called a A) workbook. B) presentation. C) chart. D) database. 2. The individual pages of an Excel document are called A) cells. B) worksheets. C) workbooks. D) charts. 3. A _____ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns. A) spreadsheet B) chart. C) data marker D) cell 4. A _____ is created when a row and a column intersect. A) label B) cell C) data point D) data marker 5. Two or more cells that Excel treats as a single unit is called a A) series. B) worksheet. C) workbook. D) range. 6. A prewritten formula known as a(n) _____ looks at one or more values, performs an operation, and returns a value.
2 A) operator B) label C) function D) data point 7. All Excel formulas begin with which symbol? A) ? B) * C) % D) = 8. Each worksheet is identified by the _____ found along the lower border of the Excel window. A) sheet tabs B) value axis C) labels D) row headings 9. Anything a user types into a cell is known as. A) a label. B) a formula. C) cell content D) a number. 10. A predefined formula is called a A) function. B) data bar. C) filter. D) criteria. 11. The values that an Excel function uses to perform operations are called A) tests. B) criteria. C) arguments. D) panes. 12. The _____ function adds all of the numbers in a range of cells. A) MEDIAN B) MIN C) SUM D) MAX 13. Excel 's _____ function finds the largest value in a selected range of cells. A) MEDIAN B) MIN C) COUNTIF D) MAX 14. IF is an example of a _____ function. A) navigation B) summary C) logical D) statistical 15. The _____ function counts the number of cells within a range that meet a certain criteria.
3 A) SUM B) COUNTIF C) IF D) MEDIAN 16. Excel 's _____ function retrieves the date and time from the Computer 's calendar and clock. A) NOW B) TIME C) CLOCK D) CALENDAR 17. You would _____ a table if you wanted to display only data that matched specific criteria. A) sort B) freeze C) filter D) scale 18. A _____ displays and summarizes totals from other worksheets. A) data bar B) detail sheet C) summary sheet D) sheet tab 19. A _____ shows the relationship of each part of the data to the whole. A) line chart B) bar chart C) pie chart D) column chart 20. A workbook sheet that contains only a chart is called a(n) A) data marker. B) axis. C) chart sheet. D) legend. 21. To _____ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart. A) bevel B) tick C) base D) explode 22. A gallery of text styles that can be used to apply decorative effects to text is A) TextArt. B) WordArt. C) ItemArt.
4 D) 3-D Art. 23. Goal Seek is an example of a _____ tool. A) charting B) plotting C) function D) what-if analysis 24. The _____ identifies patterns and colors assigned to categories in the chart. A) legend B) data point C) data series D) chart sheet 25. Changes made to the _____ affect the overall totals on the Summary worksheet. A) detail sheets B) paste area C) data bars D) sheet tabs
