wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Formulas & Functions in Excel

Total questions: 86

Worksheet time: 1hrs 16mins

Name
Class
Date
1.

Excel formulae are entered or edited in:

a)

The formula box

b)

The formula bar

c)

The formula space

d)

The formula area

2.

The ABSOLUTE reference to cell G13 would be:

a)

G13

b)

?G?13

c)

!G!13

d)

$G$13

3.

Excel ranges are denoted with

a)

:

b)

!

c)

?

d)

.

4.

Concatenate() also has a shortcut, which is:

a)

&

b)

+

c)

#

d)

!

5.

This function returns the current date without the time

a)

TODAY()

b)

NOW()

c)

DATE()

d)

CURRENT()

6.

In binary logic OR will evaluate to TRUE under the condition "TF" because it is:

a)

Strict, it requires 2 TRUE inputs

b)

Permissive, it only requires 1 TRUE input

c)

Permissive, it requires no TRUE inputs

d)

Strict, it requires 3 TRUE inputs

7.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

8.

Office 365's version of Excel has limited features compared to Microsoft Excel 2016 desktop application.

a)

True

b)

False

9.

Which functionin Excel checks whether a condition is true or not ?

a)

SUM

b)

COUNT

c)

IF

d)

AVERAGE

10.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
11.
Let's say you're trying to find your average grade in this spreadsheet. What's wrong with the formula in cell C11?
a)
It should use the COUNT function instead.
b)
There is nothing wrong with the formula.
c)
It should have an equals sign (=) at the beginning.
d)
It's referencing the wrong cell range.
12.

If =left(A1,3) is applied, what is the result?

a)

SEC

b)

OND

c)

123

d)

SECO

13.

If =right(B2,2) is applied, what is the result?

a)

_7

b)

0)

c)

ND

d)

56

14.

If =mid(B1,3,4) is applied, what is the result?

a)

LE(2

b)

LE(

c)

8_7

d)

3456

15.

If =left(A1,3) is applied, what is the result?

a)

SEC

b)

OND

c)

123

d)

SECO

16.

If =right(B2,2) is applied, what is the result?

a)

_7

b)

0)

c)

ND

d)

56

17.

If =mid(B1,3,4) is applied, what is the result?

a)

LE(2

b)

LE(

c)

8_7

d)

3456

18.

If =mid(A1,4,2) is applied, what is the result?

a)

ON

b)

ECON

c)

45

d)

2345

19.

If =left(B2,1) is applied, what is the result?

a)

:

b)

:9

c)

F

d)

7

20.

If =right(A2,3) is applied, what is the result?

a)

456

b)

654

c)

123

d)

SEC

21.

What is =COUNTA function?

a)

counts the number of cells that are not empty.

b)

counts the number of cells that contain a number.

c)

counts the number of cells in a range, that meets a given criteria.

d)

counts the number of cells that are empty.

22.

What is =COUNT function?

a)

counts the number of cells that are not empty.

b)

counts the number of cells that contain a number.

c)

counts the number of cells in a range, that meets a given criteria.

d)

counts the number of cells that are empty.

23.

What is =COUNTIF function?

a)

counts the number of cells that are not empty.

b)

counts the number of cells that contain a number.

c)

counts the number of cells in a range, that meets a given criteria.

d)

counts the number of cells that are empty.

24.

If =COUNTA(A1:A6) is applied, what is the result?

a)

5

b)

6

c)

2

d)

3

25.

If =COUNT(A1:A6) is applied, what is the result?

a)

5

b)

6

c)

2

d)

3

26.

If =COUNTIF(A1:A6,ROUND) is applied, what is the result?

a)

2

b)

3

c)

0

d)

1

27.

If =COUNTIF(A1:A6,"ROUND") is applied, what is the result?

a)

2

b)

3

c)

0

d)

1

28.

If =COUNTIF(A1:A6,"Here") is applied, what is the result?

a)

2

b)

3

c)

0

d)

1

29.

If =LEFT(A2,5) is applied, what is the result?

a)

Here2

b)

2

c)

ROUND

d)

Here

30.

If =RIGHT(A6,2) is applied, what is the result?

a)

33

b)

333

c)

2333

d)

ND

31.

If =MID(A4,4,1) is applied, what is the result?

a)

N

b)

U

c)

OUND

d)

D

32.

Which of the following function is applied to receive "h"

a)

=MID(A1,2,1)

b)

=LEFT(A2,1)

c)

=LEFT(A1,2,1)

d)

=LEFT(A1,2)

33.

Which of the following function is applied to receive "Th"

a)

=MID(A1,2,1)

b)

=LEFT(A2,1)

c)

=LEFT(A1,2,1)

