20 questions
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
Active Cell
Formula
Cell
Cell address
The name of the cell is determined by the name of the row and the column intersecting, such as A8.
Formula
Formula Bar
Cell Address
Cell Grid
A combination of numbers and symbols used to express a calculation.
Active Cell
Label
Formula Bar
Formula
A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
AutoSum
Headings
Cell
AutoFill
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
Cell Address
Cell Grid
Cell
Active Cell
The lines on your worksheet that separate the columns and rows.
Sheet Tabs
Functions
Formula Bar
Cell Grid
In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.
Column
Label
Row
Cell Address
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.
Function
Sheet Tabs
Workbook
Drag
An Excel file/Google sheet that contains individual worksheets. Also called a spreadsheet file.
Workbook
Drag
File
Headings
A “page” within an Excel workbook that contains columns, rows, and cells.
Workbook
Worksheet
Label
Cell
It is known as the spreadsheet application.
MS Word
MS Excel
MS PowerPoint
MS Publisher
MS Excel is widely used for ______, financial application, statistics and engineering calculations.
accounting
word processing
photo editing
video editing
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
What does the mouse look like in a spreadsheet?
Arrow
Pointer
Two headed arrow
Selection cross
An Excel file format extension is
doc
xls
txt
mp3
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
The set of data that runs left to right in a spreadsheet
column
row
cell
active cell