wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

A Excel

Total questions: 100

Worksheet time: 55mins

Name
Class
Date
1.

This is a_____________?

a)

Column

b)

Row

c)

Cell

d)

Range

2.

The area within the red box is called_______?

a)

Fill Handle

b)

Active Cell

c)

Cell

d)

Row

3.

These are called___________?

a)

Sheet Tabs

b)

Spread sheets

c)

Work books

d)

Sheets Menu

4.

An Excel file is called_____________?

a)

Workbook

b)

Worksheet

c)

Spread sheets

d)

Excel

5.

This is a ___________?

a)

Group

b)

Ribbon

c)

Tab

d)

None of above

6.

This is the __________?

a)

Title bar

b)

Entry bar

c)

Tab

d)

None of above

7.

Name the active cell______?

a)

C5

b)

B4

c)

C6

d)

D6

8.

Ctrl + N is a shortcut for_________?

a)

Creating a new Workbook

b)

Saving a workbook

c)

Insert a new worksheet

d)

Opening an existing worksheet

9.

Which short cut is used to close excel application?

a)

Alt + F4

b)

Alt + F5

c)

Ctrl + F4

d)

Alt + Q

10.

Shortcut key for bringing a disappeared ribbon?

a)

Ctrl + F1

b)

Alt + F1

c)

Ctrl + Alt + F1

d)

Alt + F4

11.

Short Cut key to open an existing Excel file?

a)

Ctrl + O

b)

Ctrl + N

c)

Windows + R

d)

Alt + O

12.

Every Formula in MS Excel must begin with _______?

a)

An Equal Sign

b)

An () sign

c)

A Plus Sign

d)

A > Sign

13.

What are the shortcut keys for AutoSum?

a)

Alt + =

b)

Ctrl + =

c)

Ctrl +S

d)

Alt + A

14.

What are the keyboard shortcut keys to edit formula in a cell?

a)

F2

b)

F1

c)

Alt + F2

d)

Ctrl + F2

15.

What would be a correct formula for sum in excel?

a)

=SUM(B3:B9)

b)

=SUMB3+B9

c)

SUM(B3:B9)

d)

=ADD(B3:B9)

16.

Microsoft Excel is what type of software?

a)

Spreadsheet

b)

Drawing

c)

Word Processing

d)

Presentation

17.

To move to the previous sheet

a)

Ctrl + PageDown

b)

Ctrl + W

c)

Ctrl + PageUp

18.

To go the Formula tab

a)

Ctrl + O

b)

Alt + W

c)

Alt + M

19.

To hide a selected column

a)

Ctrl + 0

b)

Ctrl + Shift + 0

c)

Ctrl + 9

20.

To hide selected row

a)

Ctrl + Space

b)

Ctrl + 9

c)

Ctrl + 0

21.

To select the entire column

a)

Ctrl + Shift + arrow

b)

Shift + Space

c)

Ctrl + Space

22.

To select the entire row

a)

Ctrl + Space

b)

Shift + Space

c)

Shift + Space, Ctrl + - 

23.

To apTo insert current time

a)

Ctrl + Shift + $

b)

Ctrl + Shift + %

c)

Ctrl + Shift + :

24.

To insert a hyperlink

a)

Ctrl + K

b)

Ctrl + H

c)

Ctrl + L

25.

How do you open the "Find and Replace" dialog in Excel?

a)

Ctrl + F

b)

Ctrl + R

c)

Ctrl + G

d)

Ctrl + H

26.

Which key would you press to select random cells as shown?

a)

Shift

b)

Control

c)

Escape

d)

Backspace

27.
In Excel, rows 
a)
are horizontal and represented by a letter
b)
are horizontal and represented by a number
c)
are vertical and represented by a number
d)
are vertical and represented by a letter
28.
What is circled?
a)
function button
b)
name box
c)
cell reference
d)
formula bar
29.
A group of selected cells is called the
a)
Cell Block
b)
Multi-cell
c)
Range
30.

Which option allows you to sort data in Excel?

a)

a) Right-click and select "Sort"

b)

b) Use the "Sort" option under the "Insert" tab

c)

c) Press Ctrl + S

d)

d) Shift +S

31.

This is a_____________?

a)

Column

b)

Row

c)

Cell

d)

Range

32.

The area within the red box is called_______?

a)

Fill Handle

b)

Active Cell

c)

Cell

d)

Row

33.

