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
... [Show More] 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 [Show Less]