NEW
Font size
WorksheetsREVIEW TEST – Microsoft Excel - G7
Total questions: 45
Worksheet time: 23mins
What type of software is Microsoft Excel considered?
Spreadsheet
Presentation
Word processor
Database
A workbook in Excel is made up of several:
Tables
Worksheets
Charts
Slides
The box formed by a row and a column is called a:
Field
Cell
Range
Group
What displays the name of the Excel file and program?
Formula Bar
Title Bar
Status Bar
Ribbon
Which tab do you click to save your Excel work?
Home
File
Data
Insert
What shortcut key pastes copied data?
Ctrl + V
Ctrl + C
Ctrl + X
The default file format of an Excel workbook is:
.xlsx
.docx
.pptx
.xls
Which bar shows the active cell’s contents?
Formula Bar
Status Bar
Title Bar
Tool Bar
Which key combination redoes an action?
Ctrl + Y
Ctrl + X
Ctrl + C
Ctrl + U
The long horizontal group of commands in Excel is called the:
Menu
Ribbon
Toolbar
Formula bar
To adjust column width, you use:
Page Layout
Home tab → Format
Data → Sort
Review
To select multiple cells together you create a:
Field
Range
Set
Record
Which command combines cells into one large cell?
Wrap Text
Merge & Center
Border
Fill Color
Which feature repeats your last action?
Redo
Undo
Refresh
Reset
The vertical lines labeled A, B, C... are called:
Columns
Rows
Cells
Tabs
In Excel, every formula starts with what character?
#
=
+
%
Which function finds the largest number in a range?
=MAX
=MIN
=AVERAGE
=COUNT
Which function calculates the mean value?
=SUM
=AVERAGE
=COUNT
=MAX
The function =COUNT(A1:A5) returns:
Total of numbers
Number of numeric cells
Text count
Highest value
A fixed cell reference is written as:
A. A1
B. A
C. A$1
D. $A$1
Which key converts a relative reference into an absolute reference?
F1
F4
F3
F10
Which operator performs multiplication?
/
*
+
%
Which tab provides font, alignment, and cell border options?
Data
Home
Insert
Review
Which chart type shows percentages of a whole?
Pie
Column
Line
Bar
The first step to make a chart is:
Collect the data
Draw the chart title
Color the chart
Print the chart
A line chart is best for showing:
Changes over time
Category comparison
Percentages
Totals
The function =MIN(A2:A10) will show:
The highest number
The lowest number
The sum
The average
The function =SUM(A1:A4) does what?
Counts data
Adds data
Subtracts data
Divides data
Which option adds a border around cells?
Home → Borders
Data → Filter
View → Gridlines
Page Layout → Margins
Which tool lets you include labels and legends in a chart?
Chart Tools
Page Layout
View
Review
Sorting allows you to:
Filtering helps you:
Display only chosen data
Change the font color
Delete rows
Add totals
You can find Sort and Filter commands in which tab?
Home
Data
Insert
View
Which icon appears when filtering is active?
Small arrow on header
Star symbol
Dot
Check mark
To remove filters, select:
Data → Clear
File → Reset
Home → Delete
View → Options
A column in a list represents a:
Record
Field
Group
Dataset
A row in a database represents a:
Field
Record
Header
Filter
What should the first row of a table contain?
Field names
Totals
Filters
Blank cells
Which data consistency rule is correct?
Each column should have the same data type
Use mixed formats
Leave blank rows
Merge cells
Data → Sort & Filter group is found in:
Data tab
Home tab
File tab
Review tab
Which feature hides unwanted data temporarily?
Filter
Sort
Merge
Format
Filtering and sorting are both:
Data management tools
Layout options
Formula types
Chart types
Which command alphabetizes text data?
Sort A to Z
Count
Align
Merge
A properly structured Excel database must not have:
Blank rows
Column titles
Numeric data
Text data
Why use sorting and filtering?
To analyze information quickly
To delete old data
To change background color
To print faster
