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