Excel Test Review

11 September 2022
4.7 (114 reviews)
30 test answers

Unlock all answers in this set

Unlock answers (26)
question
######
answer
Increase the width of the column.
question
.xlsx
answer
The file extension for Excel files.
question
Ctrl + Home
answer
Quickly takes you to cell A1.
question
Ctrl + G
answer
Allows you to type in a cell reference to go to.
question
Equal Sign
answer
Every formula and function begins with this.
question
Line Chart
answer
A chart that shows trends over time.
question
Insert
answer
The tab that allows you to create charts.
question
Active Cell
answer
This cell has a border around it.
question
Functions
answer
Sum, Average, Max, and Min are examples of this.
question
Ascending
answer
This is a sort order that is from smallest to largest.
question
Rename
answer
Double click on a sheet tab to do this.
question
Column Chart
answer
Use this chart type to visually compare values across a few categories.
question
Labels
answer
These are left-aligned.
question
Values
answer
These are right-aligned.
question
Cell
answer
This is an intersection between a column and a row.
question
Descending
answer
This is a sort order that is from largest to smallest.
question
Pie Chart
answer
Use this chart to show proportions of a whole.
question
Bar Chart
answer
Use this chart type to visually compare values across a few categories when the chart shows duration or the category text is long.
question
Ctrl `
answer
Shows formulas.
question
Apostrophe
answer
Place this in front of a value and it will become a label.
question
Rows
answer
These run horizontally.
question
Columns
answer
These run vertically.
question
Range
answer
A group of cells; two or more.
question
Exponents
answer
If there are not parenthesis, this is calculated first in an arithmetic operation.
question
Workbook
answer
This contains individual pages called worksheets.
question
Legend
answer
This defines the different parts of the chart.
question
Autofit
answer
This automatically adjusts the widths of the column(s).
question
Print Preview
answer
Allows you to look at the workbook before printing.
question
Ctrl
answer
Hold down this key when selecting the second column of data for a chart.
question
Fill Handle
answer
This is a small black plus sign found in the bottom right-hand corner of a cell.