WorksheetsExcel Quiz
Total questions: 70
Worksheet time: 28mins
What is the function used to find the average of a group of numbers in Excel?
SUM
COUNT
IF
AVERAGE
Which function allows us to calculate the sum of a range of values in Excel?
IF
VLOOKUP
SUMIF
SUM
What does the COUNT function in Excel do?
Counts the number of cells with text
Counts the number of empty cells in a range
Counts the number of cells in a range that contain numbers
Counts the number of cells with errors
How can the CONCATENATE function in Excel be used?
To count the number of cells in a range that are not empty
To perform calculations based on logical tests
To find the average of a range of numbers
To combine information from two columns into one
What is the purpose of the IF function in Excel?
To find the average of a group of numbers
To perform calculations based on logical tests
To count the number of cells in a range that contain numbers
To calculate the sum of a range of values
How can the VLOOKUP function be used in Excel?
To count the number of cells in a range that contain numbers
To look up information based on a specific value
To calculate the sum of a range of values
To create a drop-down list
What is the purpose of using a drop-down list in Excel?
To perform calculations based on logical tests
To select specific values from a list
To find the average of a group of numbers
To calculate the sum of a range of values
Which function in Excel allows you to count the number of cells that are not empty?
COUNTIF
AVERAGE
COUNTA
SUMIF
How can the SUMIF function in Excel be used?
To count the number of cells in a range that contain numbers
To calculate the sum of a range of values based on a specific condition
To perform calculations based on logical tests
To find the average of a group of numbers
What does the COUNTBLANK function in Excel do?
Counts the number of cells with errors
Counts the number of cells in a range that contain numbers
Counts the number of empty cells in a range
Counts the number of cells with text
How can the AVERAGE function in Excel be used?
To find the sum of a range of numbers
To calculate the average of a group of numbers
To perform calculations based on logical tests
To combine information from two columns into one
What is the purpose of the COUNTIF function in Excel?
To count the number of cells in a range that contain numbers
To calculate the sum of a range of values based on a specific condition
To find the average of a group of numbers
To combine information from two columns into one
How can the IF function in Excel be used?
To find the average of a group of numbers
To perform calculations based on logical tests
To count the number of cells in a range that contain numbers
To calculate the sum of a range of values
What is the format for an IF function in Excel?
=IF(logical_test,value_if_true,value_if_false)
=IF(value_if_true,logical_test,value_if_false)
What does the SUMIF function do in Excel?
Adds certain data based on a condition
Calculates the average score of students
/
*
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
What is the name of the cell that is colored blue?
A
B
2B
B2
How are ROWS in MS EXCEL spreadsheet named?
numbers
letters
cells
columns
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
A graphic representation of data. Can you guess the name of this chart?
Column Chart
Line Chart
What is this part of Ms-Excel called?
Worksheets Tab
Status Tab
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Filtering
Pivot Table
What type of chart is useful for comparing values over categories ?
Pie Chart
Column Chart
Line Chart
Dot Graph
What type of chart will you use to compare performance of two employees in the year 2016 ?
Column Chart
Pie Chart
Dot Graph
Line Chart
Which of the following is not a term pertaining to spreadsheets?
Cell
Character
Formula
Browse
This is not a function category in Excel.
Logical
Text
Financial
Data Series
Formulas in Excel are made up of ___
Only arithmetic operators
Only symbols
Arithmetical operators and functions
Symbols and functions
___ operator, combines multiple references into one reference.
Space
Comma
Ampersand
Colon
____ sign is used to create an absolute cell reference
@
&
=
$
# VALUE! Refers to ___
Font Value
Error in Value
Subscript of the Number Value
Addition of value
Typed text showed in active cell and also in ___
Ribbon
Title Bar
Scroll Bar
Formula Bar
Which bar show the used formula of selected active cell?
Formula Bar
Ribbon
Scroll Bar
Menu Bar
What type of chart is useful for showing trends or changes over time ?
Line Chart
Bar Chart
Pie Chart
Line Chart
You can auto fit the width of column by
Double clicking on column right border on column header
Double clicking on the column left border of column header
Double click on the cell pointer in worksheet
double clicking on the column name on column header
To _________ cells means to combine multiple selected cells into a single cell.
merge
fuse
form
mix
What symbol is placed before a number to convert it from a value to a label?
/
' or "
!
*
The data shows five values: 27, 35, 32, 41 and 36. The result after using a function shows 41. Which of the five basic functions was used to display the result?
(a)
What do you call this part of the Excel interface?
Name box
Sheet tab
Active cell
Formula bar
A cell is
a portion of the spreadsheet where you type your formula.
the intersection of the row and column
the upper corner that is to the left of the column indicator and above the row indicator.
any place on the spreadsheet where you can type.
Not Sure
When you enter data into a cell and press the Enter key on the keyboard, the cursor will move to ___?
the cell below the cell where you entered the data.
the cell to the right of where you entered the data.
it will not move.
the formula bar so you can double-check your data.
Not Sure
Which of the following is not an example of an Excel function?
=SUM(A4:A10)
=A4:A10
=AVERAGE(A4:A10)
=MIN(A4:A10)
Not Sure
It is possible in Excel to insert a new row in a range of cells without affecting the entire row on the worksheet.
True
False
Not Sure
Which statement regarding formatting is true?
You can only change the font type and size for text data.
If you want to add decimal points to a number, your only choice is to use the format menu and then choose cells
You can use the autoformat command to create a certain look and then customize it to your individual requirements.
When you use a �$�, it always appears left justified in the cell.
Not Sure
Once you go to print preview mode, you either have to print or cancel because there is no way to go back and edit your spreadsheet after you have gone that far.
True
False
Not Sure
A 3D reference means
Adding a graphic to the spreadsheet
Reference in a formula to cells on other worksheets
A special kind of function that uses 3 numbers.
Formatting with 3 colors
Not Sure
Which of the following is a description of the pie chart?
Display the importance of values over time emphasizing the amount of change
Display the individual values for comparison.
Display one data series as a whole. Each of its parts represents a percentage of the whole
Show trends over time emphasizing time flow and rate of change.
Not Sure
Which method is not a method to select multiple objects for grouping?
Hold the shift key while selecting each object with the left mouse button to create an outline for grouping.
Place the mouse pointer somewhere outside the proposed group and drag the mouse around the objects to create an outline for grouping
Right click each object while holding down the shift key to select an object for grouping
Choose Edit on the menu bar, choose Go To, then click on the Special button and select Objects from the list
Not Sure
