wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Basics

Total questions: 30

Worksheet time: 17mins

Name
Class
Date
1.

What are the individual boxes in Excel called?

a)

Box

b)

Cells

c)

Columns

d)

Rows

2.

A page of cells is called a...

a)

Page

b)

Worksheet

c)

Spreadsheet

d)

None of the above

3.

A group of vertical cells is called a(n)...

a)

Row

b)

Column

c)

Spreadsheet

d)

Excel

4.

A group of horizontal cells is called a(n)...

a)

Row

b)

Column

c)

Spreadsheet

d)

Excel

5.

A cell's name includes...

a)

A letter

b)

A number

c)

A letter and number

d)

A shape

6.

What can you use to "unite"cells?

a)

Merge

b)

Merge and center

c)

Autosum

d)

Autofill

7.

What does Autosum do?

a)

Allows you to calculate formulas

b)

Gives you numbers to use in your document

c)

Multiplies all numbers on a spreadsheet

d)

Adds all numbers in a data set

8.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
9.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
10.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
11.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
12.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
13.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
14.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
15.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
16.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
17.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
18.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
19.

What are the commands placed inside the Quick Access Toolbar? Choose at least three (3).

a)

undo

b)

save

c)

print

d)

redo

20.

These are the vertical sets of rectangles labelled in alphabet.

a)

rows

b)

columns

c)

ribbon

d)

cells

21.

These are the horizontal blocks of cells labelled in numbers.

a)

MS Office Button

b)

cell

c)

columns

d)

rows

22.

It is the intersection between a row and a column.

a)

rows

b)

columns

c)

cell

d)

ribbon

23.

It lies at the intersection between a row and a column

a)

ribbon

b)

cell

c)

worksheet

d)

Quick Access toolbar

24.

What is the correct format in naming a cell?

a)

row number then column letter

b)

column letter then row number

c)

row letter then column number

d)

column number then row letter

25.

What is the extension of the MS-Excel 2016 file?

a)

.xlsx

b)

.xls

c)

.doc

d)

.docx

26.

How do you hide a column in Excel?

a)
Click on the 'Hide' button in the 'Home' tab.
b)
Press the 'Ctrl + H' shortcut key.
c)
Go to the 'Format' tab and select 'Hide Column'.
d)
Right-click on the column letter and select 'Hide'.
27.

On Excel 2007 , how do you freeze a group of rows so that when you scroll the rest of the worksheet, those rows are always visible?

a)
Select the rows you want to freeze, right-click and choose 'Freeze Panes' from the context menu.
b)
Go to the 'Format' tab, click on 'Freeze Panes', and select 'Freeze Rows' from the drop-down menu.
c)
Highlight the rows you want to freeze, go to the 'Layout' tab, click on 'Freeze Panes', and select 'Freeze Rows' from the drop-down menu.
d)
Select the row below the rows you want to freeze, go to the 'View' tab, click on 'Freeze Panes', and select 'Freeze Panes' from the drop-down menu.
28.

What is the quick access toolbar on Excel 2007?

a)
A toolbar for changing the font style and size.
b)
A toolbar for creating charts and graphs.
c)
A toolbar for sorting and filtering data.
d)
A customizable toolbar for frequently used commands.
29.

How do you configure in Excel 2007 the page setup options to print the worksheet gridlines.

a)

Go to the 'Page Layout' tab, select area to be printed then click on 'Print Area' in the 'Page Setup' group, and then select 'Print Gridlines'.

b)
Go to the 'File' tab, click on 'Print' in the 'Page Setup' group, and then select 'Print Gridlines'.
c)
Go to the 'Home' tab, click on 'Page Setup' in the 'Page Layout' group, and then select 'Print Gridlines'.
d)
Go to the 'Insert' tab, click on 'Page Layout' in the 'Page Setup' group, and then select 'Print Gridlines'.
30.

In Excel 2007 how you paste only the values of a range of cells and formatting into another range?

a)
Use the 'Copy' and 'Paste' commands to transfer both values and formatting
b)
Use the 'Paste Special' feature and select 'Formatting' option
c)
Use the 'Paste Special' feature and select 'Values' and 'Formats' options
d)
Use the 'Paste Special' feature and select 'Values' option

Similar Resources on Wayground

Computational Thinking, Algorithms & Flowcharts

28 questions

Computational Thinking, Algorithms & Flowcharts

quiz

Worksheet

•

8th - 12th Grade

Y7 Introduction to Computing Assessment

25 questions

Y7 Introduction to Computing Assessment

quiz

Worksheet

•

8th - 9th Grade

Year 8 - EOUT - Cyber Security - 2021/2022

30 questions

Year 8 - EOUT - Cyber Security - 2021/2022

quiz

Worksheet

•

8th Grade

Grade 4 - ICT - Review S1

28 questions

Grade 4 - ICT - Review S1

quiz

Worksheet

•

3rd - 10th Grade

7-րդ Համակարգչային հմտություններ

25 questions

7-րդ Համակարգչային հմտություններ

quiz

Worksheet

•

7th Grade

TIK Kelas 6

25 questions

TIK Kelas 6

quiz

Worksheet

•

1st - 10th Grade

Computer Knowledge Pretest

25 questions

Computer Knowledge Pretest

quiz

Worksheet

•

6th - 8th Grade

Networks - Chapter 8

25 questions

Networks - Chapter 8

quiz

Worksheet

•

8th Grade