d)

=LEFT(A1,2)

34.

Which of the following function is applied to receive "re"

a)

=MID(A2,2,2)

b)

=RIGHT(A2,2)

c)

=RIGHT(A2,3)

d)

=MID(A2,3,2)

35.
The shortcut key for AutoSUM is:
a)
Ctrl + =
b)
Alt =
c)
= SUM
d)
Shift +
36.

The formula that adds values in a specified range that meet a certain condition or criteria is called:

a)

SUMIFS

b)

SUMIF

c)

COUNTIF

d)

SUBTOTAL

37.
The formula used to make the error return value of a function look "pretty" or clean and non-confusing is:
a)
IFERROR
b)
IF
c)
ERROR
d)
VLOOKUP
38.

To combine text that is in two different cells, use the formula:

a)

COMBINE

b)

MATCH

c)

CONCATENATE

d)

SUBTOTAL

39.

In formulas, spaces count as characters.

a)

TRUE

b)

FALSE

40.

Cell A2 contains the following e-mail address: support@excel-skills.com


Cell B2 contains the following formula: =MID(A2,FIND(“@”,A2)+1,LEN(A2)-FIND(“@”,A2)+1)


What is the result of the formula in cell B2?

a)

@

b)

excel-skills.com

c)

support

d)

#VALUE

41.

To count how many cells have text in them, use the function:

a)

COUNT

b)

COUNTIF

c)

COUNTA

d)

SUMIF

42.

To Count the number of cells in a range that contain numeric values only, We have to use ................ function

a)

Sum

b)

COUNT

c)

COUNTA

d)

Average

43.

What is the function that allow us to remove unwanted spaces in a text?

a)

=SUBSTITUTE

b)

=REPLACE

c)

=VALUE

d)

=TRIM

44.

The function to call an specific amount of characters at the beginning of a text string is:

(a)  

45.

If I have the text "123456 - 010" in cell A1, what is the formula that allows me to call the last 3 characters?

a)

=LEFT(A1,3)

b)

=RIGHT(A1,3)

c)

=LEFT(A1,6)

d)

=RIGHT(A1,6)

46.

If I have the text "123456 - 010" in cell A1, what is the formula that allows me to call the first 6 characters?

a)

=LEFT(A1,3)

b)

=RIGHT(A1,6)

c)

=LEFT(A1,6)

d)

=RIGHT(A1,3)

47.

... function calculate cells that contain numbers only

a)

a. COUNT()

b)

b. COUNTA()

c)

c. SUM()

48.

$B$2 this cell is ...

a)

a. relative to others

b)

b. absolute cell

c)

c. none of the above

49.

#DIV/0 refers to ...

a)

a. Divide a document error

b)

b. Divide a number by zero

c)

c. Divide zero by a number

50.

... function gives the highest value.

a)

a. MIN()

b)

b. AVG()

c)

c. COUNT()

d)

d. none of the above

51.

IF(10>=10, "OK", "No") this will output ...

a)

a. 10

b)

b. OK

c)

c. NO

52.

When you have a condition you can use ...

a)

a. WHILE()

b)

b. IF()

c)

c. DO()

53.

... function calculate cells that contain numbers only

a)

a. COUNT()

b)

b. COUNTA()

c)

c. SUM()

54.

The IF Statement takes a logical test and determines a result that is either True or False.

a)

True

b)

False

55.

If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')

a)

60

b)

pass

c)

fail

56.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
57.

What does the Countif formula return?

a)

Counts the number of cells within a range that meets the given condition.

b)

Counts the number of words within a range that meets the given condition.

c)

Counts the number of columns within a range that meets the given condition.

d)

Counts the number of letters within a range that meets the given condition.

58.
VLookUp is used when there are more than two columns in the array (lookup table).
a)
True
b)
False
59.
IF statements can be written to carry out an action, such as: IF a value in a cell is greater than or equal to another value, insert the word "Pass" in a cell.
a)
True
b)
False
c)
x
d)
x
60.
Date Functions are used to calculate a period of time. DATE360.....
a)
returns the current date
b)
returns tomorrow's date
c)
calculates the difference in days    between 2 dates
d)
is only used in database
61.
VLookUp is used when there are more than two columns in the array (lookup table).
a)
True
b)
False
62.
IF statements can be written to carry out an action, such as: IF a value in a cell is greater than or equal to another value, insert the word "Pass" in a cell.
a)
True
b)
False
c)
x
d)
x
63.
Date Functions are used to calculate a period of time. DATE360.....
a)
returns the current date
b)
returns tomorrow's date
c)
calculates the difference in days    between 2 dates
d)
is only used in database
64.
A collection of related values from a worksheet is called....
a)
legend
b)
plot area
c)
axis
d)
data series
65.

