Button on the keyboard is used to accept any data that has been typed in a cell and move the active cell down vertically to the next one in a column
SHIFT
ENTER
TAB
CTRL
In Excel, Columns are labeled as:
Letters
The AVERAGE formula does what?
averages the selected cells
displays the largest number
add the selected cells
displays the smallest number
What does the Sort feature do?
Autofill
Multiply
Put data in order
Apply a thick border
What kind of chart shows a circle is divided into sectors which shows a percentage of a whole.
Bar Chart
Line Chart
Column Chart
Pie Chart
This feature allows the user to select specific rows or columns that remain visible when scrolling in the worksheet.
ACTIVE CELL
CELL SELECTOR
FREEZE PANES
___ Charts are used to display trends over time.
Line
Pie
Column
Bar
Which function would you use to find the largest value in a range of cells in Excel?
LARGEST
MIN
LARGER
MAX
To combine multiple cells into one large cell, which button do you use?
Increase indent
Center button
Merge and Center
Column Width command
"Alignment" refers to
where the text shows up in the cell (left, center, right)
the number of decimals
font size
the lines around a cell
How do you add a new column in Excel?
Right-click on any existing column and choose "Insert"
Type "New Column" in a cell and press Enter
Click on the "Column" tab and select "New"
Press Ctrl + Shift + C
The cell in the spreadsheet that is currently selected for data entry
RANGE
ROW
ACTIVE CELL
COLUMN
The function to find the biggest number in a range
=MOST
=MIN
=BIGGEST
=MAX
The black lines between all cells are called:
Grids
Cell
Line
Gridline
Sorting in Excel has two different options - ascending or descending. Which option would sort a series of data from largest to smallest?
Descending
Ascending
What would the following formula do? =SUM(B2:B21)
Add the numbers in cells B2 to B21
Average the numbers in cells B2 to B21
Find all numbers in cells B2 to B21
None of the answers are correct.
In Excel, a row runs:
Vertically
Horizontally
Diagonally
To include multiple non-adjacent rows, hold down the ___ key and lock on the row number you would like to copy.
CTRL
TAB
SHIFT
ALT
Different pages within the same spreadsheet located on the bottom left. Can also be referred to as “sheets”. You can add, delete, and rename tabs within a spreadsheet.
COLUMN
TAB
RANGE
ROW
At the intersection of a row and column you will find:
A link
A Reference
A Value
A cell
What is the location of the active cell?
A1
D2
B5
C5
Is a defined set of formatting characteristics such as font, font size, font color, cell borders, and shading.
NAME BOX
ORIENTATION
CELL STYLE
FORMAT
In Excel, a column runs:
Diagonally
Vertically
Horizontally
There are three main parts to a spreadsheet, which of the following is not one of them?
Rows
Cells
Columns
Links
This command allows you to automatically insert the most common functions into your formula, including SUM, AVERAGE, COUNT, MAX, and MIN (without having to type the whole function out!)
FUNCTION
FORMULA
AUTO SUM
RANGE
If you want to sort data from A to Z, you would use which sort option?
Descending
Ascending
+ (the plus sign) in Excel means to
Average
Divide
Add
Combine
To select a single worksheet cell so you can work with it, which of the following would you do?
Hover over the cell
Click the name box.
Click the status bar
Click the cell
If you double click between a column header in Excel, what happens to the column?
Delete the Column
AutoFit to Contents
Select the Column
Hide the Column
An entire Excel file is called a workbook. A workbook can have multiple tabs referred to as:
Workfiles
Copies
Spreadsheets
Worksheets
What is a function?
Highlighting of cell references in a formula
The addition of all values in a range of cells
A predefined formula
A formula that contains one operator
What is the red rectangle called?
Cell address
Row
Cell
Column
A graphic representation of values used to identify trends and contrasts in data
WORD ART
CELL STYLES
SMART ART
CHART
What is the definition of a spreadsheet?
the largest number
Displays horizontal bars going down the chart with the value
A document that stores data in a grid of horizontal rows and
Horizontal line of cells
True or False: You can start Excel using the Start button on the Windows Taskbar or a shortcut on your desktop.
True
False
If you double click between a column header in Excel, what happens to the column width?
Hide the Column
Select the Column
Delete the Column
AutoFit to Contents
Which of the following can be created using Excel data?
Tables
Stories
Essay
Pictures
When using a formula in Excel, you must start it with a(n):
Equals Sign
Appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell
FORMULA BAR
NAME BOX
ROW HEADING
COLUMN
An entire Excel file is called a workbook. A workbook can have multiple tabs referred to as
Workfiles
Worksheets
Spreadsheets
Copies
A combination of a column letter and a row number that identifies a cell on a worksheet.
ACTIVE CELL
RANGE
CELL ADDRESS
What's the advantage of using a formula rather than just typing in the answer to a formula?
A formula will import data from the internet
A formula will automatically update when new data is added
A formula will auto-save your file
It's better to do all the math by hand and not use a formula
What kind of file stores data in a grid of horizontal rows and vertical columns.
Presentation
Document
Database
Spreadsheet
Which chart best represents values across different categories?
Pie
Bar
Line
Scatter
True or False: You can use the delete key to clear cell contents.
FALSE
TRUE
What does it mean to "merge" cells?
to make selected cells into one larger cell
to create a chart
to make cells smaller
to make numbers show decimals
A custom calculation created by the user
Function
Request
Formula
Command
A unique "address" defined by coordinates of the intersection of a column and a row. Example: D11 refers to the cell located at the intersection of column D and row 11
RANGE
COLUMN HEADING
ROW HEADING
CELL REFERENCE
In Excel, Rows are labeled as:
Numbers
Where is the fill handle located?
At the beginning of any formula or function
In Backstage View
On the right side of the Home tab on the Ribbon
In the bottom-right corner of the selected cell
What type of program is Excel?
Spreadsheet
Word Processor
Presentation
Publishing
This function adds all of the values of the cells in the argument.
MIN
SUM
MAX
COUNT