These are called___________?

a)

Sheet Tabs

b)

Spread sheets

c)

Work books

d)

Sheets Menu

34.

An Excel file is called_____________?

a)

Workbook

b)

Worksheet

c)

Spread sheets

d)

Excel

35.

This is a ___________?

a)

Group

b)

Ribbon

c)

Tab

d)

None of above

36.

This is the __________?

a)

Title bar

b)

Entry bar

c)

Tab

d)

None of above

37.

Name the active cell______?

a)

C5

b)

B4

c)

C6

d)

D6

38.

Ctrl + N is a shortcut for_________?

a)

Creating a new Workbook

b)

Saving a workbook

c)

Insert a new worksheet

d)

Opening an existing worksheet

39.

Which short cut is used to close excel application?

a)

Alt + F4

b)

Alt + F5

c)

Ctrl + F4

d)

Alt + Q

40.

Shortcut key for bringing a disappeared ribbon?

a)

Ctrl + F1

b)

Alt + F1

c)

Ctrl + Alt + F1

d)

Alt + F4

41.

Short Cut key to open an existing Excel file?

a)

Ctrl + O

b)

Ctrl + N

c)

Windows + R

d)

Alt + O

42.

Every Formula in MS Excel must begin with _______?

a)

An Equal Sign

b)

An () sign

c)

A Plus Sign

d)

A > Sign

43.

What are the shortcut keys for AutoSum?

a)

Alt + =

b)

Ctrl + =

c)

Ctrl +S

d)

Alt + A

44.

What are the keyboard shortcut keys to edit formula in a cell?

a)

F2

b)

F1

c)

Alt + F2

d)

Ctrl + F2

45.

What would be a correct formula for sum in excel?

a)

=SUM(B3:B9)

b)

=SUMB3+B9

c)

SUM(B3:B9)

d)

=ADD(B3:B9)

46.

Microsoft Excel is what type of software?

a)

Spreadsheet

b)

Drawing

c)

Word Processing

d)

Presentation

47.

To move to the previous sheet

a)

Ctrl + PageDown

b)

Ctrl + W

c)

Ctrl + PageUp

48.

To go the Formula tab

a)

Ctrl + O

b)

Alt + W

c)

Alt + M

49.

To hide a selected column

a)

Ctrl + 0

b)

Ctrl + Shift + 0

c)

Ctrl + 9

50.

To hide selected row

a)

Ctrl + Space

b)

Ctrl + 9

c)

Ctrl + 0

51.

To select the entire column

a)

Ctrl + Shift + arrow

b)

Shift + Space

c)

Ctrl + Space

52.

To select the entire row

a)

Ctrl + Space

b)

Shift + Space

c)

Shift + Space, Ctrl + - 

53.

To apTo insert current time

a)

Ctrl + Shift + $

b)

Ctrl + Shift + %

c)

Ctrl + Shift + :

54.

To insert a hyperlink

a)

Ctrl + K

b)

Ctrl + H

c)

Ctrl + L

55.

How do you open the "Find and Replace" dialog in Excel?

a)

Ctrl + F

b)

Ctrl + R

c)

Ctrl + G

d)

Ctrl + H

56.

Which key would you press to select random cells as shown?

a)

Shift

b)

Control

c)

Escape

d)

Backspace

57.
In Excel, rows 
a)
are horizontal and represented by a letter
b)
are horizontal and represented by a number
c)
are vertical and represented by a number
d)
are vertical and represented by a letter
58.
What is circled?
a)
function button
b)
name box
c)
cell reference
d)
formula bar
59.
A group of selected cells is called the
a)
Cell Block
b)
Multi-cell
c)
Range
60.

Which option allows you to sort data in Excel?

a)

a) Right-click and select "Sort"

b)

b) Use the "Sort" option under the "Insert" tab

c)

c) Press Ctrl + S

d)

d) Shift +S

61.

The function that lets you add up a range of cells or values

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

62.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

63.

What function was used to find the highest grade?

a)

average

b)

min

c)

sum

d)

max

64.

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

a)

user-defined functions

b)

online functions

c)

table functions

d)

predefined functions

65.

All formulas used within the table are seen on the __________

a)

cells

b)

cell reference

c)

name box

d)

formula bar

66.

The function COUNT is specific for ___________

a)

counting cells

b)

counting numbers

c)

counting text

d)

counting tables

67.

