WorksheetsMicrosoft Excel Quiz
Total questions: 14
Worksheet time: 7mins
What is the intersection of a column and a row on a worksheet called?
Address
Cell
Range
Value
What type of chart is useful for comparing values over categories?
Pie Chart
Column Chart
Line Chart
Bar Graph
Which function in Excel tells how many numeric entries are there?
NUM
SUM
COUNT
CHKNUM
A feature that displays only the data in column(s) according to specified criteria is called?
Sorting
Filtering
Grouping
Formula
Statistical calculations and preparation of tables and graphs can be done using?
PowerPoint
Excel
Adobe Photoshop
Notepad
Which of the following is NOT a type of chart in Excel?
Scatter Plot
Dot Graph
Column Chart
Pie Chart
What is the default file extension for an Excel workbook?
.xlsb
.xlsm
.xlsx
.xls
Which function is used to find the average of a set of numbers in Excel?
AVG
SUM
MEAN
AVERAGE
What is the shortcut key for saving a workbook in Excel?
Ctrl + V
Ctrl + C
Ctrl + P
Ctrl + S
Which of the following is a logical function in Excel?
IF
COUNT
AVERAGE
SUM
What does the VLOOKUP function do?
Counts the number of entries
Looks up a value vertically
Looks up a value horizontally
Calculates the sum
Which of the following is used to create a drop-down list in Excel?
Conditional Formatting
Data Validation
Filtering
Sorting
What is the maximum number of rows in Excel 2016?
65,536
1,048,576
2,097,152
32,768
Which of the following functions can be used to count non-empty cells?
COUNTA
COUNTIF
COUNTBLANK
COUNT
