WorksheetsMicrosoft Excel Revision
Total questions: 23
Worksheet time: 12mins
What function would you use to sum a range of cells?
TOTAL
SUM
CALCULATE
ADD
How do you create a chart in Excel?
Right-click on the data and choose 'Delete'
Go to 'View' tab and select 'Gridlines'
Click on 'File' and select 'New'
Select data, go to 'Insert' tab, choose chart type.
What is the shortcut for saving a workbook?
Ctrl + P
Alt + S
Ctrl + S (Windows) / Command + S (Mac)
Shift + S
What function would you use to find the average of a range of cells?
SUM
MEAN
AVERAGE
AVG
The intersection of a row and column
Active Cell
Sort
Cell Range
Cell
If you click on a letter at the top of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
A program that can be used to do calculations and graphing
PowerPoint
Spreadsheet
Word
Outlook
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
Mathematical Calculation
Formula
Spreadsheet
Function
Cell Range
What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?
cell bar
formula bar
status bar
name box
The cell that is currently selected for data entry
Cell Address
Active Cell
Cell Range
Values
All functions and formulas begin with which symbol?
#
/
:
=
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
Which of the following is an example of a range?
D3
D3 and D5
D3:D18
Sum
What function was used to find the highest grade?
average
min
sum
max
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
A box that holds data
Spreadsheet
Cell
Row
Data
BAR
LINE
STOCK
COMBO
Identify this chart.
Column
Bar
Line
Pie
