wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

BELTRON EXAM

Total questions: 56

Worksheet time: 11mins

Name
Class
Date
1.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
2.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
3.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
4.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
5.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
6.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
7.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
8.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
9.
To see what math formulas are used in a cell, click on the
a)
Show formulas button
b)
Show the math button
c)
the auto sum button
10.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
11.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
12.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
13.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
14.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
15.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
16.

__________________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

17.

There are two types of references.

a)

Relative and Dependent

b)

Relative and Proportionate

c)

Absolute and Dominant

d)

Relative and Absolute

18.

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

a)

Function

b)

Reference

c)

Chart

19.

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.

20.

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.

21.

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.

22.

What does the Average formula return?

a)

Returns the lowest argument.

b)

Returns the middle argument.

c)

Returns the three highest arguments.

d)

Returns the mean of all its arguments.

23.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
24.
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.
25.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
26.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
27.
Numbers in Excel is automatically aligned  ____.
a)
Right
b)
Left
c)
Center
d)
Justify
28.
When making a chart, you always highlight the entire spreadsheet.
a)
True
b)
False
29.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
30.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
31.
The area within the red box is called
a)
Active Cell
b)
Fill Handle
c)
Cell
d)
Row
32.

Which new workbook option displays the title, Book1, when it is created?

a)

A blank workbook.

b)

A workbook created from a template.

33.

Why would you enter labels into the worksheet?

a)

Labels should be used when you need to enter text only.

b)

Labels are entered for report titles or column headings only.

c)

Labels identify the values and help outline the mathematical relationships.

d)

d.Labels identify where and how the values should appear.

34.

To select an entire row, where would you click?

a)

The cell in column A for that row.

b)

Click the row header for the row you want to select.

c)

Click the column header where your cell is in the row you want to select.

d)

Click the row number in the Name Box and press ENTER.

35.

What is an EXCEL Spreadsheet used to make?

a)

Calendar

b)

Publisher

c)

Graph

d)

Card

36.
Can be used travel from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
37.

What is the difference between a workbook and a worksheet?

a)

A workbook is the actual file that contains the worksheets, which turn contain the data.

b)

A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

38.

Which is the best way to set a column to a specific width?

a)

On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement.

b)

Press CTRL+W to specify the width for the column.

39.

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

a)
b)
c)
d)
40.

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

41.

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)

42.

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

43.

What is the name of this Cell ?

a)

6B

b)

A5

c)

6A

d)

B6

44.

What is the formula sign for multiply?

a)

/

b)

*

c)

=

d)

-

45.

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

a)
b)
c)
d)
46.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

47.
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
48.
This is the:
a)
title bar
b)
entry bar
c)
group
d)
none of the above
49.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
50.
This is a:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
51.
To create a hanging indent using shortcut keys, press..........
a)
ctrl+t
b)
ctrl+r
c)
ctrl+2
d)
ctrl+m
52.
The default font in word 2013 is usually..............
a)
Arial
b)
Tahoma
c)
Times New
d)
Calibri
53.
The ........... is the control center for word.
a)
Status bar
b)
Home Tab
c)
Ribbon
d)
Control
54.
To save a file, press the .......... keys.
a)
alt+end
b)
ctrl+z
c)
alt+z
d)
ctrl+s
55.
The ........... is a temporary windows storage area.
a)
clipboard
b)
copy and paste pane
c)
copyboard
d)
editing folder
56.
To create a hanging indent using shortcut keys, press..........
a)
ctrl+t
b)
ctrl+r
c)
ctrl+2
d)
ctrl+m

Similar Resources on Wayground

Apple Motion and Final Cut Pro X

60 questions

Apple Motion and Final Cut Pro X

quiz

Worksheet

•

10th - 12th Grade

Advanced HTML5 & CSS3 Part IV

55 questions

Advanced HTML5 & CSS3 Part IV

quiz

Worksheet

•

9th - 12th Grade

LATIHAN SOAL - MIKROTIK (XII TKJ A/XII TKJ B) SMK OANJATEK

60 questions

LATIHAN SOAL - MIKROTIK (XII TKJ A/XII TKJ B) SMK OANJATEK

quiz

Worksheet

•

12th Grade

#5 CIW Data Analyst - Certification Prep

54 questions

#5 CIW Data Analyst - Certification Prep

quiz

Worksheet

•

9th Grade - University

Ulangan Harian

60 questions

Ulangan Harian

quiz

Worksheet

•

12th Grade

on tap cuoi ki 1 tin 12

60 questions

on tap cuoi ki 1 tin 12

quiz

Worksheet

•

12th Grade

R093 iMedia Mix Up#2

51 questions

R093 iMedia Mix Up#2

quiz

Worksheet

•

9th - 12th Grade

Media and Information Literacy (Generated)

52 questions

Media and Information Literacy (Generated)

quiz

Worksheet

•

12th Grade