wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel - Basics

Total questions: 45

Worksheet time: 2hrs 35mins

Name
Class
Date
1.
Which one of the following is a spreadsheet application? 
a)
Microsoft Word
b)
Microsoft Powerpoint
c)
Microsoft Excel
d)
Microsoft Outlook
2.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
3.
Which button allows you to copy cell formats from one cell to another?
a)
Enter
b)
Autofit
c)
Format Painter
d)
Esc
4.
True or False.  If you choose a larger font size, the height of the row is automatically made taller.
a)
True
b)
False
5.
An example of a  range address.
a)
A1:B3
b)
A1;B3
c)
A1-B3
d)
A1=B3
6.
A formula in the spreadsheet should always start with 
a)
a plus sign
b)
an asterisk
c)
an equals sign
d)
a capital letter
7.
Which filename extension is used for Excel workbooks? 
a)
.com
b)
.xls
c)
.htm
d)
.doc
8.
In a spreadsheet formula which symbol is used to multiply? 
a)
+
b)
-
c)
*
d)
x
9.
What is the name given to the intersection of a row and a column in a spreadsheet? 
a)
cell
b)
block
c)
cube
d)
square
10.
Which direction do rows run in a spreadsheet? 
a)
vertical
b)
clockwise
c)
horizontal
d)
diagonal
11.
How are columns designated?
a)
Circles
b)
Letters
c)
Numbers
d)
Stars
12.
How are rows designated?
a)
Circles
b)
Letters
c)
Numbers
d)
Stars
13.
Which of these would add up the numbers from A3 to A6 
a)
+(A3:A6)
b)
=(A3:A6)
c)
=(Ave(a3:a6))
d)
=Sum(A3:A6)
14.
Which direction do columns run in a spreadsheet? 
a)
Vertical
b)
Counter-Clockwise
c)
Diagonal
d)
Horizontal
15.
Pressing ENTER moves the selection one cell to the right by default.
a)
True
b)
False
16.
The active cell is what is currently selected, where data is entered when you begin typing.
a)
True
b)
False
17.
What are lines that can be applied around worksheet cells or objects?
a)
Gridlines
b)
Borders
c)
Underlines
d)
Boundaries
18.
It is possible to type numbers and letters (words) into a cell.
a)
True
b)
False
19.

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

a)

File Bar

b)

Formula Bar

c)

Help Bar

d)

Window Bar

20.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Database Software

d)

Presentation Software

21.

Excel refers to files as...

a)

Presentations

b)

Databases

c)

Workbooks

d)

Documents

22.

The letters in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

23.

When creating a chart in Excel, what is the first thing you need to do?

a)

Select the data to be graphed.

b)

Select the Insert Tab

c)

Choose a chart from the ribbon

d)

Double click the active cell

24.

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

a)

Calculate

b)

Compute

c)

Sum

d)

Max

25.

To sort data in Excel, go to the __________ ribbon.

a)

Home

b)

Data

c)

Insert

d)

View

26.

What is the cell in the worksheet in which you can type data?

a)

Main cell

b)

Open cell

c)

Active cell

d)

Absolute cell

27.

Text in Excel is automatically aligned _____________.

a)

Right

b)

Left

c)

Center

d)

Justify

28.

If I want to find an average of cells A1 through A25, which formula would I use?

a)

=average(A1:A25)

b)

=avg(A1:A25)

c)

=average(A1-A25)

d)

=avg(A1-A25)

29.

Numbers in Excel are automatically aligned ____________?

a)

Left

b)

Right

c)

Center

d)

Justified

30.

The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.

a)

Autofill

b)

Copy and Paste

c)

Drag and Drop

d)

Typing

31.
Which is an example of a cell address?
a)
126
b)
A9
c)
=SUM
d)
75/65
32.
What combines one or more cells?
a)
merge
b)
wrap text
c)
cell address
33.

You can add, subtract, multiply and divide in excel.

a)

true

b)

false

34.

When you enter something into excel that WILL be used in calculation, it is considered a............

a)

value

b)

label

c)

word

d)

equal sign

35.

When you enter something into excel that WILL NOT be used in calculation, it is considered a.................

a)

value

b)

label

c)

equal sign

d)

formula

36.

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

a)

Active Cell

b)

Formula

c)

Cell

d)

Cell address

37.

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

a)

Formula

b)

Formula Bar

c)

Cell Address

d)

Cell Grid

38.

A combination of numbers and symbols used to express a calculation.

a)

Active Cell

b)

Label

c)

Formula Bar

d)

Formula

39.

A function that automatically identifies and adds ranges of cells in your worksheet.

a)

AutoSum

b)

AutoFill

c)

Cell Address

d)

Function

40.

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

a)

AutoSum

b)

Headings

c)

Cell

d)

AutoFill

41.

The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date.

a)

Row

b)

Column

c)

Headings

d)

Label

42.

A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.

a)

Formula Bar

b)

Formula

c)

Function

d)

Headings

43.

Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.

a)

Function

b)

Sheet Tabs

c)

Workbook

d)

Drag

44.

A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.

a)

File

b)

Workbook

c)

Formula Bar

d)

Function

45.

An Excel file/Google sheet that contains individual worksheets. Also called a spreadsheet file.

a)

Workbook

b)

Drag

c)

File

d)

Headings

Similar Resources on Wayground

City & Guilds Certificate in Network & Architecture Assessment

50 questions

City & Guilds Certificate in Network & Architecture Assessment

quiz

Worksheet

•

12th Grade

BAB 3 PERANGKAT KERAS KOMPUTER

41 questions

BAB 3 PERANGKAT KERAS KOMPUTER

quiz

Worksheet

•

9th - 12th Grade

Module 10

48 questions

Module 10

quiz

Worksheet

•

University

Loop Control Statement in C

41 questions

Loop Control Statement in C

quiz

Worksheet

•

University

Computer basics

50 questions

Computer basics

quiz

Worksheet

•

5th - 9th Grade

Python Basis (S3)

41 questions

Python Basis (S3)

quiz

Worksheet

•

9th Grade

Computer Fundamentals - Study Quiz

44 questions

Computer Fundamentals - Study Quiz

quiz

Worksheet

•

8th - 12th Grade

Year 9 end of year assessment

45 questions

Year 9 end of year assessment

quiz

Worksheet

•

10th Grade