Tutorial 1 Questions
To divide the value of a cell by some number, use the ____ operator
/
What is the result of the expression =50/(10*5)?
1
____ makes it easier to enter repetitive text in cells
AutoComplete
To change a column width, you can click ____ on the Column submenu to make the columenu to make the column(s) as wide as the longest entry of the cells in the column
Autofit
To complete a cell entry the ___ key.
Enter
According to the order of precedence on Excel.
Excel performs exponentiation, then multiplication, then division, then addition, then subtraction
____ headings are identified by a number
Row
The active cell has a ____ border
Thick
The characters +,-,* and / are examples of
arithmetic operators
Excel stores its documents as a files called
workbooks
Excel makes reading formulas simpler by _____each cell reference in the formula and its corresponding cell
color coding
A sheet is a worksheet that provides information about the content and purpose of the workbook
documentation
Text is ___ -aligned in cells
left
Row headings identify each row using different
number
In ______ orientation, a page is taller than it is wide
portrait
A(n) ____ is a group of cells
range
Excel is an electronic version of a(n)
spreadsheet
By default, an Excel workbook is made up of ____ worksheets
three
There are ____ ways to view the current worksheet
three
The expression used to calculate values displayed in a worksheet is called a(n) ___
formula
The contents of an active cell are displayed in the ___
formula bar
To view formulas, rather than the resulting values in a worksheet, switch to _____
formula view
To change the order of operations, enclose part of the formula in ___
parentheses
The formula used to multiply cell A1 by cell C1 is
=A1*C1
What is the syntax for a SUM formula adding the values of a cell F6 to F9
=SUM(F6:F9)
The name given to an Excel workbook before you rename it is
Book1
To insert a new column, select a column, then click the Insert button in the ____ group on the Home tab
Cells
Cutting a selection sends its to the ____ until you paste it
Clipboard
To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other adjacent ranges
Ctrl
To make A1 the active cell, press which of the following Keys?
Ctrl+Home
From formula view, press ____ to switch the worksheet back to Normal view
Ctrl+~
Press the ___ key to switch to editing mode
F2
The Undo and Redo buttons are found on the
Quick Access Toolbar
The intersection of a row and column is know as a
cell
An Excel formula always begins with a(n)
equals sign
