NEW
Font size
WorksheetsYear 7 - MS Excel (Beginner)
Total questions: 15
Worksheet time: 8mins
MS Excel is mainly used for:
Writing letters
Drawing pictures
Storing and calculating data
Playing games
What is a worksheet?
A single cell
A page in an Excel workbook
A file name
A formula
Which symbol is used to start a formula in Excel?
+
=
*
#
What function is used to sum a range of cells in Excel?
SUM()
ADD()
COUNT()
SUBTRACT()
Which of the following is a valid Excel file extension?
.pptx
.xlsx
.docx
.txt
What function is used to find the average of a range of cells in Excel?
SUM()
MEDIAN()
MEAN()
AVERAGE()
What is a cell in Excel?
A graphical element
A type of formula
A collection of worksheets
A single data point in a worksheet
Which of the following functions is used to count the number of cells that contain numbers?
SUM()
COUNT()
AVERAGE()
COUNTA()
Which function is used to determine the maximum value in a range of cells in Excel?
SUM()
MIN()
AVERAGE()
MAX()
Which shortcut key is used to copy data?
Ctrl + V
Ctrl + X
Ctrl + C
Ctrl + Z
What function is used to find the minimum value in a range of cells in Excel?
MIN()
MAX()
SUM()
AVERAGE()
Which of the following is a feature of Excel?
Data visualization
Video editing
Text editing
Web browsing
Which function is used to find the number of non-empty cells in a range?
COUNT()
AVERAGE()
COUNTA()
SUM()
A workbook contains only one worksheet.
True
False
Rows in Excel are labeled using numbers.
True
False
