Excel - Unit A - Review
Which view shows you a reduced view of each page of your worksheet?
page break preview
Which worksheet view shows how your worksheet will look when printed?
page layout
In which view can you see the header and footer areas of a worksheet?
page layout view
Selection of multiple cells.
range
Which feature could be used to print a very long worksheet on a single sheet of paper?
scale to fit
In which area can you see a preview of your worksheet?
backstage view
Using a cell address in a formula is known as:
cell referencing
In an Excel worksheet - how many boxes do you find in your header view?
3
A1 = 5 B2 = 10 B1 = 2 What is answer to this formula =(B2*2) + (A1*B1)
30
A1 = 5 B2 = 10 C3 = 3 What is answer to this formula =(A1*B2) - (C3 x 3)
41
A1 = 5 B2 = 10 What is answer to this formula =(A1*B2)-2
48
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
5
A1 = 5 B2 = 10 C3 = 3 What is answer to this formula =(A1*B2) + (C3 x 3)
59
A1 = 5 B2 = 10 What is answer to this formula =(A1*2)-2
8
Columns are identified in Excel by using __________________________.
Alphabetical letters
Equal sign preceding a formula
Formula prefix
A1 = 5 B2 = 10 If the following is shown on the formula bar for cell A3 - what would be shown on the worksheet? (A1*2)-2
(A1*2)-2
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained A1/A2, what would cell A3 show on the worksheet?
A1/A2
Name box
Displays the active cell address.
Which key can you press to switch to Edit mode?
F2
Cell
Intersection of a row and a column.
Formula Bar
Location in Excel where you find the formulas for cells.
Default view in Excel
Normal view
Rows are identified in Excel by using ____________________.
Numbers
Direction in which contents of page will print
Orientation
Maximum number of worksheets you can include in a workbook is _____________________.
Unlimited
File consisting of one or more worksheets
Workbook
An excel workbook is made up of
Worksheets