NEW
Font size
WorksheetsWorkforce Spreadsheet
Total questions: 20
Worksheet time: 15mins
The numbers in Excel represent the...
Rows
Columns
Cells
Data
To sort data in Excel, go to the __________ ribbon.
Home
Data
Insert
View
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
Which of the following is the correct reference for a cell range?
A2...E15
F15-J28
B2;F30
A7:D20
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
In PivotTables, ____ fields correspond to columns in the original data.
row
index
summary
category
Can you group or ungroup the Pivot data as per your preference?
Yes
No
______ counts all values in a range, including numbers and text?
COUNTBLANK (Range)
COUNTIFS (Range. Criteria)
COUNT (Range)
COUNTA (Range)
_____ (Range) function in Excel returns the number of cells that contain numbers in a given range.
COUNTA
COUNT
COUNTBLANK
COUNTIFS
What is this type of graph called?
Line
Pie
Bar
Donut
Explain the concept of Autofill in Excel.
Autofill in Excel only works with numerical data, not text.
Autofill in Excel is a manual process that requires entering data cell by cell.
Autofill in Excel is a feature that automatically fills in a series of data or formulas into adjacent cells by recognizing patterns in the existing data.
Autofill in Excel can only be used in one direction, either horizontally or vertically.
How can you create a new worksheet in an Excel workbook?
Press Ctrl + N
Double-click on existing worksheet tab
Go to File -> New Worksheet
Right-click on existing worksheet tab -> Insert -> Worksheet
Which of the following is an absolute cell reference?
A:2
$A$2
A2
#A2
If an entry is £3.99 what should we format the cell as?
Number
Currency
Text
Number with 2 decimal places
