Excel Training 1 Exam 35 Questions with Verified Answers,100% CORRECT

Excel Training 1 Exam 35 Questions with Verified Answers Which are three ways to create a new workbook in Excel 2016? - CORRECT ANSWER Using an existing template, using an online template, create a blank workbook from scratch Users can save a workbook in Excel 2016 using which item? - CORRECT ANSWER Quick access toolbar Which data format in Excel 2016 treats text as text and numbers as numbers? - CORRECT ANSWER General Which are ways to add worksheets to a workbook in Excel 2016? Choose three answers. - CORRECT ANSWER Open the Home tab, click the insert drop-down arrow, and click insert sheet. Click the plus sign button near the existing worksheets. Right-click an existing sheet, click insert, and click the OK button. Which are two ways to copy a worksheet in Excel 2016? - CORRECT ANSWER Right-click a worksheet tab and click Move or Copy. While holding the Ctrl key on the keyboard, click and drag the worksheet to a new location. To Find and Select feature in Excel 2016 is located in which tab on the ribbon? - CORRECT ANSWER Home Which feature on the Excel 2016 ribbon is used to navigate to the last cell of a worksheet? - CORRECT ANSWER Go To Special The format drop-down menu is found under which group on the ribbon? - CORRECT ANSWER Cells Which symbol indicates where a worksheet will be placed during the click and drag method of moving a worksheet in Excel 2016? - CORRECT ANSWER Black arrow Rows and columns can be inserted and deleted using the ribbon under the ____________ tab or by right-clicking the row or column. - CORRECT ANSWER Home Users can change the theme of an Excel 2016 workbook using which tab? - CORRECT ANSWER Page Layout Which are two ways to add headers and footers in an Excel 2016 document? - CORRECT ANSWER Click the view tab and page layout. Click the page layout tab, click the page set up dialog box launcher, and click the header/footer tab. Which signifies that there is a hidden worksheet in an Excel document? - CORRECT ANSWER The Unhide sheet option under hide & unhide in the format drop-down menu will not be grayed out. Which item is used to add commands to the Quick Access Toolbar - CORRECT ANSWER Drop-down arrow on the Quick access toolbar. In addition to the ribbon, users can change workbook views by using the formula bar. - CORRECT ANSWER False The Freeze panes feature is located under which tab in Excel 2016? - CORRECT ANSWER View In Excel 2016, document properties can be modified from which location? - CORRECT ANSWER Advanced properties In order to set a print area, users need to go to the ______________ tab in Excel 2016. - CORRECT ANSWER Page layout Which is the default setting for printing documents in Excel 2016? - CORRECT ANSWER Excel will only print the active worksheet Which are items Excel 2016 will look into when checking for accessibility issues? Choose two answers. - CORRECT ANSWER Font size Colors Initially, how many worksheets does a user have access to in a blank Excel 2016 workbook? - CORRECT ANSWER One Which two file formats are used to import delimited data? - CORRECT ANSWER .txt .csv Which tab on the ribbon is used to add sheets to an Excel 2016 workbook? - CORRECT ANSWER Home Which drop-down arrow is used to move or copy a worksheet? - CORRECT ANSWER Format If a user wishes to move a worksheet to a different workbook in Excel 2016, the user will need to make sure the file is ____________. - CORRECT ANSWER Open Which feature is used to find specific cell references in an Excel 2016 workbook? - CORRECT ANSWER Go To Users can create internal hyperlinks using _________________ and named ranges in Excel 2016. - CORRECT ANSWER Bookmarks Which are three ways to rename a worksheet in Excel 2016? - CORRECT ANSWER Select a worksheet tab, click the Format drop-down menu under the Home Tab, click rename sheet, and type in a new name. Right-click a worksheet tab, click rename, and type in a new name. Double-click a worksheet tab and type in a new name. Which item is used to help users modify the page setup of an Excel document? - CORRECT ANSWER Page Break Preview Users can hide and unhide rows, columns, and sheets in which area of the Format drop-down menu? - CORRECT ANSWER Visibility In order to unhide a row, the user must begin by selecting the first rows above and below the hidden row. - CORRECT ANSWER True Which are the three basic views in Excel 2016? - CORRECT ANSWER Normal Page Layout Page Break Preview Which are window views in Excel 2016? Choose three answers. - CORRECT ANSWER Cascade Horizontal Vertical In order to freeze columns and rows at the same time, the user needs to freeze the ____________________. - CORRECT ANSWER Intersection Which options are found in the Zoom section of the Excel 2016 ribbon? Choose two answers. - CORRECT ANSWER 100% Zoom to selection