Question 1

What values does the user need to input or confirm in the Format as Table dialog box?

Accepted Answer

The user needs to input the cell range and confirm whether their table has headers or not in the Format as Table dialog box. Option A is not necessary as the cell range is already inputted. Option C is incorrect as the worksheet tab name and range of cells containing table headers are not required in this dialog box. Option D is not applicable as the Format as Table dialog box does not require specific ranges for table column or row headers.

Question 2

Only text values can be rotated and angled.

Accepted Answer

Both text and numerical values can be rotated and angled in various software applications, including spreadsheet and graphic design programs, to improve readability or visual appeal.

Question 3

Which is NOT a Total row summary function?

Accepted Answer

TODAY is not a summary function. It returns the current date in Excel. The other options (SUM, AVERAGE, COUNT) are all summary functions that can be used in the Total row of a table to perform calculations on the data in that column.

Question 4

A ________ is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table.

Accepted Answer

A calculated column in Excel tables allows a formula to be applied to each row in the table, with cell references automatically adjusting for each row.

Question 5

The combination of using the Merge Cells feature, increasing font size, and adding borders gives a worksheet row a banner-like appearance.

Accepted Answer

The Merge Cells feature allows multiple cells to be combined into one larger cell, which can then be formatted to have a banner-like appearance by increasing the font size and adding borders.

Question 6

The function IF is a logical function.

Accepted Answer

The IF function in Excel is a logical function that returns one value if a condition is true and another value if it is false.

Question 7

The ________ button is the arrow to the right of a header row label in a table.

Accepted Answer

The filter button is represented by an arrow to the right of the header row label in a table, which allows users to filter and display only certain data based on specific criteria. Edit, analyze, and sort buttons are different functions in a table.

Question 8

Borders are always black.

Accepted Answer

Borders can be any color, not just black. The color can be defined using CSS or other styling methods.

Question 9

All prebuilt Excel functions are volatile.

Accepted Answer

Not all prebuilt Excel functions are volatile. Volatile functions recalculate every time the worksheet recalculates, but many Excel functions, like SUM or AVERAGE, are not volatile and only recalculate when the input cells they depend on change.

Question 10

The ________ tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet.

Accepted Answer

The option to keep rows at the top of and columns at the left of each printed page is found in the Sheet tab of the Page Setup dialog box. The Page tab is intended for adjusting margins, paper orientation, and scaling. The Margins tab is for setting the margins of the printed page. The Header/Footer tab is where you define the content that appears at the top and/or bottom of each printed page.

Question 11

The function COUNT returns the number of cells that are in the user selected range and have a number as the displayed value.

Accepted Answer

The COUNT function counts only the cells in the selected range that contain numbers as the displayed value. Any cell with a text or other value will not be counted.

Question 12

When a range of cells is converted to a table, the default setting in the Filter gallery is ________.

Accepted Answer

The default setting in the Filter gallery when a range of cells is converted to a table is "Select All." This allows all the data in the table to be displayed initially, before any specific filters or sorting options are applied.

Question 13

The functions TODAY and NOW have no arguments.

Accepted Answer

The TODAY and NOW functions do not require any arguments as they simply return the current date and time.

Question 14

The ________ group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

Accepted Answer

The Scale to Fit group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

Question 15

When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of ________.

Accepted Answer

The COUNT function counts the number of cells that contain a numerical value in the selected column. Therefore, the displayed value in the Total row will represent the number of cells in that column that contain a number value.

Question 16

The functions TODAY and NOW are volatile.

Accepted Answer

TODAY and NOW are volatile functions because their value is constantly changing, even if the workbook is not being actively calculated or edited. This means that the functions recalculate every time that Excel recalculates the worksheet, regardless of whether any changes have been made to the data or formulas in the workbook.

Question 17

A comparison operator returns a value of yes or no.

Accepted Answer

A comparison operator returns a boolean value of either true or false, not "yes" or "no".

Question 18

In a table with manual or conditional formatting, a column can be sorted only by ________.

Accepted Answer

The answer of In a table with manual or conditional...

Question 19

When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays ________.

Accepted Answer

When the Sort Smallest to Largest option is selected, the Filter button displays another up-arrow icon, indicating that the data is sorted in ascending order.

Question 20

The AutoFill method of copying the underlying value of a cell can be used on cells containing the function IF.

Accepted Answer

The AutoFill method can copy the underlying value of a cell including cells containing the IF function.

Quiz 10: More Functions and Excel Tables