Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel

Total questions: 179

Worksheet time: 2hrs 32mins

Name
Class
Date
1.

What do you call the blank boxes on a excel sheet

a)

cell

b)

info

c)

Squares

d)

Spots

2.

Microsoft Excel is what type of Software ?

a)

Drawing

b)

Word processing

c)

Spreadsheet

d)

Presentation

3.

Which symbol must you use to begin a formula ?

a)

$

b)

#

c)

@

d)

=

4.

How do you make a cell into the active cell

a)

Cells are always active

b)

Click INSERT Cell

c)

Click on the Cell

d)

Click the ACTIVE button

5.

What is the name of this Cell ?

a)

6B

b)

A5

c)

6A

d)

B6

6.

What is the formula sign for multiply?

a)

/

b)

*

c)

=

d)

-

7.

To sort names in a worksheet, we can use ____ button

a)
b)
c)
d)
8.

You want to enter a series of numbers down a column. what would be the best tool for the job?

a)

Find & replace

b)

Autofill

c)

Cut & Paste

d)

Spelling Checker

9.

Here in Excel, Which button will you select to calculate total marks ?

a)
b)
c)
d)
10.

In Excel,what would be a correct formula for changing a text from lower case to upper case ?

a)

=UPPER B1

b)

=PROPER(B1)

c)

=UPPER(B1)

d)

UPPER(B1)

11.

A cell is the intersection of a row and column?

a)

True

b)

False

12.

Displays the both name of application and the name of the spreadsheet.

a)

Name Box

b)

Spreadsheet Area

c)

Worksheet Tabs

d)

Title Bar

13.

A grid of cells organized into rows and columns in which we enter and store our data.

a)

Spreadsheet Area

b)

Name Box

c)

Insert Function

d)

All of the above

14.

Are rectangular tabs visible on the bottom left of the excel workbook.

a)

Worksheet tabs

b)

Title Bar

c)

Row Headers

d)

Scroll Bar

15.

In excel and other spreadsheet applications, the _____ is the colored row of letters used to identify each column within the sheet, or workbook. This is located above the row one.

a)

Formula Bar

b)

Active Cell

c)

Status Bar

d)

Column Header

16.

The ___ is located at the bottom of the screen, below the working area. It displays information about the current activities in the worksheet.

a)

Active Cell

b)

Status Bar

c)

Insert Function

d)

Dialog Launcher

17.

It is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and allow you to create and view formulas.

a)

Active Cell

b)

Formula Bar

c)

Command Buttons

d)

Ribbon Group

18.

This excel buttons are located at the extreme right-top corner of the excel window.

a)

Window Control Bottons

b)

Select Buttons

c)

Command Buttons

d)

None of the above

19.

Alternatively referred to as a cell pointer, current cell, or selected cell, a ______ is a rectangular box that highlights the cell in a spreadsheet.

a)

Formula Bar

b)

Dialog Launcher

c)

Ribbon Group

d)

Active Cell

20.

A small arrow in the lower- right corner of a group brings up more related commands.

a)

Formula Bar

b)

Dialog Launcher

c)

Ribbon Group

d)

Active Cell

21.

Choose the best description of the IF function

a)

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

b)

Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false

c)

Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false

d)

Returns a value from a list using a given position

22.

Choose the correct format of the IF function:

a)

=IF(logical test,value if true,value if false)

b)

=IF(logical test,value if false,value if true)

c)

=IF(value if true,value if false,logical test)

d)

=IF(value if false,value if true,logical test)

23.

Which is the correct way to write this function:

IF B4 is greater than 200, show "High", otherwise, show "Low"

a)

IF(B4>200;"High";"Low")

b)

=IF(B4<200,"High","Low")

c)

=IF(B4>200,"High","Low")

d)

=IF(B4>200"High","")

24.

Which of these comparison operations means "Less than or equal to"?

a)

<

b)

<>

c)

<=

d)

$

25.

In this IF function example:  =IF(G8>40,"Yes","No")

What would show in the cell after you hit enter if the value in G8 was 62?

