EXCEL TEST

Which item is used to tell the IF function that the user wants a field to remain blank?

""

Which item means a formula cannot preform its function in Excel

#REF!

Which symbol is used to keep a formula variable constant?

$

Which is an example of an absolute reference in Excel?

$K$1

Which two file formats are used to import delimited data?

1. .txt 2. .csv

Which options are found in the Zoom section of the Excel 2016 ribbon? Choose 2 answers

1. 100% 2. Zoom to Selection

Which are types of pie charts in Excel 2016? Choose 3 answers

1. 2-d Pie 2. 3-d pie 3. Doughnut

Which are types of date filters in Excel 2016? Chose 2 answers

1. After 2. Before

Which are types of COUNT functions in Excel 2016? Choose 3 answers

1. COUNTA 2. COUNTIF 3. COUNTBLANK

When applying conditional formatting, users can preform which actions? Choose 3 answers

1. Change rules 2. Change where the rules apply 3. Change the format of the rules

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 ways to add worksheets to a workbook in Excel 2016? Choose 3 answers

1. Click the plus sign button near the existing worksheets 2. Right-Click an existing sheet, click inter, and click the OK button 3. Open the Home tab, click the Insert drop-down arrow, and click Insert Sheet

Which are items Excel 2016 will look into when checking for accessibility issues? Choose 2 answers

1. Colors 2. Font Size

Which are types of conditional formatting in Excel 2016? Chose 2 answers

1. Data Bars 2. Color Scales

Which two tabs appear in Excel 2016 when a char is selected

1. Design 2. Format

Which are three ways to rename a worksheet in Excel 2016?

1. Double click a worksheet and type in a new name 2. Right click a worksheet tab, click remake, and type in a new name 3. Select a worksheet tab, click the format drop-down menu under the Home tab, click Rename Sheet, and type in a new name

Which items in the File tab are used to save Excel workbooks in various file formats? Choose 2 answers

1. Export 2. Save As

Which are examples of items that can make up the format of a cell? Choose 2 answers.

1. Font 2. Color

which are configuration options for table styles in Excel 2016? Choose 3 answers

1. Header Row 2. First Column 3. Banded Rows

Which are the three types of sparklines in Excel 2016?

1. Line 2. Column 3. Win/Loss

Which are two date formats in Excel 2016?

1. Long Date 2. Short Date

Which are merge options in Excel 2016? Choose three answers

1. Merge Cells 2. Merge Across 3. Merge & Center

The AutoFill feature in Excel 2016 works with which three items?

1. Months 2. Weekdays 3. Numeric Patterns

What are the three basic views in Excel 2016?

1. Normal 2. Page Layout 3. Page Break Preview

Which are paste special options in Excel 2016? Choose 2 answers.

1. Paste Link 2. Values & Source Formatting

Users can utilize which times to cut, copy, and paste in Excel 2016? Choose 2 answers

1. Ribbon 2. Keyboard Shortcuts

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 items can be configured in Excel 2016? Choose 3 answers

1. Styles 2. Effects 3. Shape fill

Users can customize sparklines in Excel 2016 using which items? Choose 2 answers.

1. Styles 2. Markers

The Quick Analysis tool can be used to preform which actions on cell ranges in Excel 2016? Choose 3 answers

1. Totals 2. tables 3. Formatting

Which are three ways to create a new workbook in Excel 2016?

1. Using an existing template 2. Using an online Template 3. Create a blank workbook from scratch

Which are window views in Excel 2016? Choose 3 answers

1. Vertical 2. Cascade 3. Horizontal

Which are ways to replace text in Excel 2016 worksheet? Choose 3 answers

1. double click the cell 2. use the formula bar 3. simply start typing on the selected cell

Which character is always at the beginning of a formula in Excel 2016?

=

Options to show or hide a chart's tittle can be found under which button?

Add Chart Element

In Excel 2016, document properties can be modified from which location

Advanced Properties

Cells can be merged from which group on the Home tab of the ribbon?

Alignment

If a cell range is already highlighted and the user is holding down the Sift key, they can quickly change the highlighted area by using the _________

Arrow keys

