Excel lesson 1
An arrow in the bottom-right corner of a group on the ribbon tells you that what is available?
dialog box
consists of details that describe or identify a file, including the author?
Document properties
where you can save, select a template, change document properties, and close or exit Excel?
Backstage
In Excel, what is the result of =1 + 3 * 2 / 2 - 1?
3
calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?
AutoSum
What is another name for a selected cell?
active cell
is a group of adjacent cells that you select to perform operations on all of the selected cells?
Range
Which feature enables you to create custom tabs and groups?
Ribbon
To allow Excel to distinguish formulas from data, all formulas begin with
=
You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range
AVERAGE
After a file has been opened, the filename appears
title bar
To use a worksheet or workbook outside Excel, you have the option to save as
File format
Which dialog box in Backstage view should you access to view and alter your workbook’s properties?
Options
Once you name a range, you can change the size of the range using
Name Manager
You want to calculate the number of non-blank cells in your worksheet. Which function do you use?
COUNTA
How many worksheets does a new Excel 2013 workbook open with?
one
is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?
Fill handle
When you modify the ribbon, what do you create?
Tab
an example of an absolute cell reference (write on the board)
$A$9
The arguments of a function are contained within
parentheses
To get to the last cell on the worksheet, should you press.
Ctrl + End
Which Excel feature helps you quickly enter previous data into cells?
Auto Complete
What is a predesigned file that already has a significant amount of formatting, text, and other features?
Template
an example of a mixed cell reference (write on the board)
A$9
The COUNT and SUM functions are examples of
statistical