a)

Yes

b)

No

c)

Nothing would show

26.

The arrangement of data in Z to A will arrange the data in __________ order.

a)

Ascending

b)

Descending

27.

The Sort & Filter option is present under which tab of Microsoft Excel?

a)

Insert Tab

b)

Data tab

c)

Home tab

d)

Format tab

28.

The _____________ feature allows you to see only those records that you want display while it hides the rest of the data temporarily from the view .

a)

Filter

b)

sort

c)

Custom Sorting

d)

Removing Filter

29.

State true or false.

You can sort data in only one field.

a)

True

b)

False

c)

Don`t know

d)

Not able to answer

30.

To colour those cells blue where temperature is above 50 degree you will

a)

Apply filtering

b)

Use fill colour option

c)

Shade Cells

d)

Use Conditional Formatting

31.

The program that we use to create spreadsheets

a)

MS Word

b)

MS Paint

c)

MS Excel

32.

MS Excel?

a)
b)
c)
d)
33.
a)

Spreadsheet

b)

Cell

c)

Column

d)

Row

34.
a)

Spreadsheet

b)

Cell

c)

Column

d)

Row

35.

What is "A1"?

a)

Cell address

b)

Cell letter

c)

Cell number

36.

Which one is a correct cell address?

a)

A1

b)

1A

c)

A

d)

1

37.

What is the intersection of a column and a row on a worksheet called

a)

Column

b)

Value

c)

Address

d)

Cell

38.

An Excel file is generally called a / an :

a)

E-Spreadsheet

b)

Woorksheet

c)

Workbook

d)

Sheet

39.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
40.

Identify the MS Excel Window...

a)
b)
c)
d)
41.

Displays the name or location of the active cell

a)

Formula bar

b)

Name box

c)

Column

d)

Row

42.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
43.

In which of the Excel Tabs you can find Slicer and Timeline options?

a)

a) Insert Tab

b)

b) View Tab

c)

c) Pivot Table Analyze Tab

d)

Both a) and b)

e)

Both a) and c)

44.

What will Ctrl + 1 do?

a)

It will opens the Go to dialog box

b)

It will select the column range

c)

It will bold the selected range

d)

It will opens the format cells dialog box

45.

Total number of columns in Excel worksheet?

a)

16,284

b)

16,385

c)

16,384

d)

17,384

46.

Study the screenshot above. To find the price for the selected product (coffee in the example above), what formula would you type into the highlighted cell (B19)?

a)

=VLOOKUP(A19,A2:C16,C,FALSE)

b)

=VLOOKUP(A19,A2:C16,3,FALSE)

c)

=VLOOKUP(B19,A2:C16,3,FALSE)

d)

=VLOOKUP(A19,A2:C16,1,TRUE)

47.

The intersection of row and column is called as

a)

Row

b)

Column

c)

range

d)

Cell

48.

what does "#######" in excel?

a)

column has missing numbers

b)

column is not wide enough

c)

column is showing error

d)

None of the above

49.

What will Ctrl + Shift + 3 do to a certain numerical range?

a)

It will apply the date format to that range

b)

It will apply the time format to that range

c)

it will apply the scientific format to that range

d)

It will apply the percentage format to that range

50.

I want to add a Scroll bar and Spin button in excel dashboard. In which tab I can find these features?

a)

View Tab

b)

Data Tab

c)

Developer Tab

d)

Page layout Tab

51.

In a VLOOKUP formula, what does the argument column_index_number mean?

a)

This is the secret INDEX number that each column in an Excel worksheet has.

b)

This is a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc.

c)

This is the number of the column within the selected table_array where the lookup result is located.

d)

I don't Know

52.

What is a Pivot Table?

a)

A table containing data that is organized horizontally.

b)

A table containing only black, grey and white formatting

c)

A table used to calculate financial pivot values.

d)

A tool used to summarize data.

53.

Short cut key for inserting Pivot Table

a)

Alt + N + T

b)

Alt + B + V

c)

Alt + N + V

d)

Ctrl + N + V

54.

How will you able to add "Developer Tab" in excel ribbon?

a)

Click on File Tab --> click on Options --> click on Advanced --> Developer Tab --> OK

b)

File Tab --> Options --> Quick Access Tool Bar --> Developer Tab --> OK

c)

File Tab --> Options --> Customize Ribbon --> Main Tabs --> Developer --> OK

d)

File Tab --> Options --> Add-ins --> Developer Tab --> OK

55.

When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.

a)

True

b)

False

56.

Which of these functions will you use if you wish to evaluate more than one condition?

a)

IF()

b)

IFELSE()

c)

IFS()

d)

IFELSES()

57.

 

In the function =IF(SUM(B3:B6)>10, "Yes", "No"), which of the two functions will be evaluated first?

a)

IF function

b)

SUM function

58.

Sorting data alphabetically, numerically, or by date.

a)

Ordering

b)

Switching

c)

Sort Order

59.

Sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. Uses an equal sign (=).

a)

Formatting

b)

Formula

c)

Both answers are incorrect.

60.

Another word for spreadsheet.

a)

Worksheet

b)

Excelsheet

c)

Alphasheet

61.

Two or more cells on a sheet.

a)

Both answers are incorrect.

b)

Sort

c)

Range

62.

Collection of cell formats (fort size, patterns, alignment) that can be applied to ranges of data.

a)

Autoformat

b)

Data Formatting

c)

Both answers are correct.

63.

The pointer changes to a black cross when you point to this on the spreadsheet.

a)

Cell

b)

Fill Handle

c)

Corner

64.

The intersection of a row and column in a worksheet.

a)

Cell

b)

Box

c)

Both answers are correct.

65.

A bar used to edit or enter values or formulas in cells or charts.

a)

Merged Bar

b)

Formula Bar

c)

Edit Bar

66.

Numbered grey area located to the left of each row on a spreadsheet.

a)

Both answers are correct.

b)

Row Starter

c)

Row Heading

67.

Data that is currently being entered into this area.

a)

Active Cell

b)

Fill Cell

c)

Range Cell

68.

One cell created by combining two or more selected cells.

a)

Merged Cell

b)

Double celling

c)

Two Cells

69.

Toolbar that shows a list of options when clicking a small arrow next to the list box.

a)

Column Box

b)

Tab Box

c)

Drop-down list box

70.

Shaded gray area describes the lettered area on the worksheet.

a)

Title Heading

b)

Column Heading

c)

Side Heading

71.

The intersection of a row and column.

a)

Numbering

b)

Cell Reference

c)

Both answers are incorrect.

72.

What is this called?

a)

cell

b)

workbook

c)

column

73.

Look at where the green arrow is pointing. What is it called?

a)

cell

b)

workbook

c)

column

74.

What is this called?

a)

columns

b)

sheets

c)

row

75.

What is this called?

a)

columns

b)

sheets

c)

row

76.

What is this called?

a)

columns

b)

sheets

c)

row

77.

What is this called?

a)

cell address

b)

cell range

c)

sum formula

78.

B2:B6 is called?

a)

cell address

b)

sum formula

c)

cell range

79.

This is an example of a ?

a)

formula

b)

sum formula

c)

cell address

80.

What is the sum formula?

a)

=sum(f8:h8)

b)

=sum(d8:h8)

c)

=sum(e8:h8)

81.

What is the sum formula?

a)

=sum(I13:I20)

b)

=sum(J13:J19)

c)

=sum(J19:J20)

82.

______that allows the user to check for multiple conditions and returns true if all conditions are met and false if any of the conditions are not met.

a)

conditional formatting

b)

ADD function

c)

data validation

d)

countif function

83.

A feature that creates rows and columns based on values in the selected cells.

a)

cell style

b)

avg if function

c)

data validation

d)

auto fill

84.

A function that returns the average in a range of cells based on one specified criterion.

a)

average

b)

IF

c)

avg if

d)

none

85.

Provides an option to autofill data across a row or column using a user-established pattern.

a)

goal seek

b)

fill series

c)

if series

d)

adding series

86.

A function that allows the user to make a comparison between two values and then returns a true or false result.

a)

AVG IF FUNCTION

b)

IF FUNCTION

c)

COMPARE FUNCTION

d)

RESULT FUNCTION

87.

A list of commands that are recorded or coded with the purpose of executing the commands using a single command.

a)

Micro function

b)

recorder function

c)

coding function

d)

macro

88.

This option allows a user to set protection settings on a worksheet with a password.

a)

workbook protection

b)

worksheet protection

c)

saving protection

d)

excel savings protection

89.

A function that returns the current date.

a)

Month function

b)

day function

c)

Today function

d)

current function

90.

A function that adds up all of the numbers in a range of cells based on a criterion that the user specifies.

a)

sum function

b)

sumif functions

c)

sumifs function

d)

adding function

91.

A tool that allows a user to establish the format of data that is entered into cells.

a)

User function

b)

ENTER function

c)

format function

d)

data validation

92.

A type of chart used to plot more than one data series using a second axis.

a)

TWO AXIS

b)

DUAL AXIS

c)

AXIS

d)

CHART AXIS

93.

WHICH TYPE OF SOFTWAR IS BEST FOR ADDING NUMBERS

a)

WORD

b)

POWERPOINT

c)

ACCESS

d)

EXCEL

94.

WHICH APP IS BEST FOR WRITING A REPORT?

a)

WORD

b)

EXCEL

c)

POWERPOINT

d)

ACCESS

95.

a combination of a column letter and a row number that identifies a cell on a worksheet.

a)

CELL RELAVTIVE

b)

CELL ADDRESS

c)

CELL REFERENCE

d)

CELL LOCATION

96.

s one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook.

a)

NO CHANGE REFERENCE

b)

CELL RELATIVE REFERENCE

c)

ABSOLUTE CELL REFERENCE

d)

MIXED REFERENCE

97.

a type of reference in which either the column is made constant or the row is made constant. When we make any column or row constant then the column name or row number does not change as we copy the formula to other cell(s).

a)

RELATIVE CELL REFERENCE

b)

ABSOLUTE REFERENCE

c)

MIXED CELL REFERENCE

d)

COMMON REFERENCE

98.

basic cell references that adjust and change when copied or when using AutoFill.

a)

STYLE CELL REFERENCE

b)

RELATIVE CELL REFERENCE

c)

ABSOLUTE CELL REFERENCE

d)

MIXED CELL REFERENCE

99.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
100.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
101.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
102.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
103.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
104.

Identify the Excel Icon.

a)
b)
c)
d)
105.
The name of the cell located at the intersection of column F and row 223 is:
a)
223F
b)
F223
c)
F222
d)
22F3
106.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
107.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
108.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
109.
a)

Spreadsheet

b)

Cell

c)

Column

d)

Row

110.

What is the cell address of the pink cell?

a)

A1

b)

1A

c)

D3

d)

3D

111.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Presentation Software

d)

Database Software

112.

Division symbol in spreadsheet.

a)

/

b)

+

c)

=

d)

*

113.

Every formula starts with what?

a)

()

b)

+

c)

-

d)

=

114.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

115.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

116.

In Excel, the name of the bar where information appears as you input data is called?

a)

File Bar

b)

Status Bar

c)

Formula Bar

d)

Help Bar

117.

What function in MS Excel will be used to easily compute the Classification of Grades?

a)

Sum

b)

If

c)

Average

d)

Frequency

118.

What function in MS Excel will be used to easily know if the students are pass or fail your subjects?

a)

Sum

b)

If

c)

Average

d)

Frequency

119.

What part of Microsoft Excel Window is a text field where you can enter words and phrases about what you want to do next and quickly get to features you want to use or actions you want to perform?

a)

Quick Access Toolbar

b)

Formula Bar

c)

Tell Me

d)

File Tab

120.

What part of MS Excel Workbook Views will appear on the printed page?

a)

Normal View

b)

Page-Layout View

c)

Page Break View

d)

Zoom

121.

Excel formulae are entered or edited in:

a)

The formula box

b)

The formula bar

c)

The formula space

d)

The formula area

122.

The ABSOLUTE reference to cell G13 would be:

a)

G13

b)

?G?13

c)

!G!13

d)

$G$13

123.

In binary logic OR will evaluate to TRUE under the condition stated below 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

124.

An ideal visualization would be:

a)

Simple

b)

Complex

c)

Byzantine

d)

Elaborate

125.

Excel can create the following charts:

a)

Line

b)

Pie

c)

Scatter

d)

All listed answers

126.

The Excel macro language is:

a)

C

b)

C++

c)

Python

d)

Microsoft Visual Basic

127.

Excel macro workbooks use the standard .xlsx format.

a)

True

b)

False

128.

Between ISERR and ISERROR, the function with broader conditions for a match is:

a)

ISERROR

b)

ISERR

c)

Trick question: Neither is a matching function

d)

Trick question: They are equally broad

129.

In PowerQuery language, a reference to an existing column, COL, would be denoted with:

a)

COL

b)

[COL]

c)

(COL)

d)

{COL}

130.

ETL stands for:

a)

Extract, Transform, Load

b)

Extract, Transform, Link

c)

Enable, Transform, Load

d)

Extract, Transmogrify, Load

131.

The way to freeze a particular row and column is by

a)

Selecting the particular row and clicking on freeze pane option

b)

Selecting the particular column and clicking on freeze pane option

c)

Selecting the cell that lies on the intersection of the particular row and column and clicking on freeze pane option

d)

Selecting the cell besides the cell that lies on the intersection of the desired row and column and clicking on freeze pane option

132.

The way to copy the formatting of a cell is by selecting the ____________ option

a)

Copy

b)

Format Painter

c)

Drag and Drop the cell into the desired cell

d)

Copy and Paste

133.

The __ feature of ms excel quickly completes a series of data.

a)

Auto Filter

b)

Auto Complete

c)

Auto Fill

d)

Auto Sum

134.

Which one is not a function in ms excel?

a)

RIGHT

b)

MID

c)

LEFT

d)

CLEAR

135.

What does COUNTA function do?

a)

Counts cells having alphabets

b)

Counts empty cells

c)

Counts cells having number

d)

Counts non-empty cells

136.

In the formula, which symbol specifies the locked columns or rows?

a)

$

b)

*

c)

%

d)

;

137.

You can auto fit the width of column by

a)

Double clicking on the column name on column header

b)

Double click on the cell pointer in worksheet

c)

Double clicking on column right border on column header

d)

Double clicking on the column left border of column header

138.

Long text can be broken down into many lines within a cell. You can do this through

a)

Wrap Text in Format > Cells

b)

Justify in Edit > Cells

c)

None of the above

d)

All of the above

139.

Which area in an Excel window allows entering values and formulas?

a)

Title Bar

b)

Menu Bar

c)

Formula Bar

d)

Standard Tool Bar

140.

In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

a)

Auto Fill

b)

Auto Correct

c)

Auto Sum

d)

Auto Format

141.

Which functioning Excel tells how many numeric entries are there ?

a)

NUM

b)

COUNT

c)

SUM

d)

None of these

142.

Statistical calculations and preparation of tables and graphs can be done using?

a)

Notepad

b)

Power Point

c)

Excel

d)

Adobe Photoshop

143.

Which one is not a Function in MS Excel ?

a)

SUM

b)

MAX

c)

MIN

d)

AVG

144.

Functions in MS Excel must begin with ___

a)

An Equal Sign

b)

A Plus Sign

c)

A > Sign

d)

An () sign

145.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc.

d)

$A$1, $A$2, etc.

146.

Which bar show the used formula of selected active cell?

a)

Menu bar

b)

Ribbon

c)

Formula bar

d)

Scroll bar

147.

When all the number between 0 to 100 in a range should be displayed in Red color, Apply

a)

Use =if() function to format the required number red.

b)

Apply Conditional Formatting command on format Menu

c)

Select the cell that contain number between 0 to 100 then click Red color on Text color tool

d)

All of the above

148.

What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?

a)

Count

b)

IF

c)

SUM

d)

CountA

149.

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array?

a)

Lookup

b)

VLookup

c)

NOW

d)

CountIF

150.

Which ONE of the following is not true?

a)

Excel sheets have the extension *.doc

b)

A new workbook is called Book 1

c)

You can have Word and Excel open together

d)

You can also create graph in excel sheets

151.

To Add up entries from D6 to D10, we use the formula?

a)

=Add(D6:D10)

b)

=Sum(D6:D10)

c)

Both A & B

d)

None of these

152.

The intersection of row and column is called?

a)

Pointer

b)

Cursor

c)

Sheet

d)

Cell

153.

Finds minimum value among a range of cell from A4, A5, A6, A7 and A8 in MS-Excel?

a)

=MIN(A4 to A8)

b)

=MIN(A4-A8)

c)

=MIN(A4:A8)

d)

All of the above

154.

Excel files have a default extension of?

a)

XLW

b)

XLS

c)

DOC

d)

WK1

155.

Which feature allows you to create specific rules?

a)

Pivot Table

b)

Sorting

c)

Data Validation

d)

None of these

156.

To create a new workbook

a)

Ctrl + N

b)

Ctrl + PageUp

c)

Ctrl + O

157.

To move to the previous sheet

a)

Ctrl + PageDown

b)

Ctrl + W

c)

Ctrl + PageUp

158.

To go the Formula tab

a)

Ctrl + O

b)

Alt + W

c)

Alt + M

159.

To close Excel

a)

Ctrl + F4

b)

Ctrl + C

c)

Alt + A

160.

To hide a selected column

a)

Ctrl + 0

b)

Ctrl + Shift + 0

c)

Ctrl + 9

161.

To hide selected row

a)

Ctrl + Space

b)

Ctrl + 9

c)

Ctrl + 0

162.

To select the entire column

a)

Ctrl + Shift + arrow

b)

Shift + Space

c)

Ctrl + Space

163.

To select the entire row

a)

Ctrl + Space

b)

Shift + Space

c)

Shift + Space, Ctrl + - 

164.

To apTo insert current time

a)

Ctrl + Shift + $

b)

Ctrl + Shift + %

c)

Ctrl + Shift + :

165.

To insert a hyperlink

a)

Ctrl + K

b)

Ctrl + H

c)

Ctrl + L

166.

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

a)

True

b)

False

167.

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

168.

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

a)

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

b)

=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)

c)

=VLOOKUP(lookup_value, table_array, col_index_num, value)

169.

Which of the following is NOT possible with VLOOKUP?

a)

You can lookup values located in a different worksheet.

b)

You can lookup values located in a column to the right of the column that contains the lookup value.

c)

You can lookup values located in a column to the left of the column that contains the lookup value.

170.

What is a Pivot Table?

a)

A table containing data that is organized horizontally.

b)

A table used to calculate financial pivot values.

c)

A tool used to summarize data.

d)

A table containing only black, grey and white formatting

171.

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

172.

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

173.

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

a)

COMBINE

b)

MATCH

c)

CONCATENATE

d)

SUBTOTAL

174.

Which conditional formatting feature can be used to identify duplicate values on a worksheet?

a)

Data Bars

b)

Highlight Cell Rules

c)

Top / Bottom Rules

d)

Color Scales

175.

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

a)

COUNT

b)

COUNTIF

c)

COUNTA

d)

TEXT

176.

You can have multiple sheets within the same Google Sheet document.

a)

False

b)

True

177.

A sales manager has requested the highest sale for the first quarter. Which function will be used?

a)

SUM

b)

HIGHEST

c)

MAX

d)

TOTAL

178.

Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?

a)

Label

b)

Value

c)

Formula

d)

Function

179.

Adding two cells

a)

SUM(A1:A9)

b)

ADD(A1:A9)

c)

SUMIF(A1:A9)

d)

NONE OF THE ABOVE