Excel Basics
What Microsoft program is used to organize data into rows and columns?
What is Excel?
What is the intersection of a row and a column called?
A cell.
What symbol must every formula begin with?
=
What feature changes the appearance of text?
Formatting.
What is used to display data visually?
A chart.
What is a workbook?
A file that contains one or more worksheets.
What is a range?
A group of selected cells.
Which function adds numbers together?
SUM.
What tool makes text bold?
Bold
What chart is best for comparing categories?
Column Chart.
What is a worksheet?
A single spreadsheet page inside a workbook.
What is the active cell?
The currently selected cell.
Which function finds the average of numbers?
AVERAGE.
What feature combines several cells into one?
Merge & Center.
What chart is best for showing parts of a whole?
Pie Chart.
Which are three ways to create a new workbook in Excel 2019?
Blank Workbook, Template, Existing Workbook.
What displays the address of the selected cell?
The Name Box
Which function finds the largest number?
MAX.
What feature automatically changes the width of a column?
AutoFit.
What feature arranges data in alphabetical or numerical order?
Sort.
What is the Quick Access Toolbar used for?
It provides quick access to commonly used commands.
What is the Formula Bar used for?
To enter or edit data and formulas.
Which function counts cells containing numbers?
COUNT.
What feature changes how numbers are displayed, such as currency or dates?
Number Format.
What feature displays only rows that meet certain conditions?
Filter.