Font size
WorksheetsSpreadsheet Quiz
Total questions: 50
Worksheet time: 38mins
Under the order of arithmetic operators, Excel will calculate division before exponents.
TRUE
FALSE
The absolute cell reference uses which symbol:
$
%
*
&
To combine text that is in two different cells, use the formula:
COMBINE
MATCH
CONCATENATE
SUBTOTAL
To add a special sort order to a “Sort By” list, you would use:
SORT A to Z
SUBTOTAL
FILTERS
CUSTOM SORT
In VLOOKUP, the column # refers to the column in the:
table array
worksheet
workbook
list
A table can have blank columns and rows in it, if they are selected when the table is created.
TRUE
FALSE
In Excel 2016 mini toolbar is an efficient formatting tool that can be accessed by:
Clicking the view tab on the ribbon
Right clicking a cell selection
Clicking the office button
Clicking the status bar
To count how many cells have text in them, use the function:
COUNT
COUNTIF
COUNTA
SUMIF
If we have a table with 100 columns, and we want a new table only with columns 1, 50, 2, 10, 99 (in that order), what option is faster?
Copy/pasting each column manually
Data>Data tools>Text to columns
Data>Sort&Filter>Advanced Filter
Stop working, surrender to the void
To make a column or a row fixed, you can use ...
a. fixed row tab
b. fixed column tab
c. freeze tab
#DIV/0 refers to ...
a. Divide a document error
b. Divide a number by zero
c. Divide zero by a number
To type your phone number, the field must be ...
a. number
b. general
c. text
$B$2 this cell is ...
a. relative to others
b. absolute cell
c. none of the above
... function calculate cells that contain numbers only
a. COUNT()
b. COUNTA()
c. SUM()
... function gives the highest value.
a. MIN()
b. AVG()
c. COUNT()
d. none of the above
IF(10>=10, "OK", "No") this will output ...
a. 10
b. OK
c. NO
When you have a condition you can use ...
a. WHILE()
b. IF()
c. DO()
The IF Statement takes a logical test and determines a result that is either True or False.
True
False
If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')
60
pass
fail
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, value)
Which of the following is NOT possible with VLOOKUP?
You can lookup values located in a different worksheet.
You can lookup values located in a column to the right of the column that contains the lookup value.
You can lookup values located in a column to the left of the column that contains the lookup value.
What is a Pivot Table?
A table containing data that is organized horizontally.
A table used to calculate financial pivot values.
A tool used to summarize data.
A table containing only black, grey and white formatting
The formula that adds values in a specified range that meet a certain condition or criteria is called:
SUMIFS
SUMIF
COUNTIF
SUBTOTAL
You can have multiple sheets within the same Google Sheet document.
False
True
A sales manager has requested the highest sale for the first quarter. Which function will be used?
SUM
HIGHEST
MAX
TOTAL
Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
Label
Value
Formula
Function
Adding two cells
SUM(A1:A9)
ADD(A1:A9)
SUMIF(A1:A9)
NONE OF THE ABOVE
What does the Average formula return?
Returns the lowest argument.
Returns the middle argument.
Returns the three highest arguments.
Returns the mean of all its arguments.
What does the Min formula return?
Returns the smallest three numbers form a set and ignores text.
Returns the smallest value in a set of values and ignores text.
Returns the largest three numbers form a set and ignores text.
Returns the largest value in a set of values and ignores text.
What does the Countif formula return?
Counts the number of cells within a range that meets the given condition.
Counts the number of words within a range that meets the given condition.
Counts the number of columns within a range that meets the given condition.
Counts the number of letters within a range that meets the given condition.
Which operator is used to multiply in Excel?
+
-
/
*
All formulas begin with a(n) _______________.
&
=
+
#
Excel will display _______________________ if the cell is not wide enough.
******
^^^^^
######
>>>>>
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
Answer =2+3*3-2
9
10
11
12
__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.
Formula
Calculation
Cell address
None of the above
There are two types of references.
Relative and Dependent
Relative and Proportionate
Absolute and Dominant
Relative and Absolute
A predefined formula that performs calculations using specific values in a particular order.
Function
Reference
Chart
Multiple arguments must be separated by a ______________.
Space
Comma
= Sign
!
Which of the formulas below are valid? Select all that apply.
=F2+F3+F4-53
=R2*D2
=5B+6B
A3+100
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
You can click the tabs at the bottom of a workbook to switch between ________.
formulas
number formats
worksheets
permissions
