WorksheetsMicrosoft Excel Final
Total questions: 21
Worksheet time: 20mins
The function that lets you add up a range of cells or values
(a)
SUM, AVERAGE, IF, MIN and MAX are examples of _______.
predefined functions
online functions
table functions
user-defined functions
If you click on a letter at the top of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
A four-sided arrow does what in Excel?
copies the contents of one cell to others around it
moves the contents of one cell to another location
selects the cell
autofills the information from that cell to the next
Every formula starts with what?
(a)
If you see the following, what does it mean? ######
the formula has an error
text was entered where numbers should be
the contents are too large to display
there are only numbers in that cell
If you center or merge and center it does exactly the same thing.
True
False
What function was used to find the highest grade?
(a)
What tool allows you to capture the formatting in one location and easily format other cells the same way?
copy format
format painter
cut and paste
copy and paste
What is the difference in the following numbers: 1/3, .33, 33%
the format
the value
the function
the amount
If you selected (A1:G5) what is this called?
(a)
The rectangular shaped area on a worksheet that is created by the intersections of columns and rows.
(a)
An Excel file that contains individual worksheets is called what? Also called a spreadsheet file.
Cell grid
Workbook
Formula
Function
What function was used to find the lowest grade?
(a)
How do you change column width to fit the contents?
Press ALT and single-click anywhere in the column
Single-click the boundary to the left of the column heading
Double-click the boundary to the right of the column heading
Double-click the boundary to the left of the column heading
Write the formula you would use if you want to add up a range of cells A1 through A25.
(a)
Write the formula you use to convert the number of cups in cell A3 to tsp.
(a)
A (a) is another name for an equation used in Excel.
When creating a chart in Excel, what is the first thing you need to do?
Choose a chart from the ribbon
Select the Insert Tab
Double click the active cell
Select the data to be graphed.
Explain, in detail, in at least 3 paragraphs (First you do this.... then you do this... finally you do this...) how to create a conversion table with specific formulas for cups to teaspoons, tablespoons, and fluid ounces.
Explain, in detail, how to create a graph that compares the different miles per gallon rates of your dream car. What specific formula is used and what steps would you take to create the graph from that information? *3 paragraph minimum*
