Edit Game
Excel Test Review
 Delete

Use commas to add multiple tags

 Private  Unlisted  Public



 Save


Get beautiful free images


Delimiter between question and answer:

Tips:

  • No column headers.
  • Each line maps to a question.
  • If the delimiter is used in a question, the question should be surrounded by double quotes: "My, question","My, answer"
  • The first answer in the multiple choice question must be the correct answer.

 Import questions


Get beautiful free images






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


Get beautiful free images

Your experience on this site will be improved by allowing cookies.