The absolute cell reference uses which symbol:

a)

$

b)

%

c)

*

d)

&

66.

To combine text that is in two different cells, use the formula:

a)

COMBINE

b)

MATCH

c)

CONCATENATE

d)

SUBTOTAL

67.

In formulas, spaces count as characters.

a)

TRUE

b)

FALSE

68.

To create a drop-down list in a cell or cell range, you would use:

a)

the LIST function

b)

DATA VALIDATION

c)

NAME MANAGER

d)

a VLOOKUP function

69.

In a computer, when we create an Excel chart as a separate sheet, it is stored in a

a)

A. current worksheet

b)

B. separate workbook

c)

C. current book

d)

D. A or C

70.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
71.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)
=(C3+C5+C9)
72.

Which of the following has a syntax error?

a)

If(B3<=20,"good",If(B3=<30,"better","best))

b)

If(B3<=75,"pass",if(B3<=60,"credit","distinction"))

c)

If(B3="blue","Boy,"Girl")

73.

Suppose cell B2 in a spreadsheet contains the formula:

=if(A1>100,"bazinga","zippo") If cell A1 contains the value 425, what value appears in cell B2?

a)

zippo

b)

425

c)

bazinga

d)

B2 is blank

74.

PROPER function converts string to

a)

lower case

b)

upper case

c)

first letter of a word to lower and others to upper case

d)

first letter of a word to upper and others to lower case

75.

In the Formulas ribbon, which category should you click to use "WORKDAY" function?

a)

Text

b)

Database

c)

Math & Trig

d)

Date & Time

76.

Logical functions are based on the values:

a)

True or False

b)

Equal or Not Equal

c)

Yes or No

d)

On or Off

77.

Which of the following is the formula for looking up data with the "VLOOKUP" function?

a)

HLOOKUP(Lookup Value, Table Array, Row Index Number)

b)

HLOOKUP(Lookup Value, Table Array, Column Index Number)

c)

VLOOKUP(Lookup Value, Table Array, Row Index Number)

d)

VLOOKUP(Lookup Value, Table Array, Column Index Number)

78.

What best describes "VLOOKUP"?

a)

A function that looks up data in the 1st worksheet in the workbook

b)

A function that finds data in another location based on data in the current worksheet. This information can then be displayed in a cell or used in a calculation

c)

A function that references another function to provide data

d)

A function that returns a row of data based on input parameters

79.

Function that used to check and assign 'pass' and 'fail' to group of scores

a)

SUM

b)

VLOOKUP and HLOOKUP

c)

COUNT and COUNTA

d)

IF and IFS

80.

Which are the three essential elements to enter a function?

a)

Equal sign, cell reference and formula

b)

Equal sign, function name and cell reference

c)

Function name, data and cell reference

81.
What is missing from this function?
=(F8 : F13)
a)
It doesn't need parentheses ( )
b)
The name of the function being applied
c)
SUM should be in front of the equal sign
d)
Nothing is missing
82.
What is the difference between a function and a formula?
a)
A function is a commonly used, preset formula
b)
A formula is basic math while a function is more advanced math
c)
You have to create the formula but a function is like an "auto formula" in Excel
d)
Functions are used in statistics
83.

What is this symbol?

a)

less than

b)

greater than

c)

less than or equal to

d)

greater than or equal to

84.

a function used to count the number of cell that contains something in them if the criteria are met.

a)

COUNT

b)

COUNTNOW

c)

COUNTING

d)

COUNTIF

85.

a function used to add a certain range of cell if a condition is met

a)

SUMIF

b)

ADDIF

c)

TOTALIF

d)

PLUSIF

86.

a syntax in the AVERAGEIF function that includes the value or label that determines if the cell is part of the range to be averaged

a)

range

b)

criteria

c)

average range

d)

logical test

Similar Resources on Wayground

Piggy Update Wave 3 :)

81 questions

Piggy Update Wave 3 :)

quiz

Worksheet

•

KG - Professional Dev...

failure management vol.1

91 questions

failure management vol.1

quiz

Worksheet

•

KG - Professional Dev...

01-Developer 1-85

83 questions

01-Developer 1-85

quiz

Worksheet

•

Professional Development

5/23 - IT Bridge Final Review

84 questions

5/23 - IT Bridge Final Review

quiz

Worksheet

•

Professional Development

DATA PROCESSING THIRD TERM EXAM

85 questions

DATA PROCESSING THIRD TERM EXAM

quiz

Worksheet

•

Professional Development

CONTENTS

83 questions

CONTENTS

quiz

Worksheet

•

Professional Development