Font size
WorksheetsMS Excel
Total questions: 50
Worksheet time: 50mins
can you make chart in Ms Excel ?
yes
no
sometimes
impossible
The main reason of using Microsoft Excel is to create ...
spreadsheets
flyers
word processing documents
pictures
One Excel workbook may have many sheets ?
True
False
When you make many charts from one set of data, you should open many Excel sheets ?
True
False
a way to rename a sheet is ?
right click --> Rename
click on the sheet and add a chart title
rename the whole spreadsheet document
right click --> Delete
Which tab in the ribbon do you click to insert a chart?
home
insert
view
data
How are rows designated ?
Circles
Numbers
Letters
Stars
To auto-fill the formula down a column you...?
Type the formula again
Click in the bottom right corner of the cell and drag down
Copy and paste the formulais
In an Excel formula which symbol is used to SUM?
+
=
/
*
What symbol do all formulas start with?
*
=
+
/
The _____________ are represented by letters, and run vertical on the spreadsheet ?
rows
boxes
columns
cells
The ___________ are represented by numbers, and run horizontal ?
row
cells
column
tables
What function can be used to find the largest number in a range of numbers ?
BIGGEST
MAX
BEST
MOST
What does it mean to merge cells?
centre the contents of the cells
combine 2 or more cells into a single cell
split a single cell into 2 or more cell
apply a border around a set of cells
You can select data in an Excel sheet and turn it into a chart ?
TRUE
FALSE
Why would you want to change the column width ?
make sure headings are always visible when scrolling
make sure the cells are always visible when scrolling
make sure all of the information in the column is visible
draw attention to the data in those cells
Another name for an excel file ؟
new page
workbook
document
slide
You can add, delete, and rename a sheet tab ?
TRUE
FALSE
###### means ?
Misspelled something
number wrong
The cell is not wider enough
incorrect word
When putting in a formula, does it show when you print it out ?
YES
NO
the Data can be insert into Excel in boxes called ?
Graphs
Cells
Info Boxs
Drop Boxs
When you open Excel it opens up a blank ___________?
Workbook
Mathbook
Wordbook
Mathsheet
Which cursor below is used to drag columns to make them wider?
A
B
C
Which letter on the image is a Cell?
A
B
C
D
Which letter on the image is the CELL NAME BOX ?
A
B
C
D
Which Pointer do you need to select cells?
A
B
C
What function should be entered to calculate the total ?
AVERAGE
MIN
MAX
SUM
Which of the following is an option for changing a columns width?
Auto fit Column Width
Using the Format Button to change Column WidthT
Placing the cursor in between two columns and dragging it
All of these
he following is a one of the rules in conditional formatting command ?
submit
greater than
protect
font
which one from the following is conditional formatting list ?
text
data bars
highlight
cell
Which of the following domains is written in the proper format?
(6C:C14)
(C6-C14)
(6C-C14)
(C6:C14)
If you want to colour several cells that contain the title, you would highlight ?
The whole row
The range of cells
The whole column
The sheet
MAX, MIN, AVG and SUM are all _________ ?
Letters
texts
Symbols
Functions
Most software, including Excel, have DEFAULT settings. What does DEFAULT mean?
Secret
Automatic
Combined
Delete
In Excel, two or more cells can be combined into one cell. This is called____________. ?
Merge
Auto-Fit
Join
AutoSum
To change the way a text looks without changing the actual text. ?
Copy
Paste
Edit
Format
To add a row or column between another row or column. ?
Delete
Insert
Erase
Merge
To make a chart you must :
Click Insert
selsect all information that you want on the chart
Choose a chart
All of the above
what kind of charts can you add in excel?
none. you cant put charts in excel.
column and line
bar and pie
area and scatter
can you add more elements to your chart ?
sometimes
yes
no
What does this tool do?
colors the background of the selected cells.
nothing
changes the font color
Which letter on the image is a Column?
A
B
C
D
What is the address of the currently selected cell?
D3
B3
3B
There
Which of the following buttons would you use to turn a number in a cell into a percentage?
$
%
,
What are the different vertical alignment options in Excel?
High, Medium, Low
Left, Right, Center
Front and Back
Top, Middle, Bottom
When you use the Cut command the information is immediately removed from the Cells. ?
TRUE
FALSE
What is D?
name box
formula bar
columns
cell
What is A?
formula bar
cell
function key
range
What is H?
active cell
range
row
What is F ?
group of columns
group of rows
group of cells
