wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel - Computer Fundamentals

Total questions: 54

Worksheet time: 2hrs 24mins

Name
Class
Date
1.

The symbol of greater than use in inserting text and numeric data.

a)

*

b)

>

c)

&

2.

Division symbol in spreadsheet.

a)

/

b)

+

c)

=

3.

Concatenation (joins text)

a)

/

b)

&

c)

*

4.

Exponentiation (raised to the power)

a)

=

b)

*

c)

^

5.

Multiplication symbol in Microsoft Excel

a)

&

b)

*

c)

^

6.

It is composed of a worksheet, which has thousands of cells that each have a name to help 

    the user find a specific cell easily.

a)

Microsoft Word

b)

Power Point Presentation

c)

HTML website

d)

Microsoft Excel

7.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Presentation Software

d)

Database Software

8.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

9.

In Excel, the name of the bar where information appears as you input data is called?

a)

File Bar

b)

Status Bar

c)

Formula Bar

d)

Help Bar

10.

What function in MS Excel will be used to easily know if the students are pass or fail your subjects?

a)

Sum

b)

If

c)

Average

d)

Frequency

11.

What do we need to click to create a new worksheet in our workbook?

a)

active cell

b)

new sheet button

c)

sheet tab

12.

What do we call the currently selected cell with thick green borders?

a)

active cell

b)

name box

c)

rows

13.

What do we call the horizontal line of cells labeled using numbers?

a)

horizontal

b)

rows

c)

column

14.

What do we call the vertical lines of cells labeled using letters?

a)

column

b)

rows

c)

name box

15.

Where does the file name of the active workbook will appear once we open it?

a)

ribbon

b)

title bar

c)

workbook

16.

An Excel function to get data from a table organized vertically.

a)

vlookups

b)

index match

c)

index finger

d)

xlookups

17.

One of the excel functions to join two or more text strings into one string.

a)

Merge

b)

Concatenate

c)

Paste

d)

Vlookups

18.

An Excel file format extension is

a)

doc

b)

xls

c)

txt

d)

mp3

19.

The intersection of a column and a row is called a __________.

a)

Four-way Stop

b)

Formula Bar

c)

Cell

d)

Template

20.

Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.

a)

Enter Keys

b)

Arrow Keys

c)

Piano Keys

d)

Tab Key

21.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

22.

The cell address of the highlighted cell is

a)

C

b)

4

c)

A4

d)

C4

23.

What does the indicated icon do in the red box?

a)

Apply underline

b)

Apply italic

c)

Make text bigger

d)

Apply bold

24.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

25.

To exit an active formula, you always click out of the current cell?

a)

True

b)

False

26.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

27.

In Excel, rows are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

28.

Adding two cells,

a)

A1+A3=SUM

b)

SUM(_)

c)

=SUM(A1+A3)

d)

Total

29.

Sum of all number divided by amount of number

a)

maximum

b)

median

c)

minimum

d)

average

30.

What function adds all of the numbers in a range of cells?

a)

Calculate

b)

Compute

c)

Sum

d)

Max

31.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
32.
Can you format text with Excel
a)
Yes
b)
No
33.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
34.
Excel would be the ideal program to type out a book report.
a)
True
b)
False
35.
You can use the Auto Sum Key ∑ to subtract numbers.
a)
True
b)
False
36.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
37.
To accept a formula in a cell, press the _________ key.  
a)
Tab
b)
Enter
c)
Ctrl
d)
Shift
38.
EACH PAGE IS CALLED A SPREADSHEET
a)
TRUE
b)
FALSE
39.
=A1+5
a)
Formula
b)
Function
40.
Use the ___ function to display the highest value in a range. 
a)
MAX
b)
MIN
c)
both choices
d)
none of the choices
41.
I totally messed up what I was working on. I need to press ________ to Undo what I did.
a)
Ctrl + Z
b)
Ctrl + U
c)
Ctrl + Y
d)
Ctrl + R
42.
I went back too far. I need to press ________ to Redo what I need.
a)
Ctrl + Z
b)
Ctrl + U
c)
Ctrl + Y
d)
Ctrl + R
43.
I am finished and ready to print. I can use _______ to get to the print screen.
a)
Ctrl + D
b)
Ctrl + O
c)
Ctrl + P
d)
Ctrl + W
44.
To arrange information by kinds or classes, or in a particular order:
a)
enter
b)
tab
c)
sort
d)
none of the above
45.

4. Which of the following is an absolute cell reference?

a)

a. #A2

b)

b. $A$2

c)

c. A:2

d)

d. A2

46.

6. What value would Excel return for this formula? =(82-32)/5+8*2

a)

a. 36

b)

b. 26

c)

c. 7.69

d)

d. 91.6

47.

You can use the drag and drop method to

a)

a. Copy cell contents

b)

b. Move cell contents

c)

c. Add cell contents

d)

d. Both ‘a’ and ‘b’

48.

What does this symbol represent in MS Excel?

a)

a. Subtract

b)

b. AutoSum

c)

c. formula

d)

d. average

49.

Order of operation in Excel

a)

a. DASEMP

b)

b.EPSDAM

c)

c. PEMDAS

d)

d. PEMDSA

50.
Which is an example of a cell address?
a)
126
b)
A9
c)
=SUM
d)
76/65
51.
What is an example of a cell range?
a)
65-75
b)
=SUM(A1)
c)
1295
d)
(C1:C9)
52.
A column is vertical (up and down)
a)
true
b)
false
53.
A row is horizontal (across)
a)
True
b)
False
54.
* (multiplication) / (division) + (addition) - (minus) signs are all ......
a)
values
b)
cells
c)
ranges
d)
mathematical operations

Similar Resources on Wayground

CUESTIONARIO DE REPASO DE HACKING ÉTICO

50 questions

CUESTIONARIO DE REPASO DE HACKING ÉTICO

quiz

Worksheet

•

Professional Development

Information Storage & Management Assessment (Set A)

50 questions

Information Storage & Management Assessment (Set A)

quiz

Worksheet

•

Professional Development

ITF+ Practice Exam #1

56 questions

ITF+ Practice Exam #1

quiz

Worksheet

•

Professional Development

Python CH1-3 Review

59 questions

Python CH1-3 Review

quiz

Worksheet

•

8th Grade - Professio...

Employbility skills

50 questions

Employbility skills

quiz

Worksheet

•

Professional Development

AZ-900 Practice Test 3

51 questions

AZ-900 Practice Test 3

quiz

Worksheet

•

Professional Development

Web Design (HTML + CSS)

54 questions

Web Design (HTML + CSS)

quiz

Worksheet

•

Professional Development

HTML/CSS контрольный

50 questions

HTML/CSS контрольный

quiz

Worksheet

•

Professional Development