Study sets, textbooks, questions
Upgrade to remove ads
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 _____.
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.
If a function is included in an argument within a function, it is called a __________
Which of the following is an absolute cell reference?
If the following IF function, =IF(A2<B2,A3,B3), were place in cell B4 what would be displayed?
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
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:
The mode function will give you the
the most common occurring value of a range of values
The _______ defines what the data is
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.
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
If you wanted to show the change of a value over time such as the price of a stock you would use a ________ chart.
If you want to highlight the background of a cell you would use the ________ command.
Students also viewed
Theology Test 3 (Only vocab)
Spanish Vocab 1/20/21
Other sets by this creator
Exam 2 Quizzes
Operation Management Final
MIS Chapter 11
The belief in one all-powerful god is know as ___.
The “rate of absorption”: A. Has to do with how quickly alcohol enters the bloodstream B. Has to do with how quickly alcohol is processed by the kidneys C. Both A and B D. Neither A nor B
Which two shotgun chokes are best for hunting small, fast, close birds?
Someone's mom has 4 sons North, West and South. What is the name of the fourth son.