Upgrade to remove ads
Only $35.99/year

Excel Quiz

Terms in this set (25)

In the Excel address C5 the C refers to
the column of the cell
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
B1:G10
A named range in Excel
can be referenced by its name from all worksheets
To name or delete a range, you use the __________ dialog box.
Define Names
If a function is included in an argument within a function, it is called a __________
nested function
Which of the following is an absolute cell reference?
$B$3
If the following IF function, =IF(A2<B2,A3,B3), were place in cell B4 what would be displayed?
2
The following value "###########" in a cell of an Excel spreadsheet indicates
a number and format combination that is too large for the cell
The count function increments by 1 for
each cell in the range that contains a numeric value
To include a character value in an IF function
the character must be in double quotes
After performing an arithmetic action on two cells containing dates and the result is a number, you should
format the cell to show a date
If the number in a column are arraigned from largest at the top to smallest at the bottom the sort order is
descending
The countif function is used to
count the number of times a specific condition is met within a defined data range
A pie chart can contain _____ data ranges.
any number selected by the user
The fit to option is used to
make the active sheet print on to a single page
The formula =(4 + 3) * 2 will evaluate as:
14
The mode function will give you the
the most common occurring value of a range of values
The _______ defines what the data is
trend line
What is true about adding a new record to an existing table?
you add it below the last record and Excel will extend the table to include it
If you wish to keep the titles in column A visible as you page to the right you should
you should freeze the first column
To calculate the Mean of a set of numbers you would use the _________ function.
Average
To include two non-adjacent columns in a pie chart (one title, one data).
Highlight the first desired column, press and hold the shift key, select the second column, Select Insert, Select which type of pie you want
A cell address that adjusts both the row and column values to its new location when copied is known as a
relative address
If you wanted to show the change of a value over time such as the price of a stock you would use a ________ chart.
Line
If you want to highlight the background of a cell you would use the ________ command.
Fill
Students also viewed