The ___________ feature in Excel 2016 will commonly not work when attempting to group cell ranges

Auto Outline

The MAX function is located in the ___________ drop-down menu

AutoSum

Which is used to insert the Sum function into an Excel document?

AutoSum

In addition to the sum total of a cell range, users can create a/an __________ subtotal of a cell range in Excel 2016

Average

Which symbol indicates where a worksheet will be placed during the click and drag method of moving a worksheet in Excel 2016?

Back arrow

Which type of chart in Excel 2016 is horizontal

Bar

Which items do not affect the AVERAGE function

Blank Cells

Which best defines the purpose of the PROPER function?

Capitalizes the first letter of every word for each cell of a cell range

The Format Drop-Down Menu is found under which group on the ribbon

Cells

Which common item causes compatibility issues with older versions of Excel?

Colors

Which of the following options converts a table into a normal range of cells>

Convert to Range

When adding partial series of data to a chart, which key on the keyboard should be held down as the additional range is selected?

Ctrl

When applying cell formats in Excel 2016, users can hold down the __________ key to select individual cells they wish to apply formats to

Ctrl

The Flash Fill feature in Excel 2016 is located on which tab?

Data

Users can clear any filters on a table in Excel 2016 using which tab on the ribbon

Data

Chart elements can be added from which tab in Excel 2016?

Design

Users can add a total row to a table using which tab in Excel 2016?

Design

Users can configure sparkline styles and colors from which tab in Excel 2016?

Design

Users can use the Convert to Range button in the ________ tab to change a table in Excel 2016 to a normal cell range

Design

Which actions will allow a user to continuously use the Format Painter

Double-clicking the Format Painter button

Which item is used to add comments to the Quick Access toolbar

Drop-down arrow on the Quick Access toolbar

Which is a true statement concerning duplicate record removal in Excel 2016?

Excel will delete the bottommost duplicate records first

Which is the default setting for printing documents in Excel 2016?

Excel will only print the active worksheets

Data in Excel 2016 needs to be in a table in order for it to be sorted properly

False

In addition to the ribbon, users can change workbook views by using the formula bar

False

Users cannot create their own personal styles for cell ranges in Excel 2016?

False

Which feature allows you to quickly fill cells in a range with numbers or dates?

Fill Series

Which feature allows you switch every instance of a specific word with a different word?

Find and Replace

By default, the LEFT function will only move the ______ from the left to the new location

First letter

Alternate text can be added to an Excel item from the ________________ dialogue box

Format

Which drop-down arrow is used to move or copy a worksheet?

Format

The _________ will appear if a shape is selected in Excel 2016, allowing users to add text boxes

Format Tab

Which symbol tells a user that a filter is currently in use on a table, and what that filter is

Funnel with an arrow next to it

Which data format in Excel 2016 treats text as test and numbers as numbers

General

Which feature is used to find specific cell references in Excel 2016 workbook?

Go To

While Feature on the Excel 2016 ribbon is used to navigate to the last cell of a worksheet

Go To Special

Which is a best practice when dealing with formulas and functions in Excel?

Have an empty row and an empty column between data and totals

Cells and cell ranges can be inserted and deleted from the __________ tab of the ribbon

Home

Conditional Formatting is preformed from which tab in Excel 2016?

Home

Rows and columns can be inserted and deleted using the ribbon under the _________ 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

Which is a true statement regarding adding data to a table in Excel 2016?

If a user types test next to a table, it will. by default, be added to the table

Callouts and other shapes can be inserted from which area of Excel 2016?

Illustrations drop-down menu

Logos and similar objects can be inserted to an Excel document using which items?

Illustrations drop-down menu

Where do you have the option to customize a table in your document?

In the table Style Options group

Tables are created in Excel 2016 from which tab

Insert

In order to edit an existing formula in Excel, the user can click which item?

Insert Function button

In order to freeze columns and rows at the same time, the user needs to freeze the _________

Intersection

Which is a true statement about changing sort order in Excel 2016?

It is safe to change the sort order of a single column in a table

Which is a chart element that can be modified in Excel 2016?

Legend

The SUMIF function can be found under which top-down menu in Excel

