IBA Second Semester Exam Excel and PowerPoint

1. IBA Second Semester ExamExcel andPowerPoint

2. Excel Lesson 1: Microsoft Excel Basics • When Excel starts, the program window displays a blank workbook titled Book1, which includes ____ blank worksheets. • Three • The file used to store worksheets. • Workbook

3. The name of each worksheet appears in the ____ at the bottom of the worksheet window. • Sheet tab • A ____________________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2. • formula

4. ____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window. • Columns • A _________________ is the intersection of a row and a column. • Cell

5. ____ appear horizontally and are identified by numbers on the left side of the worksheet window. • Rows • The cell in the worksheet in which you can type data is called the __________. • Active cell

6. The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____. • Colon • Numbers that extend beyond a cell’s width appear as ____ in the cell. • #######

7. Microsoft Office Excel 2010 is the _______ program in Microsoft Office 2010. • spreadsheet

8. Excel Lesson 2: Changing the Appearance of a Worksheet • As you format cells, ____ shows the results of the different formatting options you can choose. • Live Preview • Numbers that do not fit in the cell are shown as a series of _________________. • Number signs (####)

9. Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell. • Bottom-right • Standard accounting format uses a single border below a column of numbers and a ______ border below the total. • double

10. Excel ____ all numbers. • Right-aligns • The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places. • currency

11. You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon. • Merge and center • Determines the height of characters as measured in points. • Font size

12. A ____ is a preset collection of design elements, including fonts, colors, and other effects. • theme • ____ determines the best width for a column or the best height for a row, based on its contents. • AutoFit

13. Excel Lesson 3: Organizing the Worksheet • Click the Ctrl+C keys to ____ selected cells. • copy • Click the ___________ keys to copy selected cells. • Ctrl+C

14. Click the Ctrl+V keys to ____ the selected cells. • paste • Worksheets printed in ________ orientation are longer than they are wide. • portrait

15. To use the drag-and-drop method, select the cell or range you want to move or copy. Then, position the pointer on the top border of the selected cells. The pointer changes from a white cross to a ____ arrow. To move the selected cells, drag them to a new location. • Four-headed

16. To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab. • Row number • Headers and footers are each divided into ______ sections, which you can use to organize the text. • 3

17. Worksheets printed in ____ orientation are wider than they are long. • landscape • What view is best for entering and formatting data in a worksheet? • Normal view

18. A ____ is text that prints in the top margin of each page. • header • By default, ____________________, row numbers, and column letters appear in the worksheet—but not on the printed page—to help you enter and format data. • gridlines

19. Excel Lesson 4: Entering Worksheet Formulas • After you finish typing a formula in a cell, you must enter it by pressing the ____. • Enter key • Tab key • Enter button on the formula bar

20. The formula = E6/4 is an example of a(n) ____ operation. • division • When formulas with mixed cell references are copied or moved, the row or column references preceded by a _______________ do not change. • Dollar sign ($)

21. The sequence used to calculate the value of a formula is called the ____. • Order of evaluation • Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are __________. • operands

22. To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual. • Calculations Options • A symbol that indicates the type of calculation to perform. • operator

23. The SUM function that adds the numbers in the range D5:D17 is ____. • =SUM(D5:D17) • Does not change when copied or moved to a new cell. • Absolute cell reference

24. Each formula begins with a(n) ___________ • equals • The formula =B5+C5 is an example of a _____________________ operation. • addition

25. Excel Lesson 5: Using Functions • An example of the function that returns the number of cells in a range of cells that contain data is ____. • =COUNT(B4:B15) • The rounding operation requires two arguments, which are separated by a _______. • comma

26. The ____ function returns the current date and time based on the computer’s date and time settings. • NOW() • A _______________ is a shorthand way to write an equation that performs a calculation. • function

27. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly? • =AVERAGE(E4:3) • The _______________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand. • argument

28. If a function contains more than one argument, _____________ separate the arguments. • Commas • Functions, such as the square root functions, that manipulate quantitative data in a worksheet. • Mathematical functions

29. In the IF function, the first argument sets a condition for comparison, called a_________________. • Logical test

30. Excel Lesson 6: Enhancing a Worksheet • When you no longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. Then press the ____ key. • delete • When you click the shape you want to insert the pointer changes to a ___________. • crosshair

31. ____ graphics enhance worksheets by providing a visual representation of information and ideas. • SmartArt • A _____ can help make a work sheet more informative—examples: rectangles, circles, and arrows. • shape

32. A(n) ____ is a digital photograph or other image file. • picture • ____________ graphics are often used for organizational charts, flowcharts, and decision trees. • SmartArt

33. ____ are predesigned workbook files that you can use as the basis or model for new workbooks. • templates • You can make a perfect square or circle by pressing and holding the _______ key as you drag in the worksheet to draw the shape. • shift

34. A ____ is a reference in a worksheet that opens another file or page when you click it. • hyperlink • A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest. • descending

35. Hiding ______________ removes a row or column from view. • hiding • Rearranging the data in a more meaningful order. • Sort

36. Excel Lesson 7: Working with Multiple Worksheets and Workbooks • Until ____ are named, they are identified as Sheet1, Sheet2, and so on. • worksheets • A(n) ______________ mark separates the worksheet range from its cell or range reference. • exclamation

37. You can reposition a worksheet by dragging its ____ to a new location. • Sheet tab • Identifies the worksheets within the workbook. • Sheet tab

38. To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group. • Ctrl • A ___________ reference is a reference to the same cell or range in multiple worksheets that you use in a formula. • 3-D

39. The active sheet has a _________ sheet tab. • white • The worksheet that appears in the workbook window. • Active sheet

40. Excel Lesson 8: Working with Charts • You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu. • rename • In Excel, the chart data, called the _______________, is stored in a range of cells in the worksheet. • Data source

41. The chart element called ____ is the graphical representation of all of the data series. • Plot area • _________ are lines that establish a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis. • axes

42. A selected chart element is surrounded by a ____. • Selection box • A ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart. • Data series

43. A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____. • workbook • A ____________________ chart uses bars of varying heights to illustrate values in a worksheet. • column

44. The quickest way to select a chart element is to ____. • Click it with the pointer • Formats the chart based on the colors, fonts, and effects associated with the workbook’s theme. • Chart style

45. Each part of a pie chart is shown as a ____ of the pie. • slice • A graphical representation of data. • chart

46. A chart sheet does not have worksheet cells and cannot contain ________________. • Data or formulas

47. PowerPoint Lesson 1: Microsoft PowerPoint Basics • The ____ slide introduces your presentation to your audience. • Title • To save a new presentation for the first time, you use the ___________ command. • Save As

48. ____ refers to the way each new slide appears on the screen. • transition • The ____________ tab is the default tab on the Ribbon and includes many of the commands you will use most often when creating the slides. • Home

49. A(n) ____ is an effect you can apply to text, objects, graphics, or pictures to make those objects move during a slide show. • animation • You use ________________ to prepare a presentation that includes slides, outlines, speaker’s notes, and audience handouts. • PowerPoint

50. The Zoom In and Zoom Out buttons increase or decrease the zoom level by values of ____. • 10 • The ______________ tab, which opens Backstage view, includes file management commands such as the Save, Save As, Open, Close, and Print commands. • File