Create a Worksheet
Create a Worksheet
Formulas
Functions
Formatting
100
Something that contains buttons, boxes, and menus.
What is a toolbar?
100
A basic unit of a worksheet.
What is a cell?
100
This takes a value or values, performs an opertaion, and returns a result to the cell.
What is a function?
100
A function that gives the lowest value in a range.
What is the MIN function?
100
A formatting in which Excel let you apply formatting that appears only when the value in the cell meets conditions that you specify.
What is conditional formatting?
200
A separate window that enables users to carry out some Excel tasks more efficiently.
What is a task pane?
200
The horizontal and vertical lines on the worksheet.
What are gridlines?
200
This sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.
What is the AVERAGE function?
200
This can be used to check which cells are referenced in the formula assigned to the active cell.
What is a range finder?
200
A technique you can use to hide data that might not be relevant to a particulat report or sensitive data that you do not want others to see.
What is hiding cells?
300
Like a notebook.
What is a workbook?
300
A list of commands that you can use to retrieve, sstore, print, and manipulate data.
What is a menu?
300
A function that gives the highest value in the range.
What is the MAX function?
300
Defined as a letter, number, symbol, or punctuation mark.
What is a character?
300
This means the printout is printed along the width of the page.
What is portrait orientation?
400
Inside the workbook are sheets.
What is a worksheet?
400
This means the cell entry is positioned at the far left in the cell.
What is left-aligned?
400
This is an important part of the formula, preceding d4*e4; it alerts you that you are entering a formula and not a function.
What is an equal sign?
400
This is made up of two values and a relational operator.
What is a condition?
400
This means the printout is printed along the length of the page.
What is landscape orientation?
500
A column letter above a grid.
What is a column heading?
500
A blinking vertical line that indicates where the next typed character will appear.
What is an insertion point?
500
This allows you to select cells for use in a formula by using the mouse.
What is the point mode?
500
A dot on the screen that contains a color.
What is a pixel?
500
One of the reasons Excel is so valuable, is that you can assign something to a cell and it will calculate the value.
What is a formula?
M
e
n
u