Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Tap Tap ur Brain

Total questions: 20

Worksheet time: 7mins

Name
Class
Date
1.
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
2.
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
3.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
4.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
5.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
6.
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
7.
If a column has joint-data (such as last name, first name), you can automatically "pull" sections of the data into a new column by using:
a)
Flashfill
b)
Autofill
c)
Merge & Center
d)
Copy and Paste
8.
To quickly highlight an entire range within a column, you can click on the first cell of that range and:
a)
Press Ctrl + Shift + ↓
b)
Press Ctrl + Alt + ↓
c)
Double-click cell border
d)
Hold the shift key
9.

The absolute cell reference uses which symbol:

a)

$

b)

%

c)

*

d)

&

10.
When using the SUBTOTAL command, you must sort by the column you are wanting to subtotal.
a)
True
b)
False
11.

To combine text that is in two different cells, use the formula:

a)

COMBINE

b)

MATCH

c)

CONCATENATE

d)

SUBTOTAL

12.

To add a special sort order to a “Sort By” list, you would use:

a)

SORT A to Z

b)

SUBTOTAL

c)

FILTERS

d)

CUSTOM SORT

13.

Cell A2 contains the following e-mail address: support@excel-skills.com


Cell B2 contains the following formula: =MID(A2,FIND(“@”,A2)+1,LEN(A2)-FIND(“@”,A2)+1)


What is the result of the formula in cell B2?

a)

@

b)

excel-skills.com

c)

support

d)

#VALUE

14.

To count how many cells have text in them, use the function:

a)

COUNT

b)

COUNTIF

c)

COUNTA

d)

SUMIF

15.

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

a)

colon

b)

semicolon

c)

comma

d)

dash

16.

Suppose cell B2 in a spreadsheet contains the formula:

=if(A1>100,"bazinga","zippo") If cell A1 contains the value 425, what value appears in cell B2?

a)

zippo

b)

425

c)

bazinga

d)

B2 is blank

17.

GoTo Special can be used to

a)

find blank cells

b)

copy range with hidden cells

c)

find specific format of cells

d)

find nonblank cells

18.

PROPER function converts string to

a)

lower case

b)

upper case

c)

first letter of a word to lower and others to upper case

d)

first letter of a word to upper and others to lower case

19.

Which of these charts does not exist in MS Excel

a)

A. Scatter

b)

B. Line

c)

C. Doughnut

d)

D. Graph

20.

........... is a visual representation of data from a worksheet

a)

Cell

b)

Row

c)

Function

d)

Chart

Similar Resources on Wayground

DBZ Quiz

25 questions

DBZ Quiz

quiz

Worksheet

•

KG - Professional Dev...

JAVA - Arrays

15 questions

JAVA - Arrays

quiz

Worksheet

•

University - Professi...

Independence Day- Quiz

15 questions

Independence Day- Quiz

quiz

Worksheet

•

Professional Development

Basic Electricity

20 questions

Basic Electricity

quiz

Worksheet

•

Professional Development

HTML & CSS quiz

21 questions

HTML & CSS quiz

quiz

Worksheet

•

6th Grade - Professio...

International Women's Day 2019

15 questions

International Women's Day 2019

quiz

Worksheet

•

Professional Development

ACTIVE TRADER QUIZ (TOS)

20 questions

ACTIVE TRADER QUIZ (TOS)

quiz

Worksheet

•

Professional Development