Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS EXCEL HS

Total questions: 84

Worksheet time: 1hrs 6mins

Name
Class
Date
1.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

2.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

3.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

4.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

5.

What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

a)

SUMMING

b)

SUM

c)

ALL

d)

None at all

6.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

7.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

8.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
9.
This is the:
a)
title bar
b)
entry bar
c)
group
d)
none of the above
10.
The cell in a spreadsheet application in which data may be entered:
a)
cell reference
b)
name box
c)
active cell
d)
none of the above
11.
Unique address of a cell that is the coordinate of the intersection of a row and a column:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
12.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
13.
The bar that displays the data being entered in the active cell:
a)
status bar
b)
entry bar
c)
Windows Task Bar
d)
none of the above
14.
This is a:
a)
cell
b)
row
c)
column
d)
none of the above
15.
This is a:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
16.

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.

17.

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

a)

Standard tool Bar

b)

Title bar

c)

Formula Bar

d)

None of the above

18.

In Microsoft Excel, the file you create and edit is called:

a)

A form

b)

A ledger

c)

A table

d)

A workbook

e)

A record

19.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
20.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
21.

Which function is used to add the values of several cells?

a)

Average

b)

Max

c)

Min

d)

Sum

22.

The AutoSum button is present in the _________ group on the HOME tab.

a)

Styles

b)

Editing

c)

Font

d)

Alignment

23.

The _________ function finds the average of a set of values in a column or row.

a)

Max

b)

Min

c)

Sum

d)

Average

24.

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

a)

Find & Select

b)

Format Cell

c)

Sort & Filter

d)

Organize

25.

Which chart type to show proportions of a whole and we use it when the total of numbers is 100%

a)

Pie or Doughnut Chart

b)

Bar Chart

c)

Bubble Chart

d)

Line Chart

26.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
27.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
28.

Which function is used to add the values of several cells?

a)

Average

b)

Max

c)

Min

d)

Sum

29.

The AutoSum button is present in the _________ group on the HOME tab.

a)

Styles

b)

Editing

c)

Font

d)

Alignment

30.

The _________ function finds the average of a set of values in a column or row.

a)

Max

b)

Min

c)

Sum

d)

Average

31.

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

a)

Find & Select

b)

Format Cell

c)

Sort & Filter

d)

Organize

32.

Which chart type to show proportions of a whole and we use it when the total of numbers is 100%

a)

Pie or Doughnut Chart

b)

Bar Chart

c)

Bubble Chart

d)

Line Chart

33.

Which formula below will add the value of B2 to the value of C3

a)

=B2+C3

b)

=C3+B3

c)

=6+4

d)

=B+C

34.

Which of the following option is a formula?

a)

=SUM(A1:A5)

b)

Add A1 - A5

c)

Subtract the numbers from A1 to A5

d)

A1 = A5

35.

A worksheet is a(n) ___________

a)

Piece of graph paper

b)

Single page in a workbook

c)

Excel file

d)

All of the above

36.

A selection of multiple cells is called a

a)

Group

b)

Range

c)

Reference

d)

Package

37.

Using a cell address in a formula is known as:

a)

Formularizing

b)

Prefixing

c)

Cell referencing

d)

Cell mathematics

38.

All formulas in Excel begin with the following symbol

a)

+

b)

=

c)

#

d)

%

39.

In which view can you see the header and footer areas of a worksheet

a)

Normal view

b)

Page layout view

c)

Page break preview

d)

Header/Footer

40.

Which is the active cell in the spreadsheet above?

a)

B2

b)

2B

c)

1D

d)

1C

41.

Cell reference for the range of cells G2 to M12 is _____

a)

G2.M12

b)

G2;M12

c)

G2:M12

d)

G2-M12

42.

In Excel, you can sum a large range of data by simply selecting a tool button called __________________

a)

AutoFill

b)

AutoCorrect

c)

AutoSum

d)

Auto Format

43.

What does Vlookup stand for in Excel?

a)

Variable Lookup

b)

Vertical Lookup

c)

Vertical Loop

d)

Virtual Lookup

44.

What is the syntax of the Vlookup formula?

a)

=SUMIF(range, criteria, [sum_range])

b)

=INDEX(lookup_array, MATCH(lookup_value, lookup_array, 0))

c)

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

d)

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

45.

What is the purpose of using Vlookup in Excel?

a)

To search for a value in a table and return a corresponding value from another column.

b)

To insert a new row in the spreadsheet

c)

To change the font style of a cell

d)

To calculate the sum of a range of cells

46.

What are the four arguments of the Vlookup function?

a)

lookup_value, table_array, row_index_num, and range_lookup

b)

search_value, data_array, col_index_num, and exact_match

c)

value_to_find, array_to_search, index_num, and approximate_match

d)

lookup_value, table_array, col_index_num, and range_lookup

47.

How does Vlookup search for a value in a table?

a)

It searches for a value in the rightmost column of a table.

b)

It searches for a value in the middle column of a table.

c)

It searches for a value in the leftmost column of a table.

d)

It searches for a value in all columns of a table.

48.

What happens if the lookup value is not found in the table?

a)

Lookup value becomes zero

b)

#N/A or #VALUE!

c)

Table explodes

d)

Error 404

49.

Can Vlookup be used to search for values in multiple columns?

a)

No

b)

Only if the columns are adjacent

c)

Yes, but only in specific versions of Excel

d)

Yes, always

50.

What is the difference between Vlookup and Hlookup?

a)

Vlookup looks up a value in the horizontal direction

b)

Hlookup looks up a value in the vertical direction

c)

Vlookup looks up a value in the diagonal direction

d)

Vlookup looks up a value in the vertical direction, while Hlookup looks up a value in the horizontal direction.