Math & Trig

When is the best time to change chart types in Excel 2016?

Near the beginning before the chart is customized

A series in a chart with a secondary axis can be changed to a ________ to avoid overlapping data

New type of chart

The COUNT function can only count which item in Excel

Numbers

Initially, how many worksheets does a user have to access to in a blank Excel 2016 workbook?

One

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 2016b workbook using which tab

Page Layout

Which tab in Excel has the option to change the margins for the document?

Page layout

Which option allows you to paste only a specific aspect of copied data, such as formatting or value?

Paste Special

Data labels are more often used for which type of charts?

Pie

___________- charts are most effective with a single series of data

Pie

Which is a type of gridline users can add or modify for charts in Excel 2016?

Primary Minor Horizontal

Which is the purpose of a total row for a table in Excel 2016?

Provides a simple way for users to generate totals without having to write formulas

Users can save a workbook in Excel 2016 using which item?

Quick Access Toolbar

Which drop-down menu in Excel 2016 is used to add chart layouts?

Quick Layout

In a conditional function like SUMIF, which item refers to where the condition is located

Range

Which of the following features can find and delete repeated information in a cell range?

Remove Duplicates

Which symbol represents the Cut button on the ribbon in Excel 2016?

Scissors

Which button under the Design tab is used to configure the data source in an existing chart?

Select Data

Which is the first step to creating a chart in Excel 2016?

Select the data including the labels

Which key allows users to quickly highlight cell rangers in Excel 2016 in order to cut, copy, or paste data

Shift

Which options allows you to see the actual formula instead of its calculated result?

Show Formulas

Which is used to display formulas on a worksheet in Excel?

Show Formulas Button

Under _______ in the Format dialog box, users can insert alternate text to images and other Excel objects

Siez & Properties

Which MID function elements specifies which character in the cell ranges will be the beginning of the extraction?

Start_num

Which button in Excel is used to change the orientation of the chart's source data?

Switch Row/Column

Which best defines the CONCAT function

Taking two pieces of text and combining them

The RIGHT function is located under which drop-down menu in the Formulas tab?

Text

Which is a sign that a user is working inside of a table in Excel 2016?

The Design tab will be visible

Where can you set the option to have the data in the first row appear on every printed page?

The Sheet tab in the Page Setup dialog box

Where on the ribbon is the COUNTIF function located in Excel 2016?

The Statistical group under the More Functions drop-down menu

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

The IF function can be found in which area of Excel

The logical drop-down menu under the Formulas tab

Which is a true statement when copying or cutting and pasting data to a new location in Excel

The user does not have to select the entire cell range where the data will be pasted

Which is a true statement concerning basic formulas in Excel 2016?

The user does not need to alter the formula when entering new data into applicable cells

Every chart element in Excel 2016 has a menu which provides additional modification options

True

In addition to the AutoSum feature, users can simply type the SUM function in Excel

True

In order to ungroup a cell range, the range will need to be selected

True

In order to unhide a row, the user must begin by selecting the first rows above and below the hidden row

True

The Compatibility Checker in Excel 2016 is useful for locating formats and other items in a workbook that are not used in older versions of Excel.

True

The user does not need to highlight data within an Excel worksheet in oder to remove continual formatting

True

Users cannot view a chart with its own worksheet and the original data source simultaneously without a data table chart element

True

When sorting information inside of a table on multiple columns, it is important to sort the most detailed column first

True

Which of the following commands converts a text string to all uppercase letters?

UPPER

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

Which is a common best practice when wrapping text within cells in Excel

Wrap the text for the entire row or column

Users can create internal hyperlinks using _________ and named ranges in Excel 2016

bookmarks

Users can alter where the _______ is for any number in Excel 2016

decimals

If a user wants to change the Lock aspect ratio feature for an image in Excel 2016, they can open the ___________

dialog box launcher

Users have the option to turn off the feature that automatically __________ tables in Excel 2016

expands

If a user wishes to move a worksheet to a different workbook in Excel 2016, user will need to make sure the file is _______

open

Using the __________ when resizing a chart can lead to proportion issues

side anchors