Excel 1
Excel 2
Excel 3
Excel 4
Mystery
100
Define Active Cell?
The current cell in a worksheet. It is indicated by a dark border onscreen.
100
What is the Sum formula?
=Sum( )
100
Excel is useful for using ________ as opposed to words or presentations?
Excel is useful in numbers/data
100
How would you save an Excel Document?
File- Save as- pick location- name document-save
100
How do you adjust the width of a column?
Mouse between letters and adjust size when cursor indicates.
200
Define Cell?
The intersection of a column or row in a worksheet or table.
200
When starting a formula what is the first thing you type in the cell?
=
200
To quickly add a set of number you can use the ____ feature?
Auto Sum Botton
200
How do you format for currency in EXCEL?
Highlight data or column, then go to home tab, then number group and select currency.
200
Name two types of graphs in excel that can be used to show data?
Pie Graph, Line Graph and Bar Chart
300
Define Formula Bar?
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.
300
When you open Excel you are viewing Excel in the ____ View?
Backstage
300
The letters in Excel represent the _______?
Columns
300
Where is the active cell shown for quick reference?
Upper left of screen by the formula bar.
300
What is the cell refference formula?
Choosing 1 cell to use in relationship to another cell. Example B1-F1
400
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.
400
Excel spreadsheets that are already created and ready for you to edit are known as?
Templates
400
The numbers in Excel represent the _____?
Rows
400
A function in Excel is represented by what to letters?
fx
400
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
=A1-C3
500
What is a sheet in Excel?
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
500
What is the green bar at the top of Excel referred to as?
The Ribbon
500
When making a graph whats the first thing you need to do?
Highlight your data being used.
500
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
500
What version of Excel are we using in class?
Excel 2016
M
e
n
u