excel chapter 1,2,3
Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?
#
column
A vertical stack of cells in a table or worksheet.
formula
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
Home Tab
AutoFit column widths
IF function
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
A(n) ________ is a vertical group of cells in an Excel worksheet.
Column
count
Counts the number of cells in a range that contain numbers
countif
Counts the number of cells within a range that meet the given condition
Which of the following is NOT a way to insert the SUM function into a cell?
Ctrl + =
What is the keyboard shortcut for flash fill?
Ctrl + E
The status bar displays the ribbon as well as the Quick Access Toolbar directly above it
False
Which of the following Excel features recognizes a pattern in the data of a worksheet?
Flash Fill
What are the two contextual tabs that display under Chart Tools when a chart is selected?
Format and Design
The ________ command allows you to select one or more rows or columns and lock them into place.
Freeze Panes
Where is the fill handle located?
In the lower right corner of a selected cell
The ________ function determines the largest value in a range of cells
MAX
PageDown
Move down a page
The ________ displays the name given to a selected cell, table, chart, or object
Name Box
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.
Sparklines
When you type data in a cell and press Enter, what cell becomes the active cell?
The cell below
cell
The intersection of a row and a column
The Formula Bar in Excel 2016 displays the value or formula in the active cell.
True
cell style
a defined set of formatting characteristics
row
a horizontal group of cells in a worksheet identified by numbers
sum
add a range of cells
average
add a range of cells and divide by number of values in range
Worksheet
also known as a spreadsheet
spreadsheet
also known as a worksheet
logical test
any value with a true/false result
Page Layout Tab
change a worksheet to landscape orientation
format
change the appearance of text
comparison operator
compares values in an excel function
Insert Tab
create a recommended chart
A(n) ________ illustrates the value of a cell relative to other cells in the worksheet
data bar
Formulas tab
display formulas on the screen
workbook
displays upon startup of Excel
File tab
exporting a document as a PDF file
Arguments are surrounded by brackets in a function
false
Conditional Format
formatting applied to a cell based on criteria
Cell content can be one of two things: a constant value or a(n) ________.
formula
column
group of vertical cells on a worksheet
median
locates the middle value
Shift + Tab
moves left one cell
Tab
moves right one cell
Ctrl + End
moves the cell to the last cell in the last column of the active area of a worksheet
Shift + Enter
moves up one cell
value
number, date, or time of day
theme
predefined set of features
Comma Style
space at the right of the cell
The ________ displays the current cell mode, the page number, and the zoom buttons
status bar
An Excel ________ is a range of cells converted in Excel used to analyze a group of related data
table
label
text value
The MEDIAN function finds ________.
the middle value in a range of cells
Accounting Number Format
thousand comma separator, dollar sign
The SUM function adds all numbers in a selected range of cells.
true
The NOW function is ________, meaning that it will update automatically each time the workbook is opened
volatile
A(n) ________ is an Excel document that stores data
workbook