Excel Basic

Given the IFERROR statement, what is the value of F7 after execution in this instance?

$48,000

When naming a cell, what can the name start with?

-A backslash -A letter -An underscore

What can you create a hyperlink to?

-A place in a document -An e-mail address -An existing file or web page

What are characteristics of Wrap Text tool?

-Align tools can still be used on wrapped text -The row will automatically adjust to fit wrapped text -Text will wrap in the selected area

What options are available when searching for a template?

-Choosing to create and open the template to use it -Scrolling through the templates -Previewing the template

What types of screenshots can you take in Excel 2016?

-Clipping of one of the open windows -Any open windows

How can you modify the formatting of a single word in a cell?

-Double-click the cell to edit it, highlight the word, and make the changes -Select the cell, highlight the word in the formula bar, and make the changes

How can you resize columns?

-Double-click the right of a column for it to display all the data -Select multiple columns, click and drag from the right column to make them all the same size -Click between two cells and drag to resize

What are parts of the ribbon?

-Groups -Tabs

What properties information updates automatically?

-Last Modified By -Last Modified -Size

How can you unhide a column that has been hidden?

-Mouse over the hidden column until you see two parallel bars and click and drag to unhide -Double-click when you see two parallel bars over the hidden column -Highlight the before and after column, right-click, and choose the option to unhide the column

What are characteristics of the Format as Table feature?

-Permits creating new pivot table styles -Enables you to create a new table style -Provides a menu of colors and a list of preset table styles

What are different ways of using the copy command to copy data?

-Press Ctrl+C on the keyboard -Right-click the cell with the mouse and select the option to copy from the menu -Use the copy feature available on the Home tab

What are some of the options that can be customized with sparklines?

-Range of data used -Markers -Line Style -Color

Match the meaning with the formula operator.

-Range reference : , -Multiplication and division * or / -Concatenation (text) & -Exponent ^

How can you move around to navigate the spreadsheet?

-Scroll with the mouse wheel -Press the Page Up or Page Down nuttons -Use the arrow keys

What are characteristic of inserting rows?

-The new row will be inserted above the selected rows -An inserted row takes the formatting of the row above it -You can highlight multiple rows to insert the same number of rows above

Match each description to the chart type it describes?

-Treemap - Represents date values as the area of rectangles -Box and Whisker - Display variation within a set of data -Histogram - Show the distribution of the data grouped into bins -Sunburst - Represents hierarchical data as concentric rings in a circle Waterfall - Show cumulative effect of a series of positive and negative values

Sequence the steps to edit the text in a cell with a hyperlink using the keyboard.

1. Select an open cell 2. Navigate to the cell with the hyperlink using the arrow keys 3. Press F2 on the keyboard 4. Edit the text 5. Press Enter on the keyboard

How would you indicate 2 to the 10th power in Excel?

2^10

Identify the correct result of the formula. =(10*1+5)/3

5

Which formula yields 120 as the result?

=(13+5-3)*1*8

Which formula adds the First and Last Name into the Full Name column in cell C6?

=A6&" "&B6

What is the formula used in cell G5 to calculate the total of the Salary and Bonus for Lucas Brenner?

=D5+E5 =E5+D5

Which formula may be used to display a 20% bonus if the Salary is above the Average and 10% if not?

=IF(D5>$D$12,20%,10%) =IF(D5>D12,20%,10%)

What is the formula to determine if the Salary is a greater than $55,000 or in the East region?

=OR(D5>55000,C5="East")

What is the formula to determine the sales reps total salaries in the Northwest region?

=SUM(D5:D6,D9:D10) =SUM(D5,D6,D9,D10)

Given the named cells, what is the formula to find total of all the salaries?

=SUM(Salary)

How do you include text in a custom format?

Add the text to the type using quotation marks before and after

How does choosing a monochromatic color change the chart?

All the bars are different shades of the same color

What are the values inside the parentheses of a function known as?

Arguments

You want to access additional pasting options for data copied to the clipboard.

Arrow below the Paste button

What option lets you create lines around a cell or a group of cells?

