wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Computer Midterm Test for M1 - Term 2

Total questions: 40

Worksheet time: 48mins

Name
Class
Date
1.
IF statements can be written to carry out an action, such as: IF a value in a cell is greater than or equal to another value, insert the word "Pass" in a cell.
a)
True
b)
False
c)
x
d)
x
2.

The shortcut key for AutoSUM is:

a)

Ctrl + =

b)

Alt =

c)

= SUM

d)

Shift +

3.

The absolute cell reference uses which symbol:

a)

$

b)

%

c)

*

d)

&

4.

In formulas, spaces count as characters.

a)

TRUE

b)

FALSE

5.

When creating an IF function, a ____ separates the logical test from the value if true/false.

a)

colon

b)

semicolon

c)

comma

d)

dash

6.
it allows you to make logical comparisons between a value and what you expect
a)
IF condition
b)
vlookup
c)
sum
d)
count
7.
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
8.
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
9.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
10.
When entering numbers in  Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
11.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
12.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
13.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
14.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

15.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

16.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

17.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

18.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

19.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

20.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
21.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
22.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
23.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
24.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
25.
What is the Formula sign for multiply? 
a)
\
b)
*
26.

Excel would be the ideal program to type a book report?

a)

False

b)

True

27.

You can use the auto-sum key to subtract numbers.

a)

True

b)

False

28.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
29.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
30.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
31.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
32.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
33.
เมื่อต้องการใช้สูตรคำนวณ จะต้องเริ่มด้วยเครื่องหมายใด เสมอ
a)
=
b)
-
c)
+
d)
==
34.
เครื่องหมายคำนวณทางคณิตศาสตร์ข้อใด ที่ใช้สำหรับการคูณ
a)
*
b)
x
c)
+
d)
&
35.
a)
=if(D3<80,"A","F")
b)
=if(D3>80,"A","F")
c)
=if(D3>=80,"A","F")
d)
=if(D3<=80,"A","F")
36.
Cell C1 contains the formula =A1+B1. If you copy the formula in C1 to cell C2, which of the following formulas will appear in cell C2?
a)
=A1+B1
b)
=C1+C2
c)
=A2+B2
d)
=B2+B3
37.
ไฟล์งาน Microsoft Excel ที่บันทึกแล้วจะมีนามสกุลใด
a)
.ppt
b)
.doc
c)
.xlsx
d)
.mdb
38.
การหาค่าเฉลี่ยใช้คำสั่งอะไร
a)
AVERAGE
b)
STDEV
c)
max
d)
sum
39.
หากข้อความที่เราพิมพ์ลงในเซลล์มีความกว้างเกินขนาดของเซลล์ Excel จะไม่สามารถแสดงข้อความที่พิมพ์ออกมาได้ แต่จะปรากฏข้อความ ใดแทน
a)
%%%%%
b)
#####
c)
!!!!!
d)
*****
40.

จากภาพตรงกับข้อใด

a)

เปิดงาน

b)

บันทึก

c)

เรียกคืน

d)

ลบ

Similar Resources on Wayground

Introduction to Typing

45 questions

Introduction to Typing

quiz

Worksheet

•

7th - 12th Grade

Movies

44 questions

Movies

quiz

Worksheet

•

2nd Grade - Professio...

Computer Exam Term 1

40 questions

Computer Exam Term 1

quiz

Worksheet

•

7th Grade

6th Grade ICT 3rd Quarter REview

40 questions

6th Grade ICT 3rd Quarter REview

quiz

Worksheet

•

6th - 8th Grade

TIN 7 - ÔN TẬP KT CUỐI KỲ I 23-24

40 questions

TIN 7 - ÔN TẬP KT CUỐI KỲ I 23-24

quiz

Worksheet

•

7th Grade

Python Assessment 1

40 questions

Python Assessment 1

quiz

Worksheet

•

7th - 9th Grade

Aplicații multimedia test clasa a 7 a

35 questions

Aplicații multimedia test clasa a 7 a

quiz

Worksheet

•

7th Grade

ICT - Revision

40 questions

ICT - Revision

quiz

Worksheet

•

5th - 8th Grade