Have an account?
Skip to Content
20 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.Where rows and columns meet are referred to asBlocksCellsBoxes
- Multiple ChoicePlease save your changes before editing any questions.When inserting a formula, always start withequals symbolplus symbolminus symbol
- Multiple ChoicePlease save your changes before editing any questions.What key should you use to take you to the cell to the rightTab keyRight arrow keyjust click in it
- Multiple ChoicePlease save your changes before editing any questions.If you see a series of "######" in a cell, that means the following:You keyed in an incorrect numberThe row height is too highThe text is incorrectly spelledThe column width is not wide enough
- Multiple ChoicePlease save your changes before editing any questions.The name of the cell's location; such as A8Active cellCell AddressRowHeading
- Multiple ChoicePlease save your changes before editing any questions.What would be a correct formula for SUM in excel?=SUM(B3:B9)=SUMB3+B9SUM(B3:B9)=ADD(B3:B9)
- Multiple ChoicePlease save your changes before editing any questions.
Which phrase best describes a spreadsheet?
a computer file that uses rows and columns to organize, analyze, store, and manipulate data
a computer file that is created and saved by a word-processing software program
a computer file that presents information on slides using text, images, and video
a computer file that does not have any built-in data organization functions or methods of making calculations
- Multiple ChoicePlease save your changes before editing any questions.
What are the two parts of a cell reference?
column letter and row number
column intersection and row range
column range and row intersection
column number and row letter
- Multiple ChoicePlease save your changes before editing any questions.
To filter data means to
arrange data to line up a certain way
represent data in a certain way
sort for items by specific criteria
rename data
- Multiple ChoicePlease save your changes before editing any questions.
A column
a chart
a rowe
a vertical part of the worksheet grid
changing the type of font
- Multiple ChoicePlease save your changes before editing any questions.
What is the answer the answer to the following Excel formula =B5*C5
16.99
13.26
25.00
29.85
- Multiple ChoicePlease save your changes before editing any questions.What kind of software is Excel?Word processing softwareSpreadsheet SoftwareData Base Software
- Multiple ChoicePlease save your changes before editing any questions.In Excel rows are labeled bylettersnumbersrows and numbers
- Multiple ChoicePlease save your changes before editing any questions.In excel, columns are labeled byLettersNumbersLetters and numbers
- Multiple ChoicePlease save your changes before editing any questions.You can only work in one cell at a time. The actual cell that you are working in is called what?ColumnName BoxActive CellRow
- Multiple ChoicePlease save your changes before editing any questions.Cells are identified by the following:Column Letter followed by their Row NumberRow Number followed by their Column LetterRow Number OnlyColumn Letter Only
- Multiple ChoicePlease save your changes before editing any questions.2 or more cells that are selected to create a source to be used in a formulaRangeMaxFilterColums
- Multiple ChoicePlease save your changes before editing any questions.Making a change in the default settingsFormatErrorChartAverage
- Multiple ChoicePlease save your changes before editing any questions.You can edit a cell by...Clicking the formula buttonDouble clicking the cellSelecting Edit>Edit Cell from the menuNone of above
- Multiple ChoicePlease save your changes before editing any questions.Which of the following formulas is not entered correctly?=10+50=B7+B8=B7+1410+50