Font size
WorksheetsExcel Gmetrix Quiz
Total questions: 37
Worksheet time: 19mins
To begin a formula you must have _____ first.
=
+
SUM
()
______is a feature that allows you to quickly apply the contents of new cell to another cell or range of cells selected.
autofill
autosum
cell
drag
Autofill looks like __________________.
thick white cross/plus sign
thin black cross/plus sign
black square
grey square
Which formula would you use to add cells together?
=SUM()
=MIN()
=AVERAGE()
=COUNT()
What tab would you use to use the paint bucket?
home
insert
page layout
formulas
Which formula would you use to find the highest sales number?
=SUM()
=MIN()
=MAX()
=AVERAGE()
_____is a rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
autofill
column
cell
excel box
_____is the cell in your worksheet that has been selected. It will have bolder grid-lines around it.
column
cell grid
cell
active cell
______is the vertical spaces with headings A, B, C, etc...
column
row
cell
drag
____is the horizontal spaces with headings 1, 2, 3, 4, etc.
drag
cells
columns
row
_____is the name of the cell is determined by the name of the row and the columns and rows
cell reference
cell name
cell
active cell
A "page" within an Excel workbook that contains columns, rows, and cells is called ______________.
page
workbook
worksheet
heading
An Excel file that contains individual worksheets within the workbook is ___________.
workbook
worksheet
sheet tabs
range
You can rename worksheets/tabs in excel.
true
false
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 is called a __________.
cell address/reference
formula
function
fill
Where can you zoom in and out to adjust a better view of a worksheet? You can select more than one.
top left corner on the home tab
bottom right corner
you can't zoom in but you can make your font size bigger
click zoom on the view tab
Without using a calculator what's the answer to the calculation in B5 =SUM(B2:B4)
answer not listed
$9.00
$20.00
$10
How do you change the tab color?
right click on sheet one then select tab color
insert tab, illustrations group, select tab color
home tab, font group, select tab color
home tab, font group, select the paint bucket
What do you click on to print out certain cells?
wrong tab you must go to the view tab
print area
print titles
wrong tab you must go to file then print to set cells
What does this
autofill
selects a range of cells
adjust columns
adjust rows
Can you unmerge cells?
yes on the home tab
no but you can click on the undo button
In a formula, what sign should you use to divide?
/
*
=
-
What do you see when your column is not wide enough?
########
??????
ERROR
it only shows part of the information
__________ is a combination of a font, text color, cell color, and other font attributes applied to a single cell.
themes
cell styles
conditional formatting
font styles
_______is a predefined set of colors, fonts, line and fill effects, and other formats that can be applied to an Access database and give it a consistent, professional look.
theme
format painter
font styles
currency
What does merge do ?
combines multiple cells
changes the size of a cell
none of the above
hides a column
What is the shortcut key for selecting all cells in a worksheet?
Ctrl + A
Ctrl + V
Ctrl + S
Enter Key
What do you click on to and unhide rows or columns?
home tab, cells group, format
home tab, styles group, format table
home tab, styles group, conditional formatting
home tab, alignment group, merge & center
What tab do you go to to hide gridlines?
view tab
home tab
file tab
page layout
__________format places the dollar sign right next to the number on the home tab.
currency
general
number
accounting
How do you insert a footer?
insert tab, text group, footer
insert tab, charts group, click on dialog box, select footer
wrong tab.... it's on the page layout tab
wrong tab.... it's on the home tab
What is this button called?
orientation
line spacing
merge
none of the above
Is it possible to show and hide gridlines?
yes
no
___________a feature in Excel used to control what a user can enter into a cell. For example, you could use this to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.
data validation
autosum
sort & filter
name manager
What score do you have to have in order to pass the certification test?
700
1000
500
600
What is this button called?
insert function
autosum
merge
sort
What is this button called?
find & select
find & replace
finder
excel looker