51.

How can Vlookup be used to retrieve data from another worksheet?

a)

Specify the worksheet name followed by an exclamation mark (!) before the table array reference

b)

Enter the data manually from the other worksheet

c)

Use the SUM function to retrieve data

d)

Use the AVERAGE function to retrieve data

52.

What are some common errors that occur when using Vlookup and how can they be resolved?

a)

Double-checking the table array, using relative cell references, and ensuring the exact match option is selected.

b)

Forgetting to input the lookup value

c)

Using absolute cell references

d)

Not specifying the exact match option

53.

Identify the formula for

VLOOKUP

a)

=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])

b)

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

c)

=VLOOKUP(table_array, col_index_num, lookup_value,[range_lookup])

d)

=VLOOKUP(lookup_value, table_array, [range_lookup], col_index_num)

54.

What is the correct formula for this?

a)

=HLOOKUP(A4, A1:F1,2, FALSE)

b)

=VLOOKUP(B4, A1:F1,2, TRUE)

c)

=HLOOKUP(A4, A1:F1,2, TRUE)

d)

=VLOOKUP(A4, A1:F2,2, FALSE)

55.

What formula is used to find East_01?

a)

=HLOOKUP(A11, B1:B9,2, TRUE)

b)

=VLOOKUP(A11, A1:B9,2, TRUE)

c)

=HLOOKUP(A11, A1:B9,2, FALSE)

d)

=VLOOKUP(A11, A1:B9,2, FALSE)

56.
The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.
a)
range containing data
b)
Price of the item being looked for
57.
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
a)
True
b)
False
58.
The LookUp function has three arguments. First ___________ then data to search and finally, results column
a)
Value to Look Up
b)
Value to Calculate
59.

Jill wants to search her spreadsheet for a vaule in the first column of her tabel. What function should she use?

a)

VLOOKUP

b)

HLOOKUP

c)

LOOKUP

d)

SEARCH

60.

What function is used to find price of Product_2?

a)

HlookUp

b)

Index

c)

Match

d)

VlookUp

61.

What is the correct formula?

a)

=VlookUp(A8, A1:B5, 2, FALSE)

b)

= HlookUp(A8, A1:B5, 2, FALSE)

c)

= VlookUp(A8, A1:B5, 2, TRUE)

62.

What match type returns the exact value?

a)

0(zero)

b)

1(positive one)

c)

-1(negative one)

d)

2 (two)

63.

What are columns in spreadsheet?

a)

vertical

b)

horizontal

c)

upside down

d)

downside

64.

What are rows in spreadsheet?

a)

vertical

b)

horizontal

c)

upside down

d)

right

65.

What is the first step to create a formula?

a)

Select the cell you want to place the formula into

b)

Type the equals sign (=) to tell Excel that you're about to enter a formula

c)

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d)

Choose the new command from the file menu

66.

the intersection of a single

row and a single column

a)

range

b)

reference

c)

cell

d)

argument

67.

Absolute cell reference

a)

is group of selected cells which are highlighted

b)

is reference which is automatically fills other cells

c)

does not change when the formula is copied or moved to a new location

68.

There are two types of references:

1._____________ : (B2:B6), C4

2.Absolute : $A$2, ($B$2:$B$6),

a)

Changing

b)

Fluctuate

c)

Relative

d)

Linked

69.

If the mark is more than 50, the student passes. Which function we should use in D3? (We will use AutoFill for others)

a)

=IF($B$3>50,"YES","NO")

b)

=IF($C$3>50,"YES","NO")

c)

=IF(C3>50,"YES","NO")

d)

=IF(B3>50,YES,NO)

70.

What's the main data that being processed by Ms. Excel?

a)

Words

b)

Numbers

c)

Lines

d)

Image

71.

Microsoft Excel is categorize as ?

a)

Word Processing Software

b)

Database Software

c)

Spreadsheet Software

d)

Presentation Software

72.

What is the correct definition of cell in Ms Excel?

a)

The intersection of a row and column

b)

A prison for numbers and text

c)

The basic structural, functional, and biological unit of organisms

d)

The box to calculate data

73.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

74.

Which one is the icon function in Ms. Excel?

a)
b)
c)
d)
75.

What function is used to calculate data in a column?

a)

IF( )

b)

COUNTA

c)

SUMIF

d)

SUM

76.

Which function that doesn't exist in Ms. Excel?

a)

=IF

b)

=AVERAGE

c)

=HTML

d)

=MAX

77.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

78.

What this function do?


=MAX(A12:A16)

a)

To determine the average result

b)

To show which cell has the most character

c)

To determine the highest number of the list of number in a column

d)

To change font size to all caps

79.

Which result that will be shown by using that function?

a)

33

b)

24

c)

116

d)

29

80.

The function COUNT is specific for _________________

a)

Counting cells

b)

Counting text

c)

Counting number

d)

Counting tables

81.

What's the purpose of the IF function?

a)

To make logical comparisons between a value. There's true and false.

b)

To create a conditional sentence

c)

To count all the text in a cell

d)

To calculate the average result of a column

82.

What is the main function of F4 button while creating a formula?

a)

To refresh a page

b)

To select all cells

c)

To make a cell bigger

d)

All options are incorrect

83.

What's the function of merge and center button?

a)

To delete a cell in the center

b)

To combine cells into one and make it justified

c)

To mix 2 cells into 1 and calculate the value of the cells

d)

All options are correct

84.

Excel default format file is saved as a ____________

a)

PPTX

b)

XLSX

c)

DOCX

d)

JPEG

Similar Resources on Wayground

SisKom

80 questions

SisKom

quiz

Worksheet

•

10th Grade