Excel Class 6 AND 1

Excel Class 6 and S1

by Costas Pringipas

Fill in the Blank

a spreadsheet is made up of columns and

​Excel 2019

​Spreadsheet program in MS Office

Fill in the Blank

an example of a spreadsheet software is

​in a spreadsheet cell, you are allowed to enter

​text, numbers and f________

Multiple Choice

A row is a vertical reference in a spreadsheet.

• True
• False

workbook

Multiple Choice

Numbers identified in spreadsheets that are used in calculations are called _____.

• gridlines
• selecting
• values
• graph

Multiple Choice

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

• gridline
• cell
• value
• formula

Multiple Choice

A mathematical operation is called a _____.

• formula
• range
• label
• graph

Multiple Choice

Highlighting items within a spreadsheet is called selecting.

• True
• False

Multiple Choice

A graph is a visual representation of data within a spreadsheet.

• True
• False

Multiple Choice

The letters in Excel represent the...

• Rows

• Columns

• Cells

• Data

Multiple Choice

The numbers in Excel represent the...

• Rows

• Columns

• Cells

• Data

Multiple Choice

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

• Main cell

• Open cell

• Active cell

• Absolute cell

Multiple Choice

The intersection of a row and column.

• column

• row

• cell

• active cell

Multiple Choice

Excel is part of

• Access
• Microsoft Office
• PowerPoint

Multiple Choice

Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.


Which of the following suggestions would help Luisa?

• Make the cell wider
• Change the number formatting in the cell
• Change the font format in the cell
• Delete the data and re-type it

Multiple Choice

To allow you to evenly distribute a title over a table of numbers, use the

• Center button
• Merge and Center button
• Merge cells only button

Multiple Choice

How do you change column width to fit the contents?

• Single-click the boundary to the left of the column heading
• Double-click the boundary to the right of the column heading
• Press ALT and single-click anywhere in the column

Multiple Choice

The cell address of the highlighted cell is

• C

• 4

• A4

• C4

Multiple Choice

These are known as

• workbooks

• worksheets

• formula bar

• cell

Multiple Choice

What does the indicated icon do in the red box?

• Apply underline

• Apply italic

• Make text bigger

• Apply bold

Multiple Choice

A formula in the spreadsheet should always start with 

• a plus sign
• an asterisk
• an equals sign
• a capital letter

Multiple Choice

Which of these would add up the numbers from A3 to A6 

• +(A3:A6)
• =(A3:A6)
• =(Ave(a3:a6))
• =Sum(A3:A6)

Multiple Choice

A combination of numbers and symbols used to express a calculation. Always begins with an = sign.

• Cell Address
• Worksheet
• Formula

Multiple Choice

True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?

• false
• true

Multiple Choice

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column