Borders

You want to check a web page URL before creating a hyperlink.

Browse the Web

What feature in Excel 2016 enables you to limit what users can view in an online shared documents?

Browser View Options feature

Click the option that will allow you to apply custom formatting to a group of cells.

Cell Styles

What feature lets you apply predefined formatting to cells with one click?

Cell Styles

What are parts of a spreadsheet?

Cells Scroll bars Columns Rows

You want to export to a text file in Excel 2016.

Change the File Type

You want to change the data that is displayed in your existing chart.

Chart Filters

You want to remove the data labels from an existing chart.

Chart elements

How can you share an online workbook with other people using the share function?

Choose the option to obtain a sharing link Add the e-mail address of those people

What is Auto Fill default when copying cells?

Copy content and formatting

You want to adjust the contrast in a picture.

Corrections

How would you create a named cell range?

Create from Selection

What Picture Tools features enables you to select only part of an image?

Crop

What is the keyboard shortcut to use the Flash Fill function?

Ctrl+E

What Cells Styles Number Format lets you display monetary values with no decimals?

Currency [0]

What does the icon beside Salary mean in the drop down?

Defined name

You want to provide a table in Excel 2016 with a name.

Design

Under what menu group does Flash Fill reside?

Editing

Which function key on the keyboard is used to create an absolute reference for a formula in Excel?

F4

You want to add document properties to an Excel 2016 document.

File

What features allows you to add color to the background of a cell?

Fill color

What is the little square in the corner of a selected cell called?

Fill handle

How can you access extra formatting options?

Font Settings

Besides the Home tab, on what other tab of the ribbon can the AutoSum function be found?

Formulas

How many sections of formatting can you have in a custom format?

Four

What rule would be used if you wanted to check a number was larger than 10?

Greater Than

When multiple sparklines are created at the same time they are known to be?

Grouped

Based on the given data set, what Quick Analysis option was used?

Icon Sets

You want to create a table in Microsoft Excel 2016.

Insert

Which type of functions is IFERROR?

Logical

What type of functions are AND, OR, and NOT known as in Microsoft Excel?

Logical functions

You want to customize existing rules when working with custom conditional formatting.

Manage Rules

How do you combine cells together?

Merge & Center

How can you vertically center text?

Middle Align

What are sparklines compared to?

Mini charts

You want to move a chart to its own sheet in Excel 2016.

Move Chart

What text is shown in the cell after this edit is completed?

Naomi Miller

You want to open a template document in Excel 2016.

New

How do you change the negative numbers so they display in red?

Number Format launcher

You want to specify what pages to include when exporting a document to PDF.

Options

How do you change the angle of the text?

Orientation

What feature in the View tab enables you to view headers and footers to edit them?

Page Layout

You want to print only a portion of a spreadsheet.

Print Selection

You want Excel to suggest what type of chart works best for your data.

Recommended Charts

You want to access and use the Insight feature of Excel 2016.

Review

How do you unhide a hidden workbook?

Right-click any workbook tab and select the option to unhide

How do you make changes to an existing custom style after right-clicking it?

Select Modify from the menu

How can you ensure that a column that prints on a second page fits on one page?

Set the scaling to fit a sheet on one page Change the orientation to landscape

What's the content in B1 and A1 when using Auto Fill moving left?

TDK 1, TDK-1

What key enables you to navigate through a table?

Tab

You want to insert a screenshot into a worksheet in Excel 2016

Take a Screenshot

What happens if you highlight one cell and press the Delete button on the keyboard?

The content of that one cell will be deleted

What sizing handles do you use to resize an inserted picture to maintain the proportions?

The corners

What does the Format Painter function copy from one cell to another?

The formatting

What does an icon set tell you about the data set?

The top, middle, and bottom thirds of the data

How many sections are in a header or a footer?

Three

Where do you paste a selection of cells when using the format painter?

Top left corner

What's the content in C1 and D1 when using Auto Fill?

Tuesday, Saturday

What is the thickness of a sparkline known as?

Weight

What is the default file type for an Excel 2016 document?

XLSX