Spreadsheet C268 2023 Exam Questions With Complete Solution

Spreadsheet C268 2023 Exam Questions With Complete Solution Workbook - CORRECT ANSWER an Excel file that stores all the information, previous calculations, and analyses that you may have already completed Worksheet - CORRECT ANSWER contains the actual data and calculations Cells - CORRECT ANSWER store individual pieces of data or calculations File Menu - CORRECT ANSWER menu used to manipulate workbooks Home - CORRECT ANSWER area includes items used in formatting the appearance of data in cells Insert Area - CORRECT ANSWER include features that allow you to place specialized elements into your workbooks, such as charts, pictures, and shapes Page Layout Menu - CORRECT ANSWER menu items are used to format the appearance of worksheets Formulas Menu - CORRECT ANSWER menu items aid in performing calculations using Excel's built-in functions Data Area - CORRECT ANSWER used to aid in importing and working with large amounts of data Review Menu - CORRECT ANSWER menu items help in sharing an Excel workbook with colleagues View Menu - CORRECT ANSWER menu items are used to change how a worksheet is displayed on the screen Info portion of the File - CORRECT ANSWER menu displays information about the current workbook and the users who have contributed to the file New portion of the File - CORRECT ANSWER menu contains features related to creating a new workbook Templates - CORRECT ANSWER can be particularly useful because they often contain data, formatting and calculations that relate to common spreadsheet tasks Open - CORRECT ANSWER used to select a different workbook that you want to be opened in Excel or select a workbook that has been saves on Skydive or locally on your computer Save and Save As Functions - CORRECT ANSWER allow you to (1) save the current workbook, (2) save a copy of the current workbook with a new name or location, or (3) save a copy of the current workbook as a different file type. Print Area - CORRECT ANSWER menu area contains items related to printing a worksheet Print Area - CORRECT ANSWER area displays a preview of how a particular worksheet will look once printed. Share Area - CORRECT ANSWER area used make the workbook available for colleagues Export Area - CORRECT ANSWER area allows you to convert your work to another file format (such as PDF) for those colleagues who prefer to review the work in a different application