To display the Letter Grade Equivalent, we can use the ___ function.

a)

if

b)

count

c)

average

d)

sum

68.
In the picture, why is D2 through D5 placed in paranthesis?
a)
So Excel knows to total the cells before performing the next operation.
b)
So the total of the cells can be multiplied rather than added.
69.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
70.
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
a)
relative
b)
relational
71.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
72.

What does the Max formula do?

a)

Returns the highest three values in a set of values and ignores text.

b)

Returns the largest value in a set of values and ignores text.

c)

Returns the text that you are searching for.

d)

Returns the smallest value in a set of values and ignores text.

73.

What does the Min formula return?

a)

Returns the smallest three numbers form a set and ignores text.

b)

Returns the smallest value in a set of values and ignores text.

c)

Returns the largest three numbers form a set and ignores text.

d)

Returns the largest value in a set of values and ignores text.

74.

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.

75.

Which operator is used to multiply in Excel?

a)

+

b)

-

c)

/

d)

*

76.

All formulas begin with a(n) _______________.

a)

&

b)

=

c)

+

d)

#

77.

Excel will display _______________________ if the cell is not wide enough.

a)

******

b)

^^^^^

c)

######

d)

>>>>>

78.

Formulas can be copied to adjacent cells with the ____________.

a)

Fill handle

b)

PgDn Key

c)

Function key F4

d)

None of the above

79.

To edit a formula you

a)

Double-click the cell

b)

Click in the formula bar

c)

Press F2

d)

All are correct

80.

Answer =2+3*3-2

a)

9

b)

10

c)

11

d)

12

81.

Answer =3+5*(6-2)

a)

23

b)

32

c)

31

d)

64

82.

__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.

a)

Formula

b)

Calculation

c)

Cell address

d)

None of the above

83.

There are two types of references.

a)

Relative and Dependent

b)

Relative and Proportionate

c)

Absolute and Dominant

d)

Relative and Absolute

84.

A predefined formula that performs calculations using specific values in a particular order.

a)

Function

b)

Reference

c)

Chart

85.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
86.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
87.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
88.

What text formula joins the text from two or more cells?

a)

concatenate

b)

proper

c)

left

d)

e=mc2

89.

Which formula will calculate the average based on a condition? (return the average of sales if over $20)

a)

average

b)

countif

c)

averageif

d)

sumif

90.

Which formula would you use to calculate how many sales are over $20 from a series.

a)

sum

b)

sumif

c)

count

d)

countif

91.

Which formula will automatically capitalize the first letter of a word?

a)

abra-ka-dabra

b)

proper

c)

capitalize

d)

upper-case

92.

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

a)

format cell

b)

conditional formatting

c)

fill color

d)

magic cell

93.

Which tab contains the tool "Freeze Panes"?

a)

Home

b)

Page Layout

c)

View

d)

Review

94.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
95.
_____ are vertical. 
a)
Rows
b)
Columns
96.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
97.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
98.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
99.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
100.
What allow quickly apply the content for one cell to another cell?
a)
Active cell
b)
Autocell
c)
Auto sum
d)
Auto Fill

Similar Resources on Wayground

PRETEST EXCEL & SCRATCH

100 questions

PRETEST EXCEL & SCRATCH

quiz

Worksheet

•

9th - 12th Grade

Ulangan Informatika Kelas 7 Sem 1

100 questions

Ulangan Informatika Kelas 7 Sem 1

quiz

Worksheet

•

7th Grade - University

Latihan USP

100 questions

Latihan USP

quiz

Worksheet

•

9th - 12th Grade

AWS Cloud Practitioner

103 questions

AWS Cloud Practitioner

quiz

Worksheet

•

9th - 12th Grade

ميزات التصميم ثنائي الأبعاد والتصميم ثلاثي الأبعاد

99 questions

ميزات التصميم ثنائي الأبعاد والتصميم ثلاثي الأبعاد

quiz

Worksheet

•

6th Grade - University

Financial Literacy LIFE TEST

100 questions

Financial Literacy LIFE TEST

quiz

Worksheet

•

8th - 12th Grade

X TKJ 1 ( 23-11-2023 )

100 questions

X TKJ 1 ( 23-11-2023 )

quiz

Worksheet

•

10th Grade

PTS INFORMATIKA 2023 - GENAP

100 questions

PTS INFORMATIKA 2023 - GENAP

quiz

Worksheet

•

10th Grade