wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Test 11/15

Total questions: 58

Worksheet time: 51mins

Name
Class
Date
1.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
2.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

3.

A __ is a document that stores data in a grid of horizontal rows and vertical columns.

a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
4.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
5.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
6.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
7.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
8.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
9.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
10.
To create a formula, you first:
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
11.
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)
12.
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
13.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
14.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
15.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
16.

Which of these symbols is used for divide on a computer?

a)

\

b)

*

c)

/

d)

|

17.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
18.

Style attributes include fonts and font sizes, number formats, and borders and shading.

a)

true

b)

false

19.

Which of the following indicates a proper cell address?

a)

3A

b)

:A3

c)

A3

d)

@A3

20.

Which of the following is the selection pointer?

a)
b)
c)
21.

Which of the following is the move handle?

a)
b)
c)
22.

If you have too much text and would like to display it on multiple lines of the same cell, you need to:

a)

Merge the cell

b)

Wrap the text

c)

Auto-fit the cell

d)

Resize the cell

23.

Combining multiple cells into a single cell is:

a)

Wrapping

b)

Re-sizing

c)

Merging

d)

Auto-fitting

24.

The name for an outline or grid around cells

a)

Margin

b)

Layout

c)

Wrap

d)

Border

25.

To enter text in a cell, you must first:

a)

Insert a text box

b)

Right click the cell

c)

Double click the cell

d)

Merge the cell

26.

To position text or data within a cell:

a)

Align

b)

Merge

c)

Wrap

d)

Format

27.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
28.

This is a valid simple formula

a)

A2+A4

b)

=AB3+Y5

c)

(a2*t3)/100

d)

=(a2*t3)/100

29.

What is the answer if the value in cell A5 is 75; C10 is 20; B23 is 15; E15 is 100; G20 is 5 and the formula is: =C10 + (A5 * G20)/ B23

a)

43

b)

55

c)

49.6

d)

45

30.

What function would you use to find the highest value in a range of cells?

a)

MIN

b)

MAX

c)

AVERAGE

d)

SUM

31.

Which of the following is used to create a chart in Excel?

a)

Insert

b)

Data

c)

Review

d)

Formulas

32.

What is the shortcut key to save a workbook in Excel?

a)

Ctrl + S

b)

Ctrl + P

c)

Ctrl + C

d)

Ctrl + V

33.

Which function is used to calculate the average of a range of cells?

a)

SUM

b)

AVERAGE

c)

COUNT

d)

MAX

34.

What is the default file extension for an Excel workbook?

a)

.xls

b)

.xlsx

c)

.docx

d)

.pptx

35.

Which formula was used on row 14 to calculate the numbers 3.8, 1.9, 2.3, 4.1, 1.6, & 3.15?

a)

SUM

b)

AVERAGE

c)

MINIMUM

d)

MAXIMUM

36.

Which formula was used in column I to add up the numbers in column I?

a)

SUM

b)

AVERAGE

c)

MINIMUM

d)

MAXIMUM

37.

Which formula was used on row 15 to calculate the numbers 1, 0, 0, 1, 0, & 1?

a)

SUM

b)

AVERAGE

c)

MINIMUM

d)

MAXIMUM

38.

What type of chart is in the picture?

a)

Line

b)

Pie

c)

Bar

39.

What type of chart is in the picture?

a)

Line

b)

Pie

c)

Bar

40.

What type of chart is in the picture?

a)

Line

b)

Pie

c)

Bar

41.

Data in a worksheet can be sorted.

If names are sorted in ascending order, this means that the names will be sorted this way...

a)

A to Z

b)

Z to A

42.

To insert a chart on a worksheet, the user must first do this...

a)

Select the data which will be in the chart, select Insert & then just choose the chart you want.

b)

Nothing. Just select Insert & then just choose the chart you want.

43.

How is the data arranged below?


100, 90, 80, 70, 60, 50

a)

Ascending Order

b)

Descending Order

44.
What is the formula for =sum(B2:B9)
a)
B1+B2+B3+B4
b)
=B2+B3+B4+B5+B6+B7+B8+B9
c)
B2+B3+B4+B5+B6+B7+B8+B9
d)
=B1+B2+B3+B4
45.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
46.
What would I use to combine cells A1:A9?
a)
adjust column width
b)
merge
c)
wrap text
47.

What is it called when you drag the lower right hand corner of a cells to put the formula in other cells?

a)

Fill handle

b)

Hide columns

c)

Paste transpose

d)

Wildcard

48.
Groups of cells are called:
a)
list
b)
range
c)
set
d)
None of these
49.

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

a)

SUM

b)

COUNT

c)

IF

d)

AVERAGE

50.

What is this icon?

a)

Sum

b)

AutoSum

c)

Insert Function

d)

Object

51.

What is the function used to count the number of cells that contain numbers in a range?

a)

MAX

b)

AVERAGE

c)

SUM

d)

COUNT

52.

What is the shortcut key to undo the last action in Excel?

a)

Ctrl + U

b)

Ctrl + X

c)

Ctrl + Y

d)

Ctrl + Z

53.

Which function is used to calculate the average of a range of cells?

a)

MIN

b)

MAX

c)

AVERAGE

d)

SUM

54.

What is the default alignment for text in an Excel cell?

a)

Justify

b)

Center

c)

Right

d)

Left

55.

Which of the following is a valid cell reference in Excel?

a)

11

b)

AA

c)

A1

d)

1A

56.

What is the shortcut key to save a workbook in Excel?

a)

Ctrl + S

b)

Ctrl + C

c)

Ctrl + V

d)

Ctrl + X

57.

What is the shortcut key to copy in Excel?

a)

Ctrl + V

b)

Ctrl + C

c)

Ctrl + Z

d)

Ctrl + X

58.

What is the name of the feature that allows you to quickly fill cells with repetitive or sequential data?

a)

AutoFill

b)

AutoSum

c)

AutoFormat

d)

AutoCorrect

Similar Resources on Wayground

Video Game Design/Programing 2nd SWT Review

63 questions

Video Game Design/Programing 2nd SWT Review

quiz

Worksheet

•

10th Grade

CPA for Sec 1

60 questions

CPA for Sec 1

quiz

Worksheet

•

12th Grade

CBT

60 questions

CBT

quiz

Worksheet

•

11th - 12th Grade

Computer ٍSkills- Chapter 3

62 questions

Computer ٍSkills- Chapter 3

quiz

Worksheet

•

1st Grade - University

KIỂM TRA HỌC KỲ 2 MÔN TIN KHỐI 10 - 45P

60 questions

KIỂM TRA HỌC KỲ 2 MÔN TIN KHỐI 10 - 45P

quiz

Worksheet

•

10th Grade

Week 7 - User Functions

54 questions

Week 7 - User Functions

quiz

Worksheet

•

9th - 12th Grade

Excel Lessons 4-6

53 questions

Excel Lessons 4-6

quiz

Worksheet

•

9th - 12th Grade

TIK KELAS 8 SEJARAH KOMPUTER

55 questions

TIK KELAS 8 SEJARAH KOMPUTER

quiz

Worksheet

•

2nd - 12th Grade