Excel Final Exam with 100% Correct Answers 2023

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? - Correct answer-B. Show Which of the following notebook- like features organizes the sheets for use in Excel? - Correct answer-A. Workbook Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? - Correct answer-A. Page Layout Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? - Correct answer-B. Worksheet John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option? - Correct answer-B. Split Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet? - Correct answer-B. Ctrl + End What occurs when the cursor is moved over a cell and a user clicks? - Correct answerB. The cell is selected Which tab do you use to display the area that contains the print command? - Correct answer-D. File Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? - Correct answer-C. Name box Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands? - Correct answer-A. Quick Access Toolbar(QAT) Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? - Correct answer-B. Open Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? - Correct answer-C. Row Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? - Correct answer-C. Excel Which view is the default view used in Microsoft Excel? - Correct answer-C. Normal Which ribbon option opens a related dialog box? - Correct answer-C. Launcher 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? - Correct answer-D. Zoom to Selection 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? - Correct answer-D. Key Tips Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the: - Correct answer-D. Row What command will arrange Microsoft Excel windows so that they appear side by side on the screen? - Correct answer-C. Arrange All 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? - Correct answer-A. Entry Which command do you use to close an open file and completely exit the Microsoft Excel program? - Correct answer-C. Exit In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact? A. Paste B. Move C. Cut D. Copy - Correct answer-D. Copy Sharon's spreadsheet contains information about the number of music downloads in F1:F25.F1:F25 represents a: A. Cell B. Column C. Range D. Row - Correct answer-C. Range When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point? A. Delete key B. Backspace Key C. Left arrow key D. Enter key - Correct answer-B. Backspace key Joan is creating a table that will include demographic information about her employees. What is each header in her table considered? A. Label B. Value C. Formula D. Function - Correct answer-A. Label What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet? A. Mini Toolbar B. Quick Access Toolbar C. Shortcut Menu D. Shortcut Toolbar - Correct answer-C. Shortcut Menu John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose? A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit Sheet on One Page - Correct answer-B. Print Active Sheet Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry? A. AutoComplete B. AutoFill C. AutoCorrect D. AutoSpell - Correct answer-A. AutoComplete David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task? A. AutoFill B. Filter C. Find and Replace D. Sort - Correct answer-A. AutoFill What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells? A. Fill handle B. Filler C. Copy handle D. Copy box - Correct answer-A. Fill handle Which command on the Fill options dialog box is the default option if you enter a month or day? A. Copy Cells B. Fill Formatting Only C. Fill without Formatting D. Fill Series - Correct answer-D. Fill Series Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group? A. Segment B. Set C. Range D. Cluster - Correct answer-C. Range Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header? A. Values B. formulas C. labels D. functions - Correct answer-C. labels What is the process of using the mouse to move or copy cells called? A. Click and paste B. Drag and move C. Dragging D. Drag and Drop - Correct answerD. Drag and Drop To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use? A. File details B. Document Properties C. File facts D. Document options - Correct answer-B. Document properties Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use? A. Exit B. Open C. Save D. Save As - Correct answer-C. Save Alicia needs to delete the data in cell B5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter - Correct answer-A. Clear Alicia needs to move the date in cell B5 to cell E5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter - Correct answer-C. Cut Which command on the "Home Ribbon" allows data to be moved from one worksheet location to another? A. Cut B. Move C. Copy D. Duplicate - Correct answer-A. Cut In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit? A. Smart Fit B. AutoFit C. Best Fit D. Trust Fit - Correct answer-B. AutoFit Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header? A. values B. formulas C. labels D. functions - Correct answer-C. labels What area contains the command used to customize the print options in Microsoft Excel? A. Home Ribbon B. Page Layout Ribbon C. File Tab D. Quick Access Toolbar - Correct answer-C. File Tab Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? A. Close B. Save C. Save As D. Exit - Correct answer-C. Save As Steve would like to print only the worksheet he is currently working on. What print option should he choose? A. Print Area B. Active Sheets C. Entire Workbook D. Quick Print - Correct answer-B. Active Sheets Jim would like to print only the cell range A1:F20. What page setup option should he change? A. Orientation B. Page Break C. Print Area D. Print Titles - Correct answer-C. Print Area Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets? A. Form B. Boilerplate C. Smart Sheet D. Template - Correct answer-D. Template John's workbooks includes 3 worksheets. Which option should he choose to print them? A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit to one page - Correct answer-C. Print Entire Workbook Relative reference - Correct answer-When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location? external reference. - Correct answer-Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n): formulas - Correct answer-Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry? =B4-C4 - Correct answer-Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use? Cell reference and cell location are outlined in matching colors - Correct answer-How is a cell reference in a formula and its corresponding location in a worksheet identified? =$B$1+25 - Correct answer-Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create? =B4*C4 - Correct answer-Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use? named range. - Correct answer-Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n): Worksheet Reference - Correct answer-What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address? Copy using the Fill Handle - Correct answer-What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously? external reference. - Correct answer-Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n): Absolute - Correct answer-What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area? AVERAGE - Correct answer-Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test? TODAY - Correct answer-Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1? Formula bar - Correct answer-Where can you find the Insert Function button in Microsoft Excel? functions - Correct answer-Angie is calculating her average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry?