Excel 1
Define Active Cell
The current cell in a worksheet. It is indicated by a dark border onscreen.
what is the sum formula
=Sum( )
Excel is useful for using ________ as opposed to words or presentations?
Excel is useful in numbers/data
How would you save an Excel Document?
File- Save as- pick location- name document-save
How do you adjust the width of a column?
Mouse between letters and adjust size when cursor indicates.
Define Cell
The intersection of a column or row in a worksheet or table.
When starting a formula what is the first thing you type in the cell?
=
To quickly add a set of number you can use the ____ feature?
Auto Sum Button
How do you format for currency in EXCEL?
Highlight data or column, then go to home tab, then number group and select currency.
What is the cell reference formula?
Choosing 1 cell to use in relationship to another cell. Example B1-F1
Define Formula
An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.
When you open Excel you are viewing Excel in the ____ View?
Backstage
The letters in Excel represent the _______?
Columns
Where is the active cell shown for quick reference?
Upper left of screen by the formula bar.
Name two types of graphs in excel that can be used to show data?
Pie Graph, Line Graph and Bar Chart
what is a spreadsheet
An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.
Excel spreadsheets that are already created and ready for you to edit are known as?
Templates
The numbers in Excel represent the _____?
Rows
A function in Excel is represented by what two letters?
fx
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
=A1-C3
what is a sheet in Excel
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
What is the green bar at the top of Excel referred to as?
The Ribbon
When making a graph whats the first thing you need to do?
Highlight your data being used.
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
What version of Excel are we using in class?
Excel 2016