Excel Concept Review 1
Which data format in Excel 2016 treats text as text and numbers as numbers?
General
Which feature is used to find specific cell references in an Excel 2016 workbook?
Go To
Which feature on the Excel 2016 ribbon is used to navigate to the last cell of a worksheet?
Go To Special
Rows and columns can be inserted and deleted using the ribbon under_________tab or by right-clicking the row or column.
Home
The Find and Select feature in Excel 2016 is located in which tab on the ribbon?
Home
Which tab on the ribbon is used to add sheets to an Excel 2016 workbook?
Home
Users can save a workbook in Excel 2016 using which item?
Quick access toolbar
Which are the three basic views in Excel 2016?
Normal, Page Layout, Page Break Preview
Initially, how many worksheets does a user have access to in a blank Excel 2016 workbook?
One
Which signifies that there is a hidden worksheet in an Excel document?
The Unhide Sheets option under Hide & Unhide in the Format drop-down menu will not be grayed out
Which item is used to help users modify the page setup of an Excel document?
Page Break Preview
In order to set a print area, users need to go to the_______tab in Excel 2016.
Page Layout
Users can change the theme of an Excel 2016 workbook using which tab?
Page Layout
In order to unhide a row, the user must begin by selecting the first rows above and below the hidden row.
True
What are the three ways to create a new workbook in Excel 2016?
Using an existing template, using an online template, and/or creating a black workbook from scratch
The Freeze Panes feature is located under which tab in Excel 2016?
View
Users can hide and unhide rows, columns, and sheets in which area of the Format drop-down menu?
Visibility
In Excel 2016, document properties can be modified from which location?
Advanced Properties
Which symbol indicates where a worksheet will be placed during the click and drag method of moving a worksheet in Excel 2016?
Black arrow
Which are window views in Excel 2016? Choose three answers.
Cascade, Horizontal, Vertical
The Format drop-down menu is found under which group on the ribbon?
Cells
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________.
open
Which two file formats are used to import delimited data?
1.) .txt 2.) .csv
Which are two ways to add headers and footers in an Excel 2016 document?
1.) Click the View tab and Page Layout. 2.) Click the Page Layout tab, click the Page Setup dialog box launcher, and click the Header/Footer tab.
Which are items Excel 2016 will look into when checking for accessibility issues? Choose two answers.
1.) Font size 2.) Colors
Which are ways to add worksheets to a workbook in Excel 2016? Choose three answers.
1.) Open the Home tab, click the Insert drop-down arrow, and click Insert Sheet. 2.) Click the plus sign button near the existing worksheets. 3.) Right-click an existing sheet, click Insert, and click the OK button.
Which are two ways to copy a worksheet in Excel 2016?
1.) Right-click a worksheet tab and click Move or Copy. 2.) While holding the Ctrl key on the keyboard, click and drag the worksheet to a new location
Which are three ways to rename a worksheet in Excel 2016?
1.) Select a worksheet tab, click the Format drop-down menu under the Home tab, click Rename Sheet, and type in a new name. 2.) Right-click a worksheet tab, click Rename, and type in a new name. 3.) Double-click a worksheet tab and type in a new name
Which options are found in the Zoom section of the Excel 2016 ribbon? Choose two answers.
100%, Zoom to Selection
Which item is used to add commands to the Quick Access toolbar?
Drop-down arrow on the Quick Access toolbar
Which is the default setting for printing documents in Excel 2016?
Excel will only print the active worksheet
In addition to the ribbon, users can change workbook views by using the formula bar.
False
Which drop-down arrow is used to move or copy a worksheet?
Format
Users can create internal hyperlinks using_________and named ranges in Excel 2016.
bookmarks
In order to freeze columns and rows at the same time, the user needs to freeze the_______.
intersection