Excel Basics
What is an Excel file that can contain multiple worksheets called?
A workbook
What is the intersection of a row and column called?
Cell
What symbol begins a formula in Excel?
What is changing the appearance of text, numbers, or cells called?
Formatting
What tool keeps rows or columns visible while scrolling?
Freeze Panes.
What is a single page in an Excel file called?
Worksheet
What is a group of selected cells called?
Range
What is a built-in formula that performs a calculation called?
Function
What feature combines selected cells into one cell?
Merge & Center.
What tool arranges data in a specific order?
Sort.
What is the cell currently selected in Excel called
Active Cell.
What identifies the location of a cell, such as A1
Cell Reference
What is an expression used to calculate a result called?
Formula
What feature displays text on multiple lines inside a cell?
Wrap Text
What tool displays only data that meets certain conditions?
Filter.
What is the area at the top of Excel that contains commands called?
Ribbon
If you move across a worksheet from left to right, what type of cells are you moving through?
Rows
Which function would you use to add the numbers in cells A1 through A5?
sum
If you want a number to display as $25.00 instead of 25, which feature would you use?
Number Format
If you want to show sales numbers as a bar or pie picture, what feature would you use?
Chart
What is the toolbar that provides quick access to frequently used commands called?
Quick Access Toolbar.
If you move down a worksheet from top to bottom, what type of cells are you moving through?
Columns
If you select a column of numbers and click the AutoSum button, what does Excel automatically insert?
SUM formula.
If you want cells containing grades below 70 to turn red automatically, which feature would you use?
Conditional Formatting.
If you have a large sales list and want to summarize totals by product, which tool would help?
PivotTable.