Font size
WorksheetsExcel Quiz
Total questions: 16
Worksheet time: 8mins
True or False: You can view a formula by double-clicking the cell that contains the formula.
True
False
Which of the following is an absolute cell reference?
A2
A:2
#A2
$A$2
Which of the formulas below are valid? Select all that apply.
=F2+F3+F4-53
=R2*D2
=5B+6B
A3+100
The intersection of a row and a column is called a ________.
worksheet
field
cell
calculation
A group of cells is called a ________.
cell range
cell cluster
column
row
Where is the fill handle located?
In the bottom-right corner of the selected cell
On the right side of the Home tab on the Ribbon
At the beginning of any formula or function
In Backstage view
In this image, why does the value in cell G1 look slightly different from the value in the formula bar?
It’s using conditional formatting
It’s using an absolute cell reference
It’s using the Currency number format
It’s using a formula
You can click the tabs at the bottom of a workbook to switch between ________.
formulas
number formats
worksheets
permissions
Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?
It should use quotation marks instead of parentheses
There is nothing wrong with the formula
It should use the COUNT function instead
It should have an equals sign (=) at the beginning
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
In Excel, Rows are labelled as ______
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
The _____ command is used to change or customize the order of the spreadsheet data
Filter
Sort
Reorganize
Ribbon
The ____ command is used to view only the required data while the rest of the data is temporarily hidden,
Filter
Data validation
Sort
Find
What calculation function is used to find the highest data point?
AVERAGE
MIN
SUM
MAX
Why do we use the Freeze Panes feature in an Excel documents?
To zoom the document to 100% of the normal size
To view and scroll different parts of worksheet independently
To hide the current window so that it cannot be seen
To freeze all the data and prevent future edits
What is the file extension of Microsoft Excel files?
.xlsx
.docx
.excel
.pptx
