It Application Tools Midterm Exam
It Application Tools Midterm Exam
It Application Tools Midterm Exam
True
False
True
False
3.
6
5
4 Series 1
3 Series 2
2 Series 3
1
0
Cat Cat Cat Cat
Bar chart
Line Graph
4. If text has already been entered in a column and you start typing in the same column. Excel will
suggest existing values that begin with what you have typed.
True
False
5. Clicking on cell C3 and clicking Freeze Panes will freeze the top 3 rows and the first 3 columns.
False
True
6. Cells D1, D2, D3, …… D20 are all in the same column
True
False
Select the range of cells and click on fill icon in the data tab
Right click an active cell and choose the fill handle from content menu
Click and drag the thick black cross on the right hand corner of active cell
9. How many different types of cursors are present while hovering over the data in a spreadsheet
Number value
Columns
Smartart
Pictures
Shapes
12. Which type of graph is the best to show the following data? How much a child grows between the
age of 1 and 7.
Pie
Bar
Graph
13. The cell address is where a row and columns intersect. The address is the ______ letter first and then
the________ number (e.g E7)
Row, column
Row, cell
Cell, column
Column, row
Select the range of cells and click on fill icon in the data tab
Right click an active cell and choose the fill handle from content menu
Click and drag the thick black cross on the right hand corner of active cell
True
False
16. The_____ box shows the address of the cell you have selected.
Name
Cell All
Cell A13
16,IS A
Workbook
WorkHOMEsheet
Balance sheet
Spreadsheet
20. Which of the following can change using the page setup dialog box?
Margin
Page orientation
Vertical alignment
PAGE SETUP
WORKSHEET
Which of the following can change using page setup dialog box?
BAR
To clear the content of the celle (without effecting the surrounding cell), which option can be used?
SINGLE CLICK
If the ribbon is not visible, double-lick (single-click on mac) on the ribbon tabs to maximize it.
TRUE
What is a worksheet?
Spreadsheet
Graph title
A __ is a group of cells that run left to right
ROW
You can navigate to the right of your spreadsheet by scrolling the scroll whelle of your mouse
TRUE
FALSE
The text label that describes each data series in a chart is called
The quick acces toolbar can be customized to show tools you use most often
TRUE
TRUE
What are the two ways you can sort a spreadsheet list
A TO Z and Z to A
You cannot copy and paste text into excel from another office software such as microsoft word
FALSE
COLUMNS
If you want to reverse most previously conducted tasks, you can click undo button at the top left of the
excel window
TRUE
What is a Column?
In an excel workbook, which cell do you need to click in order to freeze the first 3 columns and first 5
rows of the workbook
D6
COLUMNS
A____ IS AN EXCELFILE
WORKBOOK
If you want to remove someinformation fromyour spreadsheet, you can highlight this information and
press delete
TRUE
WORKSHEETS
=B3-B4
If you notice an error in a cell, you can correct it by typing over the error
TRUE
In a blank excel workbook,go to the insert tab on the ribbon.which of the following is not available?
ROWS
When you are changing the preset group of excel chart, you are changing:
LAYOUT
The large toolbar that stretches across the top of the excel window is known as the excel bar
TRUE
LAYLA
16348
ROWS
MORE THAN 1M
The _______ shows the addressof the cell you have selected
NAME BOX
=B3+B4
What is the keyboard shorcut for creating chart from selected call range?
F11
CELL