Microsoft Word and Excel: Navigation, Formatting, and Data Analysis, Exams of Computer Science

Download Microsoft Word and Excel: Navigation, Formatting, and Data Analysis and more Exams Computer Science in PDF only on Docsity! MISY 5325 Excel Midterm Ultimate Review study guide questions and answers exam A ctrl key should be pressed if users want to select cells or a range of cells which are not adjacent. TRUE To properly move a chart to another worksheet, you should use the function ________ move chart C. move chart If users enter the functions correctly, the functions SUMIF and DSUM should return the same result. TRUE Which of the following of cell reference will not change when the formula was copied and pasted in another cell? B. $A$1 (Absolute Reference) Which one of the following statement is NOT true about the function Table? C. Once the Table function is applied on the data, there is no way to convert it back. (The above statement is FALSE/NOT TRUE) To display the formula in a worksheet, a user should press ____________ C. Ctrl + Accent The PV function is usually used to calculate the ending balance of the loan in an amortization schedule. TRUE The function Hide will allow users to hide the column, but not row. FALSE Linda deposits 200 into a bank every month. The annual interest rate is 6%. She deposits the money for 4 years. Which one of the following is the function to calculate the money she would have at the end of the fourth year? C. = -FV(6%/12, 4*12, 200) [with a minus – sign before the future value] Typically, the function Autosum should not be used to find the total for a column containing data in percentage. TRUE The function Hide will allow users to hide the column, but not row. FALSE Linda deposits 200 into a bank every month. The annual interest rate is 6%. She deposits the money for 4 years. Which one of the following is the function to calculate the money she would have at the end of the fourth year? (Excel) TRUE/FALSE: To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). TRUE (Excel) TRUE/FALSE: To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu. FALSE (Excel) TRUE/FALSE: The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers. TRUE (Excel) TRUE/FALSE: You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu. EXCEL: An Excel _____ allows data to be summarized and charted easily. a. worksheet b. workflow c. document d. presentation a. worksheet We have an expert-written solution to this problem! EXCEL: The first step in creating an effective worksheet is to make sure you _____. a. apply font formatting b. understand what is required c. insert chart d. enter the data b. understand what is required EXCEL: To enter data in a cell, you must first select the _____. a. row b. worksheet c. column d. cell d. cell EXCEL: ______ is/are used to place worksheet, column, and row titles on a worksheet. a. Color b. Text c. Links d. Tabs b. Text EXCEL: Clicking the _______ box completes an entry. a. Cancel b. Formula c. Enter d. Tab c. Enter EXCEL: The ______ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. a. AutoComplete b. AutoCorrect c. AutoFormat d. AutoTyping b. AutoCorrect EXCEL: Pressing the_____ key to complete an entry activates the adjacent cell to the right. a. RIGHT ARROW b. LEFT ARROW c. UP ARROW d. DOWN ARROW a. RIGHT ARROW EXCEL: In Excel, a number can contain the characters _______. a. 0 1 2 3 4 5 6 7 8 9 b. + - ( ) , / c. . $ % E e d. all of the above d. all of the above EXCEL: The ______ is the small black square located in the lower-right corner of the heavy border around the active cell. a. selection handle b. sizing handle c. fill handle d. copy handle c. fill handle EXCEL: The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. a. Copy Options b. Replace Options c. Formatting Options d. Auto Fill Options d. Auto Fill Options EXCEL: The _______ preceding a formula alerts Excel that you are entering a formula or function and not text. a. quotation mark (") b. colon (:) c. plus (+) d. equal sign (=) d. equal sign (=) EXCEL: You _______ a worksheet to emphasize certain entries and make the worksheet easier to read and a. HOME EXCEL: If you wish to sign out of your Microsoft account, tap or click ______ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link. a. ACCESS b. TOOLS c. EXIT d. FILE d. FILE EXCEL: When you enter a two-digit year that is less than 30, Excel changes the year to ______. a. 20xx b. 30xx c. 18xx d. 19xx a. 20xx EXCEL: The _____ function displays the highest value in a range. a. MIN b. SUM c. MAX d. AVERAGE c. MAX EXCEL: Clicking the ______ opens the Insert Function dialog box. a. Insert Function box in the formula bar b. Function dialog box launcher (HOME tab | Calculations group) c. Function button (HOME tab | Function group) d. Functions & Formulas button on the status bar a. Insert Function box in the formula bar EXCEL: A company or department may standardize with a specific _______ so that all of their documents have a similar appearance. a. scheme b. gallery c. theme d. style c. theme EXCEL: Which of the following Auto Fill Options menu options i the same as the Fill Series option? a. Fill months b. Fill Without Formatting c. Fill Formatting Only d. Copy Cells a. Fill months EXCEL: Which of the following is the path to the Increase or Decrease Indent button? a. (HOME tab | Clipboard group) b. (HOME tab | Editing group) c. (HOME tab | Alignment group) d. (HOME tab | Number group) c. (HOME tab | Alignment group) EXCEL: The Increase Indent button indents the contents of a cell to the right by ______ spaces each time you click it. a. two b. three c. four d. five a. two EXCEL: The _______ function is useful when you want to assign a value to a cell based on a logical test. a. IF b. NOW c. AND d. OR a. IF EXCEL: A(n) _______ chart provides a simple way to show trends and variations in a range of data within a single cell. a. section b. sparkline c. special d. sparkle b. sparkline EXCEL: You use a(n) _______ to automate data analyses. a. data table b. formula checker c. amortization schedule d. IF function a. data table EXCEL: A(n) _______ shows the beginning and ending balances and the amount of payment that is applied to A combination of cell references, operators, values, and/or functions used to perform a calculation. Syntax A set of rules that governs the structure and components for properly entering a function. TODAY Function Displays the current date. Absolute Cell Reference Circular Reference Occurs when a formula directly or indirectly refers to itself. Arguments An input, such as a cell reference or value, needed to complete a function. MAX function Identifies the highest value in a range. COUNTA function Tallies the number of cells in a range that contain values. VLOOKUP Looks up a value in a vertical lookup table and returns a related result from the lookup table. Lookup Table A range that contains data for the basis of the lookup and data to be retrieved. AVERAGE function Calculates the arithmetic mean, or average, of values in a range. MEDIAN function Identifies the midpoint value in a set of values. NOW Function Displays the current date and time. IF Function Evaluates a condition and returns one value if the condition is true and a different value if the condition is false. SUM Function Calculates the total of values contained in two or more cells. PMT Function Calculates the periodic payment for a loan with a fixed interest rate and fixed term. Relative Cell Reference Indicates a cells location from the cell containing the formula; the cell reference changes when the formula is copied. Mixed Cell Reference Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula. Range Name A word or string of characters that represents one or more cells. Logical Test An expression that evaluates to true of false. MIN Function Displays the lowest value in a range. Name Box Which area on the left side of the formula bar indicates the cell address of a selected cell? Row Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent? Entry Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table? Ctrl End What is the shortcut that will lead to the last record on her spreadsheet? Quick Access Toolbar Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands? Worksheet Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? Normal Which view is the default view used in Microsoft Excel? File Which tab is used to display the area that contains the print command? Close Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program? Microsoft Excel Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? Cut Alicia needs to move the data in cell B5 to cell E5. Which command would she select? AutoFit In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit? Document Properties Hide Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select? Find and Select Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting? Page Layout Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? Tab Color Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose? Freeze Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select? Sort Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet? Filter David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task? Sort and Filter Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? Lower Tom wants to convert all text to lowercase. Which function should he use? COUNTIF Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should she use? NOT James wants his spreadsheet to return true when the logical value is false. What function should he use? Share Workbook Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this? Edit Comment Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose? Slicers What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts? Pivot Table In order to directly report the data, what must a PivotChart always be associated with? Insert What ribbon contains the commands for creating charts in Microsoft Excel? Labels John wants to identify the exact value that each column in his chart represents. Which option should he choose? Column Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create? Exploded What term refers to an Excel Chart with offset pieces for emphasis? Embedded Chart John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create? Fields When creating a PivotTable, which are drawn in columns in the worksheet data? Numeric Data and Titles What is typically included in the range of data selected to create a chart? Format John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use? Rotate Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet? Format Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt? Which of the following is Not a number format available in the Number group on the Home tab? Date Format To begin a formula in a cell, first type the # symbol. False When you hide a column or row, the data is not deleted, it is just hidden. True Text in a cell can by angle clockwise True The ___ command is helpful for navigating to a cell that is not visible onscreen Go to The ___ view displays print options and displays a worksheet in print preview Office Backstage Comma, Date, Time, and Fraction are all number formats available in Excel 2013. True Click Format in the Cells group o the __ tab to change the color of a worksheet tab. Home Formatting data makes it difficult to read and tends to obscure meaningful details. False In Excel 2013, it is only possible to add a new worksheet when the workbook is created. compares groups set side by side relationship of individual data points to the whole Clustered column chart Stacked column chart A(n) __ is a grid that contains the data source values and labels. data table A pie chart shows each data point in proportion to the whole data series as a slice in a circular pie. A stacked column chart: places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color. A chart is: a visual depiction of numerical data A chart__ controls which data series and categories are visible in a chart. filter Excel automatically determines the starting, incremental, and stopping values on a chart based on the data selected. True Which of the following is NOT one of most commonly used chart types? X Y chart A(n) ___ chart is a derivative of a scatter chart in which both axes are value axes. bubble Excel 2013 automatically assigns a different pattern to each column of a clustered column chart. False To begin creating sparklines on a worksheet, click the __ tab. Insert To print only a chart, select the chart, click the __ tab, and click Print. file Axes, chart tittles, and data tables are examples of chart elements. True In addition to sorting and filtering cells by content you can sort and/or filter by __. conditional formatting Excel enables you to sort data on __ different levels. 64 Print order: is the sequence in which pages print. Freeze Panes only locks columns above the active cell as you scroll through a worksheet. false Table style controls Table Style Options group Sorting Text A to Z Sorting Dates oldest to newest Sorting Values smallest to largest fill color of the header row, columns and records in a table check boxes to select format actions arranges data in alphabetical order displays data in chronological order arranges numbers in sequential order In addition to sorting and filtering cells by content, you can sort and/or filter by __ formatting conditional Highlight Cells Rules Top Bottom Rules Data bar Color scale Icon set highlights cells meeting criteria with a color, font, or border formats cells based on the value in relation to the other cells horizontal gradient of solid fill indicating a cell's relative value conditional format that displays a particular color based on the relative value of a cell conditional format that displays a small image representing a value A(n) __ defines the range of data from a worksheet to print. print area The ___ Table Style option displays the field names of a table when checked. header row Top/Bottom Rules: format cells based upon their value in relation to the value of other cells. Function key __ accesses to Go To command in Excel. F5 To ___ a table into a range, click within the table, click the Table Tools Design tab, and from the Tools group, select Convert to Range. convert You can apply text, value, and date filters to fields based on the data in a particular field. true 1.Filtering 2.Top 10 option 3.Custom Filter 4.Duplicate Values 5.Sorting 1.displays only records that meet conditions 2.specify a number or percentage of records to display 3.complex filtering requirements 4.conditional formatting that displays doubled cells 5.arranges records in a table by the value 1.Slicer 2.Filter 3.Calculated Field 4.PivotChart 5.Slicer caption scenario summary report 1.Scenario Manager 2.Scenario Summary Report 3.Scenario 4.Goal seek 5.Optimization model 1.Enables you to define and manage scenarios to compare how they affect results 2.A worksheet that contains scenario results 3.Detailed sets of values that represent different possible situations 4.A tool that identifies the necessary input value to obtain a desired goal 5.Finds that highest, lowest, or exact value for one particular result by adjusting values for selected variables 1.Add-in 2.Binding constraint 3.Constraint 4.Changing variable cell 5.Solver 1.A program that can be added to Excel to provide enhanced function 2.A constraint that Solver enforces to reach the target value 3.A limitation that imposes restrictions on Solver 4.A cell containing a variable whose value changes until Solver optimizes the value in the objective cell 5. An add-in application that manipulates variables based on constraints to find the optimal solution to a problem. Which of the following is best suited for comparing the effects of two variables on a formula? Two-variable data table the analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals. Solver quick access toolbar formula bar name box close button title bar columns What part of Excel Window is labeled with the ALPHABET rows What part of Excel Windows is labeled with NUMBERS active cell What is the part called that has the BLACK BORDER BOX Ctrl O the shortcut key to open WORKBOOK Ctrl N the shortcut key to open a NEW WORKBOOK Ctrl S & F12 the shortcut key to SAVE a WORKBOOK Ctrl P the shortcut key to PRINT a WORKBOOK Ctrl W the shortcut key to CLOSE A WORKBOOK tab/right arrow Which key makes you go one cell to the right?? shift tab/left arrow Which key makes you go one cell to the left?? enter/down arrow Which key makes you go down one cell?? shift enter/up arrow Which key makes you go up one cell?? Ctrl Home Which key makes you go to call A1?? = What symbol shows that you are inserting a formula?? * What symbol shows that you are multiplying?? / What symbol shows that you are dividing?? auto sum Data Tab - Sort and Filter - Advanced Modify the worksheet so the first row is always visible when you scroll the worksheet down. View Tab - Freeze Panes Remove duplicate rows where data in all the columns are identical. Table Tools Design Tab - Tools Group - Remove Duplicates - OK - OK Add markers for all the data points in this Sparkline group. Sparkline Tools Design Tab - Show Group - Markers Checkbox Add the Bonus field to the PivotTable. Scroll down in Fields - Check Bonus checkbox Enter a formula in cell B4 using the VLOOKUP function to find the meaning for the medical abbreviation listed in cell A4. Use the name Abbreviation for the lookup table. The item names are located in column 2 of the lookup table. Be sure to require an exact match. Insert VLOOKUP - 2 in the VLOOKUP Col_index_num field text box - abbreviation in the VLOOKUP Table_array field text box - a4 in the VLOOKUP lookup_value field text box - false Use the Flash Fill command to autofill the remaining cells in this column with the pattern from cell F2. Data Tab - Data Tools Group - Flash Fill Hide the formulas in this worksheet and display the values instead. Formulas Tab - Formula Auditing Group - Show Formulas Sort the data first alphabetically by the values in the Category column and then by the dates in the Date column with the oldest dates first. Data Tab - Sort - Catgeory - Add Level - Date Add a report filter for the Employee field and use it to filter the PivotTable to show only data where the value of the Employee field is Dr. Patella. Drag Employees to Filter - Go to Employees Cell - Select drop arrow - Dr Patella Create and apply a new conditional formatting rule to apply bold font formatting to only cells that are equal to or below the average for the selected range. Home Tab - Style - Conditional Formatting - New Rule - Format only values above/below avg - Edit Rule Description: (drop-down) equal or below - Format: Bold - OK - OK Manually create groups of rows that can be expanded or collapsed as needed. Start with the group of selected cells. On the Data tab, in the Outline group, click the Group button. In the Group dialog, Rows is selected by default. Click OK Workbook When Excel opens a new _____________ is created, which is like a notebook. Worksheet Inside a workbook are ______________, each of which has a name. Sheet tab Each worksheet has a name that appears on a _______ ____ at the bottom of the workbook. 16,384 Each Excel worksheet has over ___________ possible columns. 1,048,576 Each Excel worksheet has over ___________ possible rows. Cell reference A cell is referred to by its unique address, or _______ ______________, which is the coordinates of the intersection of a column and a row. Active A cell is designated the _________ cell because it is the one into which data can be entered. Gridlines The horizontal and vertical lines on the worksheet itself are called ____________ and make it easier to see and identify each cell. Formula bar As you type, Excel displays the entry in the __________ _____. Name box Excel displays the active cell reference in the ________ _______, which can also be used to move to a specific cell or range of cells. Text In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________ and is left-aligned. Autocorrect The _______________ feature of Excel works behind the scenes, correcting common mistakes when a text entry is completed in a cell. Sum function The _______ __________ in the Editing Group of the Home Ribbon can be used to enter a function that adds the numbers in a range of cells. Range A _________ is a series of two or more adjacent cells in a column, row or rectangular group. Relative reference When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a (n) ___________ ______________. Fill handle The ________ ________ is the small green square located in the lower right hand corner of the active cell. Legend The _______ identifies the columns, bars or slices of a chart by assigning a color to each. Insert With a range selected, to initiate drawing a chart click the __________ main tab. Above When proposing the range, the Sum Function first looks for a range of cells with numbers _______ the active cell and then to the left. In-cell editing A procedure called ___ _____ _______allows the contents of a cell to be edited directly in the cell by double-clicking the cell containing an error. Autocalculate True You can press the esc key to cancel a cell entry before entering it into a cell. False Excel remembers the last 500 actions you have completed. False You use the ALT key when trying to select more than one range. True An embedded chart is simply a chart on the same worksheet as the data. False When adding a row to a spreadsheet, by default in comes in below the selected range. ALT Enter To start a new line in a cell, press ______ + _________ after each line Flash Fill _______ ____ is an Excel feature that looks for patterns in the data and automatically fills or formats data in the remaining cells. Formula One reason Excel is such a valuable tool is that if you enter a ___________ to multiply values, Excel recalculates the product whenever new values are entered. Circular Reference A formula in a cell that contains a reference back to itself is called a __________ ___________. Parentheses _____________________ can be used in a formula to override the order of operations. Point Mode __________ _________ allows cells to be selected for use in a formula by using the mouse. Marquee A moving border that surrounds a cell selected for a formula or group of cells selected for a function is called a __________. Relative References Cell references that Excel adjusts when a formula or function is copied are called __________ ___________ Trace Error When an error occurs in a formula in a cell, Excel displays the _________ ________ button next to the cell with the error by placing a green triangle in the upper left hand corner of the cell. Function A _______________ is a prewritten formula that is built into excel. Ex. Sum, Max, Min Arrangements The values used with a function are called ______________. Average Excel has a function called the _____________ function that sums the numbers in a specified range and then divides the sum by the number of non-zero cells in the range. Range Finder Excel's __________ _____________ can be used to check which cells are being referenced in the formula assigned to the active cell. Office theme New workbooks are formatted in Calibri 11 which is the default font for the __________ _________. Accounting Style The ________________ __________ format that displays a fixed dollar sign to the left of a number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place). Floating The currency style format assigns a ___________ dollar sign that appears immediately to the left of the first digit. Percent The ________________ style button instructs Excel to display a value as a percentage, which is determined by multiplying the cell entry by 100, rounding the result, and adding a percent sign. Conditional __________________ formatting offers the ability to automatically change how a cell appears - the font, font color, background fill, and other options - based on the value of the cell. Condition A _______________, which is made up of two values with a relational operator, is true or false for each cell in the range. 15 The default row height is ________ points. 8.43 The default column width is _______ characters. Best Fit _______ ______ means that the width of a column or row will be increased or decreased so the widest entry will fit in the column. Hidden _______________ cells is a technique that can be used to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see. Landscape ________________ orientation is a good choice for large worksheets, because when printed the worksheets width is greater than its height. Debugging F A Blank cell always has a value of zero. T You can enter Header and Footer information by switching from Normal View to Page Layout View. Cell Reference When you set up a worksheet you should use ______ ___________ in formulas whenever possible, rather than constant values. Assumption __________________ are values in cells that can be changed to determine new values for formulas. Rotate To __________ text in a cell you can use the Alignment Tab of the Format Cells dialog box. Paste Options Button The advantage of copy and paste over other methods of copying or moving information is that following the paste in the destination you are given formatting choices using the ________ _______ _________. Drag and Drop Using the mouse to move or copy cells is called ________ _____ ________. #REF! Excel displays the error message ____ _____ in cells to indicate a cell reference error as a result of deleting a row or column. Format When a number is entered with a (n) ___________ symbol, Excel immediately displays the number with an assigned format. Now A simple way to way to create a date stamp is to use the __________ function to enter the system date tracked the computer. Absolute Cell Reference To keep a cell reference constant when it copies a formula or function, Excel uses a technique called ____________ ______ _____________. F4 The easiest way to keep the cell reference C4 constant in a formula as it is copied to a destination area is to format it using the ______ key. IF The _____ function is useful when you want to assign a value to a cell based on a logical test. Logical Test The leftmost entry in the general form of the IF function is the __________ _______ that is made up of two expressions and a comparison operator. #### Excel displays the error message __________ in cells not wide enough to display the entire entry. Sparkline Charts A ______________ ________ provides a simple way to show trends and variations in a range of data within a single cell. Format Painter Using the ____________ _____________ in the Clipboard Group of the Home Ribbon, a cell can be formatted quickly by copying a cell's format to another cell. Chart-sheet A separate sheet on which a chart resides is called a (n) __________ __________. Category Names The entries in the range that identify the major groups for the chart are called __________ _______. Data Service The data that determines the size of the columns or slices in a pie are called the _______ ________. Split When working with a large worksheet, you can ________ the Excel window into two or four panes to view different parts of the worksheet at the same time. Freezing ___________ worksheet titles is a useful technique for viewing large worksheets that extend beyond the window so that Excel displays row and column headings no matter how far down or to the right you scroll. What-if Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called __________ ____ or sensitivity analysis Goal Seeking If you know the result you want a formula to produce, you can use __________ ________ to determine the value of a cell on which the formula depends. Equal When creating a column/bar chart with two or more separate ranges, make sure that you select a ________ number of columns or rows in each range. Pic A (n) ________ chart is a type of chart used to show the relationship or proportion of parts to a whole. Y Axis X Axis In order to have a properly labeled column or pie chart with a proper title, legend and axis labels you must include the __________ and ____________ headings in the ranges selected. Graphics _______ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations Themes PowerPoint displays many _____ that are varied and appealing and give you an excellent start designing a presentation. Title slide The ___ introduces the presentation to the audience Contrast A photos color intensity can be modified by changing the brightness and ____ Style A ___ is named group of formatting characteristics To create a split form select the table in the navigation pane tap or click create on the ribbon, tap or click the _______ button on the create tab to display a menu, and then tap or click Spilt Form on the menu. More Forms To move from Layout view to Form view, tap or click the ______ button on the Access status bar. Print To print the results with the query open, tap or click FILE on the Ribbon, tap or click the _________ tab in the Backstage view, and then tap or click Quick Print. >=0 and <=30000 To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter _________ in the Validation Rule property box. Selection To use Filter by Selection to find all customers located in Greer, click the city field for any record where the city is Greer and then click the ______ button on the home tab. Character Filter To use a common filter to find only those customers whose city begins with G, tap or click the arrow to the right of field name and point to the ______ command to display the custom text filters. Design To delete a field from a table, open the table in ______ view, tap or click the the row selector for the field to be deleted, and then press the DELETE key. Lookup A _____ field allows the user to select from a list of values. Lookup To change the list of choices in a single or multivalued lookup field, open the in Design view, select the field to be modified, and tap or click the _______ tab in Field Properties pane. Calculated A(n) ______ field is a field that can be computed from other fields. Update To create an update query, create a new query and then tap or click the ______ button on the DESIGN tab. Query Type To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane, point to ______ on the shortcut menu, and then tap or click Update Query on submenu that appears. Run To update record using an update query, enter the field to be update in the design grid, enter any necessary criterion, and then tap or click the ___________ button to update the records. Append A(n) ________ query adds a group of records from one table to the end of another table. Required To specify that a field is to be required, change the value for the ___________ property from No to Yes. T> To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box. Quick Access Toolbar To save validation rules, default values, and formats, tap or click the Save button on the _____ to save the changes. Totals To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet. Value To change a query so that each item in a multivalued field occurs on a different row, use the ____ property Ascending To order the records in the Client table by city in alphabetical order, use the _____ button. Descending To order the records in the Client table in reverse alphabetical order by City, click the ____ button. Close To exit Access, click the ______ button on the right side of the Access title bar. True To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). False To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu. True The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers. True You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu. True The equal sign (=) precedes a formula True The most common error when entering a formula is to reference the wrong cell in the formula. False An asterick (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. False The arithmetic operator, ^, directs excel to perform the division operation. False As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations. False Display cells with two decimals places that align vertically What effect does the accounting number format format have on the selected cells? Display cell content with two decimal places and commas as thousands separators What effect does the comma style format have on the selected cells? 10 How many chart types does Excel offer? Exploded A pie chart with one or more slices offset is referred to as a(n) _____ pie chart AutoCalculate The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu Home Which of the following keys moves the insertion point to the beginning of data in a cell? File If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link. 20xx When you enter a two digit year that is less than 30, XL changes the year to Max The ___ function display the highest value in a range Insert Function box in the formal box Clicking the ____ opens the insert function dialog box. Theme A company or department may standardize with a specific ______ so that all of their documents have a similar appearance. Fill Months which of the following auto fill options menu options is the same as the fill series option? (Home tab | Alignment group) which of the following is the path to the increase or decrease indent button Two The increase indent button indents the content of a cell to the right by _____ space each time you click it. If The _____ function is useful when you want to assign a value to a cell based on logical test. Sparkline A(n) _____ chart provides a simple way to show to show trends and variations in a range of data within a single cell. Data table You use a(n) _____ to automate data analyses Amortization schedule A(n) _____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period. Cell protection ________ ensure that users do not change values inadvertently that are critical to the worksheet. Shortcut used to save a new file or an existing one in its same storage location Ctrl S The list of frequently used commands that appears when you right click an object Shortcut Menu Full-featured word processing program that allows users to create professional-looking documents and revise them easily Word Command used to save existing document with new file name or in new location Save As Window that allows user to see document pages exactly as they will print Print Type of template most appropriate for FBLA Secretary to inform FBLA members of monthly club activities Newsletter Action or command that cannot be undone in Word Saving a document Control center located below title bar at top of Word window Ribbon Someone is creating a custom template. If they use the tools found on the Review tab and proofreads her document, which important question are they answering? Will the template have correct spelling, grammar and punctuation? Shortcut key for accessing Word Help from Word window F1 File type you need to select when saving to protect you original letter Template Command to cancel recent action Undo Allows user to create new folder in desired storage location Save As How do users switch from one ribbon to another? Click the tab of the ribbon they wish to access Tab that contains Print command File Type of document most appropriate to use for a new policy Group on Home ribbon that contains commands to control text alignment Paragraph Method for changing Bullet symbol within list Select list and choose down drop-down arrow Tab stop used to align page numbers to result in even right edge Right Tab Amount of space between paragraphs Paragraph spacing Amount of vertical space between lines of text Line Spacing Option selected in Columns dialog box to create multiple columns in only one paragraph Apply to: drop-down list Ribbon containing command to change preset margin settings Page Layout Shortcut for inserting manual page break Ctrl Enter Term that refers to the two page layout positions Orientation Automatically inserted when determined text has filled one complete page allowed Page Break Method for bringing up dialog box to put 20 rows and 4 columns Insert Table Option to add predefined formatting to table Styles Command to divide cells in top row of table into two separate cells Split Cells Layout feature to adjust white space around cell Cell Margins Layout feature to make text start at top left Cell Alignment Option to navigate across colums Tab Command group in Table Tools that contains command to modify height or width of rows and columns Cell Size Ribbon that contains commands to apply preset table styles Table Tools Design Ribbon Command to place content from one source to another Copy Places box around entire document Page Border Ribbon that contains command to create headers Insert Valid placement options for page numbers Top of page or Bottom of page How user modifies colors in theme Theme Colors command on Page Layout Printable text and graphics at top of each page Header Tool to survey users through yes or no questions Content Controls Fills rectangle shape Picture Jordan inserted an image from his USB drive into his science report. What did he insert? Picture Capital letter that is much bigger then the rest of text Drop Cap Command on Picture Tools Format used to change way text wraps Wrap Text Where do you insert an arrow Shapes Command to e-mail entire program window Screenshot Small white circles surrounding graphic that allows user to resize graphic Corner Command to create quick and easy visual representation SmartArt Text placed below object Caption Chart types available Bar, pie, line and column Command to put pictures behind text Wrap Text Command to draw a star Shapes Type of drawing object enables users to create shadowed, rotated, stretched and wavy text effects In the Print dialog box, which area provides a user with a list of available printers? A. Print B. Printer Status C. Printer List D. Printer Selector List B Which of the following actions or commands cannot be undone in Microsoft Word? A. Saving a document B. Borders and shading C. Font color change and font size change D. Paragraph alignment and page orientations A Which of the following software programs is a full-featured word processing program that allows users to create professional-looking documents and revise them easily? A. Microsoft Office B. Windows C. Word D. WordPad C Which window allows a user to see document pages exactly as they will print? A. Print Outline B. Document C. Print D. Review C To save an existing document with a new file name or to save an existing document in a new location, which command is used? A. Save B. Close C. Exit D. Save As D Which dialog box allows a user to create a new folder in the desired storage location? A. Options B. Save As C. Close D. Print B To store a new or existing file with the same name, which button is used? A. Exit B. Close C. Save As D. Save D What is the name assigned to a file when it is saved? A. Document name B. Document title C. File name D. File title C What is the name of the list of frequently used commands that appears when you right-click an object? A. Mini Toolbar B. Shortcut Menu C. Quick Access Toolbar D. Status bar B Which automatically appears based on tasks you perform, and contains commands related to changing the appearance of text in a document? a. Dialog Box B. Mini Toolbar C. Shortcut Menu D. Ribbon B What is the control center located below the title bar at the top of the Microsoft Word window called? A. Task Pane B. Tab C. Ribbon D. Groups C Which command is used to close the current document without exiting Microsoft Word? A. File tab, choose Exit button B. Close button in upper right corner of the program window C. File tab, choose Close button D. File tab, choose Quit button C How do you access Microsoft Word Help from the Word Window? A. Click the Microsoft Office Word Help button in the upper right corner of the Word window B. Press the F2 key C. Choose the Help command on the View Ribbon D. Click the Microsoft Office Word Help button in the lower left corner of the Word window A Which is the shortcut key for accessing Microsoft Office Word Help from the Word window? A. F4 B. F1 C. F5 D. F9 B What type of template is most appropriate for the FBLA Secretary to use to inform FBLA members of monthly club activities? A. Chart B. Newsletter C. Letter D. Fax B Shameka is a Yearbook Staff member. Every semester she has to create a newsletter. Instead of recreating it each time, what should she create for future use? A. Template B. New Document C. Macro D. Mail Merge A Trey wants to use the Black Tie Newsletter template created by Office.com. Which icon would he select to create this document? A. Blank Document C Mrs. Perry has assigned the class to type a report. To view the report as a hard copy, which view should she use? A. Read Mode B. Outline C. Print Layout D. Web Layout C Which bar presents information about a document, the progress of current tasks, and the status of certain commands and keys, and also provides controls for viewing the document? A. Task B. Scroll C. Tool D. Status D... To increase or decrease the size of the content in a Microsoft Word window, which item on the status bar would you use? A. Zoom slider B. View picker C. Next page control D. Previous page control A What area in Microsoft Word enables users to view document properties and update the properties information at any time while creating a document? A. Document Properties Panel B. Advanced Properties C. Word Options dialog box D. File Save as Options Screen A What area is used to provide information about the author, title, subject, keywords, category, and comments that describe the document? A. Document Properties Panel B. Advanced Properties C. Word Options dialog box D. File Save as Options Screen A What is the name of the view that provides data about documents and contains a set of commands to help a user manage documents? A. Backstage B. Properties C. Document D. Normal A On the View Ribbon, which command allows the document to be viewed as it would appear in a multilevel outline? A. Print Layout B. Draft C. Outline D. Web Layout C Which tool on the Home Ribbon lets a user search for text in a document by keying the word into a search box? A. Select B. Find C. Search D. Locate B Which Editing group tool is used to search for and replace specific text in a document? A. Select B. Find C. Replace D. Locate C Sally wants to select an entire paragraph in her word processing document. What is the quickest way to select the paragraph? A. Double-Click B. Select All C. Single-Click D. Triple-Click D Sally wants to select the entire document that she is currently editing. What is the quickest way to select the document? A. Double-Click B. Select All C. Single-Click D. Triple-Click B To specify the size of the viewable area and allow users to reduce or enlarge the size of a document window, which command is used? A. Scale B. Resize C. Zoom D. Scope C What is the process of creating a duplicate of an item while leaving the original item in place in the document called? A. Cut B. Move C. Paste D. Copy D Which action would Drake take to insert the contents from the Office Clipboard into a document? A. Keep Source Formatting B. Keep Text Only C. Merge Formatting D. Paste D Mrs. Perry has assigned the class to type a report. To maximize space, which option would you choose to display the content? A. Read Mode B. Outline C. Print Layout D. Web Layout A C. Quick Styles D. Normal Styles C Which of the following terms defines the appearance and shape of the letters, numbers, and special characters in a document? A. Print B. Font C. Scheme D. Format B What type of break is used to create a new section on the same page as the previous section? A. Text B. Line C. Continuous D. Page C What does Microsoft Word automatically insert when it determines the text has filled one complete page allowed by the page size, margin settings, line spacing, and other settings? A. Line change B. Soft line change C. Page break D. Soft page change C Which ribbon contains the command to change the preset margin settings in a Microsoft Word document? A. Home B. Insert C. Page Layout D. Review C Which term refers to the two page layout positions of a document? A. Direction B. Alignment C. Configuration D. Orientation D What is the keyboard shortcut for inserting a manual page break? A. Ctrl+Insert B. Ctrl+Return C. Shift+Return D. Shift+Pause/Break B Where is the command to divide a Microsoft Word document into multiple columns located? A. Home Ribbon, Paragraph group B. Home Ribbon, Styles group C. Insert Ribbon, Text group D. Page Layout Ribbon, Page Setup group D What is the default space between columns? A. 1 inch B. 0.25 inch C. 1.25 inch D. 0.5 inch D Where is column width and spacing controlled in a Microsoft Word document? A. Page Setup dialog box on the Page Layout Ribbon B. Paragraph dialog box on the Home Ribbon C. Columns dialog box on the Page Layout Ribbon D. Font dialog box on the Home Ribbon C Which option is selected in the Columns dialog box to create multiple columns in only one paragraph of text in a document? A. Apply to: drop-down list B. Line Between C. Column Width D. Create Column A How are columns removed from a document? A. Select One Column in the Page Setup dialog box B. Select the column text and choose One from the Columns drop-down list on the Page Layout Ribbon C. Select No Column in the Paragraph dialog box D. Select the column text and choose the No Column command in the Arrange group on the Page Layout Ribbon B Mark created a three column newsletter. He wants to increase more words per line in each column. What should Mark do? A. Adjust column width B. Adjust column spacing C. Insert a column break D. Insert a vertical line between columns A Mark creating a three column newsletter. He wants to end the first column early to insert a picture below it. What should Mark do? A. Adjust column width B. Adjust column spacing C. Insert a column break D. Insert a vertical line between columns C Alexis is creating a table with numbers. She would like the numbers to be displayed as currency. Which tab stop should she use? A. Bar Tab B. Decimal Tab C. Left Tab D> Right Tab B What is the process of changing the appearance of a paragraph of text called? A. Text formatting B. Paragraph formatting C. Character formatting D. Document formatting B What is the amount of vertical space between the lines of text in a paragraph called? A. Paragraph spacing B. Document spacing C. Shift+Tab D. Shift+Enter A Which of the following refers to text that is arranged in alphabetic, numeric, or date order based upon the first character? A. Filtering B. Alphabetizing C. Sorting D. Ordering C Where is the command to insert a new table into a Microsoft Word document? A. Home Ribbon, Table group B. Insert Ribbon, Table group C. Home Ribbon, Paragraph group D. Insert Ribbon, Pages group B Which two ribbons become available when a table is selected in a Microsoft Word document? A. Table Format and Table Tools B. Table Tools and Table Edit C. Table Tools Edit and Table Tools Format D. Table Tools Design and Table Tools Layout D Table styles may be applied to a table in a Microsoft Word document from which ribbon? A. Table Tools Design Ribbon B. Table Tools Format Ribbon C. Table Tools Layout Ribbon D. Table Tools Edit Ribbon A Which ribbon is used to insert a new row into a Microsoft Word table? A. Table Tools Format Ribbon B. Table Tools Edit Ribbon C. Table Tools Layout Ribbon D. Table Tools Design Ribbon C Which command group in the Table Tools Layout Ribbon contains the command to modify the height or width of rows and columns in a table? A. Editing B. Cell Size C. Rows and Columns D. Table Styles D Which ribbon contains the commands to apply preset styles to a Microsoft Word table? A. Table Tools Format Ribbon B. Table Tools Edit Ribbon C. Table Tools Layout Ribbon D. Table Tools Design Ribbon D John would like to place a box around the entire document that includes his table. Which option should he choose? A. Border B. Page Border C. Shading D. Styles B John wants add predefined formatting to his table. Which option should he choose? A. Border B. Page Border C. Shading D. Styles D Lois has created a table in her document. She would like to divide each cell in the top row of her table into two separate cells. Which option should she choose? A. Merge B. Split Cells C. Split Table D. Autofit B Lois is unable to view all the information in the first column of her table. Which option should she choose? A. Merge B. Split Cells C. Split Table D. Autofit D Lois has created a table in her document. She would like to add a blank row between the table headers and the first row of data. Which option should she choose? A. Insert B. Delete C. Copy D. Cut A Joan would like to place the table she has created in her document in another document as well. Which option should she choose? A. Insert B. Delete C. Copy D. Cut C Lisa created a table. She wants the text in her rows to start at the top left. Which layout featuyre will she apply? A. Cell Alignment B. Text Direction C. Cell Margins D. Distribute Rows A Lisa wants to adjust the white space around a cell in her table. Which layout feature will she apply? A. Cell Alignment B. Text Direction C. Cell margins D. Distribute Rows C Johanna wants to navigate across columns to the left in her table. Which option should she choose? A. Tab B. Enter In a Microsoft Word document, what are the printable text and graphics at the top of each page called? A. Title B. Header C. Lead Note D. Leader B Which ribbon contains the command to create headers in a document? A. File B. Home C. Insert D. Page Layout C Which group contains the command to place text at the bottom edge of each printed page of a document? A. Links B. Text C. Format D. Header & Footer D What are the text and graphics that print at the bottom of every page in a Microsoft Word document called? A. Footnote B. Endnote C. Footer D. Closer C What is a quick way to close the Header or Footer view in a Microsoft Word document? A. Right-click the footer or header B. Double-click the footer or header C. Double-click the title bar D. Double-click the dimmed document text D Which of the following are valid placement options for page numbers in a document? A. Left of page or bottom of page B. Top of page or bottom of page C. In the endnote or top of page D. Top of page or in the footnote B Where does Microsoft Word put elements such as text, logos, graphics saved for later use in a document? A. Building Blocks Gallery B. Parts Gallery C. Quick Parts Gallery D. Element Gallery C Which tab group within the Insert Ribbon contains the commands that enable a user to insert common mathematical symbols or equations? A. Format B. Symbols C. Text D. Pages B What command on the Insert Ribbon creates a preformatted placeholder for text in a document? A. WordArt B. Bookmark C. Hyperlink D. Textbox D Sara inserted a graphic used to visually display her family tree. Which graphic did she use? A. Charts B. Shapes C. SmartArt D. WordArt C Jordan inserted an image from his USB Drive into his science report. What did he insert? A. Screenshot B. Screen clipping C. Picture D. Print Screen C What is the name of a capital letter that is the first letter in a paragraph but is set in a larger font size than the rest of the characters in the paragraph? A. Paragraph starter B. Drop cap C. Line starter D. Paragraph capital B Which command on the Picture Tools Format Ribbon is used to change the way text wraps around a selected object? A. Position B. Wrap Text C. Align Text D. Text Direction B In Microsoft Word, what is the name of the group of picture formatting characteristics that includes shadows, reflections, glow, soft edges, bevel, and 3-D rotation? A. Style B. Effects C. Cluster D. Group B Which command is used to insert a picture file from a storage device into a document? A. Screenshot B. Import C. Picture D. ClipArt C Which ribbon includes the command for inserting charts that illustrate or compare data? A. File B. Home C. Insert D. Draw C C Kim inserted a rectangular shape into her Word document. She wanted the shape to transition from one color to another. Which shape fill option should she use? A. Texture B. Solid Color C. Picture D. Gradient D Sara inserted an arrow to point out information in a newsletter, which object did she use? A. Charts B. Shapes C. SmartArt D. WordArt C Jordan wants to e-mail a view of the entire program window to the Technology Department of the error message that he received when logging onto his computer. What command would he use? A. Screenshot B. Screen clipping C. Picture D. Print Screen A Ann wants to add her name to the Microsoft dictionary. Which section of Backstage/Options will she use? A. Advanced B. Display C. Proofing D. Save C What is the name of the Microsoft Word feature that reviews spelling and grammatical errors as you type and compares them against the Microsoft Word dictionary? A. Spelling & Grammar B. Review & Edit C. Spell Correct D. Dictionary Check A Which features of Microsoft Word automatically corrects typing, spelling, capitalization, or grammar errors as they are typed? A. AutoCorrect B. Spell & Grammer Check C. AutoSpell D. AutoCheck A Which dialog box provides the user with the ability to replace text as it is typed? A. AutoFormat B. Find & Replace C. AutoCheck D. AutoCorrect D When comments are inserted into a Microsoft Word document, how can they be removed? A. Review Ribbon, Comments group, Delete command B. Insert Ribbon, Delete Comment command C. Double-click the comment to delete D. Review Ribbon, Comments group, Remove command A What is the name of the note that can be inserted into a Microsoft Word document by a reviewer to communicate suggestions, alerts, or tips to the author? A. Footnote B. Citation C. Comments D. Caption C Which tool converts words or paragraphs into a different language using the Microsoft Word bilingual dictionaries? A. Spelling & Grammar B. Research C. Translate D. Thesaurus C Which command is used to find the number of words, characters, paragraphs, or lines in a Microsoft Word document? A. Compare B. Review C. Word Count D. Research C Which feature in Microsoft Word highlights insertions, deletions, or formatting modifications in a document? A. Track Changes B. Reviewer C. Mark Entry D. Compare A What group in the Review Ribbon contains the command to accept or reject changes made to a document? A. Proofing B. Compare C. Tracking D. Changes D Which Track Changes command allows a user to see what a document looked like before any changes were made to it? A. Reject All Changes B. Original C. Remove Edits D. Show Markup B Hal and Alive have both made changes separately to the Biology lab report that they created together. They need to turn in one final version to their teacher. Which Word tool could they use to easily create a single final report that includes both of their changes? A. Compare B. Combine C. Restrict Editing D. Track Changes B Non contiguous cells Not next to each other Contiguous cells Next to each other ###### Column is not wide enough AutoFill Completes previously typed words when you begin to repeat the typing Bar Chart A graphical representation of data, a horizontal bar chart if for excel Cell Address The column and the row number of a cell ex: C13; F27 #div/0 You need numbers in your cells. You cannot divide by zero Format Making a change in the default settings #name? Error in your formula Line Chart A graphic representation of data, you use a line, and the points are called markers Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? A. Workbook B. Worksheet C. Notepad D. Folder B. Worksheet Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? A. Word B. Publisher C. Excel D. PowerPoint C. Excel What Command will arrange Microsoft Excel windows so that they appear side by side on the screen? A. Zoom to selection B. New Window C. Arrange All D. Freeze Panes C. Arrange All Which tab do you use to display the area that contains the print command? A. Home B. Page Layout C. View D. File D. File John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option? A. Freeze Panes B. Split C. Hide D. Unhide B. Split Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? A. Entry B. Workbook C. Row D. Column C. Row Which ribbon option opens a related dialog box? A. Ellipse B. Drop-down Arrow C. Launcher D. Slider C. Launcher Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? A.Page Layout B. Print C. Normal D. Web A. Page Layout Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the: A. Cell B. Column C. Range D. Row D. Row Joan has entered her name in the first name field in cell b2 of her table. what does her first name represent in the table? a. Entry b. workbook c. row d. column A. Entry Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? A. Cell Box B. Address Box C. Name Box D. Formula Box C. Name Box Which command do you use to close an open file and completely exit the Microsoft Excel program? A. Close B. Save As C. Exit D. Quit C. Exit What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key? A. Quick Access Toolbar B. Hot Keys C. Mini Toolbar D. Key Tips D. Key Tips What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility? A. Magnify Area B. Enlarge Selected Area C. Amplify Range D. Zoom to Selection D. Zoom to selection Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? A. Workbook views B. Show C. Zoom D. Window B. Show What occurs when the cursor is moved over a cell and a user clicks? A. The row is selected B. The cell is selected C. The column is selected D. The worksheet is selected B. The cell is selected Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? A. Exit B. Open C. Save D. Save As B. Open Which of the following notebook-like features organizes the sheets for use in Excel? A. Workbook B. Worksheet C. Notepad D. Folder A. Workbook