NEW
Font size
WorksheetsExcel Test
Total questions: 40
Worksheet time: 23mins
A column is represented by ________?
Numbers
Letters
Lines
Cells
Rows are represented by ______?
Numbers
Cells
Letters
Numbers and Letters
Values are letters.
True
False
What does a formula always begin with?
Addition symbol +
Exclamation Symbol !
Equals symbol =
Minus symbol -
A file which contains one or more worksheets is a :
Active cell
Cells
Spreadsheet
Workbook
An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form is called:
Spreadsheet
Workbook
Cell range
Active cells
What are individual locations on a spreadsheet called?
Word box
Formula
Cells
Cell data
A ___________ instructs the software to perform a calculation.
Workbook
Active cell
Cell range
Formula
Calculations are NOT performed by the Order of Operations.
True
False
What term indicates a cell's location and provides instructions for how cell data is copied or used in calculations?
Cell reference
Cell selection
Active cell
Cell
A business has listed all of its sales information for one product in the cell range A1 to K1. Where is this sales information displayed?
Row
Column
Entry
Cell Address
Which of the following is the correct way to write a function in a spreadsheet?
=SUM(A1-A5)
=SUM A1+A5
SUM (A1:A5)=
=SUM(A1:A5)
What is the cell in the worksheet in which you can type data?
Main cell
Open cell
Active cell
Absolute cell
The intersection of a row and column.
column
row
cell
active cell
If your data is showing up as ######### in a cell, what must you do to fix it?
Make the cell (column) wider
Change the number formatting in the cell
Change the font format in the cell
Delete the data and re-type it
Excel refers to files as...
Presentations
Databases
Workbooks
Documents
To create darkened, bold grid lines around your cells, what must you select?
All Borders
All Grids
Outer Borders
Bold Grids
Combines cells into one large cell but deletes all contents except the first (Upper Left) cell of the group.
Multiple Lines of Text
Merge Cells
Move Text
Autofill Series
Select a cell(s) that you want, R click “Copy”, move to a new cell, R click clipboard icon.
Unmerge Cells
Copy Text
Formatting
Autofill Series
Splits a merged cell back into several separate cells.
Clearing Content
Move Text
Unmerge Cells
Multiple Lines of Text
Used at the beginning of all formulas. A formula will not work in Excel without this sign
Range
Click Header
Hold down CTRL and click cells
= (Equals Sign)
What is the green bar at the top of Excel referred to as?
the data bar
the function bar
the ribbon
the row
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
What is it called to have 3 cells become 1 cell?
wrap text
merge and center
Fill Color
joining cells
What is it called when text goes underneath itself in one single cell?
Wrap text
Merge and center
Formula Bar
Auto Sum Button
What is this picture called?
Auto Sum
Equation
Formula Bar
Answer Bar
What is the name of this? (Red Square)
Font size
Wrap Text
Merge
Alignment
Rows in a spreadsheet run _____________ and are designated by a _____________.
horizontally, letter
horizontally, number
vertically, letter
vertically, number
Division
= B9/B5/B3
=SUM(B1:B3)
=AVERAGE(B2:B7, B10:B15)
=B1+B2+B3
