Within the "number" tab, how many categories are available for displaying numbers?

Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell?

No

If you proceed to remove duplicate values using the "Remove Duplicates" feature in "Table Tools", will Excel remove one of the two table rows?

No, these are not considered duplicates by Excel. To remove the duplicate data you must ensure that the date in the second row is formatted the same way as the date in the first row.

What keys do you need to press to select the newly created table so that it can be copied or moved to a different worksheet?

Press Ctrl+A

What happens if you try to store a number greater than 15 digits in Excel?

Replace the digits exceeding 15 with the number zero

What command under the Table Tool /Design Tab can you use to add two more rows to the table?

Resize table

Adding comments to a cell is available through which tab of the Excel ribbon?

Review

What sequence of steps will allow you to format the data into a table?

Select the data, then click "Table" under the "Insert" tab of the Excel Ribbon

To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut:

Shift + F2

What keyboard shortcut can you press to move to the PREVIOUS field in an Excel data Form ?

Shift+Tab

Which of the following is TRUE about sorting a table?

Sorting a table re-arranges the rows based on the contents of a particular column.

When comparing two sheets using the "View Side by Side" feature, there is an option which lets you scroll the two sheets in sync. What is the option called?

Synchronous Scrolling

Microsoft Office Excel can automatically generate a data form (which allows for convenient data entry, among other things) for your range or ________.

Table

The formula =COUNTIF(range, "*budget*") will count the number of cells in the specified range containing the word "budget" in certain positions within the text. Which of the following best describes the cells counted?

The word "budget" can appear anywhere within the cell.

Which option provided in the View ribbon tab is best to compare two open Excel workbooks simultaneously in Excel 2016?

View Side by Side

What of the following is FALSE about filtering a table?

When you copy data from a filtered table, both visible data and rows hidden by filtering are copied.

When a row of data is very ____ and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows

Wide

Is it possible to convert a cell with text data into a .png format?

Yes

Would you be able to apply the "watch window" option in multiple sheets at the same time?

Yes

In an Excel Form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character?

Yes, the "?" symbol is used to find/match a single character

Different table formatting styles can be previewed by mousing over different options within "Table Styles" (i.e., you can see what the appearance will be like without actually applying a new style). Is this statement accurate?

Yes, the statement is accurate

What is a Sparkline?

a mini-chart that is displayed in a single cell

A single element in a worksheet that can hold a value, some text, or a formula is called a(n) ____?

cell

Which option is not available after right clicking in an excel worksheet tab?

changing the font color in the worksheet

A data form provides a convenient means to enter, display and search for data within a table. It also permits you to do the following:

delete a record/row

Which Excel tab is not visible by default?

developer

Which operator in Excel combines multiple range references into a single reference?

"," (comma)

How many sort options/commands do we have in Excel under the 'Data' tab?

3

What column name comes directly after column Z?

AA

Which of the following chart-related items identifies general trends in your data?

Trendline

Which of the following is an advantage of using Excel tables?

Using table and column names in formulas provides greater flexibility as extending a table does not require re-writing of formulas

Which is valid to use for an excel workbook name?

_

What does the function =NOW() return?

current date and time

The COUNTIF() function used for single-criterion counting formula takes two arguments (or parameters) _______ and ______.

range and criteria

What would you type in the Find and Replace dialog box (Home (tab) -> Editing (command group) -> Find & Select) to find all four-digit entries that begin with 5 and end with 2?

5??2

Which formula can be used to find: How many songs were sung by singers whose last names contain exactly six letters?

=COUNTIF(B2:B23,"??????")

Which formula can be used to find: How many songs were sung by singers whose names begin with S?

=COUNTIF(B2:B23,"S*")

Which two wildcard characters are supported by the "Find and Replace" dialog box in an Excel worksheet?

?,*

What is true for the new name being defined?

A name is being applied to a range. This name can be used in formulas anywhere in the current workbook?

Based on the class lecture, which of the following is true about table renaming?

A table can be renamed to better reflect its contents (e.g., PARTS or PRODUCTS)

If you want to remove chart labels, where do you find the options to do so within the design tab (chart tools)?

Add chart element > Data labels

The SUM() function does which of the following in Excel?

Allows you to total up numbers in a specified range of cells

Which of the following is an INVALID horizontal text alignment option provided in Excel?

Bottom

Which action should be taken while creating a table to display Table Headers?

Check 'My table has headers'

Which of the following options scrolls the screen so that the active cell is visible?

Ctrl + Backspace

Which keyboard shortcut is used to start a new document?

Ctrl + N

Which keyboard shortcut will add the current time to a cell?

Ctrl + Shift + :

Which of the following keyboard shortcuts can be used in Excel 2016 to create a table?

Ctrl+L

You can store the results of a formula entered in the formula bar (e.g., =(25*10)/2 ) as an actual number (e.g., 125) in the active cell. What keyboard shortcut do you need to press while editing the cell to do this?

F9

Excel uses column headers to create labels for each _____ on data entry form.

Field

What does the excel keyboard shortcut Ctrl + Alt + F9 do?

Forces a complete recalculation of all formulas in all open workbooks

If you format a chart element with a certain font, how can you reset it to its original state?

Format tab (chart tools) --> Reset to Match Style or Right click on the chart --> Reset to Match Style

Which is not one of the excel functions to determine whether a cell contains an error value?

ISLOGICAL

In the Analysis ToolPak for Excel, which of the following parameters can you specify when creating a Histogram?

Input Range and Bin Range

When a column is sorted within a table, which of the following is true about the drop-down list in the header row?

It displays a different graphic to remind you that the table is sorted by that column